Search results

RV Year is just a name for a column, you could call it group or you could call pink fluffy bunny, I applied the name year as in year he did buisness with customer. That way you could run a query eg show me all customers did buisness with in year 200? Otherwise with no grouping all you would...

how would you suggest RV to sort the customers if you don't have another field that lets you know what group they are in. Ash

you could create and expression for date field iif([start date] = date() > 7,[start date], [start date] = dateadd ("d",7,[start date])) this says if start date is greater than 7 days form today then do nothing else add 7 days to start date. Is thiss what you where after. Ash

will have a look. on converting macros. Once converted you will need to go into each form that runs the macro and change the event from macro to the vb code that it has converted to. Ash

Why don't you create on table that has all the information and have a field on that table that has the date you desire. Then you can create a query that filters the record by date. Ash

Go and get yourself access 2003 for dummies. It is a great reference guide to starting out. It will explain how access works and the principles behind db design. It also gives great examples. I still use the book as a guide when stuck on a prob. Ash

The easiest way is if you create a replica of your db. Then you can just scyronise the db with the main db. Have a look at the online help of microsoft access. Working with replicas. It will show you how it is done. Ash

before you try and fix the above prob you will need to tidy up the db. forgive me i spent only a couple of minutes on it however there is a couple of things that need to be fixed. Firstly i would convert all the macros to vb. You also need to create relationships between the tables. Run a...

Just a thought but when you send information from one db to the other why not just use an append table query form each db to update master on new db. If it is all the same structure then it should work. Instead you are copying data first and then appending three tables. Does this make sense? Ash

OK downlowed ok. Prob is it is password protected so still can't access it Ash

How are the tables related to each other? Ash

How are the forms related? Ash

You can't hide any object that has focus. The only way is to set focus elsewhere first. It can be done but requires a fair bit of code. The only other way (apart from rg suggestion which would be easier) i can think of is to set the onfous property on all objects to cmdbutton.visible = false...

No that doesn't work either Ash

what is the point of having 3 tables with the same information Ash

here is how i did what you are after. First create an unbound form with the optionbox. Put a command button on main form to open unbound form create a command button on unbound form that has this code Sub printreports(printmode As Integer) On Error GoTo Err_Preview_Click const option1 = 1...

when you set up a command button to open form (with wizard) you can set the link criteria. Why write code when access will do it for you. Ash

I have fixed the prob. I feel stupid that i didn't pick this up earlier. I will post solution in case other people have this prob. My error was in creating a lookup field in the table. eg Productid could not update as it was a combo box on the table. Turned it back to a text box and prob...

In db security you can set group perrmissions. Simply change the user group perrmissions to what you want. Ash

Q.What is green and sits in the corner? A. A Naughty Frog Q. What is white and sits in the corner? A. A naughty Fridge Q. What is green and smells like pork? A. Kermit the Frogs finger. Q. How many social workers does it take to change a light bulb? A. One but the light bulb has to want to...