Search results

  1. C

    access97 to access2000 compatibility

    I have 4 computers on a network. 3 have access2000 one has access97 the one with 97 can't open the the shared documents with 2000 database fills.
  2. C

    Capital Letters

    I would like for the data in a field to have the first letter of each word to be capital. How can I do this. Thanks For your help Chris
  3. C

    Network Nightmare part II

    This problem stems from me trying to make a database with sharing capabilites. As of now two people can not open the same form at the same time. I know this is because both users are opening the database in exclusive mode because this is an default permision for admins. I used the user level...
  4. C

    Network Nightmare

    I have a simple database I stick in the my shared documents folder so 2 other people can use it and the the forms and everything else works as long as only one person uses it. if another person tries to open the same for it gives me that stupid Could not lock onto Database error. The default...
  5. C

    Simply combo box quest

    How can make the focus go to the next field when I select a record from the combo box. right now you select a trucking company from the combo box and the focus stays on the combo box. Quick question can u change the backcolor a unenabled field from grey thanks for all your help...
  6. C

    Check box form problems

    On a form i am going to have a check box for each U.S. state abbrevations. In my table i am going to have a field called StatesServiced. I would like it to work like this, Lets say you check the boxes for nc,sc,ga,fl, it shows in the field stateservice such, "NCSCGAFL". Remember each state...
  7. C

    simple look up question

    I have a table with mc#,company,address, and etc. The mc# is made up of a 5 digit number, with no duplicates. I would like to make a query where i could type in the mc# and the query pulls up the rest of the information. I appreciate any help thankyou...
  8. C

    Qeury dates

    I have a table with fields pickup date, delivery date, cost, company and so forth. I made a form called weekly summary. I typed a control that says "Input start date and finish date" and an unbound control. I can make a query to find the information i need by putting in the criteria for...
  9. C

    check box

    how can you make a control source where you cannot type in it unless you check the check box. thanks
  10. C

    update data

    i have a table with trucking company information such as address phone, fax, and cargo insurance dates, and liability insurance dates. i need a form to update the trucking company insurance that has expired. I do not want to pull up every trucking company that has expired insurance, but just...
  11. C

    form problem

    I have a form with a combo box on it that pulls information from a table called customers. The combo box pulls information such as company name, address, phone, and etc. In the customer table I have a field for cargo insurance and liability insurance. The validation rule for the cargo...
  12. C

    Auto lookup

    All I need is for the combo box in an order form that looks up a company from a table called "companytable" to fill the address and state in the appropriate places on the form the combo box displays all information but instead i wish it just showed the company name and in the fields on the form...
  13. C

    list boxes

    Could I please get some help, I have a drop down box with Customers listed. I have maybe 20 customers. The record source for the drop down list is a table with fields customers, address, city, state, phone and etc, The problem I have is I would like for when I select the particular customer...
Back
Top Bottom