Search results

Yeh, the subform name is sfrmDay_BlockingAndSequencing

On the line Set subfrm = Me("sfrmDay_BlockingAndSequencing").Form, I'm currently getting run-time error 2465. "Database can't find the field 'sfrm_BlockingAndSequencing' referred to in your expression. "

I wonder whether any guidance can be offered up re the following, please. I have a tab control set within a main form, and on the one tab that I've created so far (to introduce others later), I have a subform. Also on the main form (within the Form Header), I have a couple so far (to introduce...

Thanks, ebs17 & UncleGizmo. I'm continuing to sort it. The error I'm getting right now (seen it before with some other variations I tried) : Run-time error 3346 : Number of query values and destination fields are not the same.

I'm having difficulty in creating the VBA code required to - on the click of a button on a Form - insert some data recorded on that Form into a Table (ie. one that isn't the source for the Form). The data recorded on the Form that needs to be inserted into the (other) Table : dtTestDate...

Thanks, ebs17. I've taken that on board, and altered by code to take that into account.

It's a Short Text field, in which I enter Yes or No. Thanks for your interest. In any case, my error seems to be in the order of my lines of code, as pointed out by ebs17.

Could someone help me pinpoint where I'm going wrong with the following, please ? I'm attempting to insert a record into a Table named tblTasks, using the VBA code below. Dim strTaskInsertionSQL As String Dim strTaskTitle As String strTaskInsertionSQL = "INSERT INTO tblTasks (TaskTitle...

I think I'd been a bit careless in cutting-n-pasting code around. The code you provided certainly seems to have worked. Thanks ever so much !

"The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try...

In my database, I have a 'Quote' form with a Quote-line-items subform (sfrmQuoteLineItems) and a 'Sales Order Form' with an 'Order line items' subform (sfrmOrderLineItems) In the header of sfrmQuoteLineItems, I've placed an unbound field (unbQuoteLineItemsRecordCount) to provide a count of the...

omg, I've realized I made a 'school-boy' error. I replaced sql = StringFormatSQL("select * from tblStockTakes where intProductID_PK = {0} order by dtStockTakeDate desc;", lngProductID) with sql = StringFormatSQL("select * from tblStockTakes where intProductID_FK = {0} order by...

Thanks. I think I see why you made that suggestion. Trying that, I get a 'Too few parameters. Expected 1' error.

Thanks to everyone who's made suggestions so far. I'm working through them, continuing to try to get the ProductLastStockTakeQuantity Function to work. It seems that I also have some issue with Function ProductLastStockTakeDate (and of course the ProductLastStockTakeQuantity Function depends on...

Thanks for your reply. I'm nowhere near my PC just now, and won't be for another few hours now. As soon as I'm able to, I'll try that, and let you know. Thanks again.

I'm trying to create a database based on the Northwind 2.0 Developer database, but capturing & displaying dates (including stock-take dates) in Medium format (dd-mmm-yy) instead of Short Format (as in Northwind). I'm encountering a 'Invalid use of Null' error (Error 94) that point to the...

Thanks very much for your help. I'll prompt him to try it, and see how it goes.

Thanks very much for your help

So I need to instruct him to go to References, take a look down through the list of Available References, and tick whatever is present in the list where the Excel object library is concerned (ie. add a 'Microsoft Excel XX.X Object Library' Reference, XX.XX being whatever the version number is in...

Excuse my further ignorance of early binding, Refereences, etc, DBGuy, but exactly what does he have to do, technically ? Reinstate the 'Microsoft Excel 16.0 Object Library' Reference that was previously un-ticked? (Won't that re-introduce the other problem that he initially encountered ?)