Recent content by jackie77

Hi Thanks for the reply guys, Mark cheers that works - but I get what your saying about the Tempvar so I will redo and push it over from the form I appricate you taking the time to explain it to me -means I will know it next time ;) Thanks Again

Hi Ken I have tried it before and after the requery but still I get the error 2465 "Can't find Field TempVar (Button1) I have tested the tempvar on opening the "AddTemp" form just in case it didnt add properly but the tempvar is fine I have also double checked the name of the button (whos...

Hi KenHig Thanks for the reply From my form "ColdTemperatures" I click a button and the tempvar is added and the form "AddTemp" opens I then add data to this form and when I click a button on this form it closes and the form "ColdTemperaturs" requerys and its at this point I want the...

Hi all does anyone know how to use a tempvar in the following line Forms!ColdTemperatures![TempVars("Button1")].ForeColor = vbRed what im doing is on close of a form I want to change the colour of a button on another open form (the name of the button is held in the tempvar) But i cant...

Hi Thanks JHB for having a look at it for me, I'm flying now your help was most appricated cheers :) Jackie

Hi all I have been working on a bound form (For ages!) that I can't seem to getting working It records deliveries and what I am trying to achieve is after the form has been filled in the user will click a save button where the record will be added to the table and a record automatically...

Has anyone any suggestions on this? Cheers Jackie

Hi pr2-eugin Again thanks for the reply (even if it was somewhat salty!) and no Im not interested in using an inefficent method, I can see and understand where your coming from of how more efficent and simply it would be to use Continuous Form/Datasheet for this task, that being said the...

Thanks pr2-eugin for the reply The reason I didnt use bound Continuous Form/Datasheet because I needed to display all products that require temperature checked so the user did not miss a product out so in essense they simply filled out a sheet with everything labeled for them if I use a...

Hi Everyone I was looking for some help I have a form with 15 unbound text boxes (daily temperatures) and what I am trying to do after entering the temperatures into the text boxes the user clicks an add button which will add 15 new records into the temperature table the code I have...

Hi There Got it sorted, just think I needed a nights sleep was looking at it for way to long I used Ari sugesstion and changed my variable declarations to strings and bobs your uncle lol Thanks to you both for your help was most appricated Thanks again :)

Hi Thanks again for the replies Ari - I tried ur suggestion but Im back to getting an error this time its "Data type mismatch in criteria expression" Pbaldy - added code from post 4 and sql all looks good, I have pasted it to new query and it pastes in fine - the data types are...

Hi I have double checked everything and found a spelling mistake it all looks good now with no errors so thanks again for the help however when I look in the table the record is not updated I have checked the variables by adding in MsgBox Exp1 & Exp2 & Exp3 to the code and they all look...

Cheers thanks for the reply I have made the changes you have suggested but its still getting an error but its now on line: CurrentDb.Execute strUpdate, dbFailOnError and it says "to few parameters expected 1" any ideas? Cheers Jackie

Hi All Its been ages since I've been on here so hello to everyone again :) Im having some probs getting an update query using vba to work have tried doing loads of things but cant seem to get it to work, Im sure its something small and stupid Im doing! what I have at the minute is below and...