Search results

Thanks. I have columns in my main report but didn't think to put them in my sub report as well. Brain is not working well today! Help greatly appreciated

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

Hi Yes - you need to substitute all occurrences of Combo28 with the name of your combo box, tbTableName with the name of your table and ControlInTable with the name of the control in your table. In the line: Set Rs = db.OpenRecordset("tbMedIns", dbOpenDynaset) you should substitute tbMedIns with...

NotInList event in Access 2002 This might help anyone else who has had this problem in Access 2002. I took up the problem with Microsoft and they reported this is a bug in 2002. To get around the problem of the standard "text not in list" message showing even with NotInList event code, this is...

Thanks Colin, I tried it but it still gives the standard "text not in list message" after adding it to the list, which means the user has to cancel the message then reselect the newly added item from the list. If it works fine in earlier versions, could this be a problem with A2002 perhaps? I...

Thanks for your help. I should have said that I am using Access 2002. I have made the changes but unfortunately still getting the same problem. My code now looks like this: Private Sub Amount_NotInList(NewData As String, Response As Integer) Dim rst As Recordset Dim db As DAO.Database Set db =...

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

Thanks for the suggestion Travis. I had also started to doubt my own eyes but, yes the query does exist, it is a select query and it does run. This db is one I had to convert from 97 and the original developer put in a lot of code at startup and I wonder if that is causing a problem. I have...

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

Thank you so much Marion, I think you have solved it! I will try it on my client site tomorrow (Friday) and let you know if it works. It did work on my test copy. You are a star!!

Hallo Marion Thank you for your help, I have a tick against the following references in this order: Visual Basic for Applications Microsoft Access 10.0 Object Library Microsoft DAO 3.6 Object Library Microsoft Visual Basic for Applications Extensibility 5.3 I cannot move the DAO reference up...

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