Search results

Hello, I would like to create some code which on a daily basis locates a specific mail message in an Outlook public folder and the saves the attachment. The message will have the same subject text each day. Thanks, Mike

Hello, I'm using the TransferSpreadsheet method in Access 2000 to export a query in Excel format. my problem is that when I open the spreadsheet, there is a ' at the beginning of each cell. Does anyone know of a way to avoid this? Thanks, Mike

Hello, I'm trying to trap error 3022, which occurs when you try to update a record with a duplicate value in an index. My code looks like this: Private Sub Form_BeforeUpdate(Cancel As Integer) On Error GoTo DupWorkOrder Exit_Form: Exit Sub DupWorkOrder: If Err.Number = 3022 Then MsgBox...

Hello, With Access 2000, is there anyway I can read the Windows NT account name that my users would have? Thanks, Mike

Hello, I'm working with a user-level secured database and am attempting to use a second workspace which will give me more access than the actual user who logs in. I am able to create the workspace and add it to the workspaces collection, but I can't seem to reference it correctly: Global...

Has anyone run into the problem with not being able to store a value in a combo box on a form in Access2000 if there are no records on the form? This works in previous versions, but after I converted my database, my combo box doesn't keep the value I select.

I am trying to implement a classic split database (tables in one database, apps in the other) with user level security in effect. My problem is that when I try to use the OpenDatabase method to use the table in the data database, I get an error telling me that I have no permission for the...