Search results for query: *

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!

The ID# for the Field Collid is based on the 2 character field Prefix. if Prefix is between AA an FF for examples the value in collid should be 1. or if Between FG and LL it is 2 and so on for 4 Id#s. I was able to do it in series of queries or iif statements but I heard the case select method...

I Have a field called "CollID in a table "test" where I want to assign a number value based on a between statement in a 2 character text field called "prefix" there are 4 variables. I'm a novice at opening a table and using a case statement and edit the field. Any help...

I Need to send 5 access reports to Excel and know how to do this using tools office links or file save as export. I would like to have anyone in the office be able to have a macro or code to do this. Thank you! Bob Woods

My Name example could be John Doe John D. Doe or J. Doe and I want to return Doe J. in A New Field