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

Ah, thanks Brian. Worked perfectly! :-)

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

Yeah it is a form and sub form im wanting. It's worked, I just wanted to stay away from the wizard because iv already designed and made the two forms. But i suppose i can quite easily change the layout of the new forms. Cheers

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

Thanks for your help. It makes sense.And it now works. I got confused with update and append for some reason although i've been using them in the past correctly. lol oh well, thanks for your help.

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

Cheer Rick. I was playing around with VBA but couldn't find the solution, never thought it would be so simple. Oh well, i've got alot to learn :-(

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

ooh, quick reply. Thx. Edit: where do i put this?

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

Thanks for the help but I tried the MonthName but it comes up with an error when i try to save the changes to the table. Unknown Function 'MonthName' in validation or default value on tablename.fieldname Sorry for the trouble but i cannot get it to work.

It is text becuase the months are in a look up table but iv tried it as date aswell

Thanks or your reply bob but i couldnt get it to work. In the field it says #Error. I have tried Month(Now()) as the defualt value but it shows the month in its numerical form (E.G. october is represented as 10) and i would like it as text, is there any way to do this or do you know 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...

i am still working on this and thanks for your help cuttsy.Your suggestion has helped alot. I also need a booking system so the children can book any dates they want in the year and it will work out the cost. and i want the register system to know if the child is ment to be at the club that day...

thank you for the reply and help. there is one club and the register needs to record childrens arrival and departure from the club. so ive been palying around with the table structure you gave in your reply but im not sure where to go from here. This is possibly a forms forum question but...

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