Search results

Hi, I know there are quite a few threads about combo boxes and continuous forms so I will apologise in advance if this is already solved somewhere else. (I will take a good link to a post as a solution). I have a continuous form (works great), with two combo boxes that navigate (rather than...

I found a basic login using macros that works a treat and sets the user id as a tempvars! (Credit where credit is due http://www.accessallinone.com/31-log-in-form_/) Each user has a different permission level, and based on that I would like a different form to load. Managers 1 Admin- Users 2...

I have a button on my form, that runs a series of queries then closes the form. It works great!! How can I get the MsgBox feature to continue with all commands or cancel and close the form? Here is my code without message box action Private Sub AcceptChanges_Click() DoCmd.SetWarnings False...

I have a Main form with a sub form. The main form is a customer record (form view), and the sub form is all other customers (same fields) datasheet view. I have a navigation bar to filter (using different queries) the results in the sub form same postcode Same company (different location)...

I am trying to do the good 'ol sales report (query) to include customers with no sales. I have a customers table, account number table, sales table & sales (line) detail table. (all linked in that order) If I run a query to show customers (in the customer table) with account numbers, that works...

I know this seems to have been asked numerous times before, and maybe I am being stubborn with which solution can actually help me. I cannot help it, in my mind mm/dd/yyyy is an incorrect way to display a date!! (I know, I know), but that seems to be all of the solutions I can find. (I read...

I am trying to work out a way of partially merging two records. I do not actually want to delete one, just mark as "inactive" and reassign account numbers (& orders which are matched by account number not customer pk) I have a table of customers with a yes/no field of Active/Inactive, and a...

Okay, so I have been thinking about this and attempting it many different times with varying results. I am at the stage now where I am doing cross tab queries, appending records and it all just seems to be getting more messy and convoluted!! :banghead: Goal I am attempting a sales database...

Thought I'd take heed to the new members message and say Hi! I have dabbled with Access a few times over the last 10 years (really just destroying other peoples databases with no idea how to fix them) attempting to make access do "something". I have instead became quite proficient at excel and...