Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: DBServices
  • Content: Threads
  • Order by date
  1. DBServices

    Looping through recordset problem

    I have been building a database for my barber shop. On my unbound "frmHaircuts" I have some option buttons for the user to select which kind of haircut the customer just received. I have corresponding text boxes with DLookups as the control source displaying the price for the selected haircut...
  2. DBServices

    Need help on inserting record into a table

    Hello, I am building a database for a barber shop. Not too complicated and it's coming along well. I have an unbound form that has option buttons for user to select types of haircuts, prices, and payment methods. After all fields are populated, user clicks cmdSubmit button. This runs an Insert...
  3. DBServices

    File picker for image help

    I am making a frmCustomers form. It is bound to the tblCustomers. On the form I want to put an image box (do i use image boxes, bound/unbound object frames, or Active X controls?). I want the image to only display the image, not store it in the database. I've used the File Dialog Picker before...
  4. DBServices

    combo box value trouble

    I have a problem I can't figure out. I have a couple unbound combo boxes (cboEmployeeName and cboCustomerName) on an unbound form along with other controls as well. There are numerous controls on the form for user to select and once all are selected, I have a submit button that will run a SQL...
  5. DBServices

    DLookup Problems

    I am building a database for a barbershop. It's not that complicated of a database but I am having problems with the DLookup function. If anyone can help me I'd be greatly appreciative. Thank you in advance! I have an unbound form that will be used to select a customer (or add new one), and then...
  6. DBServices

    Need help on using SQL Server tables linked to Access as a front-end

    I have been working with Access for quite sometime and have a good knowledge of VBA as well. I have never used SQL Server as a back-end but I'm planning on building a database that would definitely require SQL Server. Can anyone please direct me to a step by step on how to link Access as a...
  7. DBServices

    MS Access integration with cash drawer, credit card machine, scanner??

    I would like to build a database using MS Access but was wondering if there are printers and cash drawers that will integrate...Does anyone know of any cash drawers or bar code scanners that will work with Access??? Any and all help would be greatly appreciated...Thanks.
  8. DBServices

    aggregate function error again...

    I have 3 unbound combo boxes on a form. All three have multiple columns and the third column of each combo box has a price field. All but one column have a column width of 0 so the only field being shown is the "Name" field. In my forms footer section I have a text box that I want to show a...
  9. DBServices

    Need pointing in the right direction for modifying order entry

    Am building a db for a restaurant. Have been working on this for a while now and MajP has helped me tremendously. I have started another thread due to the extensive length of the previous one concerning the same db...thread702-1616766... MajP, I would like an idea or two on how to modify an...
  10. DBServices

    formatting a listbox and have problems...

    Basically what I want to do is format a list box to look like this: BACON BRKFST PLATTER ----Egg OE ----Grits ----White Toast 3 FRENCH TOAST ON SOUR DOUGH NEW YORK STRIP & EGGS ----NY Strip MR ----Eggs OE ----English Muffin ----Grits Here is the code I have so far, but the AddItem is not...
  11. DBServices

    Invalid Use Of Null Error in RecordSet

    I have a list box that is used to display info only. I am looping through a recordset and displaying the fields using the add item method, however, one of my variables will be null for some records and have a value for others. I get the "Invalid Use of Null" error when the var is null. I have...
  12. DBServices

    3rd party software needed so Access can open cash drawer

    I am creating a restaurant database and I would like to make this database handle everything including popping open a cash drawer.Is there a specific software that will integrate w/ Access I can get? Because I don't want to have to use database to create order and then have to use cash register...
  13. DBServices

    advice on software to use to take cash in Access

    Hello, I am presently building a db for a restaurant and it's coming along well. MajP has given me some valuable advice and I am very thankful. I have a couple questions: 1.) I want to make the db do everything from entering an order to taking cash/credit to settle a ticket. Is there some...
  14. DBServices

    need direction on how to enter order

    Am building a restaurant db. I want to have the servers select the dish and then select the side(s) that come with the dish. My idea is to have a main form that will populate a listbox on it with the relevent items based on the category they selected, such as "Breakfast", "Lunch", etc...Once...

Part and Inventory Search

Back
Top