Search results for query: *

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...

I am running Access 2000 on my home computer and when I try to save a query, A window pops up stating that Access has caused some form of violation and will be closed immediately (more than a little annoying!) so when I get to save point, it conks out and I have to reinput all the work over...

I am trying to write a query for a table in access, but everytime I press the save button, and occasionally when I try to just run a query, i get an error message stating that Access has caused some form of violation and will close immediately. Something to do with Kernel32. Anyone got any...

Already figured this one out, thanks to those who read this question....

I have a database that is linked to AFD Postcode plus, so when I enter a postcode into a textbox, the rest of the address comes up for a particular area. I.E. HX1 3PA - would be Lombard Street, Halifax, W Yorks. I want my query to look at the entered postcode in that text box and extract...

Thanks for that, although I understand what you mean with regards to the query, I don't know the terms inner and outer queries. Please explain how I would run this query.........