Recent content by ready4data

Thank you for the attempt. I can't use functions since this will be asp based. I'm looking into alternate ways to what I need. Scott

Thank you both sneuberg and Beetle but neither suggestion worked. When I Use the actual text in the criteria Not In(License2, License8, License13) and move out of that field, it gets replaced with Not In("License2", "License8", "License13"). It is automatically adding quotes and runs correctly...

I have a table(tblLicense) with a field called License It has rows with License1 License2 License3 ... License15 My other table is called tblReservations It has fields License, FromDate, ToDate It is populated from a web app so the License field can have any combination of the selected licenses...

The Counter(number) field may have been a poor choice of name. It contains a monthly meter reading. I used RowId(autonumber) because that was required in some Running Sum queries I was trying. It didn't work correctly as there isn't a meter reading every month for some serial numbers. Scott

I have a table with RowId(autonumber),ReportMonth(date), SerialNumber(text), and Counter(number) I'm trying to create a query that will eventually be a Make table query. I want to show for each ReportMonth and each SerialNumber, the increase or decrease of the Counter. Issue is that there...

Correct. I was thinking about storing the txtAward field as a variable and populating a table through vba as the records of the form are scrolled through. Idealy if there is a way to open the form(hidden) and scroll through the records to populate a table with the needed controls from the form...

I have a form that has many calculated fields(hidden and shown) based on the data in the source table. The calculated values roll up to a textbox(txtAward) that shows an award(Gold,Silver,Bronze) based on the total calculated points. There is no inputting in the form. Its just used to display...

Bob, I'm coding it in Visual Studio 2010 and accessing the .mdb file through code. Its for an application external from the database. The rest of the code runs correctly and I can access and write to the tables. The delete piece is what is giving me trouble. Scott

Thanks Bob, I made the corrections to the sql but it still doesn't delete the records. I can take the sql statement and paste it into a query in MS Access and it does work, just not through my code. Scott

Can anyone see any reason why the following statements dont delete the records. strDBPath is defined earlier and works. 'Delete existing project name records. cnnDBServer = New ADODB.Connection cnnDBServer.Provider = "Microsoft.Jet.OLEDB.4.0"...

Peter, Thanks. That is what the problem was. Thanks also, Keith Scott

Keith, Not sure. I'm calling the function like this. ListCheck("lstBrand")

Keith, Here is the modified code. Function ListCheck(ListBox As String) Dim intX As Integer Dim varItem As Variant Dim db As DAO.Database Dim ListBoxName Set db = CurrentDb ListBoxName = ListBox If Forms![frmMain]!ListBoxName.Column(0) Then '* selected last intX = 0 For Each...

I have a form that has several multi-select list boxes that have an "*" as the first selection to include all items. I have to check that the user didn't select the "*" with any other items. This code works to check if that happens. 'Location listbox check If lstLocation.Column(0) = "*" Then...

If you have warnings turned off you might not be noticing that you are getting a message that the query already exists. The existing query has to be deleted first. Scott