Recent content by Xcarnate

That worked perfectly after a bit of tweeking, thanks for helping. On a related note... now that i have created this macro how do i make it run on all records? i have set it to run 'On open' and that works fine, but it only runs on the 1st record. Is there a 'Select All' command i can put at...

It is bound to several Tables, the Customer table (so the customers name can be displayed) the Orders table (contains the StartDate value) and the Publication table (so they know What item they are talking about). Ive noticed that when i have any form bound to several tables it doesnt let me...

I need to update a field in a table with a value that has been calculated in a form. It works a bit like this: The calculated value is called DDate, and is calulated from [table]![orders]![StartDate] + 7 I now need this new value to over-write the StartDate value. I have tried all sorts of...

What is the code i need to clear the value in a combo box? i have made it grey out by using: Me!CboSname.Enabled = False but i also need it to be emptied.

Not sure what type of post this is, sry if its in the wrong area... I'm new to access and i get stuck on lots of stuff :p .My current problem is as follows: Each item is received Daily, Weekly, Fortnightly or Monthly. A customer can choose to have it delivered Daily, Weekly, Fortnightly or...

i am doing a newspaper delivery system, currently focusing on the overdue payment section. I have been thinking a lot about it, and the only way i can thnk of solving the problem of recording the overdue items date due/price/customers name, is a sort of logging system. It goes like this: If the...

My problem is two fold. 1) I want it to show details relevant to a customer when their name is selected from 3 separate filters. I have built some filter method already, using VB, so for example when Mr is selected from a combo box all surnames in the next combo box are filtered by Mr. That is...

Thanks for that. That was all i was missing, linking it to the table (a bit obvious now i think about it, but then i didn't know what to look for). That has now allowed me to continue work on the database. Unfortunately, i will probably manage to get stuck (again) so *Dramatic voice* I'll BE...

I am attempting to make an access database (obviously;) ) and so at this moment have 1 simple question. i have made a form with boxes in which you can type stuff, but i would like the data entered in this boxes to be submitted to the relevant fields of a table when i click the 'Submit' button...