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: Parula
  • Content: Threads
  • Order by date
  1. Parula

    NEED SQL HElP?

    Hi everyone This is my SQL statement for a append query. i would like to put in a funtion that asks the user how many number shold be appended before it run.Is there a way to it? INSERT INTO an_sent ( cust_salutation, cust_fname, cust_lname, cust_addr, cust_city, cust_state, cust_zip, c_type...
  2. Parula

    Yes/No data field?

    Hi everyone I have a table that has a field with yes/no check box. If you have table of customer and that as the field with yes/no check box. I have query that uses zip code to pull the information When that record is use I would like the yes/no box to be check of automatically. But...
  3. Parula

    default value for data field ?

    Hi all I have a simple question. If you have field in a table with the data type test but you used the Lookup wizard to create a drop down menu. I have six options on it but I would like one of them to be a default value.the six option i have are AN,FV,LP,BD,TY,AND IN, and i would like IN to be...
  4. Parula

    how to format a text box????

    i have created a combo box that when the user enters in a zip code it give the total number of records that meet that criteria. i also have a text box that i would like the user to enter in the x number to append to a table. i am giving you my code for the combo box which should help you. How do...
  5. Parula

    How to creat a Macros

    IS it always a good idea to creat a Macros for a append queries? If so can you explain how to creat a a macros?
  6. Parula

    need help with form?

    Ok I am creating a database for a restaurant. This database is going to keep track of all the customers and the business transaction. The customer’s part keeps track of all the frequent customers and customer’s birthday and anniversary. In the for I created I would like the user to enter in a...
  7. Parula

    Help with data type date?????????????

    I have a table that has a field that contains a date. I would like to be able to automatically have the date filled once I use that field in a query. Is that a way for me do that? Thank you Parula
  8. Parula

    text box

    If I have a form with multiple columns and rows in the first column and first row I would like the user to enter in a zip code in the next column I would like the total of all the people in that zip code. I have created a query that does that for me but I do not know how to incorporate that...
  9. Parula

    how to automatically fill in a field in a table

    Hello all, my husband recomended this site. He says there are geniuses out here. So here's my dilema. I am creating a access file that outputs info to a mail sorter. My goal is to use zip codes to pull addresses from a huge local address database based on the users request of how many...
  10. Parula

    automatically check off a field in a table

    Hello all, my husband recomended this site. He says there are geniuses out here. So here's my dilema. I am creating a access file that outputs info to a mail sorter. My goal is to use zip codes to pull addresses from a huge local address database based on the users request of how many...

Part and Inventory Search

Back
Top