Search results

  1. G

    Have a value show on a form based on a query

    I have a form it has several text boxes, fields and a subform. it has a parameter that prompts for a SerialNbr. The fields on the form are SerialNbr, cboCartStatus, CartDate, CartID, ServiceID Subform fields: cboCartEvent, CartID, CartEventSubType, CartEventDate The control source for the form...
  2. G

    using a form to update a listbox

    I have a main form with a listbox and a command button for the listbox. When the use clicks the command button (called Carts) a new form opens for the user to enter information that pertains to the Cart. When the user enters the data in the new form and clicks save I need the listbox on the main...
  3. G

    open another form based on the record on the main form

    I have a form that has several fields on it and 3 command buttons. I need each the command button to open a new form based on the record that's showing on the main form. can someone please tell me how to go about bringing that record that's showing on the main form to the new form when it opens.
  4. G

    problems with a form and command buttons

    I have a form that have several command buttons one of which is a save record button. ON LOAD 3 of the command buttons are disabled if it is a new record. If it is not a new record the buttons are enabled. Now my problem is this.....The Save Record button is controlled by a macro that is done by...
  5. G

    Need help setting up and relating tables

    Hello guys, I need a little help relating my tables. I pretty much know how they should be related but I'm not sure about some of the fields. I have a Cart management system. (This system is to track the Carts (the big green garbage carts everyone uses). I have 4 main tables. Here is how I...
  6. G

    need one form to open based on the record of another form

    First I have a lookup form called AddressLookup. Then I have a form called Services and I also have a form called ServiceEvents. Every Address will have a service. and for every service there is an ServiceEvent. The user will go to the AddressLookup form and search for an address. Once the...
  7. G

    trying to create a form with a tab control

    Ok guys I need major help!!! I need to create a form with a tab control that has about 4 tabs. I have an address view, 3 tables. The reason why I have to use vAddresses as a view is because it is the city's main address database and everyone that uses it in their applications has to use it as...
  8. G

    trying to see if a value exist in a record

    I have an access form that allow users to enter some data. for instance, they will enter a FileNo, date, FileName, etc. When they enter the file no I want vba code to see if that file no has already been used. If it has been used send a message back to the user that it has already been used and...
  9. G

    trying to increment a value using a counter

    I need code to increment a value using a counter. I have a form that the user enters information when a customer purchase a brick with an inscription. The customer can buy as many bricks as they choose to. if a customer purchase more than one brick with different inscriptions the user need...
  10. G

    Need help removing a record

    i have some forms and some reports in an access application. Ok, this is what i have: i have a form that adds a new file and then i have a form that closes a file. and then i have some reports that users will run that shows "active" files and that shows "closed" files. Once they open a new...
Back
Top Bottom