Search results

Is there any way to automatically fill in certain fieilds in a new record on a form? For example, for adding multiple records, certain field data is the same for each record, until changed by the user...as they go the the next record, I would like those fields to be auto-filled with data from...

Thank you Plog! That was what was missing. It works great! Here is my final code for anyone who wants it... For I = 1 To 783 EndDate = DateAdd("d", 6, StartDate) WeekNum = Excel.WorksheetFunction.WeekNum(StartDate) Sql2 = "UPDATE tblWEDates SET WeekNum = '" &...

Thank you both for the advise! I chose to go with the Excel.WorksheetFunction.WeekNum(someDate). It works beautifully for what I need it for. I realize that I posted in the queries section...but it is in some VBA code that is being executed on an event procedure. Thanks again =]

Does anyone know how to use the Excel WeekNum() function in Access?

I like using the dateadd better, thanks... so I made those changes but I am getting the same result. I mentioned earlier that I had set up watches on those variables and stepped through the code, and the variables were all correct as it hit the docmd.run sql. I'm really stumped on this one...

Ok, I got the record order worked out thanks to your advise. But do I need to put them all into a recordset before I can change the values? The problem I am having now is that the data is somehow getting lost when it reaches the table. Here is my current version of the code: StartDate =...

I know how to do a where clause, but essentially it starts at the first record and continues until the last record (in this case 783 records). I tried pointing it to the first record and then doing a .movenext inside the loop, but that isn't working. The where clause would have to be different...

I am trying to update a single record at a time through a loop. But on the first trip through the loop it tries to update all the records at once. I am trying to update a list of records that have a start date and end date, starting with a user given date that is stored in a table. Here is my...

Thanks! That was it! And thanks for the very fast reply =]

I am trying to extract data from a field in a table to a variable so I can use it in a comparison within VBA. But I am getting a type mismatch error and I can't for the life of me see where the mismatch is... here is the code.. Dim dbsSubwayDB As Database Dim rstSnapShot As Recordset Set...