Search results

I’ve a table (tblFaultCall) with the following fields (example values are also given) strCallOwner / John Doe strCallCategory / MS Word dtmDateOpen / 01/01/2012 (note GB dates) dtmDateClosed / 20/02/2012 (note GB dates) I want a query to tell me the average time it’s taken to get calls...

I need to get my database to run as a scheduled task (using the /x option to run a macro). It uses linked tables. I wrote it on Access 2003 on my desktop machine, but the machine I need to run it off is a seperate machine that stays on all the time. I got the scheduled task bit working on a...

I have some VBA in a procedure that is an event procedure from a form. I want this code to run when Access opens, so I have created a macro with a RunCode event, but this required a function. I've never worked with functions. I added the following just above my current procedure; Public...

Having probs with this. Want to use this to import without an import spec. I've tried; DoCmd.TransferText acImportDelim, "", tbl7480Errors, str7480ErorrsPath, True and also DoCmd.TransferText acImportDelim,, tbl7480Errors, str7480ErorrsPath, True And it just keeps saying "The action or...

Hello, I have searched but cannot find. I have been creating an Access DB to process data contained in 20 exteranal spreadsheets. The format of the sheets is the same. I have gotten everything into one table OK using a loop and TransferSpreadsheet. I've done some processing on it using...

On Access 03, am trying to use this object# Dim appWord As Word.Application Get compile error user-defined type not defined. Which library do I add in the References frame from the Tools menu? I've added the Microsoft Office 12 Object Library, to no avail.... Please help....

Hi, I'm a bit new to queries in Access, and normally use SQL in Ingres to get what I need.I found the most simplest of things to do actualy quite difficult in the Query Design View of Access. Say I have two non keyed tables with exactly the same data structure. There is only one field, a 5...

Have a script which imports a CSV .txt file into a table via a TransferText method and an import spec. The file it always in the same format, same number of fields. However, sometimes a row will contain an excess comma in the name field. This causes the rows to go out of synch when the table...

Hello, first post here and am quite new to this! Have Googled this all morning and can't work it out. I have a form with unbound controls. I have a text box, with a command button at the end which when clicked loads an Open File dialog, which when used inserts the file path into the text box...