Search results

I'm trying the following...but I'm getting a syntax error? DoCmd.GoToRecord(acActiveDataObject ,TxtBxProject_Title,acNext,)

So I need to include some sort of save or move-to-next-record command??... 'Form 2: Private Sub btnAdd_Project_Click() 'save or move-to-next-record code goes here DoCmd.Close DoCmd.OpenForm "Front_Page_Form", acNormal End Sub I'm a newbie...I'm not sure what code to use...

(Newbie) Hi, Form 1: has a List Box bound to Table 1. Form 2: has a Text Box bound to Table 1. When I enter text in Text Box and click "Add" button on Form 2, I want this text to appear in the List Box in Form 1. Code so far... 'Form 2: Private Sub btnAdd_Project_Click() DoCmd.Close...

CameronM, thank you for your original (1st) post...works like a charm. Your a legend, Thanks once again. Jason. Melbourne, Australia.

(I'm a newbie to VBA). I'm trying the following but it's not working. The error I get is Runtime error '3420' object invalid or no longer set. Private Sub Command2_Click() Dim tbl As TableDef Dim fld As Field 'open the table called Call Set tbl = CurrentDb.TableDefs("Call pts") 'loop...

Hi, I have a table named "Call". I wish to add (concatenate) the text "Call_" to the front of every field name in this table. Can anyone suggest the VBA code? Thanks.