Hello i a query name- surname-date-emailaddress i want to email all the people on that query using sendto command how can this be done! any help would be...

Is there any mechanism to encrypt a column in MS Access? I'm using 2003 version. Thanks -- Dorian "Give someone a fish and they eat for a day; teach someone to...

I have a database that is updated often with no problems. Today I'm trying to change a title on a form and it's locking up with "There isn't enough memory...

Hello, I have 2 tables tbl.shape and tbl.size, I'm trying to builld combo boxes SHAPE and SIZE cbo.SHAPE has a section of 6 possible shapes. when one is...

Hello, I was wondering if anyone might know the code to use for validating partial addresses? The addresses in my table should look like this: Salem, OR...

Hello, I want to prevent duplicate record entries based on a field. For example, I have a table with an "employeename" field and a "round" field. If a user...

Good day! When pasting a large amount of data into an Access table, I get the error message "File sharing lock count exceeded. Increase Max Locks Per...

Hi all, Can someone help me why I am getting an error on the select statement below SELECT TBL_Name.Invoice, TBL_Name.DeptCode,...

Hello all and thank you for your help. I currently have a Access DB with different forms that uses the MSFLEXGRID. Now that I moved to Access 2007 I get the...

Hi, here is what I want to do: I want to be able to see the sum, average, minimum and maximum, etc underneath the data in the same column as the data. Is...

I have a database with 6 queries, currently I have to manually run each of these, but I want to automate them by clicking a button and letting them all do...

I have like 30 text boxes, each with a different name, with the following control source (sounds like bad design, but its more of an app than a db): =IIf(Not...

Our database is saved on a shared server and it's been working fine for several years. Just last week, 2 of the 3 users of the database can not open a...

I am attempting to use the datasheet functionality in Access2007. When a user either filters the datasheet or sorts the datasheet the Form_ApplyFilter event...

I want to know how to make and =IF function for my 'Amount' column that says, "If the 'Account' value = 1110, leave the 'Amount' field as is. But if the...

I am using Tony Toews code (http://www.granite.ab.ca/access/ temptables.htm) to create a temporary db and table in a project that I am working on. It works...

te iubesc

Merci de vot re accueil chaleureux avec un repas gastronomique , j' ai pas suffisamment profité de cette rencontre en partant comme un voleur ! (Elena , ma...

I have a field that contains City names and need to us it as an HTML Anchor, so there can't be spaces in the names. How can I duplicate a field and replace...