Microsoft Office Access 2003 (077-02871) for PC Logo

Related Tags:

Problem with Microsoft Office Access 2003 (077-02871) for PC

when my main form saves the design changes it takes a long time. the main form is very complex and has about 10 tabs on it. when the program is first started it goes to a questionaire page and

you must answer a number of question that will determine which design the program will format the main page to. when you are finished and click to the main page it takes a couple of minutes to open due to the save design. any suggestions?

Posted by avatar on Apr 29, 2010

Suggested Solution (1)

Use this line below:

Private Sub CommandButton_Click()

Dim NumericValue as Integer
Dim StringValue as String

NumericValue = CInt(TextField1)
StringValue = TextField2

DoCmd.RunSQL "INSERT INTO NameOfTable ( [FieldName1], [FieldName2]) VALUES (" & NumericValue & " , '" & StringValue & "');"

EndSub

I Hope this work for you... God Bless

  • by Author image DarkDoctrine Over a year ago

Source: Access-VB

Was this solution helpful?

No

Yes

Tips for Helping wayne_stone6 With Their Issue
  • Give detailed step-by-step instructions
  • A picture or video is helpful
  • Use plain language not industry jargon
  • Check spelling & punctuation
Hide Tips

Add Your Solution

Microsoft Office Access 2003 (077-02871) for PC Unsolved Problems

See all Microsoft Office Access 2003 (077-02871) for PC Problems

Related Topics