Recent content by Parula

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

Kethryn i mean only the customers who are returned in the query. also if i don't uses the yes/no check box. is there a way when i run the query more them once i don't get the same customers recodrs again? thanks Paurla

Hi Kathryn I am sorry about the confusion. I field’s name is cust_in_sent. I would like the yes/no field to be set to NO until I run the query. When I do run the query I would like all the records in the table customers to be set to YES. But after a few months I would like those records...

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

Thanks Joe I got it to work. Parula

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

Lonnie i wanted to know if you have checked you email tonight? i email your my program. i am going to try out this code you sent me. i would like you to look at the program i am working on. thank you Parula parula28@hotmail.com

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

hi Lonnie i tried to email yout he file but it was to large so i get my self a storage space online. It's at www.idrive.com. i email you the password and username at you yahoo address. thanks a million parula

Hi Lonnie i will try this but if it doesn't work can i email your my project and see if you can help me?

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?

Hi I would like to reactivate these addresses after some time as passed. I don't know how to uset he DataMailed field. Can you explane it to me?

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

Hi Tim1 Yes I need to update a table when the user pulls x number of records. However, I also want is after a certain period of time the records should be come active again. I would like to do just what your example said. Can you please help me? User selects a zip code, which returns a value...