Recent content by Stitcho

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