| Thread | Last Post | Replies |
|
| Determining number of records returned... | 13 Apr 2005 19:19 GMT | 1 |
We have a lookup form on which a user can specify a portion of (or all of) three various fields. The customers last name, first name and phone#. When the user clicks "find", the following code is run... ' Apply the filter
|
| Code to delete record and linked file | 13 Apr 2005 18:25 GMT | 2 |
I have code on a continuous form that lists all documents related to a particular client. Each row of the form has a field that contains a hyperlink to the associated file [Link]. I created a button that would delete the record and the corresponding file. The code gets an ...
|
| listbox to open files | 13 Apr 2005 16:52 GMT | 2 |
I have a sub table called subLinks. This is a referential table that stores a list of related files to a person's record in tblMaster. The link is stored in a field called fldLink. This field has data like... t:\docs\Plan 106.doc
|
| Passing a parameter to an MDE with ShellExecute | 13 Apr 2005 15:30 GMT | 2 |
I'm using the ShellExecute API function within my MDE to start another MDE. I would like to pass a command-line parameter to the other MDE when it starts, but I can't figure out how. Is there any way to pass a user-defined command-line parameter to an MDE when it starts, ...
|
| Call Public Sub from other form | 13 Apr 2005 14:27 GMT | 1 |
I try to call a Public Sub procedure from outside the actual form it is connected to. In example I use this statement sucessfully: Forms!frm_myform.Form.Form_load
|
| Auto Insert Date by Ticking Check Box? | 13 Apr 2005 12:39 GMT | 1 |
Hi there, i have a tick box in my form called: resolved_tick_box I want to have it so that when i tick this box, it inserts the current date into my text box, called:
|
| Cascading combo box add text | 13 Apr 2005 12:33 GMT | 1 |
Okay here is my thing have cascading combo boxes and the code for one of them looks like this: Dim str As String If Forms![frmSelect]![lbPart#] = "ALL" Then
|
| Execute SQL Server 2000 stored procedure from Access 2000 | 13 Apr 2005 12:27 GMT | 1 |
I have gotten the form to update the sql pass thru query for the stored procedure and the variables are updating correctly. How do I execute the stored procedure which creates tables in SQL Server from Access 2000? Any help would be greatly appreciated.
|
| Pass value between forms | 13 Apr 2005 12:06 GMT | 2 |
I think this is simple, but still I cant figure out the best way. I have a main_form which opens as default form in my Access application. The key element in the form is a combo box listing clients (cboClients). The user selects a client from the list, and all values in the form ...
|
| One step forward, two back | 13 Apr 2005 11:29 GMT | 2 |
Millions of searches through the newsgroup didn't answer my question, which is: If I click on text0, I want it to populate List6 with all corresponding entries!
|
| I have 1 user of my front-end whos calendar objects never work. | 13 Apr 2005 11:24 GMT | 3 |
I have an access app distributed on about 10 machines. 1 of those 10, her calendar objects never work. get an error every time she tries to open my little calendar pop-up form which has the calendar control 10 calendar on it. everybody elses calendar works just fine. for that matter ...
|
| autofit columnwith in listbox | 13 Apr 2005 07:52 GMT | 2 |
Is there a way to autofit each columnwith in a listbox in such a way that every columns text is visible? I guess this is not a simple question; screenresolution, font- and fontsize, max with of the listbox will be variables, or?
|
| Assign next value automatically | 13 Apr 2005 06:51 GMT | 2 |
I know this gonna be simple for expert but not for me. Say I have 2 fields: RefNo (long integer) and Rev (text). Rev stands for revision with the first revision as “- “(hyphen) followed by alphabetical sequence A, B, C,
|
| Can't save record after change | 13 Apr 2005 05:33 GMT | 1 |
I have a database to keep track of recommendations that are made for system improvements within the company. The first step in the process is to make the recommendation, which involves completing four fields. After making the recommendation the user can click a command button ...
|
| problem with openform function closing the previous form | 13 Apr 2005 05:26 GMT | 2 |
a newbie here. Server: M$ SQL 2k frontend: M$ Access 2003 file type: Access Project (.adp)
|