Search results

Hi all, I need to put the current date and time in a report footer. This is the code I have in a textbox of the report footer right now and it works... ="Printed the " & Format(Now(), "dd-mm-yyyy hh:mm") But when I change pages, the time is update... So the first page can have a...

Hi all, I've used this function to get the MsAccess database name : Function GetDbName() 'Returns the filename of the currently opened MDB GetDbName = CurrentProject.Name End Function and it worked. But the database name is in this format : ThisIsTheDatabaseName.mdb. The problem...

Hi All, I'm looking for a way to make a wait in my code before executing next steps in my procedure... I will explain what I'm doing : On button clic, I have set a vbscript to make a comma delimited file from a text report. And after that the vbscript has been executed in msaccess, my code...

Hi All, I'm trying to import a fix lenght file using a schema.ini file and it does't work.... I get the error message 3625 run time error. Schema.ini does not exist. Here is my command : DoCmd.TransferText acImportFixed, "Schema.ini", "LEVELS", "C:\share\newfile.txt" my schema.ini file ...

Hi everyone, I'm looking for a way to go get the date & time that a file has been created or updated... I have made a macro to go get a comma delimited file and imported the data in a pre-define table. But It will be nice before to go get the date & time that file has been created before the...

Hi All, I need to import some values in the format comma delimited in an access table. The format of the text file is like this : level, glno 800000000,02.75.20000000 ... but when I import this in msaccess table, the value glno get's converted in this format 2.75.... It can't receive the text...