Recent content by NHogan

Sorry, you were right. I forgot to put the :=0 in the Header formula. Hence why the total never reset. Thanks for your help.

Thanks synapsevampire, That gives me a running total all the way down. Is there a way I can reset the totals for each group.

I have a formula field that compares a fields previous and next records and either returns 1 or 0 depending where the condition is true or false. Now I want to sum the formula field to give be a total at the group level. How can I sum the formula field so I will have a total per group. I...

I have a database with a .mdw file and many users and groups that works well. But users can currently open the database without using the shortcut and still view the database. What is the easiest way to only allow users into the database using the shortcut and not letting them bypass the...

Can you add a parameter to a CrossTab query? I am getting a syntax error when trying but if I hardcode the values it works fine. Please help.

Thanks, that worked great. I had to change it around a bit but it's exactly what I was looking for. If Isnull(Dlookup("[Your Key Field]","[Your table or query]","Your criteria")) Msgbox "No matching records" Else Open Report End If Thanks again

Currently, I am launching a report from a button on a form. There is a date field and I filter on the entered date on the report. Everything works fine, but if there are no records for a specific date, then it launches an empty report. Can I give the user a message box saying that there are...

Thanks that works great. Thanks for your help.

I am having a problem importing any file types into Access '97. When I click on Import, the only file types I have in the Files of Type drop down list are Access and ODBC. Does anyone know what I have to do to add text, Excel and other file types to the list? I have tried uninstalling and...

What is the best way to disable the Shift bypass and database window shortcut key's on the front end of a database. Currently I have security which works well through a .mdw file but users can hit F11 or use the shift key to to get to the database window and bypass the Autoexec. I want to be...

Thanks anyways, but I finally got it too work. It didn't like the Left inside of Dlookup and the problem was I had to use quotes because it was a string. strLeftPartNo = Left(txtPartNo, 5) DLookup("[PartName]", "tblPartName", "[PartNo] = """ &...

I still get a Runtime Error 3075 with a syntax error. Any other suggestions?

I have a Part Number field that when is updated, populates a Part Name field. It works fine with the current 15 digit Part Number but they are changing the Part Name to be associated with the first 5 characters of the Part Number. Ex Part No PartName Old...

The table is already setup with data in it so I can't use the wizard. Is there a way to include the format with the data?

I think I have an easy question. I have a field that I want to use a Custom format for. The field is a Part Number that I want to have the field broken up with dashes. I want to show the '-' automatically and have them type the numbers around it. Ex. 12345-XXX-1234-X1 I have the Input mask...