Search results for query: *

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

I am trying to add a button to bring up a browse button to insert a picture into my database. I have it working with an unbound OLE object using the following code. DoCmd.GoToControl "OLEBOUND2" DoCmd.RunCommand acCmdInsertObject But my users are computer rookies and it's too many...

I have added a Tab Control with 7 tabs. The subforms and everything are working fine but I have one question. Can I change the Font Colour on the tabs? If so, how? I can't find a property for Font or ForeColour under Tab Control Please Help me out.

Thanks, that's great. It was a problem with the References. The problem was that it was Japanese Office and I couldn't read the characters before a specific Reference. Turns out it read Missing but I had no idea because it was in Japanese. Thanks again.

I have a database that works fine with English Access '97. But I open the same database on a Japanese PC and a get a Compile error message on a specific form The problem is that I am using the left() function. I remarked out the line in code which uses left()and it workes fine. I also tried...

I have admin rights to both databases. I have been trying opening one database and importing the other into but can't. How do I join two .mdw files into one? I tried setting my default workgroup to the .mdw from DB1 and opening DB2 without security but I received a permissions error. I...