Search results

Another quick question, When the query is run, two default warning boxes come up and annoy the user. Is it possible to get rid of these? Thanks again.

Thanks, just out of interest, what's the 178? Number of days? thankyou, Neil.

Can anybody tell me the syntax in a delete query where i want to delete all records that have the date in one field older than 6 months. Thanks a lot.

Sorry, i meant create a new record in the subform but with specific data. This specific data is not stored anywhere else in the database, it would have to be specified in the expression/code.

What i want is that when a particular field on a form is exited (i.e. you tab out or select another field with the mouse), then the first record is entered automatically into the subform. This automatic record will be the same value every time. Is this possible?

I want to append dta from one database to another. This is straight forward enough if i want to append just opne table of data. However, the database has 4 related tables and i would like to append related records from each of the tables according to criteria of one field in one of the tables...

Personally I hate switchboards. They're not easy to navigate through for novice users (trust me i've witnessed this). I normally just create a form in design view with tabs on it. Much easier and quicker to use.

Thanks for the suggestion Pat but the record source is still the actual query.

out of interest hayley, what is the shift bypass key?

if you go to the tools menu and click startup it will take you to a dialogue box where you can uncheck the tool bars. This will prevent anyone from being able to get into the design view. From here you can also set it not to show the database window which you will also need to do. Make sure you...

GKite your a great bloke/woman! Thanks a lot, I'll really appreciate that. If there's ever anything I can do to help you then i certainly wont hesistate.

David, This is what i did, i created a query which i based the main form on. The main form data all comes from one table as the query is just so it shows certain data according to one field. The primary key in thatt table is an autonumber - Order ID. As for the subform, the data comes from a...

thanks guys Pat that was the case but i had removed the subform data from the query some time ago and it had no difference

I have a form that takes data from a query, within this form there is a subform that takes data from a separate table. My problem is, when an entry is made into the form, unless an entry is also made in the subform, then the record will not show up next time i open the form. Is there a way to...

I can't really helpful because what you're doing is way too advanced for me. Does this post qualify for a free copy of your database?? Its sounds brilliant! I wanna try it out!

I need a currency field in a form to equal the sum of all entries in a subform. Is it possible to automate this or will the user have to work this out and type it manually? (By the way this is in Access 2000) [This message has been edited by Neilw (edited 03-13-2002).]