Search results

Dear Bob I hope you don't think this is too impertinent of me but you may be the man to help with this database problem. A different database! Hopefully you won't mind me asking. Here's the scenario. I have constructed a library system. It works well and the users are happy with it, but...

Hello Bob I am happy to report that I have finally got the database working the way I wanted. Adding another level of item classification certainly filters the records more effectively but led to a major headache trying to get the thing to work. Eventually, I opted for a complete re-build...

Hi Bob, something occurred to me last night and that is, without modifying the existing structure which is working well, I can add two unbound combo boxes to the form which should filter the returned records in the third combo. The problem that I have now is the request to have a number of...

Thanks very much Bob, but unfortunately this seems to have no effect The first subform is now populated with the last item entered into the underlying table.

Many thanks Bob

Hello once again Bob. Some time ago you very helpfully solved my Stock Control database for me. It has worked beautifully since then. Now there has been some new requests made which involved additional filtering. This is achieved by adding another level of item classification. Now there are...

Once again Bob...Thank you!!!!!!

Sorry Bob, I forgot to attach the DBase. The relevant form is accessed by the 'Staff Resource Allocation' button, then 'Browse Records' Button. Many thanks once again Rob

Hello again Bob Recently you solved my problem with cascading combo boxes on a continuous form. Somehow, whilst making further developments elsewhere I lost this functionality. I may have used an earlier copy or something. Do you think, if I sent you a current copy, you could have another...

Hello folks I wonder if someone could tell me where I'm going wrong? I have a command button that produces a MsgBox which should give the options to 'Proceed' or to 'Cancel'. Here's what I have: Private Sub Command10_Click() If MsgBox("continue?", vbQuestion + vbYesNo) = vbYes Then...

Hey Moke, this seems to have solved the problem. Bravo!!! You are a star! :):):)

Still the same issue. I'll have another look at the DB construction. Maybe that's where the problem lies. Thanks for your efforts.

Sorry, after you enter a value, press the Commit button to run the queries.

Unfortunately, I'm now getting another error messaging saying cannot find the field CurrBalance. If it helps, I have attached a copy of the dbase in order to show the error. Fro the Switchboard select Staff Resources Orders Then select an item from the Item Description Combo box. The...

Thank you ArnelGP. Unfortunately I'm encountering the same problem as with Ranman's solution.

Many thanks Ranman This works to a point. The error message appears as planned, however when I click OK, it is followed by a message "The value violates the validation rule for the field or record". I then have to click OK then press ESC in order to clear the box. This may be something to...

Hello folks I have a form [StockSub1] which contains a field [CurrBalance] and another [Numentered]. The user enters the number of items ordered and this is displayed in a subform below. The new current [CurrBalance] is recalculated, ready for the next [Numentered]. Is it possible to write...

Superb Moke! Works a treat. Many thanks to you, to Paul and to Arnelgp. Once again the experts have come to my aid!!!!!

Many thanks for your efforts Paul. Unfortunately, I'm still in the dark about what to do here and how to apply these controls.

In a stock order database, I have a main form [mainform] which containes the customer name and ID based om an underying table [OrderTbl]. Below this is a subform StockSub1. This is based on the underlying table [ordertbl] and contains order details, Item classification, Item description, order...