Recent content by Chyld

I have a table with relational fields and one table inparticular has a section that I am currently having trouble with.. The fields are as follows: Table: UpdateCheck Fields: 'NameOfUserUpdating' 'DateUpdated' 'LastUpdated' NameOfUserUpdating will log the system name of the user editing...

I think the switch function is cack... I will try your module and see what happens.

You think the switch function then yeah?! Then that is what I will try.... I will probably thread some other post about something else shortly... hahaha Chyld "If there is ever a time to fall, it is most likely when you are winning." Me, 10/8/01..

Thank you for that, I will give it a go, is there any way of doing this without coding in VBA though?

I've used the docmd.sendobject as pratting around with macros, I would rather do the coding myself as I like to learn, could you explain how I would do this or provide an example?

it will work the way you want right from the start and on the underlying queries, have the following criteria (as I presume you want the subs to show up based on the value of the main form?!) that checks against the form first. calculates the forms contents and if it matches specific stuff...

where you have the text acadd, this needs to change to acaddnewrec!! (if it doesn't work, email me!!) craig@chyld.co.uk I wasn't embarrassed by tripping and falling face first, but rather that I forgot to tie my laces in the first place.

Hi all and everyone... Right, I have a form that checks product selections against availability and lets you know if a product is unavailable and who to contact for specials depending on the selection... I also have a problem with emailing to a supervisor, the contents of the shown record...

Hi there peglegs, I aint no expert and don't pretend to be, but what would you want your info in that format for?

I have a table like so called 'repinfo' (slightly different but relational.) postcode Rep1 Rep2 Rep3 Rep4 ======== ==== ==== ==== ==== AB10 Craig Jack Paul Jemma HX1 Phil Jezza Gavin Jake ZS3 Laa Laa Po Tinky...

I have an unbound text box in the form header that with an afterupdate event, requeries the form details. Within the body of the form, I have a calculated control that counts the number of records that are found with similar criteria to the form header control. How do I make visible the...

I have done as instructed. Please see the below text as an explanation of what I am doing. I hope you know what I a blabbering on about with the queries.... I am running windows 98 se, access 2000 on my database one query brings up all the customers from a table 'customer details' and lists...

I am running windows 98 se, access 2000 on my database one query brings up all the customers from a table 'customer details' and lists them i.e. company_name town postcode customer_type (choice of 4 types) this is displayed as 'testcustomerdetails' subform which sits on the 'testsample'...

I am running windows 98 se, access 2000 on my database one query brings up all the customers from a table 'customer details' and lists them i.e. company_name town postcode customer_type (choice of 4 types) this is displayed as 'testcustomerdetails' subform which sits on the 'testsample'...

can anyone please explain why the following message keeps popping up on my screen when I try to save a query in MSaccess 2000: MSACCESS caused an invalid page fault in module <unknown> at 0000:1539d233. Registers: EAX=300116f8 CS=0177 EIP=1539d233 EFLGS=00010246 EBX=300116f8 SS=017f...