Search results

I would like it to search for the cell without opening the other file. Something like "update information" Reason is because this master file needs to be linked to more than 10 other files.

Hi, I am trying to create a master file that goes into ddifferent workbook to extract data. E.g, I would like VBA to go into Timetable(workbook), into classA(worksheet) in week 32(Column) and Maths(Row) and extract the data in that particular cell. If this possible? Please help.

Hi, I have a problem and wonder if anyone experienced this before. I created column A and the data type is set to TEXT. The information to be imported comes from excel spreadsheet. The information that goes into the column has both text or number. The problem happens if my first entry...

it is a modified MS outlook for company purposes. If it is working at your side, I will have to find another way to send email via access. Thanks for everybody's help.

I took out ".attachment", ".save", ".display" and it still does not work

That line works. ".send" does not.

Hi guys, I am trying to send an email via MS Access using VBA. I am using the below code: MS Access give me this error "Run-time error '287', Application-defined or object-defined error" when it runs to ".send" I have add outlook object in my reference. please help. thanks.

I tried using a different computer and it still did not work. I tried using this code from http://www.rondebruin.nl/files/windowsxpunzip.txt Now the problem with the code above is that my VBA does not recognise "Application.GetOpenFilename", stating that: "compile error, method or data member...

Ok, I will try it and and get back to you guys on Monday. :)

Yup. I tried the same directory with a TXT and RAR file using the same code and it worked.

The code works but it did not find the zip file.

It does not seem to work. I tried with *.RAR and it work. Do I need to have any add-on for it to be able to find *.ZIP files?

Hi, I used filesearch to detect zip file but it does not seems to work. Can someone teach me where did I do wrong in my code please? Dim i As Integer Dim fs, f Set fs = CreateObject("Scripting.FileSystemObject") Set f = fs.getfolder(DatabaseDir) 'Start import...

Thanks man!! May I know how do you know all these functions? I would like to read more about it so that I do not have to keep bothering you guys for such simple problems. :)

Hi, I would like to know if it is possible to display a certain word within a sentence separated by commas. Eg: New York, new york, United States I would like MS Access to show first words (New York) in one column and last words (United States) in another column. I am unable to use left or...

Thanks for your help. I will be taking a look at the thread. As I was waiting for help. I did it in another way. I made VBA to create a txt file, convert it to .bat and use a shell command to run it. In that case, I will not have to shell and wait.

Hi, Is it possible to call multiple instructions (one after another) into CMD via VBA in access without using a BAT file. The reason is because every instruction needs certain values from access itself.

Hi, If there code available to extract one single file from a zip package and transfer it to a specific folder?

Hi, I would like to know if it is posible to export multiple excel file base on fosUsername. E.g. The database has 13 reports. When user click a button, the database will check a "User name" Table and find out the number of file that belongs to the user and export the corresponding files...

It is not about that. Everything is the code works fine. The problem is that Access is deleting the wrong record. It is deleting the first record shown in the form and not the record highlighted by the record selector.