Search results

Not sure what you mean "Substitute the Location string with the name of your text box" my text box name is "text11" the control source is "Hardware Table.ServiceTag#" Getting: Runtime error 53 File not found error

Hi All, I have a inventory database that I (with a lot of your guys' help) created. We us it to track our computers, hardware, software, users etc. We have Dell computers and one of our fields is the Dell service tag. We are very archaic when it comes to remote access (if you can call it that)...

I ended up doing something different.

In reference to #1 So how do you get a report to print out say 5 pages? Thanks. I'll give the code a try

I'm fairly new to reports inside access and I have 2 questions. 1. I have taken an 4 page appraisal form and created it in Access. When I design the report I can only get the body section of the report to 22" which interns prints on 2 pages. I have another page I need to add but I can't get...

Here it is I've attached the zip file

HELP!! I'm going insane We have recently started a "library" at my company and they have asked me to create a database so we can check out the books. I have started this project over 3 times now and I'm starting to go nuts. I think I need someone to look at my "Foundation" and see where I'm...

No Go Thanks dsmaj but I'm still having a problem. I'm getting Microsoft Access can't find the field "Name" refered to in your expression. (my mistake it is called Name not EmployeeName) if I rem that out I get the same thing for "Department". I know the names are correct. Again if I go to type...

I'm working on a program for checking in and out books for our companys library. I have a couple check boxes for whether or not the book is in or out. when you click the check out button the check box automatically changes to out and todays date is entered in the out date field (ODATE)(Date/Time...

Thanks charityg, I got it I'm sorry about the confusion (I was never notified that there was another reply). I'm running 97. I got the zips dowloaded I'll take a look at them. Thanks again!!!!!!

Any help with what the code should be? I can do a little more then spell Visual Basic but that's about it.

Hi all I've been searching and reading all morning on how to send an email through access. All the examples I've seen seem to do a lot more than I need (or atleast more than I think I need). I could use a little help getting started. Here is my scenario I'm working on a "Library" database. I...

That's what I needed Thanks!!!! How about this one... is there such a thing as a If...And...Then statement? If a = True AND b <> null then C

I have a tab form which I use to track computer hardware and software along with a few other items. On the software tab I have a yes/no box for a specific program called Bridge (Field is called Bridge). Each person that has Bridge is assigned a specific Bridge id(s) (LT001). What I'm trying to...

I have a table that has several records that are duplicates. Some are duplicated many times. I have a query that finds the duplicates but now I want it to delete all but 1. For instance if a record has been duplicated 4 times I want it to delete 3 records and leave 1.

Hi all, I have a database that I use to track computer inventory. The computers are assigned to users and the users are assigned to departments. I want a report that says the Tax department has 6 computers, the Auditors department has 12 computes and so on. That is all the information I want...

I have an Add Record Button with the event procedure that I want to use the setfocus optin but I can't remember the format me!setfocus????????? Thanks, Rick

Hello All, I have a Inventory/Workorder database that we haven't done a very good job of keeping the inventory side accurate. Plus there were some design flaws. I have created a seperate database that has fixed most of the issues that we have and I want to take the valid inventory from our...

I GOT IT!!! I didn't see the note that said "You'll need to set the LimitToList property to Yes, also." So it's working!! You guys are awesome!!!! Rick

Thanks I think we're headed in the right direction. I copied the code into the Event procedure on the Not In List event. However it doesn't give me an error or anything. I enter in my course name that isn't in the list and I get the same thing prior to having the code. I figured I should at...