Search results

Hi Can anyone advise me how to show more than one record per line in a subreport, please? I have very limited space in my subreport and rather than show: Record 1 Record 2 etc I would like to show: Record 1, Record 2, Record 3 etc Preferably with the record wrapping onto the next line at the...

OK I give up, I have been round and round this problem and searched the forums for the last 2 hours and I am still stuck. Here is my simple code for adding a record to a combo box, which works fine except I still get the message "the text you entered isn't in the list" AFTER it runs the event...

Hi I had some very useful help last week from Marion in converting an Access 97 db to 2002. Now my problem has moved on as I am trying to convert the mail merge code in the same db so that when I click on a command button it merges 1 record from a query with a letter. Sounds simple, but I have...

Can anyone help please? I have an Access 97 VBA conversion to 2002 to perform and I don't know the code equivalents. One problem is this: Dim objWord As Word.Application what is the 2002 equivalent please? Is there anywhere a list of 2002 code equivalents? Any help greatly appreciated

I need to produce an invoice on preprinted stationary where the totals are at the bottom of the page. This is fine if the invoice is only one page, as I can make the detail section a fixed size, but what if the invoice goes to more than one page? Does anyone know how I can put the totals at a...

I'm sure this can be done but I must have my syntax wrong. I have a report with 1 subreport and that subreport has a subreport which lists products and their prices. In the footer of the bottom level subreport I have a calculated control called TempCCost =Sum([Price]). Here's the thing: I want...

I have a database in Access 97 which is shared across an NT network. When a user tries to quit a message appears saying: Couldn´t save;currently locked by user "nnnn" on machine nnnn" This is followed by: "The saved operation failed" "Out of memory" According to Microsoft TechNet the first...

I have an Access 97 problem – I want to select a number of records in a query from a single table, but I want to be able to tell the query how many records to select. For example if I have 500 records in the table I want to tell the query to select the first 50 that match my selection criteria...