Search results

I created an Append query. How do I pass data from my form to the query: DoCmd.OpenQuery "qryAppendNotes" ....

Yes, "Notes" is the table name. Your suggesting to use an update query instead of sql statements?

Trying to run and insert statement using: DoCmd.RunSQL insertSQL I did msgbox insertSQL: "INSERT INTO Notes ([Project ID], Status, Comment, [User Name]) VALUES (5, 'In Progress', 'This is a test', 'dr'); " Not sure why I am getting this error?

That works...thank you

I am opening a report using: DoCmd.OpenReport "rptName", , , acDialog I am trying to get the report to open in popup mode and not to open to the maximum page size. Tried various combinations of arguments after the report name in DoCmd but nothing works.

Problem solved...thank you everyone!!! I Wasn't returning the right value to the combobox.

to ensure that Module1.ProjectStatus has a value I added: msgbox Module1.ProjectStatus I get the message box popping up with the proper value. I don't get it!!!

After opening up a form I populate the combo box value using the following code: DoCmd.OpenForm "Notes" Forms!Notes!cmb_ProjectStatus.Value = Module1.ProjectStatus Everything works fine until I split the database to front and back end. Once I do that the combo box does not populate. Any idea why...

Thank you.

I think I solve the issue...I did not close access when I closed the application. Problem solved.

Thank you.

I created a shortcut to my access application. Under shortcut properties I selected Run: Minimized. When I click on the shortcut the access client opens in the background with my application in the foreground. I close the application and click on the shortcut again to restart and the...

I am using: DoCmd.GoToRecord , , acNext To scroll through my records. My problem is that when I click next on the last record it opens a new record which I don't want. I want to display a message saying "You have reached the last record". How do I determine if I have reached the last record?

I was able to get it working: Set pop up to yes and center to yes Thank you for your help.

I rebuilt the form and discovered that when pop up property is set to No the form opens fine. When I set the pop up property to yes, the form doesn't open. Any ideas?

I imported all the objects into a new database. Tried running again and the same issue.

I created a new form and copied the old form content. Ran once and same again.

How do I fix it?

I got an error code 2501 cant open form. I don't get that code anymore...just nothing happens. I created the form. When I double click on the form nothing happens. Form.Load and Form.Open has no code in it. Does this help?

Trying to open a form using: DoCmd.OpenForm "Notes" Nothing happens. Help!!