Search results for query: *

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

Hey Skip, Thanks for your help, code you gave me worked perfectly.

Thanks skip, I'll give it a try this afternoon.

I have some users on Access 2k who are using an application dependent upon VB scripting. One script calls out getDate = Format(Now(), "yy"). evertime the script is executed the program stops on this line and retuns the message "Can't Find Project or Library" is there a work around to this...

Thank you for your input PH, unfortunately I couldn't get your solution to work either. I finally created a new form that included all the information without the subform and used that as the source for the email. I hid the new form so the method is transparent to the end user. The only...

I am having an issue where I am trying to send out an email with information from a form. However, the main form has a subform with important data I also want included in the email. When I use the code the below I get error messages regarding object property can't be found or improper usage...