Recent content by i1055

Has anyone else experienced slow performance running Access on NT 4.0?<br> <br> The processor is a PIII 550 and there is more than enough RAM (240 MB).<br> <br> All other applications run substanially faster but Access actually seems to be running slower now on this computer with NT 4.0 than it...

error occurs in access when i try to run the macro, i have a macro that runs the function using the runcode command<br> <br> in the module the only thing that is in the module is the function...do i need anything else?

doug, the function worked fine the first couple of times, but today i received an error message : Run-time error '3274' External table isn't in the specified format.<br> <br> i double checked the code and it hasn't changed. is there anything i need to do in the macro that calls this procedure...

doug, the function worked fine the first couple of times, but today i received an error message : Run-time error '3274' External table isn't in the specified format.<br> <br> i get this error message the first time i run the function, but when i close the error message and run it again, it works...

i have done exactly what you said, but for some reason the next day everything reverts back to the default printer.

I have a simple macro that prints a report, however it prints to the default printer and I would like it to print to a specific printer. I have gone into the page setup of the report and changed the printer to the specific printer that I want, saved the report etc. and it prints to the printer...

Doug, thanks for the quick reply, the function worked perfectly, although my inexperience with modules, functions, etc. caused me some grief.<br> <br> Thanks again.

I am outputting a simple query to MS Excel using the OutputTo action in a macro, my problem is that the file is created in Excel 95 format and I would like it to be in Excel 97.<br> <br> Once in Excel I am able to change the format, but I was hoping there is a way in Access to have the query...

Could someone please explain what causes the &quot;numeric field overflow&quot; error??<br> <br> I have a table with no more than 250 rows, 4 fields, and I set up a select query to exclude certain criteria and sum one of the fields, and I receive the error. Oddly, if I make any change to the...

I've been using Access for about a year and feel I have come to a standstill. From reading these tips and questions I notice many references to SQL.<br> <br> Could you briefly explain SQL as it pertains to Access and also recommend some ways/resources that I could learn SQL?<br> <br> Any help...

If I have a formula in a field (w1:h1+g1), and i want to extend this formula out to other fields (w2:h2+g2)(w3:h3+g3), etc. etc....is there an easy way to do this???<br> <br> thanks