Search results for query: *

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...

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...

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...

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...

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?

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...

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

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...

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...

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...