| Thread | Last Post | Replies |
|
| How does one code the tab strip control events and make them fire | 26 Oct 2005 21:54 GMT | 7 |
In other words, I'm attempting to code the control's Update event so that another control such as a textbox or lable will either display/ not display. However, I'm limited to using the Tabstrip control that comes standard with Access 2003 upgrade. It seems that nothing I code ...
|
| Print/Save report onto the shared drive and EMail attched file. | 26 Oct 2005 21:25 GMT | 1 |
I have created a report. Now I have to save the copy of this file in PDF format on the server, and then sent that PDF file as an attachement to users via email! How can I do it?
|
| OPen and control of another mdb... | 26 Oct 2005 20:56 GMT | 8 |
I'm trying to have the VBA code module(s) in one MS Access mdb open and execute some code in another mdb file. Assuming that I can run the remote Sub, wll I be able to set some variables so that when that code runs it picks them up?
|
| Revealing the Database Window | 26 Oct 2005 20:23 GMT | 5 |
I've set up an Access menu form that activates when the file is opened and guides the user (potentially non-computer literate) through common data manipulation tasks, automating as much as possible. In order to keep the screen as free from confusing clutter as possible, I
|
| Distinguishing root cause of Form_Close event | 26 Oct 2005 19:22 GMT | 5 |
Is there any way to distinguish from Form_Close events what caused the form to close? Specifically, I need a different behavior if the form was closed because the form was closed by the corner button or if it was closed because the application is closing.
|
| filter to another textbox | 26 Oct 2005 18:01 GMT | 4 |
Hi, i'm with big problems to do this: whta i want to do, is, i have two textbox one call Tpesquisa and the other one calls Lmedicamento (this one is a listbox). in the Tpesquisa when i put, for example the word a or b, etc, i want in the Lmedicamento shows the words
|
| MDE file and VBA | 26 Oct 2005 17:25 GMT | 3 |
I have split my database and I was wondering if the next VBA statement could couse a problem by compyling the front end database. combo1.recourdsource="{some sql code}" after compyling i want to make aa MDE file
|
| Button on Form running a Query | 26 Oct 2005 17:00 GMT | 4 |
I have a button on a form performing a query, using data from the form to go into the "Criteria" argument of the Query. Does this even seem like I'm getting close? New to VBA for Access, but old to VBA. Thanks. Option Explicit:
|
| Exporting a report to multiple files | 26 Oct 2005 16:13 GMT | 5 |
I have been able to export a large report to seperate files by use of a macro. However since there are a large number of files created (over 1,000), I need to find an automated way to use one of the fields in the report in the name of the files. For instance if one of the fields ...
|
| Using IN clause in SQL via VBA | 26 Oct 2005 15:25 GMT | 3 |
I am trying to use some code that I had previously used in another DB that worked, but now for some reason won't. Below is the code and after the code is my question. Thanks in advance for you assistance. Private Sub btnDeleteUser_Click()
|
| Kill Active Connections Programmatically? | 26 Oct 2005 14:11 GMT | 3 |
Is there a way to kill all active connections to an access database? Thanks!
|
| copy values to a report | 26 Oct 2005 13:33 GMT | 7 |
i'm having a problem to copy values to a report. to be more exactly, i have one button and when i click i have this sub function: Private Sub Bok_Click() Dim a, b, c, d, f
|
| Best practice on establishing DB connection | 26 Oct 2005 12:43 GMT | 8 |
I've been reworking a particular DB to gain efficiency in the network environment in preparation for moving it out of a terminal services environment to the users' remote LAN so they can run it across their LAN. I am currently testing the FE on the user's PC's, linked to the BE ...
|
| How can i use dlookup to display data in foreign table | 26 Oct 2005 09:02 GMT | 5 |
I need help using Access 2003, PLEASE. I wish to display customers names if a customer number entered in a form called daily sales with a sub form based on the products sold. I have set primary keys and used the expression builder in the text box properties to display the first & ...
|
| Page Numbers In Reports by Section | 26 Oct 2005 07:03 GMT | 7 |
I have a report that is grouped by customers and would like individual page numbers for each customer in the report (ex. 1 of 2) instead of 1 of 800 (length of entire report). I found an article on knowledgebase as well as one on the Access Web but am having trouble using code ...
|