Search results

What is the code to test for a new record? (I have code that runs on the On Current event of my form, but I don't want the code to run if it is a new record that has not been updated yet because it is creating multiple unwanted blank records.) Thanks!

This was working fine before so I am not sure what has happened. I have a command button which creates a formatted Excel spreadsheet from one of my queries. I am getting Error 445 (Object doesn't support this action) when I try to open a Save As dialog box and have the user specify a file...

Hello all, I have some code that automatically fills in unbound fields on my form but the code produces an error (#2455) in datasheet view. I use the IsLoaded function to test if a form is open in form or datashet view but, is there a way to test if a form is open in form view only? This...

Hello all, I am having trouble with my code to which merges a query to Word Template using Document Properties. I am getting Error 5151: Word is unable to read this doucment. It may be corrupt. When debugging the error is on the line: docs.Add strWordTemplate The template seems to work...

Sorry if this topic has been covered elsewhere already... I have a database which needs to used by two people. Currently the file is saved in a shared network folder which both users can access. The problem is that using the database from the network location is very slow when the users are...

Hi all, I have written this code: Private Sub TestStaff_KeyDown(KeyCode As Integer, Shift As Integer) If KeyCode = 9 Then [Forms]![Shows Form]![Model#].SetFocus End If End Sub to move from the end of a sub form to the next control on the main form. However when this is run, the focus is...

Hello, I would appreciate some help with following. I am using a form to set the SELECT statement for qryDemographics1 which sets the time span, program name and participant type from records stored in a table, tblRegistrations. Demographic information about the people registered are stored...