Search results

Are there any Access programmers in Finland interested in some freelance work on a small company database? I can forward details to anyone interested.

Is it possible to have a specific form to open automatically whenever an Access Database is opened for the first time? How ..? Thanks ... Steve

Hi Shay, So nearly there with the price calculation thing - I transferred all info over to my main database and made the tables, changed the names etc. I put in some text dates and got the following : Compile Error : Method or Data Member not found. Checking the code, it stopped at...

I am developing a database for a travel company. Attached is a small test part of that database where I am trying to input dates of hotel stay in a form and have price of stay automatically calculated. For some reason the code used in the Form "Hotels Frm" does not work and I get a syntax...

I am developing a database for a travel company. I have a form called "Orders" with general details about customer and a "OrderID". A sub-form to this is "Order Details" listing the various itmes of the order, ie hotel stays. In the "Order Details" sub-form I want to put the Supplier name...

In the message posted below "Price calculations between dates", Shay has kindly made a sample database which seems to solve my problem. however, on runnig a command button I get error messages. Shay made the database in Access 97 using Windows 95. I'm using Acess 2002 on XP ---------- could...

I am trying to calculate the price of a hotel stay, for example, between 01 April and 06 April, when the price of the hotel room is 50 USD on 01 and 02 April, but 75 USD on 03, 04, and 05 April. I want to go to a Form, input the dates of stay (eg, 01-06 April), the hotel name, and then have the...

I have a Form which is used to input Orders, and a sub-form to that listing the Order Details of that order. What I want to do is create a Report that will extract just the information from one of those order details, and nothing else. Ie, I want to show a report with the details of just one...

I am making a datbase for a travel company and want to add a command into a Form where the Order is kept, a command which will preview the invoice for that particular OrderId. I can't seem to manage to do it - just for the specific OrderId I am working on. Any ideas? Thanks

I am making a database for a travel company. When a new booking is being added I want to choose a Product, such as a Hotel, and have the price for that product automatically appear when its selected. ie, Mr Smith makes a booking at Hotel Sunshine - I go to the "Orders Form" and start...

Can anyone tell me what the code DISTINCTROW means?