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!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Update database records
Good morning! I tried this but am not sure on the update piece of it. This is what I originally had: <cfquery datasource="shifts"> UPDATE tbl_Bid_Info SET BidNum='#(Form.BidNum)#' Where ID=#(Form.ID)# </cfquery> I've modified this to: SET BidNum='#(Form.BidNum_#avail.id#)#' and am getting... -
Update database records
Hi! Not sure I understand? There is not drop down box or list of choices, it's an open text field. I have the unique id number hidden so it is not displayed, but for each unique id number I need to update the text to the database field. Here is the first section of code: <!---Get agent... -
Updating records based on different criteria
I was running through it in the immediate window and would get that error, when I assigned a macro to the function and ran it worked fine. I really do appreciateit, you've been a great help!! Thank you!!!- angflem
- Post #7
- Forum: Microsoft: Access Modules (VBA Coding)
-
Updating records based on different criteria
This is great thanks!!! :-) Seems to be working with one exception, when I get to this step: Do While Not rs1.EOF I get a Do without Loop error? It seems that it's only doing the first and second SenNo's and not going through the rest of the list.- angflem
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
Updating records based on different criteria
I was thinking this same table could be used (or a new one created) and a field added to it for shift assignement. For seniority 1, the shift assignment would be 1, sennum 2 the shift would be 3, sennum3, shift would be 8, etc...and each time it goes to the next sen num, it will look to...- angflem
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Update database records
Hello! I need help with an update query on my CF page. I am creating a shift bid process, each agent will see a list of available shifts and will be able to bid for these shifts based on number preference, 1 is first shift they want, 2 is 2nd choice, etc. When I enter the pick number in... -
Updating records based on different criteria
Hi! I am new to VB and really don't know that much about it. I need create a module that will assign agent schedules based on seniority numbers and shift bid choices. For example, 13 shifts are available, agent with seniority number 1 gets their first choice of shift #2. Agent with seniority...- angflem
- Thread
- Replies: 6
- Forum: Microsoft: Access Modules (VBA Coding)
