Search results

  1. L

    Togglelink?

    I have a form which is opened from the DoubleClick event of another form. when I view the code for this form, it has the following pieces of code: Private Sub ToggleLink_Click() Private Sub FilterChildForm() Private Sub OpenChildForm() Private Function ChildFormIsOpen() Private Sub...
  2. L

    Making a MsgBox appear after a blank record is shown?

    hi, i have a form, which when opened, gives me a blank record. which is what i asked it to do in the OnOpen property. however, i also need a msg box to popup - but after the form has been opened. i tried placing both pieces of 'code' into the OnOpen property, however, the popup displays first...
  3. L

    can someone explain this pls?

    hi, I was using the KnowledgeBase on the Microsoft website, and found a way to have a table have picture path names, rather than having to store each picture in the dbase. I was told I need to use a Module and call it Module1. I would be extremely grateful if someone could let me know what it...
  4. L

    query lookup

    sorry if this has come up before. I have a dbase and have a query which calculates the "final price". a form is based on this query. i have another query, and i need it to lookup the "final price" field and display it on this query. i hope it makes sense would be grateful for any help, thanks
  5. L

    problems editing dbase. urgent. pls help!!!

    hi, i have set startup options for my dbase by going into Tools then Startup. I changed it so it doesnt show the tables etc, and shows only a form. i have also set a password on it. i know the way to edit a dbase with startup options is to hold down the shift key and then open it. however, i...
  6. L

    Delete from more than one table pls

    i have 3 linked tables. (invoice, customer, cars) i have a form showing details from all three tables. i want to be able to press a delete button whereby the records in all three table will be deleted. i have managed to do it for one table - however, it doesnt delete the records in other...
  7. L

    custom error msg for blank field

    this may be simple - and yes, i have tried searching for the soln, but to no avail. here goes: i need a method whereby i can prompt the user with a friendly message when they have missed out a field. e.g. when typing in customer details, i need prompt the user to enter a forename if it is left...
  8. L

    Fill in a record based on another form!

    hey every1 - i have once again searched for the soln, however, either the solns involve subfrms or go off on one - and i get confused! i wud be extremely grateful if any1 can help me: I have a form - FrmCars - which holds details of cars! This is linked to open FrmInvoice via a command button...
  9. L

    I'm stumped

    hi all - i know there are many threads relating to linking pictures to records etc, but forgive me for asking one more time: I have managed to get pictures into my dbase - using Microsoft KB help - by linking them in a table to an external source. However, I want the dbase to know which...
  10. L

    Alternative to Append/Delete queries?

    hi - currently i have an append and delete queries to first put cars that are "sold" into the soldcars table. then i run a query to delete this car from the cars table. problem is, i have invoice for all these cars. when i delete the car from the cars table - the invoice goes too! i would really...
  11. L

    Making calculation from query appear in table ?

    hi - i have tried search for the solution to my query - but to no avail, so here goes: I have a query which is based on more than one table. In the query, I have specified a calculation, eg. Final Price: SUM([Sale Price] - [Discount]) From this query I have a form, just showing everything...
  12. L

    cascading issue

    Hi,I shall be grateful for any help. My problem Tables: Cars Customer Invoice TblMake Tbl Model I have used cascading combos for Make and Model. They work fine. I have set up tblMake as follows: ID Make I have make tblModel as follows: ID Make Model I use these cascading combos on a form. The...
Back
Top Bottom