Search results

Hi, In Access 97, I'm able to use Database but Access 2000 is giving me problem. Please advise. Dim MyDB As Database, MySet As Recordset Set MyDB = DBEngine.Workspaces(0).Databases(0) Set MySet = MyDB.OpenRecordset("Sorts", DB_OPEN_DYNASET) ' Create dynaset. Regards,

Hi, I'll rename a folder call daily to system date but sometimes it is in use by the user and thus fail to rename, how can I wait until the file is not in use and then rename it? Please help. Tks!

Hi, Thanks!! Pono1. How abt if it is the other way round? Meaning now I have File1.001 File2.002 File003.003 I want to rename the filename to NEW.xxx. Thanks,

Hi, I have the following files : 1_20030704_file1.dat 2_20030803_file2.dat I want to do a global rename as the file name is not fix. In dos I can do ren *.old but how can I do it using MSAcess. Tks,

Pull query by month Hi, I currently have a date field and I want to pull out base by month, every month I need to report data as of the ending month. For example today is 09-Apr-03 and I want all records that is ending month of 31-Mar-03. How can I do this automatically? When I use the...

Hi, I help to do the following: I need to monitor for a file in G:\test.pdf. If the file is there then copy if to C:\test.pdf. If the file is not there is will wait till it is there then copy to C:\. How can this be done? Thanks.

I have 2 table how can I delete records which is found in table 2.

Hi, I have some data , for example ABCD EFG &OR SDDFAADD &OR AADDD BBBBBB &OR How can I remove the last 3 character. I cannot use Left or Mid as I cannot determine the number of character. Please help.

Hi, I need to copy the first 10 records to another table, how can I do that using query. Thanks,

Hi, How can I autonumber one column with odd numbers and another column with even numbers. Thanks,

Hi, I have a field which contain for e.g 123445A, 125344B, 933456 How can I filter out those that with an ending that contains character? Character range from A-Z. Thanks.

Hi, I have the following records in 2 fields (Main and Joint_Party): Main Joint_Party 1234 4567 1235 7890 1236 3345 how can I make the Joint_Party into another record that is right after the Main, like : Main Joint_Party 1234 4567 4567...

Hi, I have a text field, how can I use query to filter out those have more than 7 character. Thks,

Thanks! I will give it a try.

Hi, how can I display the month in weekly format. For example the month of october (does not include Sunday) Week 1 : 01 Oct 02 - 05 Oct 02 Week 2 : 07 Oct 02 - 12 Oct 02 Week 3 : 14 Oct 02 - 19 Oct 02 Week 4 : 21 Oct 02 - 26 Oct 02 Week 5 : 28 Oct 02 - 31 Oct 02 Next Month November Week 1...

Hi, I have the following file in c:\check ABC_01Sep02_01.TTX ABC_01Sep02_02.TTX ABC_01Sep02_03.TTX I need to rename all to the file to ABC.TTX. How can I read the file one by one, rename the first one and copy it to another directory, delete the first file and then process the second file...

Hi, I have a comparsion in month, for example : Dim Test as string Test = "Aug2002" if test = format(date, "mmmyyyy"). ' this will only get the current month, how can I get the previous month? Thanks,

Hi, is there a way to make the date all in caps, I'm using in the format dd-mmm-yyyy. This give me for example 30-Jul-2002 but I would like it in 30-JUL-2002. Tks,

Hi, does anyone know how I can retreieve a particular mail from Lotus Notes with an attachment, let say call test.bat and automatically detach it onto my disk. Thanks,

Thanks a zillion, this is what I'm looking for.