Search results

My company is using sharepoint 2007. What I did is to open up the directory via window explorer. Access will then transfer the file into it.

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.

thanks so much for your help guys!! It works!

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.

I dun think is the code problem. I may have accidentatly disable a functionality in access that caused this problem.

sorry. Here is what is happening. the code used to work for the last 2 years. It just stop working suddenly. Sub test() Call CriticalBackUps(DatabaseSource & "\" & RawData, DatabaseBackup & "\" & Data) End Sub Function CriticalBackUps(ByVal orginpath As String, ByVal newpath As String) Dim...

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

Bob, Is it possible to use DAO.Querydef to populate a table which is then to be uses in a form? I read that querydef creates a temp query that will not lock the original table. If that is possible, how do i create the code?

All of the subforms are in different tabs. I used a invisable connector to link the subforms to the main form. User clicks on one of the rows in the main form. He then clicks "Get details" button. This fires an event that capture the primary key of the selected row and start processing all...

If I do not use recordset.clone, will using dbopensnapshot help me? I am displaying a lot (and I mean a lot!) of information on a single page(using tabs) I have been using queries and it is taking longer and longer to load. I am trying to find a way make my application run faster.

Hi Bob, Been a while since you have helped me. Happy to hear from you again. I do not have an issue with my table, it is just that there is not enough space to display everything in a single row. There is why I need to spilt half of it to a subform. The details in the subform are meant to...

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

I will try and see, does it slow down your entire computer during this process?

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

It did not really work, I used the below code with my outlook codes to make it work: SendKeys "{ESC}", True SendKeys "{ESC}", True SendKeys "{ESC}", True SendKeys "{PGUP}", True SendKeys "{PGUP}", True SendKeys "{PGUP}", True SendKeys "{PGUP}", True SendKeys "{PGUP}", True 'AppActivate...

My code is to extract the email subject into MS access and allow users to tag that email via MS Access. MS Access will then transfer the tag into outlook without the user switching between outlook and access. The problem is that VBA will not overwrite/update the categories field (it is a...

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

OK, found it. Thanks so much for your help!!!

Dear Coach, I looked through your link but there is not much information that answers my question. Maybe I blind, but can you help me on my problems?