Search results for query: *

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

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

jbehrne Thanks I will try both of these methods, and let you know. Cheers Dee [yinyang]

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

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

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

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

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

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

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

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

Jeff, Thanks it worked a treat Daina

Jeff, Ok thanks I will try that Daina

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