Search results

Hi! Ok, this was working - and does work in another database I made, however it is no longer working and starting to piss me off! :mad: I made a form where when a check box is checked, all relating fields will become visible on the form. There are three of these on the form, each making...

I made a query to pull records by their date. (Criteria: Between [Start Date] And [End Date]) Now I was wondering if on the report I am making for the data pulled by the query if I could somehow make the data entered into the criteria (pop ups before the report is loaded) appear on the report...

This is so stupid... grr.... Ok... I am trying to make a simple query to pull records with dates between the start and finish date specified by the user. In the date column under criteria I put Between [Start Date] And [End Date]. It does nothing! I enter say the first of this month and...

Is there a way to have a form open to a blank record so that way you can skip the step of either going all the way to the end or hitting the [>*] button? I still want to be able to access the other files but it would be easier to have it automatically upon opening go to the step that most...

Ok... I am making a database with four forms that record details about changes and new bookings different from our original schedule that we make for hotel bookings, rental car bookings, taxi/limo bookings, and airline ticket bookings. Each form has 3 check boxes: Is this booking new? Was...

Hi! Google isn't helping much with this problem no matter how hard I look. Ok. I have a form I am making to record changes we make to our regular employee travel bookings each month - and technically it will be four forms (one for Air Travel changes, Hotel changes, Rental changes, and...

Ok, I am becoming increasingly thankful for this site! I few days ago I made a report that uses sub forms and expressions to 'report' in letter form an employee's trip information. My boss was really happy and liked it, and I thought that was that but late yesterday afternoon she asked for the...

Text boxes on report are squished and don't display properly? Seriously confused. Ok, I have been making reports for a database that will be shared between all the computers at my company's main office. I have about 6 or so reports that will be viewed daily by everyone. Every report looks...

Hello everyone! Back for more help: Here is my problem now: I am trying to add up the complete costs of the tickets we book so that we can produce a report to our accounting department. Using Google I figured out how to get the totals for each "ticket" (The 1, 2, or 3 legged trips going only...

Hi, I have been making a database to record employee travel - which at first I was trying to make all my information fit into one little form (disaster as pointed out by many). I fixed that and now have many different little forms all linked together and displayed neatly and with a lovely...

I'm just full of questions today! Ok, I want to add a switchboard to my database so I can make it more organized and user friendly for all my other coworkers who do not know how to use Access all that well. Using the 'Help' Function in ACCESS itself, I found the step by step instructions...

Hi! I have 3 command buttons on one form each to open different forms themselves... but I cannot for the life of me get my VB code for them working. The command buttons are: BookedAirTravelCMD BookedHotelsCMD BookedCarRentalsCMD The forms I want opened are: BookedEmployeeAirlineTickets...

I made a form to record information on employee travel. Each record has a request number, six (6) flight information sections (ariline, flight number, confirmation number, depart location, depart time, arrive location, arrive time), one hotel (hotel name, hotel confirmation, check in time...