Recent content by border20

I built a databse with access 2000. In the database are alot of Updatequery operations... but when I run the DB in access Xp. I get a Warning saying that i am about to modify X records... that get anoying... is there a way to stop there warnings ?

Yep that did the trick for me 2 :)

I have a database wich i was running from a computer with access 2000. We now have a new computer with access Xp but when I run the DB... it doesn't recognise the "date" function.... anyone know why ?? thx :) P.S. I also have a missing reference to HDBOCX ... whatever that is... maybe that is...

thanks that seems to work :)

I have a query with 4 fields that can either be null, 0, or a text value like the folowing example: f1 f2 f3 f4 0 12 0 0 0 0 23 0 3 3 0 0 0 0 65 0 What I want is to be able to have a fifth column with the text value of the...

ttt

thanks, very helpfull

I have the folowing code that works fine Docmd.TransferSpreadsheet acExport, 8, "Queryname", "x:\database\export.xls", False the problem is that X is a network drive, and the database is runed form different computer with different drive names... The target excel document is in the same...

My boss just came to me with quite a challenge,,, the thing is we have a pretty big database that is on the company network... but some company offices access the database through very "crappy" connections and cant really operate the DB. Is there a way to perform operations on the database...

I'n not a pro but the way I see it, i think you can retrieve it in your report with code like : [forms]![form_name]![combo_box].[value] hope it helps

I dont know about such code... my suggestion is just to make the DB compatible with the lowest rez

Is there a way to access information in a database using asp ??

ok, but will thew filecopy statemement take a relative path ?? for example could i put: filecopy /folder/document.doc, /document.doc ?

I only want to copy a simple file that will always be in the same location with the same file name

Ok I did that but the bat file didn't run normaly,,, the root was Mydocs folder instead of the dir where the file is located...