Search results

I have it working. At first I entered the code and rather than being invisible it only made it disabled so I went back and switched out .Enabled with .Visible and it worked :D Thanks for the help!

We make changes rather than cancellations because it is cheaper for our company. We are trying to cut down on costs, and changing tickets rather than canceling and re-booking them is way more cost efficient - and even more time efficient. As for the code you provided you lost me... If my...

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

Thank you for all your help. Your screen shots and sample databases were insanely helpful! :D I have it working perfectly... now hopefully nothing else will have to meander its way onto my forms. Thanks!

Sorry I didn't refresh in enough time to see your newest post. I followed your screen shots and now have it working... but I am a little confused. How would I get them to display on my report? I can't just used the HoteListAutoID right? Am I going to have to do the same thing on the report...

Ok, I copied the code you used in yours and adapted it to fit my naming order... however I only end up the the ID numbers instead of the words... what did I do? SELECT [Hotels].[HotelListAutoID], [Hotels].[HotelName] FROM Hotels ORDER BY [HotelName];

Ok, 1 - That is amazing. 2 - How on Earth did you do it?

Ok... I really hate to sound dumb but you lost me... :o

The sub form would not work because of the way I have all my forms linked together. I do not want to have the Hotels form show up at all. The only reason that the Hotels form should be open is to add another hotel to our list or update the information in in.

Well to be fair I knew on some level she would want more... but I really just wanted to hope that the insanely problematic form was all complete and done with... I had to get lots of help just to get it working in the first place :rolleyes: I attached some pictures of the tables and forms 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...

Wow... The most complex problems are always solved by the easiest answer. I changed the font. Now it works. The other computers didn't have the font I was using, therefore the letters would not work. Wow... O.o Thanks for trying to help! :)

How would I be able to determine what printer driver we are using? I know I am bridging outside of Access here... but when it comes to most hardware and the software related to them I am at a loss.

Ok, I had to wait for my boss to come back from a conference call to test it... and unfortunately it isn't working. I set it to the printer I know we use the most (the default on both mine and my boss's computers) and it still won't work.

This is the code for the button I use to open the report. Is it right? It was made using the Command Button Wizard: Private Sub TravelInformationRptOpnCMD_Click() On Error GoTo Err_TravelInformationRptOpnCMD_Click Dim stDocName As String stDocName = "Your Travel Information"...

Will I still be able to choose a different printer from the 'Print' menu when it is time to print? More often than not I will print to PDF and the others would print to paper.

Now that you mention 'Default' Printer I remembered something when I tried to open the report on one of the other computers. Access said something about the default printer being set to something that the computer could not access. I have access to our PDF printer, but not all computers here...

OK, did that and was doubly surprised. We are using Access 2000 and SP3.

I don't know. How do you check again?

I am using Access 2003. While I'm not 100% sure, I believe everyone has the same service packs. The IT department usually updates all the computers on the weekend and they like to keep them up to date. As for printers, we all have access to 5 different printers or so. So while someone my...