Search results

Hi guys, Is there a way I can get rid of all the Microsoft toolbars etc. so the DB loads on the 'welcome page' form. I've changed the settings so the DB loads the form on startup but want only the form to be visible just like a 'normal' application would be? If there is way for me to re-enable...

Will this quit the whole access program? I just need the form to be closed. The form is opened via a 'welcome page' (another form) with a button link hence the prompt for a password. Thanks!! Bill

Hi Guys, apologies if this has been covered but can not seem to find it; problem is that the below code does not work on my db. It asks for the password but even if i enter an incorrect password it still opens the DB albeit after the pop up message saying Invalid Password, Please try again...

Minty - you're absolutely fab! thank you soooo much. This has seemed to work:D:D:D:D:D

Yes - the transaction table is designed to lookup into the individuals table to allocate the sale to one of the individual records hence creating the link between the sale and the customer. thanks!! Bill

Arnelgp, really really appreciate the above however i'm getting an error "The expression on Load you entered as the event property setting produced the following error: Ambigous name detected: form_Load The code I've entered are; Private Sub form_Load() Me.Combo836 = "All" Me.RecordSource =...

Arnelgp Thanks! - but can you explain this is in simple steps; quite new to all this! Thank you!!! Bill

Hi Minty! thanks for replying. The form was created directly off the tables section no queries used - how do I check the record source? Without the subtable (table.transactions) all the records in the customer table show up in the form. Thanks! Bill

Hi Guys, was wondering if anyone has a solution to this; will explain as customer and sales order example for ease. I have created a form which displays all the customers and their details, I've put in a tab control box with information in the different pages; one of the pages is Transactions...