Search results for query: *

Your sig line speaks volumes... Your explanation was way too simple, and so very complicated to understand. Elaborate some if you expect an actual answer. SgtLoehr

I'm going to get working on this shortly... in the middle of an inspection at the moment. Thanks for the response, I'll let you know the results. Sgt Loehr

try this: dcount("[ID]","table1","[Area] = 'AREA1' And [SalesDate] >= #1/01/2007# AND [SalesDate] <= #1/31/2007# And [Type] = 'in') of course you'll have to replace the values with your fields names if the parameters are from a form. dcount("[ID]","table1","[Area] = '" & textbox & "' AND...

Sounds weird... I would try to simplify your SQL to see where the problem is. 1) Check all your field names make sure they aren't reserved words. You can do this by searching them in your object browser, from your example code I would imagine you would have problems with 'Year', 'Type', and...

Check your delimiter on your number field. Delimiter for text = ' Delimiter for date = # but numbers don't use delimiters

The DLL might have a different name in the new OS....what is the DLL?

I don't know what your project is, but if you aren't trying to save the wave file to the database so you can carry the database around, it might be better to save the path to your wave file in the database(text datatype) and then you can open the file directly thru the path. Look up fileopen...

I forget what they call it... but I think 'Number' is one of those words you can't use. "Reserved word" or something like that. Just try to change the field name and see if it works after that. Sgt Loehr

ck1999 probably right, however being a military system I'm not allowed to make programs and operate them on a military system. I can however make an access database which is why I'm on the VBA forum. Can you help?

I'm in the military and during exercises we often bug-out. I wanted to make a program that has a button that sits ontop of all open programs (I can do this already)... I just want to be able to click this button and it will cycle thru all open programs and close them so I can shut down the...