Search results

Would writing it to PDF do the same? Set up a PDF printer (plenty of free ones out there) and just use a print button to print the form as it is. Not sure if it would work exactly but might do what you need

Your best option would be as suggest to develop a PHP or ASP website. I am not familiar with ASP but have built a few database driven websites in PHP. PHP is goof because most stuff associated with it (i.e. PHPMyAdmin and MySQL) are open source. You can get tools to upsize an Access database...

For anyone who may be interested here is the completed DB structure which is up and running and working perfectly (well nearly but thats a PHP issue)

I've got a project similar to this coming up but it is mainly going to be for external client use. I've knocked this together quickly (see attached). Not sure if it the best way to do it but maybe a good start. Im still very inexperienced when it comes to DB's so I may be completely out lol

If you want to pop me a message with your exact requirements I will take a look for you. I have a bit of time on my hands at the moment so I can see if I can knock something together quickly for you. Dave

Thanks I'll have a search. Im not at that stage yet though, im trying to figure out how to get the bands section to work. I have added a primary key to the tblBandMembers table called BandMemberID but I dont really know how to link it all through. I think my question my be better directed at...

Thanks for all your help Chris. The member can be in multiple bands so I wasnt to sure how this would work in the BankMembers table. The Band field in the Bookings table at the moment is just going to be a text field that they enter when booking and is not mandatory for them to fill in when...

Nope they arent going to be able to book a slot. What they will see is a Google Calendar showing all the bookings/time slots. Next to the calendar will be a form they can complete to request a booking at a specific date/time. This will insert into the DB and fire off an email to the studio...

Thanks for your reply Chris. The bookings part is only going to be used for booking enquiries (sorry should have explained that better) but I need to record each of the enquiries in the DB. I have actually been working on a solution this morning and think I may have cracked it but any...

I am currently building a database and I am wondering the best way to do it. Basically I need to record booking information about 7 different studios. The way this will work is that a club member will log into their account, pick the studio they want to book and then fill out a booking form...

Thanks, I'll take a look at that some time. I have actually decided not to convert the database I am using now and have created a new database from scratch and then do a data migration, mainly because I am changing the structure of the DB

Thanks i'll take a look :)

I've just read through that article which has helped but im a little unsure of which programs to use to do the conversion and unfortunately I dont have the time for trial and error like I normally do as I have a very short deadline on this project :(

Im currently looking at converting an Access database to MySQL and I have been reading bits and pieces on the internet about how to do it but im a little confused to the best route to take. Its only a very small database with 3 linked tables that tracks membership details of a club but I need...

It certainly is possible depending on your programming knowledge. I used to work for a company who made a web integrated piece of software for hotel reservations and they used .NET technology. As long as you have a sound database for the back end then you can build a web front end around it...

OSCommerce is definately one to look at. Its very easy to install and configure and lets you handle all of your order management, products, paypal integration, etc, etc. There are a whole host of templates you can buy to fit in with it as well if you are not really up to doing the design...

Thanks for all the help. I have been trying it out in Excel first and it seems to work fine. Now that is all fine for one of the reports I have, the other issue I now have is for a different report. Basically the calculation is going to be the same be it needs to be broken down in more...

Ah right, didnt think it would be that simple lol I'll give it a try :rolleyes:

Im not sure if this is best place to put this but... I have a table where date and time is stored in one field. It is stored in the following format: dd/mm/yyyy dd:hh:mm:ss The way the table works is that the date & time gets associated to a status code in the system. So for example a case...

Hi, Im looking to create some data access pages but just have a quick question about searching (hopefully). I can create the data access page linked to a query no problem and if I run it from within Access it opens a search parameters box that I can put my search criteria into. If I run the...