Forms

MoveNext
If I need to move down x number of records Is there some easy way to to do it other than movenext movenext a bunch of times or create a loop? I was hoping for something like Movenext(6) Thanks, Rick ... 1 Jun 2010 17:32

Continuous form record number
I have a form whose default view is 'continuous form'. Then when I click a button I need to delete the record where the mouse is (was just) placed. How can I find out the record number? Alternatively any idea is welcome. Thanks Henry ... 1 Jun 2010 10:52

Can not choose in combo
Hello, I have a church membership database. I have the form to input the member data on whch form I also have a combo box to choose the address. If there is no address on the combo list, I add the member address in another form. I can only select it in the member form combo, if I complete filling the addres... 1 Jun 2010 10:52

Dlookup related records
Hi. I'm having trouble thinking through the logic for this. Can someone point me in the right direction? I have a subform that the users can attach a Position (PK=PositionID) to a Candidate (PK=CandidateID). When this is done, the Candidate and Position IDs/information are populated in a third table "Interview". ... 3 Jun 2010 11:10

record Locking multi user
Hi I have a multi-user Access 2003/2007 database. In mono user mode everything works fine, but in multi user mode there seems to be occasionally a Conflict message giving the users to either Save Record, Copy to Clipboard or Drop Changes. I open my tables something like: Public Function OpenTable(strTableN... 31 May 2010 18:36

More efficient code for multiple If...End If statements
In the on current event of my form, I'm setting the Backstyle and Borderstyle of several controls based on the whether the control is null. For example: ' 0 = Transparent ' 1 = Normal If IsNull(Me.FirstName) Then Me.FirstName.BackStyle = 0 ' Transparent Me.FirstName.BorderStyle = 1 Else Me.F... 1 Jun 2010 23:00

How to rip DVD movies and convert video to ipad
iPad tablet has a built-in rechargeable lithium-polymer battery, and the battery delivers up to 10 hours of Web surfing via Wi-Fi, music listening, and even watching video or movies. That's quite good, especially for frequent travelers or people who take video or DVD and enjoy on the go. And thanks to its bigger screen... 31 May 2010 06:31

MS ACCESS 2007 - FIND AND REPLACE NOT WORKING
Hello, Command button (FIND RECORD) for Find & Replace is working fine in the form view. When I maximize it on loading the form and click the command button for search, it comes up with message "the command or action 'Find' is not available now". Can someone help in sorting this out please? Thanks, Cho. ... 31 May 2010 02:14

Syntex Error
Would someone please tell me what is wrong with this code?: CurrentDb.Execute "INSERT INTO tblEntry (CreditorID, CategoryID, DueDate, BillDesc, BillAmount, BillNotes, PaymentAmount," & _ "PaymentDate, PaymentMethod, CheckNumber, PaymentNotes, TotalDue ) " & _ "VALUES (" & cboCreditors.Column(0... 30 May 2010 21:57

Combobox and error 3314
I have a combobox bound to a field where the Required property is set to True. When I delete value in combobox field and press enter I get a system message telling me that I need to have a value in that table and that tablefieldname. I understand that this state requires a message but is it possible to supress ... 31 May 2010 21:52