Search results

Thanks Bob, that's very helpful. RussG

Hi - I have read conflicting advice on this so wondered what members of the forum would recommend. I have a multi user DB , no more than half a dozen users. DB will be FE/BE and I have set the DB to compact on close. Obviously if another user has the db open this process won't complete. Are...

Thanks for your replies. The issue is a customer may request refreshments for multiple dates and times on one order request. The way I set up the DB was that each request(i.e. date and time request) is a seperate order and gets its own orderID. The users want to be able to pull off all these...

Didn't notice, noted for future ref. Thanks

I have been developing a catering order system at work. A demo version has been in test and initial issues sorted. The users are very happy with the way it works and though far from perfect it does everything they asked for and then some. Basically, each order for refreshments/food creates a...

Sorry - duplicated post.

I solved it by putting a close button on the form with: Me.RecLock = False DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 DoCmd.Close RuralGuy's option is no doubt better RussG Forgot to mention saving and closing the form suited the way I wanted work, I didn't want...

Locking Hi Joe - when I get a minute I will have a look and let you know how I solved it. Busy with another problem right now. RussG

Sorted this - changed my grouping order which solved the problem. Thanks RussG

Hi - little bit of assistance needed. I have a report that groups on Dept then ChargeCode then Codegroup. I have sub totals for each Chargecode. Because 'Labour' is charged separately I want to have a total for all 'Labour' costs which are then deducted off the grand total i.e. Total of...

Thanks for your help chaps , that is working now - also I had not set a link between the 2 forms:eek:, also fixed that now. Would be interested in your comments on design Bob (suspect its to do with the Category table) RussG

Bob - attached is DB as suggested, I have stripped out all the unnecessary stuff. Thanks RussG

Hi Bob - I use WinRar, I'll have to get a copy of winzip. I will upload shortly. Thanks RussG

Thanks for your reply Bob. Tried your suggestion but the same thing happens [Forms]![frmOrdersSub].[Form]![Category] Still works OK on the subform. I could open the subform as a linked form but I am curious to find the answer to why this won't work. RussG

Hi - Hoping someone can help. I have a main order form which holds orderID , customer details, date etc I plan to add a subform which contains the ordered items , much like the Northwind order form. On my subform, because there are so many products I have added a cascading combo box, so I can...

Hi again - the bound field is CatID. I have already sorted a workaround by removing the autonumber field from the Lookup table (tblCatagory), so the description is stored in the table rather than the record ID. Not as efficient (not going to be a huge amount of data stored ) but it does solve...

Hi Bob, thanks for your reply; The Data type is Number. SQL for the combo box; SELECT tblCatagory.CatID, tblCatagory.Catagory FROM tblCatagory ORDER BY [Catagory]; SQL for the form query; SELECT tblSchedule.SIID, tblCatagory.Catagory, tblScheme.Scheme, tblSchedule.DueDate...

Hi - Looking for some help which I suspect will be something obvious. I have a form that is based on a query, I am using the query as a record source so I can filter the form by a date range. On the form I have 2 combo boxes which use 'Lookup' tables to get their values. On the form-when I...

Thanks Bob

Got this working but not exactly as per the code, curious to know why the above code wouldn't work though. RussG