Recent content by aimeepeter

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...

Case closed. Thank you both!

Thanks RuralGuy - that did the trick! In repsonse to the post from georgedwilkinson can you please explain how to use the tab order property to go from the subfrom back to the main form? I know how to set the tab order to move from the main to sub form and then to use Ctrl-Tab to move back to...

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...

OK I have deleted the On Error Resume Next and it is working now. Thanks.:)

Thank you for your feedback. I am very familiar with opening the report using the WHERE clause. I think my confusion is coming from trying to use a two-step query. By this I mean I am using the first query (qryDemographics1) to set the date range and select the program name and participant...

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...