Search results

I have a form where I would like the user to re-enter the same information twice and return an error message if the confirmation does not match the origianl entry. I have the first field bound and the second one unbound with an If/Then clause tied to the AfterUpdate event of the field but I...

I have a field that contains a city and a state (ie. New Orelans, LA). I would like to find a way to strip the state out of the field, put it in another field, and leave the city in the original field. Is there an easy way to do this? Thanks in advance.

I have two tables with bank account information in them. One has the account types spelled out (Checking & Savings) and the other has just the first letter (C or S). I am trying to make a query that compares the two table and gives me anything that is different. How do I tell Access that...

I am trying to make a query that will show records from a table that aren't shown on a series of other queries. There are 15 other queries that pull different records based on the field "Client #". Each query pulls a different series of client numbers from the same table. The final query should...

Is it possible for me to send a report to multiple addresses with each record of the report specific to each address?

Is there any way to automatically update a field with todays date if another field has been changed? If yes, will it only work in a form, or will it work if you are updating info in a query and/or a table? Thanks in advance.

I have a javascript from a website that I would to implement into an access form if possible. The javascript consists of a formula that validates bank routing numbers. Is there an easy way to implement or convert the script to a usable format? The code follows. Thanks in advance. function...

I have a form based on a query and I want the form to show me the first ten records that match the criteria of the query. Is there a way to do this? On a similar note, if I am able to have the form show the first ten records, can I have the form prompt the user for his/her name and have the...

I have a table (TBL-Today) that I need to copy within the same database with a different name (usually TBL-yymmdd). I usually just copy and paste it and give it the new name. I want to make a macro that will copy and paste the table and automatically give it name based on todays date. If that...

Is there a way to have a macro assign and/or remove a primary key from a specific table?

I am trying to change the field names of a table that is created from a text document that I import into Access. The field names are set to F1, F2, F3, etc. I was wondering if there is some way to have a macro slap specific names on those fields.