Recent content by WAR40K

Thanks, I'll give that a try. Last night I discovered that part of my problem was with field type. I converted all my numbers to text so the export wouldn't try and "correct" my output values.

I've run into a problem where I have two requirements for a *.csv file created from an access table. First, I need it to be comma delimited, without quotes around text fields, and secondly it needs to be a fixed width. With the TransferText method it seems I can do one or the other using the...

Not to hijack this thread, but I have used the Security wizard on a couple of database applications I have built and it has been nothing but a source of frustration. Not every user has the same version of Access, there are problems added new users, permissions are a hassle, when all is said and...

I don't know if access has a built in logging function, but I created a log of my own to track user activity. I created a table that would store the user name, action (Modified, deleted, or added), what table the acted on, which record was affected, and when they did it. see this thread...

I use a public variable set in a module called pubVariables. i.e. Public UserID as string then when the user opens the project i capture their user name from windows: UserID = Environ("UserName") then I use UserID throughout the project to log user activity. i.e. if John Smith's windows...

I would like to use a pass through query to pull information from an SQL 2000 database on a remote server and populate an Access 2k table with the data. For example, I have one big table in the SQL database which contains Customer contact information, and some Request for Quote information. I...

You may be able to update if you define each of the fields in your query individually rather than using the asteriks. Many times Access can't perform certain functions when the "all fields" method is used. It will take less time to redefine your query identifying or selecting each field...

Kjv1611, Tried your method, compile hung up on the "Format(getYear,"yy")". I just removed that functionality as it doesn't affect the day to day operation of the program and will deal with it at some later date. Thank you for your help.

Here is the full code, maybe it will help. Note: year is a text field and ccr_no is an integer Dim email, emailCC, ref, origin, destination, notes, strBody, order, record, part, sn, strSQL As String Dim rs As Recordset Dim db As Database Dim getYear, currYear As String Dim ccr As Integer...

yeah, I'm storing it as a string i.e. DIM getYear as String. then getYear = Right(Cstr(Year(Now())),2) Then when the event triggers execution, i get a compile error "Object or Library Not Found" I'm at my wit's end. I figure it should be standard since the method is in the help file, but...

I continually get an Object or Library Not Found message on all computers that do not feature the XP version of Windows. An upgrade of VBA or Access did not solve the problem. Any thoughts?

I have a variable getYear in which I would like to store the year as 04 from a string 09/17/04. How would i do this? Can it be done without using the "RIGHT" or "FORMAT" methods? I keep getting errors with computers that do not have xp installed when I use the "RIGHT" or "FORMAT" methods. I...

thx

Can I upgrade the library w/o upgrading Access?

Uh...I have a user with Access version 9.0.6620 and I'm getting the "Can't find Object or Library" message at the "Right(Cstr(Year(NOW())),2)" any suggestions for another workaround, or am I missing something basic? by the way, I'm still storing the value in the variable getYear (which is...