Search results

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

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

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

I know this question has been brought up a million times on here and I have done searches but everyone always refers to using the Workgroup Administration within Access to provide user level security. I have a database which uses this type of security but basically it is a complete pain in the...

I have a bit of a dilemma in my related tables (screen shot of relationships attached). Basically at the moment I am using a 1-1 relationship between my tables using the primary key of CYID. The CYID is populated using an auto number at the moment but the problem I have is if the tables become...

Im looking at creating a database which includes some sort of diary system but I havent got a clue where to start, how to structure the tables, etc. I am new to our company so I am looking to streamline some of their processes. Basically there are 4 people in our department and at the moment...

I have on one of my forms a tab control with 5 different tabs on it. Each of the tabs has a different set of fields but all from the same table. I was wondering if it is possible to hide a tab if none of the fields on it have any data in? So for example tabs 2 and 3 have data on them but tabs...

Hi firstly I want to say I am not a programmer or anything like that, I know enough about Access to get me by with simple things but after that i get a little stuck so please dont baffle me with loads of technical coding terms :D Ok..I have a database with a form where the users enter a subject...