I'm attempting to script/somehow automate batch removing ~2700 different attachments that have been added to a db that I manage. The records are located in...

I posted this a few days ago, but Don't think I explained myself very well. Can anybody help me with this issue. I am trying to select an item from a pick...

I have a large amount of data in onecolumn and i want to move it to columns. how can i do this easily? -- JOE

I just upsize an Access 2003 back-end to SQL Server 2008. I have a table with only 1 record to use as "traffic light". When I need to get a new Invoice...

I have created a form in Acces that is a main menu. When I click on the database icon I want the database to open in the main menu form. How do I do...

Recordset too large? Hello, Using Access ’03… I have some code below that’s in a form module and opens a recordset based on what’s on the form. The code...

Hi, Gang, I am looking for help in parsing out a file name from a file path. I'm using the GetOpenFile api for users to choose the file path, which is what...

Recently when I try to compact and repair my 2003 database it starts to process and just freezes. No messages just freezes halfway through. Any...

No matter what I've done, code quits running after a record deletion (even a simple Msgbox "OK" to test after the deletion does not trigger). Relevant (?) form...

In the err_handler of my procedures I use: Call ErrLog("frmMyForm", "Form_Current", "Error " & Err.Number & ": " & Err.Description) I noticed that I can...

Is there any way to convert a file created in Access 1 to access 2000?

On the main form are several control buttons that open different forms that then open other forms and reports. All this works fine. But I would like to...

Tryng to add a formula for a field in a table. In the property sheet all i see is the General tab. Where are the rest of the tabs? (Format, Data, Event,...

Has anyone automated the importing of Fedex tracking numbers before? How did you do it?

The "Opening" Form's "Focus" (Titlebar) becomes Dimmed when running this code... .... DoCmd.OpenForm "Parts": DoCmd.Close acForm, "Opening" When returning to...

I have a macro built that copies an access database created from outlook containing contacts. I need to copy the outlook table (Contacts) to my system mdb...

While entering data into a form and I come up to a lookup box and try to put a new item I always have to navigate to the form the lookup is based off of...

I have a Bluetooth enabled Laptop & I have 2 Bluetooth enabled mobiles named as AX1 & AY1 My Laptop display these mobiles in main window of Bluetooth as...

Hello, I have created a MSaccess database in Office 2000 format over a year ago. This is a multi-user enviroment and multiple users can access at the same...

I run a series of queries each month in an access form that I have created. I can export the data into a new excel spreadsheet no problem. I am just...