Search results

It is OK - solution found Used FormatNumber() in my ASP page

OK, query fixed SELECT tblFaultCall.strCategory, Sum(tblFaultCall!dtmDateClosed-tblFaultCall!dtmDateOpen) AS DaysToFix, Count(tblFaultCall.ID) AS CountOfID, [DaysToFix]/Count([ID]) AS AvgDaysToFix FROM tblFaultCall WHERE (((tblFaultCall.dtmDateClosed)>#5/25/2012#)) GROUP BY...

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've resolved this now, but the VBA referenced a Word Application, and so it had been set on Office 2003 to use the Office 10.00 word library. I now get errors that the VBA can't find this, and so when I go into References to Add it on Access 2000, I get name conflicts with existing module...

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

P.s. when I'd tried the 'new module' solution before, I was simply creating a new module just for the function itself - but said function was trying to 'call' the onlcick procedure from the form - which I think is why it was not having it. Now, the code I want to run, and the function calling...

Thanks, I've amended the OnClick procedure in the Form module to simply call another sub procedure in a seperate module, and put the the function in this new module. This works better. Thanks.

No, I don't. I need to the use the DB for other purposes and so an autoexec macro would not be suitable. Other users use it also. You can run a macro on startup via a shortcut icon with a command line option of /x, and this is my preferred option and I've set up the scheduled task to do this...

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

OK, I needed " " around the table name, but now I get "field NoName does not exist in destination table. DoCmd.TransferText acImportDelim, , "tbl7480Errors", str7480ErrorsPath, True

done that, get a slightly different error, still none the wiser!

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

Thanks, but I'm having problems with the Export Spec. The TransferText was working fine without an Export Spec before. I've created the spec, and named it RentAccExport - my Transfer Text is below; DoCmd.TransferText acExportDelim, "RentAccExport", "qryRentAcc", "c:\output.txt", False...

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

Thanks for these responses. The Unmatched Query wizard acheieves what I want. I also did not know that the Ingres query would work.

Thanks! I'm now getting similar message about ADODB.Recordset ??

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

OK, so those queries will work in the SQL view of the Query Design? If relationships are set up in the design view between the two fields, would this help me write a query to resolve this problem? I could set the fields to be keys with duplicates. Cheers.

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

Unfortunately this isn't an option becuase the CSV is also imported into an Ingres database via a vendor supplied shell script. If we asked the people who provide the data to give it in the format you've asked (with "" around the fields), then it wouldn't import into the Ingres database without...