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 derfloh 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
  • Order by date
  1. Daina

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

    jbehrne This is the message that appears: Action Failed Macro Name: McrAppendClearDatasheet Condition: True Action Name: RunSQL Arguments: DELETE FROM tblPersonalDetails WHERE Details ID=*; Here is the SQL Statement from the QryAppendPersonalDetails INSERT INTO tblPersonalDetails (...
  2. Daina

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

    jbehrne UI am sorry but the vb code totally confused me so I tried the macro but I think I got the sql statement wrong as this is whrere the macro stops with an error, I have laid out exactly as in my db please let me know if you can see the error. Set Warnings Warnings on - No Open Query...
  3. Daina

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

    jbehrne Thanks I will try both of these methods, and let you know. Cheers Dee [yinyang]
  4. 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...
  5. Daina

    boldDOB age ranges calculations

    MichaelRed, Sorry but I did not understand your reply at all, a little to advanced for me but thank you anyway. SBendBuckeye, Thank you for your reply, as to my expertise in VBA I should say not a lot really I love creating databases and working in Access, but when it comes to writing...
  6. 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...
  7. Daina

    Count specific data in a field

    LittleSmudge, I entered the code listed below in to the OnFormat of the page footer and it comes up with the following error: Complie Error Variable not defined obviously I have gotten something wrong somewhere. Can I not just add a text box to the page footer and enter an expression into...
  8. Daina

    Count specific data in a field

    LittleSmudge Thank you for your help I have hopefully adapted the code you offered correctly. Yes I am adding this to the page Footer of the report and I found the On-Format that you were referring to. I have also included what I have interpreted out of the code you suggested. Please note this...
  9. Daina

    Count specific data in a field

    LittleSmudge, Thank you for your reply by "the Sections On_Format event" do you mean the report, or the text box that I am adding to the bottom of the report in order to display the results of the different fields on the page. I have looked at the properties on both and can not find...
  10. 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...
  11. 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...
  12. Daina

    Conditional Formatting

    Jeff, Thanks it worked a treat Daina
  13. Daina

    Conditional Formatting

    Jeff, Ok thanks I will try that Daina
  14. 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