Search results

I have a database that tracks client contact and I have a report that I want to print that shows all the contact a rep has had with the client. I enter the start and end dates I want and the reps name and when I run the report its listed in date order so I might have Jane Doe - 10/1/06 then...

that means one of your users has opened and converted the backend database, That was my thoughts but I have both 2003 and 97 (each on different machines) and when I tried to opent he "be" in 2003 it said it needed to be repaired so I did that and the it asked if I wanted to convert it so now...

Husky, I did split the database if that is what you mean. The data side is what is giving me the unrecognised format message.

We have both Access 2003 and Access 97 users on our network and i have a database that is written in 97. But lately we've been getting unrecognized format when we open it. So my guess is someone out there is opening it in 2003 and converting it. Is there a way to tell the database to ONLY run on...

AWESOME THANK YOU worked great

I'm in design mode of the append query but I don't have an Update to field, I have Field, Table, Sort, Append To, Criteria and Or. Whe I tried to put /100 in the Append to field of the "Amount" column I get the message "The INSERT INTO statement contains the following unknown field name: '/100'."

Well I'm not familiar withthis so I'm having a little problem. I've started creating the append query but I'm not sure how to do the calculation part. Can you tell me what I need to put where in ther query? Thanks

I'll give that a try. Thanks so much for your help on this!!!

So your saying it can't take the last 2 charaters and andd the decimal before them? Where should i do the divide by 100. inthe query or on the form? When this is all done I need to export the data back into a fixed width text format file so I need that value in the filed and not just calculated...

I'm having a problem getting imported data to display what I want. I'm importing a fixed width file and one of my fields is a currency amount. The field value in the file is 12 characters with the last 2 as the cents (000000544990) I have my access field type as currency with 2 decimals (and...

I don't have Microsoft Word anything listed. The closest is a Microsoft Office 8.0 Object Library. I tried that and it appears to be working. Thanks for all your help. I would really be lost if it wasn't for you guys!!! Thanks again

I did that and this is what I get MISSING:Microsoft Word 8.0 Object Library C:\Program Files\MSOffice\Office\MSWord8.OLB I checked the path and that MSWord8 files isn't there on the XP bax but is there on the 2000 machine. Do I just copy it over (I get access denied when I try ot copy) or do I...

I'm having a problem getting a form to open. I'm using access 97 on on XP machine and whan I open my database I get Function isn't available in expressions in query expression '[Case Types]![theName]&"-"&Format([SourceDocs]![CaseNumber]&"","00")&"-"&Format([SourceDocs]![CaseYear]&"","00")'...

THANKS that did it!!

In my database I track a program called Bridge. Once you open bridge you can have anywhere from 1 to 7 "Sessions". Each bridge is assigned a number IE LT175A. If there are mulitple sessions they are numbered LT175A, LT175B, LT175C etc. I have a check box in my database that shows if bridge is...

Are there any other options or is this going to be a lot bigger deal than I anticipated?

Thanks for the info, I looked through several of the posts and they all seem to be more detailed (supplier, dates sold, items received) that I need and not being an access expert I'm getting confused. Is this a lot more complicated that I think it is? my thinking is enter code that does on click...

I'm trying to create a database that we can use to track Vacation, Sick, and Personal days. It's a very simple setup, for each option I have a start value a place to enter the amount used and and expression field that calculates the time remaining. My query calculates the difference (Expr1...

I had this database working just fine and I haven't used it for awhile but now I get and error. Here is the code and error any suggestions? Private Sub QuickSearch_AfterUpdate() Dim db As DAO.Database Dim rs As DAO.Recordset Set rs = Me.RecordsetClone rs.FindFirst...

This is AWESOME!!! Thanks for the help it's working great. Just out of curiousity what does the /N,/E, at the end of the explorer.exe line do?