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 TouchToneTommy 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: Daina
  • Content: Threads
  • Order by date
  1. Daina

    How to Run 2 Append Queries and Clear datasheet from 1 macro

    Hi, I have two identical databases 1 is the main database and the other is loaded onto a laptop for field officers to gather information, at the end of the day I want the field officers to be able to click on 1 button on the laptop which will append the data from the 2 tables on the laptop onto...
  2. Daina

    boldDOB age ranges calculations

    Hi, I am having trouble finding an appropriate code for my form, I will try to explain I have a table "tblPersonalDetails" which has amongst other fields a DOB field. On another table "tblWeeklyImmunisationProgram" I have among other fields 4 separate fields 0-6 yrs, 7-12...
  3. Daina

    Count specific data in a field

    Greetings, I'm having a mental block, I know this is easy but I just can not seem to work it out with the help function. I have a report with a field called "Complaint Method" which is connected to a combo box and has a few choices eg. Letter, Telephone,Fax, email. what I need to...
  4. Daina

    Copy last entry in a table

    Hi, I am fairly new to access and am having trouble writing an expression for the default value in my field properties, I have a field name: Batch Number and I need to have this default to the last number entered until a new number is entered I have tried the following but I am afraid it was...
  5. Daina

    Conditional Formatting

    Hi, In my form I have a combo box with Comply, Does not comply & Not applicable as possible selections. I want the selection "Does not comply" to appear red and the other 2 selections to remain black. I have added the below expression and it seems to work when adding and editing...

Part and Inventory Search

Back
Top