Recent content by dorisr

public txt_time_stamp as string

sorry,,,, it works :)... I have declare it as : Public txt_time_stamp As String Option Compare Database Option Explicit Public txt_time_stamp As String Private Sub Report_Open(Cancel As Integer) txt_time_stamp = "Printed the " & Format(Now(), "dd-mm-yyyy hh:mm") MsgBox (txt_time_stamp) End...

Hi RuralGuy, I have done it but still not working... In my report footer, I have my text box value of control source =[txt_time_stamp] but it doesn't have the value in it... do you know why ??

Hi RuralGuy, Thanks for your poste. Can you give me some example of using the report_open procedure.... If I initialise a new variable as sting and use this variable in the footer... Private Sub Report_Open(Cancel As Integer) Dim txt_time_stamp as string txt_time_stamp = "Printed the " &...

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

Thanks Gemma-the-husky, I use another program to open my ms access database... An when I open the ms access database directly it works well it respect my dbname capitalization. But when I use the other program that opens my ms access database, the database name is all lowercase... I display...

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

Thanks for your advice I'm working on it. A do event will do the trick. Doris

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

Thanks for your reply. I have found this simple code that do it also : Dim pathname As String pathname = "C:\testfile.txt" mystamp = FileDateTime(pathname) MsgBox (mystamp) This return the date and time of creation or last update. Thanks again for your time. Doris

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

Yes this is refer to a GL number, it should be a text variable. I was doing my comma delimited wrong... now it work fine... "800000000","02.75.20000000" Now, I want to change the , for a ; Thanks all for your help, Dorisr

Thanks Kiwiman, I have an existing table and the format of that variable is text... I tested in my .txt file and when I put this it work ok : 800000000,"02.75.20000000" But Ms Access should assign the value the same format than original.... I don't know how to set that.... Please help me, Doris

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