| Thread | Last Post | Replies |
|
| Linking a Text Box to a cell in an Excel Document | 18 Jun 2008 16:46 GMT | 1 |
I have a very simple Continuous form displaying each record in a table. In that table, I have a field storing a location of a unique Excel document. Is it possible to link a text box in the Form to a cell in that Excel Document?
|
| how i create browse window in access form 2find files&save it | 18 Jun 2008 15:27 GMT | 1 |
i need to know how to create a "browse window" inside a form to search for files and copy them to a default folder on hard drive and save the path for it in a field in table,
|
| Apply value of a combo box as a filter | 18 Jun 2008 13:06 GMT | 3 |
i would like to filter through records on a form using a combo box list. I want the user to be able to select an item in the combo box and have the records filtered to that value. I am able to do this with a Value List RowSourceType and a finite RowSource of items. However, I ...
|
| Passing data from one form to another | 18 Jun 2008 09:20 GMT | 1 |
I have a form (FormA) which is opened from either of two forms (FormB or FormC). I need to pass data in field "Level" from FormA when it closes to either FormB or FormC, field "Level", depending on which form is open at the timing
|
| carry over value to new record and increment by 1 | 18 Jun 2008 07:35 GMT | 5 |
Hello; I have searched the database here and have used some code I found to address the following: I have a form bound to a table. The primary key of the table is the field
|
| Insert text string | 18 Jun 2008 06:38 GMT | 9 |
I would like to insert a string of text into a comment form field. The text in this field is multiple lines and I would like to insert a specific string of text at the end of certain lines of text within the comment field. In other words I would insert the text where I place my ...
|
| Understanding | 18 Jun 2008 00:10 GMT | 2 |
I'm using this code to count things that happened each day of the week - xSun: Count(IIf(Weekday([Collected])=1,1,Null)), it work fine, now, I want to add up the money for each day but "SUM" does not work inplace of "COUNT" I don't understand, would someone explain it to me, ...
|
| VBA to see if a form is open, and close it | 17 Jun 2008 23:01 GMT | 2 |
I have 2 forms, Form A and Form B. I have a control button on Form B. When the user clicks that control, I want to execute VBA code that will close Form A if it is open. But I can't seem to get the right coding. I've tried variations of this...
|
| Subform Default Records | 17 Jun 2008 22:54 GMT | 10 |
Hi- I have a form, frmModelInfo bound to tblModel, and a subform, tblModelinfoSubform1, bound to tblModelInfo. For every new record entered in frmModelInfo I would like to get 5 default records displayed in the subform, with the default values in certain text boxes on each ...
|
| pop up message when sending email | 17 Jun 2008 21:50 GMT | 3 |
When I send an email from my form I get a Microsft Outlook message box. It states: A program is trying to automatically send e-mail on your behalf. Do you want to allow this?
|
| Output to Excel Coding Suggestions Please | 17 Jun 2008 20:19 GMT | 6 |
I have a subform where when you double click on a specific record, another form opens up with specific information for the record selected. This form is a pivot table. What code would I use to automatically output that form (pivot table) to
|
| Set Focus to a null value in a continuous form | 17 Jun 2008 19:56 GMT | 1 |
In continuous FormA I have a field named "Purchased". Before closing FormA, I have a proceedure which checks for a null value for "Purchased" in all records and prevents closing the form if there is a null value. My question is this.... If 1 out of say 10 records has a null ...
|
| Activate a button when data is updated | 17 Jun 2008 18:15 GMT | 1 |
I have a couple of fields that can be changed by the user. When they update them the user is supposed to click the "Calculate" button. Unfortunately people are forgetting to click the calculate button before closing out. I would like to have the button automattically activate ...
|
| get desktop directory | 17 Jun 2008 15:36 GMT | 4 |
I would like to get desktop directory from system. Because every computer has different configure for desktop, i just wonder are there any function to access the desktop information by computer and users.
|
| Best book to learn VBA? (Office/Access 2003) | 17 Jun 2008 14:08 GMT | 1 |
Ok ladies and gentlemen. I really want to learn VBA from the bottom up. What is a good book for a nubee like me? I've been tinkering around and copying from the greats like Allen Browne and Helen Feddema long enough. Some of the code I've worked on I understand, some I don't.
|