Search results

Did you know that if you set your form to Data Entry in the form properties, it will open to a new record?

Do you mean that you do not have the .mdb?

Ok, and thanks again. I didnt realize that using a pre-built query would improve performance or I would have used that all along. I thought it was the other way around!

I got it sorted... thanks for helping!! Here is the query that worked: SELECT [Basic Entry].[Record Number], [Basic Entry].Reps, [Basic Entry].Leads, [Basic Entry].Supervisor, [Basic Entry].Date, [Basic Entry].[Inquiry Type], [Basic Entry].[Inquiry Sub-category], [Basic Entry].[Policy Type]...

All records vanish in the listbox

Yes, sure did

Ok, I did that. Still get the same result. Here is the query code: SELECT [Basic Entry].[Record Number], [Basic Entry].Reps, [Basic Entry].Leads, [Basic Entry].Supervisor, [Basic Entry].Date, [Basic Entry].[Inquiry Type], [Basic Entry].[Inquiry Sub-category], [Basic Entry].[Policy Type], [Basic...

I have done this before with success but can't seem to sort this out for some reason. Maybe someone can spot the trouble... I am trying to filter a listbox on my form with a combo. Here is the code behind the combo: Private Sub RepSort_AfterUpdate() Me.listbox1.RowSource = "SELECT [Basic...

Hard is a relative word :D What may be hard for some is a piece of cake for others. I would suggest searching the forums here for tabbed forms, reading Access help files, and then just go for it. If you run into something that you cannot figure out with research post back here and someone will...

I am guessing that you are using 2 forms because there is not enough room on one form for all of your controls. Have you considered using a tabbed form?

DoCmd.Close acForm, "Your Form Name"

Try this: Private Sub Close_Click() If MsgBox("Press Ok to Close, Cancel to Continue ", vbOKCancel, "Exit Data Entry") = vbOK Then DoCmd.Close End If End Sub

tools/startup/display form/page

Instead of -1 try Yes

In the English version it is the very top (first) event under the events tab of your form.

Sure, just include a text box with either: now() or Date() as the default value Store the value in a new field in your table

try this: Private Sub tblDateCreated_DblClick On Error GoTo Err_tblDateCreated_DblClick Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmCalendar" DoCmd.OpenForm stDocName, , , stLinkCriteria Exit_tblDateCreated_DblClick: Exit Sub...

try making a command button to open the form with the wizard. It is probably to do with the path statement you are using in code. else.... post the code you are using to open the form

I don't think you will be able to edit the switchboard with the switchboard manager with the import process, better check that out before you go too far.

I figured it out... Delete the table 'switchboard items' When you create a new switchboard after doing this it will prompt you that there are no switchboards and do you want to create one. After doing so, it will show up in your database window under forms edit: oops I missed a few posts! LOL