Search results

Hello all, I'm having a bit of trouble with the follwing VBA code DoCmd.RunSQL "UPDATE AlertsAM SET StationGroupID = " & Me.txtGroupID.Value & " WHERE(AlertsAM.AlertAMID) = " & Me.txtAlertAMID & ";" DoCmd.RunSQL "UPDATE AlertsAM SET StationID = " & Me.txtStationID.Value & "...

Thats' great i'll try your suggestion! thank you

Thanks for the tip about the reserved words. I'll change it. I've revised my query but it's still not giving me the answers i need. To clarify; A list of stations needs to be checked every day, and each time they are checked an alertAMID is generated. At the end of the day i need to be able...

Thanks for the tip about the reserved words. I'll change it. I've revised my query but it's still not giving me the answers i need. To clarify; A list of stations needs to be checked every day, and each time they are checked an alertAMID is generated. At the end of the day i need to be able...

Hello, I have a list of items that need to be checked on a daily basis. At the end of the day i need to print off a report of all the items that have not been checked that day. The way that i am attempting to do this is by using a nested SQL NOT IN query but i can't get it to work. The code...

Sounds a bit complicated for my level at the moment! Thanks for the suggestion. It's not urgent so i 'll come back to it in a couple of weeks when i've leant some more VBA.

Hi Guys, I need to validate text entered into a text box using VBA. The text that will be entered needs to conform to the following criteria: 1. L[000], where [000] can be any number between 00 and 999 2. L[A][] where [A] can be be any letter of the alphabet, and [000] can be any number...

Thanks Al ot Ken, and everybody else for your help

Thanks for all of your prompt responses. I get a runtime error of 3464 "data-type mismatch" when i try to run your code ken? tehnellie: I don't understand the strSQL bit at the beginning. I know it means String Sql but i don't know how to utilise that in VBA Again thank you. I'm very much a...

IHello all, I have the following bit of code that i want to insert the value from txtGroupID into a filed called GroupID in a table called AlertsID. I only want it to update the table when another the AlertID field in the table matches the value in a txt box called txtAlertID. The save button...

Thank you very much, i was banging my head against the wall with this one!

Hello all, I'm a bit rusty with access, and i can't find a discussion on this board to help. I have two combo boxes on the main form which i want to transfer the value in column one in each of them (an autonumber) to two text boxes on the subform. I have tried to do this by using the combo...