| Thread | Last Post | Replies |
|
| automatic data entry | 24 Nov 2006 07:47 GMT | 4 |
Sorry if I am in the wrong forum but I need direction on this one report. I have a need to automaticallu enter data on regular basis. Every month an employee earns sick and vacation time. I need that to be listed in the table thus the report. I have too many employees to do that ...
|
| macros and merging | 24 Nov 2006 02:13 GMT | 1 |
I have a created a table, form and report of data. In the form, I have a command button named print letters. I am hoping to use macros to take all the data and merge it into a word document so I can print off the data as individual leters.
|
| email help!!! | 23 Nov 2006 18:27 GMT | 1 |
I have created a macro to send an email. It pops up Outlook just fine, however it is not grabbing all of the data in a field. It is limiting it. Here is the macro code To: =Nz(DLookUp("[E-Mail Address]","Contacts","ID=" & Nz([Assigned_To],0)))
|
| want to be able to open a Excel and Word document from Switchboard | 22 Nov 2006 21:41 GMT | 1 |
I am using Access 2003 and i want to be able to open a Word document and Excel document from the Switchboard in my database. i was wondering what procedures must be carried out to make this possible. Can somebody help me please!
|
| Need to enter repetative data in Access 2003 | 22 Nov 2006 13:28 GMT | 6 |
I need to find a way to have this argument automated IF 123 (in field 2) THEN ABC (in field 12). I deal with a lot of the same customers and would like to have Access fill in the Custimer Name field in my fom once I key in the unique Customer ID #. I need to set this up for ...
|
| Macros | 21 Nov 2006 15:54 GMT | 3 |
I have created a macro that runs several queires...now, I want to set a condition where the user don't have to to input the date....I want them to be able to click a button and it will give them the current date information based off of the MAX date information in the table.
|
| Email Message | 20 Nov 2006 15:21 GMT | 2 |
I have a macro the fires out a snap shot of a report based on a record. Each record has a unique number - how do i get this number to appear in either the subject line or the message body of the email ? Thanks for any help
|
| Fw: Exel bestand dat openstaat na een X aantal tijd automatisch afsluiten | 20 Nov 2006 15:06 GMT | 4 |
Zoek een makro dat wanneer een exelbestand openstaat op een online pc na een X aantal tijd automatisch afsluit. Waarom. Wanneer er iemand het bestand open heeft staan kan een andere het bestand enkel openen en lezen maar niet bewerken.
|
| Don't show error message | 19 Nov 2006 00:35 GMT | 1 |
I have a macro with: CopyObject Destination Database: C:\Week\BckWeek.mdb NewName: =Bck() <in my Public Function Bck()>
|
| Week and Date Table | 19 Nov 2006 00:32 GMT | 1 |
I would like to create a table with the fields "week # "and "Date". The Data I'm using Access for is collected the same day every week for X number of weeks starting on pretty much any day of the year. i.e. every Wed. for 7 weeks starting on 11/3/06 or it may be every Tues. ...
|
| Passing arguments into a code based query | 18 Nov 2006 15:57 GMT | 1 |
I have a control button on an Access form that calls a macro in a Module: --- Private Sub Command33_Click() CreateDocs
|
| how to save a macro | 18 Nov 2006 03:35 GMT | 3 |
I was given the following macro to use to enter explanations in a memo data type box: Me.MyMemoField.SelStart=Len(Me.MyMemoField.SelStart) I entered it exactly as was given to me. When I go to enter data into that box I get the following response:
|
| inserting subdatasheet into form using macros | 18 Nov 2006 00:31 GMT | 2 |
I need help. I am wanting to automatically insert a subdatasheet into a form using a command button through macros. Is this possible? would it be better to linke it through an expression, and how would I do that. Thanks!!!!!!!
|
| Obtain distances using zip codes? | 17 Nov 2006 23:21 GMT | 1 |
I have a database with addresses and want to be able to tell access to determine driving distance between my office address versus each employee address zip code. Is it possible to have access utilize the internet to perform this search?
|
| Subst command | 17 Nov 2006 23:20 GMT | 1 |
How can I write a macro that runs this dos command: subst k: "%appdata%" TIA, Kathy
|