Search results

I've been designing a database in access for monthes now. Being close to finished, I began rolling out to multiple workstations when I encountered a new problem I have never seen before. I will describe, and if possible can someone tell me if it is a problem with Access or Network issues...

Recently I developed a check printing DB for a travel agency. This worked wonderfully, providing I was able to set the paper size to (user defined Paper Size). This weekend I was setting the DB up on a new computer, with the EXACT same version of MS Access 2000. I don't think I did anything...

Hi there, Im using dlookup to search for values entered into 3 texts boxes. When one of the values isnt found, I get a 2471 Error and have to push end to move along with the data entry. What I want to do, but cant seem to do it is: I want the error to generate my own message box, then when...

Do access reports, allow you to set a specific print area like in excel? I print cheques all time in Excel, and they stop right after the print area (that i manually set). However in access, the report forces the printer to scroll, therefor disrupting the check below the one being printed on...

Hey all, I am printing cheques, and I cant figure out how to have the printer not scroll into the check below. Its a tractor feed printer, and I need to only print the detail portion then stop, not scroll. Any ideas? I tried inserting page breaks but i think i did it wrong. Please help if...

At Home I am using Access 2002 with Windows XP. I am designing a DB for a Travel Agency. They informed me that I was going to design the application for the same platform. However when i got there with the finished application, they were using Access 2000 with Win 98. Luckily my program worked...

I got a Listbox in my report that displays LAstname and First name like so: Lastname | Firstname Basically is shows the two columns (fields) next to each other. Is it possible to change the format so I can display it as, Lastname/Firstname I cant seem to figure out how to do this. Second...

I have a report that prints cheques, it works great. It is based on a 3 table query. It displays the Cheque, and payment details after. I then added a subreport, to show how many passengers the cheque is paying for, this is done by associating the invoice ID in the invoice table to the...

I was wondering if anyone uses a template to print cheques through access? Has anyone had to do this? Is there a report template you know of? What would be the best way to do this? Use a report? Any help is appreciated. Thanks Jordan

I left clicked on one of my querys and set the property to hidden, I cant figure out how to find it now, is there a way to see the hidden queries? so i can set it back so I can view it? Thanks. Jordan

I have 2 destination Tables: The table looks like: Code Airport1 Airport2 Airport3 Airport4 Airport5 AP1 $ $ $ $ $ AP2 $ $ $ $ $ AP3 $ $ $ $ $ AP4...

Ok Ive completed my inputing and recalling data features, now its time for me to hit the reports, it seems I need a little direction is someone could give me some:) All I need to know is at what level do I SUM currency data if I need to display the total amount of all records of payment. For...

Hey all, I have 5 Text Boxes: 1: Name 1: 2: Name 2: 3: Name 3: 4: Name 4: 5: Total Number of Ninja's: What I need to do is, I need to check if each of the first 4 text boxes (names 1 through 4) contain data, if they do, I need to add a count of 1 to the number of ninja's box. The name...

I have a problem, I need the user to enter in 1+ passenger names, then I need the number of passengers to be automactically calculated so Billing is not skewed. My problem is, I was using a large Text Box to store the multiple names, I thought I would be able to separate the values and count...

Is it possible to disable the scroll button on your mouse so it doesnt make the records scroll and instead allows the user to scroll down the form? Thanks, Jordan

First of all Thank you Jon K for replying so quickly to my last post, Here's is my new question:) I have a combo box that the user will select which airport they want to go to. Above it I have a label that says Description: What I want it to do, is Say : Description: <airport name> Depending...

Hi there, I was wondering if its possible to use a text box on a form to do a parameter query instead of access prompting the user? I would the User to be able to enter a phone number into the top of an invoicing form and for all the client information to appear below it. Because I am using...