Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Chyld
  • Order by date
  1. Chyld

    Log when a record was last updated.

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

    Nested IIf statements

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

    Nested IIf statements

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

    Nested IIf statements

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

    Send information from a record as an email

    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?
  6. Chyld

    Subform_visible

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

    AddNew buttom not work

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

    Send information from a record as an email

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

    Multiple records into 1

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

    Nested IIf statements

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

    NavigationButtons.Visible = False/true problem

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

    Kernel32 errors

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

    Errors on saving a query in access

    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'...
  14. Chyld

    Error Messages on saving query.

    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'...
  15. Chyld

    Error messages

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

    Kernel32 errors

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

    Kernel32 error?!

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

    Postcode Extraction??

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

    Postcode Extraction??

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

    Query trouble

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

Part and Inventory Search

Back
Top