Recent content by phn

my database does this too, it seems to have a mind of its own though as it only happens sometimes. no idea why :>

Woohoo I got it working using the steps you described above, thankyou!

What I meant was a report. When the user selects the options in the form it generates a report, but there are 2 reports. My command button current prints a report based on the data in the current form, and also the kit checklist which is named rptPD170, but I have specified this form to be...

php + mysql would be the most appropriate way since it is going to be web based, it is also the most common.

Hi I need to print a specific form based on the selection made on a combo box. I have been able to set it up to open the relevant form when the user selects an option from the combo box, but am unable to find a way to be able to print the specific report based on the selection. I have a...

small world, i live in hull too! where abouts are you?

I'll explain a little more... As you can see, there is the add form with the pop-up form over the top which appeared after I selected the PD170P kit type. I could just put a Print button on the form and print from there, but I would like both the booking form and the kit components form to...

Hello! I have almost completed my database, everything I had originally intended to implement into it has been done, with some extra added features I popped in along the way. There is just one more thing I require assistance with... My database is used for booking camera kits in and out. On...

right you are, such a simple thing and yet i couldnt work it out.. im a noob at access! thanks for your speedy help, much appreciated!

I managed to do what I wanted to do, simply by adding acLast to the On Open event of the form. I would have liked to have been able to print the booking from the current form, but I cannot seem to do it as it prints a report of only the current record, and if I attempt to print from the add...

i dont think so. maybe i should explain a little better. form1 = add booking form2 = print booking the record added in form one must be opened up automatically on form2 when a button is clicked. I have searched these forums, viewed ALL of the relative threads, and I can not find a solution...

Hello, I have created a booking system for loaning of camera kits. I have created an Add Form which lets you add all of the information of the booking, I have also utilised a command button which opens up another form with the option to print a report based on the current record. However...

Hey guys, I'm not sure if this is possible, and it is the most challenging thing that I have tried to implement into my database to date. What I have is a booking form which allows you to Add Bookings for camera kits. When a customer comes in and would like to book a kit, the form must be...

Hi, I have a database for booking equipment in and out. I have the backend stored on a shared drive on our LAN, and the front end on each client machine. The database has been working fine until just now, it runs very slow and my DCount functions have stopped displaying data. I have no idea...

Ok well I could use a Report, but your reply does not answer or help me with my question, please help further :) Add button must add record AND print form/report/whatever :)