Recent content by RPW1

How would i send notices to all the people in my table where we have email addresses in the email field.

PH Thank you for starting me in right direction. My problem is I'm good with queries but not code. My table is named "temphist" and field name is "Dealer" for instance if dealer contains 19 records with value "117" i want to generate an excel speadsheet temp117.xls for those 19 records but if...

How do I avoid creating a table with a make table query if no records exist for a field in my query. Thank you Bob

i need to export number field 2 decimal places from a query as #####.## and it can't have quotation marks in result, to delimited text file it keeps dropping the ending zeros. New writing code. Any Suggestions. Thanks!

Can I bulk email a report created in access to a recipients email address field in database .

I want to create a make table Query which I need to use later with a series of queries and reports but want to create from an open form. I will place a command button to run the query on form. SELECT * INTO [b]temptable name [b] FROM "The tablename I want to copy is the value in a field...

I have a form [b]"View"[b] with 2 fields [b]"Dealer"[b] and [b]"Acct"[b] I have various tables that correspond to the value in the dealer field. I want to query that table and find all the records and all fields in that table with the same value as the acct field.

I can create this report from a query but I have to select the table for the query from the value on the form. There are 25 tables thatr could correspond to the dealer value on hte for.

I have a form called "View" that has two Fields "Dealer" and "Acct #" in a database called "schools". Dealer could have multible values and I have tables that correspond to the "dealer" value in the same database, as the dealer field. I would...

I have a form that inputs data to a table. The form is "Form3" and it appends the records to table Cash receipts. In the on load event I use the following code and it works fine as long as there is data in cash receipts. However if the table is empty it cannot go to the next record...

We have a form called scan where we want to have a choice of scanning a bar code which looks up our acct # from a field in a table called loans where the field name is unitalpha. I want to lookup and place the data from 4 fields in loans in the scan table. if no bar code I want to manually type...

I have various clients that I send databases. Since some use 97 and others use 2000 I am forced to use 97 and the clients that use 2000 need to convert data. They are not computer friendly and is there a way to set up a macro to convert 97 to 2000 placing the 2000 in the same directory each day...

Is there any way that when the combo box on your form gets focus that you do not have to click the drop down box to display the data as it slows down our operation by an extra mouse click with each entry. Bob Woods

My Form pulls up all the records in the table. I want to place a Print record command button that filters that record and prints only that record. Bob

I Want to have a command button on Sub Form "input roster" that jumps to control "name" on main form "input new account" and than moves to next record. Thank You!