Search results

Hi, I need to upload many different kind of files (e.g. doc, jpg, zip, xls) to my company's web server. Problem is that the server keeps prompting for username and password. Is that anyway, using vba, to provide username and password for uploading files to a web server? Thanks.

Hi, Can anyone teach me how to create and edit a text file usinb vba? I am unable to be use: DoCmd.TransferText acImportDelim, , "tableName", "c:\test.txt" as I am not apeending an entire table.

Hi, all of my vba code that I have programmed is not excuted. MS access just run through it without doing anything. Has anyone experienced this before? This is one of my sample code. Even if I "Step into" (F8) my code slowly, it does not work. Did I accidentately disable something...

Hi, I am wondering if this is possible. I have form A, user select one of the items in the table and click a button "Get details" The button will get all corresponding details and display it in a subform (let's say form B) using SQL. Problem is that the SQL locks the recordset since it is...

Hi, I am trying to create a .findfirst in my recordset based on the subject title of an email. My problem starts when my subject has special character such as ', '', ", "" and MS access gives a "missing operator" error. Has anyone had this problem before and how did you work around it? My...

Hi, I am trying to do multiple updates in the "Categories" field column in the outlook 2003 using MS access. The code that I created in VBA works fine only for the first email that is currently highlighted(or selected) on the explorer. Is that anyway I can make the selection move down...

I have finally manage to get MS Access to interact with outlook (getting subject headers, attachments, edit categories fields) but soon realise that a new problem has emerge from this. My outlook exchange server in my office is so unstable (don't ask me why, I know nuts about it) that when MS...

Hi, I would like to find out if there is anyway that VBA is able to extract / edit mail details. Details such as time stamp from "Received" column The name of the person who sent the mail Is it also possible to edit the field under the "Categories" column

Hi, If there anyway where we get use system time to calculate country time? E.g. I have a form and a text box. I enter the country's name or code (JP) into the text box and access will display the current time in that country. I read about GetTimeZoneInformation in MSDN but do not think...

Hi guys, Is there any way to create a VBA module that runs certain shell command when user startup / shut down / log on / log off windows? Thanks!!

Hi everyone, I would like to know if VBA is able to track user activity on the computer? Things like Idle time (similar to "away" or "Idle" in MSN), or to know if outlook, excel or word is open on their computer. If so, how do you do it?

This is the first time that I encounter this problem and I do not know the source of it, I hope someone can shed some light on it. I was using .lookin for a file search With Application.FileSearch .NewSearch .LookIn = f.path .SearchSubFolders = False .filename = "*.txt" .MatchTextExactly =...

Hi, I am trying to create a form with two subform in it. When users click on a row in subform A (datasheet), the row will change colour and the details will pop up in subform B (datasheet). I know this is possible as I have seen it in this forum a year back. I have search in this forum but...

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

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.

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

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

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?