Search results for query: *

Hi all, I'm running access 2007. I have a form with two subforms that make up a client index. On one of the subforms I have an autonumber field where the field is populated with the value on the double click event. It works as desired most of the time but under certain circumstances it produces...

I have a word document that I'm opening from access. All are office 2007. The word document has a number of ASK Fields and so when it runs it opens 20+ popups boxes one after the other asking the questions and this works fine. However, is it possible to combine these popup boxes into one so that...

I have this line of code to update certain values in a table. I'm getting the error that "there are too few parameters, expected 2". It's a little tricky but I can't spot the problem. Any help appreciated! db.Execute "UPDATE [Properties] SET [Discharged?] = YES WHERE [Owner#] = (SELECT [ID]...

Hi All, I have a somewhat messy chunk of code to run a mailmerge for 2 documents. I've attempted to set up and qualify all of my variables but it appears that I haven't succeeded. The code will run as desired the first time (on click event of a button). And then error the second time which is...

Hi All, I'm currently running Access 2007. I have a field called Close# that I would like to increment from the previous highest Close#. There are a number of complicating factors however. First, the tables are shared with another program and the field is a text field. So it can't simply be...

We have a split FE/BE. We converted the backend successfully, but when trying to convert the FE, we get the msg "You attempted to open a database that is already opened exclusively by user 'Admin' on 'Computer07'. Try again when the database is available." My computer is named 'Computer07' and...

Hi All, I'm currently using both Word and Access 2007. I want to insert a table of selected values into a mailmerge letter. If I enter the fields in and hit run then I get an individual letter for each record. However if the table is a separate document then it merges continuously as desired. So...

I've started to use the Contact Template that you can download in access by going New --> Contacts. When I open the "Contact List" form there is the handy "Add From Outlook" Link. I click it and choose the folder I want in Outlook and the majority of my contacts will appear but about 25% of them...