| Thread | Last Post | Replies |
|
| Bulk Email | 22 Jul 2008 20:27 GMT | 2 |
Hello One and all i have a tbl with the following fields Name Surname Emailaddress i need to send all the people on the list an email through outlook
|
| filtering query to show only future dates | 22 Jul 2008 18:55 GMT | 1 |
I have absolutly no idea how to accomplish this. I need a query that will show only records containing dates in the future and ignore any records that contain dates of the current date and back (the past).
|
| Tallying an evaluation data in Access | 22 Jul 2008 18:25 GMT | 2 |
I have created an evaluation questionnaire with 9 questions for people who attend classes. Each classes has a unique ID but will have several responses. Four of the questions have drop down responses of Yes, No or Blank. The other 5 questions are on a rating scale of 1 to 5. If ...
|
| Prompt in a Report | 22 Jul 2008 17:57 GMT | 3 |
I have a report based on a query that prompt the user for the Relationship Manager name when opened. When I run the query by itself there is only one prompt, however when I open the report, the same prompt comes up 3 different times. I figure that this has something to do with ...
|
| Compare previous records in a query | 22 Jul 2008 17:46 GMT | 7 |
Is it possible to compare a previous record in a query? I have a query that has 4 columns that give me the date, part, operation and Opvalue In a 5th column, I want to compare each line to the previous line, if the
|
| Unique Records | 22 Jul 2008 17:23 GMT | 7 |
In my table, there may be multiple listings for one company, however, each company only has one EIN. How can I get my query to just report 1 record per EIN and show other fields? I thought this would be easy to figure out, but I can't get
|
| Property Definitions | 22 Jul 2008 17:08 GMT | 2 |
When your in access and you right click on an object, form, query or just about anything, you can get to a properties option that has all these settings. Is there a place where I can easily reference what each of these settings
|
| Database | 22 Jul 2008 16:43 GMT | 1 |
If you go to compact and repair our Database and someone else is logged into the database, a pop up indicates who's workstation id is in the database. Is there anyway to run a report at any time to see who is in the database.
|
| sending one email to multiple company at once | 22 Jul 2008 16:40 GMT | 3 |
I currently have a macro that allows me to send emails to user that have invoices that are not credit released. The problem is that i have to copy and paste the email address in the to:field when the email pop ups. Is there anyway that I can put a code in the to: field of the ...
|
| Improving queries resource usage | 22 Jul 2008 16:38 GMT | 9 |
I have a 10 user access backend/front end app which runs sufficiently ok. Recently I deployed a winform/ado.net app that runs a sequence of queries on the access backend db using OleDb ExecuteNonQuery method. Problem is some users have started reporting frozen front end access app. ...
|
| Error - Module not found | 22 Jul 2008 15:55 GMT | 2 |
I have been adding code to my database mostly for actions when you press a button or fill in a form. This morning I opened my database and the module cannot be found. I have an old backup copy that works from two weeks ago so i'm not sure what the problem is. I may have left ...
|
| If Then Else statment Help | 22 Jul 2008 15:54 GMT | 5 |
I have a Module named "NumWeekdays" which take out the weekends between two dates, works fine. I have an "OriginalDate", "CompleteDate", "CurrentDate" and "Text77" fields. On the current record the user will always enter an Original Date. On a
|
| VBA code a text box for dynamic length | 22 Jul 2008 15:31 GMT | 1 |
I have a text box tbConsultNumber. My Company recently decided it wanted to accept authorization numbers in that spot as well. Consult numbers are 7 characters and Authorization numbers are 9 characters with the following format 0000000-0. What I want to do is check the data in ...
|
| How To List UserIDs Of People Using Back End? | 22 Jul 2008 15:08 GMT | 2 |
LdbView.exe does the trick for computer names. But now I've got an app on a Citrix server and everybody's PC name is the same. Is there anything out there that will do something like LdbView, but
|
| Overwrite a Summed Field | 22 Jul 2008 15:07 GMT | 1 |
I have a form that I created that has a box that adds up certain fields. Sometimes, we need the ability to overwrite the automatically calculated sum. Is there a way to do that? Thank you in advance for any help you can give me.
|