Search results

Thank you, thank you, thank you. That is so helpful, I appreciate it. Long term I might try and get the hang of the new Navigation, but for the moment, as I know how to operate the old switchboard, I'll have it up and running as I want in no time. Many thanks again Christine

Many thanks - I've got it looking pretty if nothing else. Will give the .accde file a try. Thanks again Christine

Is it possible to add queries onto your Navigation Form? I am trying to create a Navigation Form in 2010 version (and I had just got the hang of the old switchboard), but it would appear that I can only add forms and reports. However most of the reports are based on queries so would like to be...

Unbound? Sorry, I'm really dense I know, but not sure what unbound fields are. What are they and if I do have them, do I bind them!! and do you think that will sort my problem. Sorry, appreciate your help though. Chris

I have a number of tables (all linked through relationships) containing information relating to vehicles, employees etc. I created a form for the input of new information in relation to the taxation relating to the vehicles. This table has a record no as its unique code as the primary from...

Worked a treat - Many thanks Chris

Hi Simple question i know, but unfortuantely its driving me crazy. Is there anyway I can alter the order in which columns are shown in Datasheet View on a Form so that it opens up in the same order next time i open it? Thanks Chris :eek:

That worked great, many thanks:D

I'll give that a try and see how I get on - can I reserve the right to call on you again LOL

Hi I have a number of tables (all linked). In my form i have created some DLookup's through a text box to pull through info from another of the tables so that the information is correct and no manual input is required. However I would like to do a calculation that involves 2 of these dlookup...

I have a database with a number of tables, all linked. In the forms I would like to make a combo box to pull through information from another of the tables (I have also created a query linking the info if that helps), but it only pulls through the wrong info. To try and explain in Table 1 i...

Hi is it possible to pull data from one table into another without having to select from a list. I have 2 tables, one Car details, another Financial Information. I need to retain certain information in the Car details table, such as CO2 levels, list price etc, but I also need that...

Thanks Brian Worked out what you meant and query now works. Many thanks for your help. Regards Christine

Dear Brian Many thanks for your help, only not sure what you mean by inner and outer joins. The relationship from Table 1 to tables 2 and 3 are 'one to many'. christine

Hope someone can help. I have 3 tables. Table 1 contains Opening Balance (item ref is unique key). Table 2 contains qty in and Table 3 contains qty out (relationship between all 3 tables is via item ref which is only unique in Table 1). I am trying to make a query to show the current balance...