Search results

Hi, i was just wondering if the split form feature in Access 2007 is compatible with other versions of Access. I have the database saved in compatibility mode, but i was wondering if the form will work with access 2003 or Access 2000. I have tried finding out on the Microsoft Support website...

Hello all, I am trying to dispay results in a query which is based upon time. e.g. Sample data - class and class start time Class one - 7pm Class two - 7pm Class three - 7pm Class Four - 8pm Class Five - 8pm Class Six - 9pm Class Seven - 9pm Class Eight - 9pm Class Nine - 9pm If i was using...

Hi, I have a question. I have a form with details of a people on (Such as forename, surname and the such like) I also have a button to open another form (which pops up on top of the original form). On this form is other details (Such as Medical Details) No matter what record im viewing on the...

Ok, i have a question about update queries. I have two tables (I'll call table 1 and table two for simplicity) and an update query. I want to get some data from table one to table two (via an update query). But in table two there is a field that isn't in table one but i want to add a value to...

Hi, the title says it all. I have been trying this but i cannot figure out how to do it, I would like to know how to fill in a field on a form with the current time by clicking a button/macro. Thanks in advance for anyone who can help me. Much appreciated ----- Steve

hi, im a bit stuck. i am creating a mail merge and i want access to retrieve only the first character of the forename to input into the mail merge. e.g. Dear Mr. R Price. I want the 'R' to be retrieved by access from the full forename, so 'R' would be retrieved from the name Robert in the...

Aumatically fill in current month default value Hello, I have been trying to get the current month automatically filled into a field (like with the Now() function but to show the current month only) iv searched the forums and had no luck as well as trying a number of different ways to do it...

Hello, I'm trying to desgin a database for an afterschool club. The database will need to manage a few things. If i try to put it simply: A Bookings system for bookings made by parents for the child, for the dates they want thier child to be at the club and to work out payments for each...

Ok, firstly im sorry if this is in the wrong forum. I say this because my problem first begins with the tables but then i need to sort a problem out with the form aswell, but i will put it in here. Here is the problem. Im sorry if im not too clear with this. I need to create a register system...

i need help with a few lookup tables in a bookings table. I am doing a music instruemnt rental for my A level project. I have five seperate tables to store inforamtion about the following: guitars, basses, amplifiers, effects and other equipment. in the bookings table i have several lookup...