|
Hyperlink default
I have a click button that takes me to the edit hyperlink window. I would
like to have that window go directly to a default location. Is there a way to
do this?
...
|
11 |
26.09.2006 22:25:02 |
|
|
Leban's Tooltip code--- Help!
I love this tooltip routine and have started putting it into my db. The
only thing I am asking of it is to allow the user to click on a question
mark (lblHeader) and display a form msg. It worked on the first form, and
the second, and the third. The fourth form, however, crashes at the Call.
..create line. "Object variable or with block variable not set"
I am baffled. I checked the fo...
|
4 |
27.09.2006 17:47:22 |
|
|
Autofill and second column of combo box failing
Hi all,
The setup is such cboVirus-->cboTest-->cboItem. The latter two combo boxes
are dependent on the preceding one, and have a column count of 2, (bound: 1),
where the second column is the test version or item version number.
When I write the code or go into the Row Source SQL statement and return to
the form, the numbers in the second column appear. And my code appears to...
|
7 |
27.09.2006 17:26:02 |
|
|
Desperate for help
Duane has been helping me quite a bit, however, I need to get this script
(his script) to work on my form...ASAP. Even I can't be on the computer 24/7
Can anyone tell me why this is not working? (aside from stupidity on my part
....this has been established)
Private Function UpdateRowSourceProp()
Dim strSQL As String
strSQL = "SELECT ApptTime FROM AppointmentTimes " & _
"WHERE ApptTim...
|
13 |
27.09.2006 17:16:51 |
|
|
What went wrong?
I have been using a form for showing the “available inventory†and orders
that need to be shipped from this inventory. The forms data source is based
on 2 nested queries, each time the user releases goods to be shipped the
available inventory is reduced.
The code for this is as follows;
[Forms]![frmCMAOpenToRelease].Requery
Recently I have updated the form with cosmetic impr...
|
8 |
27.09.2006 16:18:02 |
|
|
me.dirty
I have where the user can optionally enter information in text boxes. There
are command buttons that move the user to the next form to enter more data.
I want to prompt the user to save information if they have entered data
before moving on to the next form. I attempted the following, but got an
error (2455)
If Me.Dirty Then
Msg = "Do you want to save your changes?"
Title =...
|
9 |
27.09.2006 16:17:02 |
|
|
Command Button Data Duplication on Switchboard Form
I used the event procudere On click process (from wizard) in a command
button, I placed on a switchboard, to build code to talley data and dump into
a table called Talley. When I created a second commsnd button also using the
cmdSortintoQuestion and tried to talley a different table called TalleyColl
with the same type of format, the TalleyColl code copied identically back
into the first...
|
1 |
27.09.2006 15:03:02 |
|
|
What property locates a control on a tab page?
I'm writing code to create a tabbed form with controls on each of the tab
pages. (There will be over a hundred buttons, and certain buttons will
occasionally need to be added or deleted or repositioned. Rather than
clicking and dragging these hundreds of buttons by hand, and revising them -
again by hand, the code will create -and re-create as necessary- the form.)
The problem is that...
|
4 |
27.09.2006 13:44:53 |
|
|
Slow data entry form
I have a payroll data entry form that compares the record just entered to
processed records in a history file to check for duplication. If the employee
number, budget code and work date are the same as a record in history, it
warns them of a duplication and tells them which batch to check to verify
that it isn't a double payment. (Some duplications are valid.) My code may
not be elegant...
|
2 |
27.09.2006 09:29:26 |
|
|
Creating string to use as dynamic Crosstab column headings
I am trying to create a string that I want to assign to a variable that I can
use to insert dynamic column headings in a sql statement. The following is
the code im using, but Im having problems inserting the required "'s around
the report names as it runs throught he loop. Im not sure of the syntax to
insert the "'s. Anyone please?
'open Database Connection
With cn
...
|
2 |
27.09.2006 04:50:34 |
|
|
how do I calculate a field?...or add them up?
Hello here is my situation.
I have a form that has a sunform on it. there is a field QTY that is taken
from a table. I am doing the subform in tabular format and when I run the
form usually or in this example I get 4 listings, there are other items on
the form such as ProductID, Price, Qty etc.
So these four products show up for this particular customer and the
quantities of each...
|
3 |
27.09.2006 04:44:03 |
|
|
Keep only two forms on top visible
I have an access2002 application with all forms Modal and Popup.
I make only two forms (top two) visible at one time, otherwise too many look
messy. Now I just use form Visible on each form's open/close events.
Wonder if there is an alternative way to implement this? Is there a way to
refer to the forms on top?
Thanks,
John
...
|
1 |
27.09.2006 04:39:45 |
|
|
Subform Filter
I have a search form that when searched opens a subform in the bottom with
the results of the search. I have many parameters to search by in the event
procedure of the on click function of the actual search button. In the below
code all the parameter searches work except the "If Assigned To" parameter of
"Issues.[Company] = " & Me.AssignedTo & "'"
I get the run time error 2448 Y...
|
2 |
27.09.2006 03:56:21 |
|
|
Problem with MOUSE SCROLLING
I have copied the code and .DLL from the
http://www.lebans.com/mousewheelonoff.htm. I have placed the .DLL file in the
folder of the .MDB. The code has been placed in the Form Load() Event. When
the for loads an error comes up - Compile Error: Sub or Function not defined.
This happens at the code:
blRet = MouseWheelOFF(False)
I hope someone can HELP MOI!!!
Newf
--
Newf
~Everyone n...
|
7 |
27.09.2006 02:24:26 |
|
|
anyone help me?storing the path...
helo everbody...i think i have ask this question many time...is there
anyone can help in this problem?? i've got link to storing path to
database...can anyone help how this program work??please...i really
need an explaination...this is the
link...http://www.datastrat.com/Download/Picture2K.zip
...
|
5 |
27.09.2006 00:23:14 |
|
|
Go through all the records....
I have the following code already there and it does what it needs to... sort
of.
Private Sub Form_Open(Cancel As Integer)
Dim strActiveNo As String
ctlActiveNo = Me.optActiveNo
If strActiveNo = 1 Then
Me.txtTermDate.Visible = False
Else
If strActiveNo = 2 Then
Me.txtTermDate.Visible = True
Else
...
|
13 |
26.09.2006 22:23:02 |
|
|
How to handle the user pressing the enter key
Hi all,
I thought I had this figured out, but obviously not. I have a login form,
and I was getting tired of always having to tab to the login button. So I
thought I would add events to the password field and the buttons "enter"
events.
Well, much to my surprise, I started to get strange errors as soon as the
form loaded and I started to enter my info. Turns out the enter event isn't
...
|
8 |
26.09.2006 22:23:01 |
|
|
Help with opening a 'pop up' form with the right record
Hi All,
I have a main form that displays products, and I need to build a 'pop up'
form to display information about the product selected on the main form. I
have a query as the source of the pop up currently, but I'm not sure how to
have the pop up on the right record when it opens. Do I need to create a
parameter query, and then do some VBA in the pop up forms 'On_Load/Open'
event?
I...
|
5 |
26.09.2006 21:51:11 |
|
|
Pass number from main form to third form
Hello,
I have three forms:
1) frmMain - cboAssetNum
2) fsubproperties - Skip Command Button
3) fskip - Skip option group
I want to pass the cboAssetNum to the fskip form and update a table.
Below is the code I have:
DoCmd.RunSQL "INSERT INTO tblVendorAssignment (SkipDate, VendorID,
AssetNumber, SkipReason) VALUES (#" & Format(Me.txtcurrdate,
"mm/dd/yyyy") & "#, '" & Me.txtV...
|
5 |
26.09.2006 21:50:14 |
|
|
More problems with Multiselect List Boxes
I can't get this list box to work with more than one choice. It works as
planned for one choice, but not more than one. Can someone take a quick look
& see what the deal is? Here's what I have:
Private Sub OkCmd_Click()
Dim frm As Form
Dim ctl As Control
Dim varItem As Variant
Dim strSQL As String, strWHERE As String
Set frm = Me.Form
Set ctl = Me.lstLevel
For...
|
11 |
26.09.2006 21:36:24 |
|
|
How do you apply a default value to an Option Group?
I have an option group with four choices and I would like to have one of
those choices to be the default value for every new record created. In the
"Properties" dialog box there is a choice for a default value. When I enter
the option value for the choice I want to use it doesn't show as being
checked in the new record. What am I doing wrong?
Thanks,
Jim...
|
4 |
26.09.2006 21:28:58 |
|
|
using a form to query
I have a table that I need to query with 5 variables. The first is date
range and that is no problem but where I am having a problem is with the
other fields. The other fields are text fields and are labled Supervisor,
Department, Standard/Nonstandard and Part Name. I have created a query from
the main table that holds all the history. Each of the four fields listed
have their own tables ...
|
5 |
26.09.2006 20:43:01 |
|
|
Update top n records
My form is based on a query of just 1 table and has 3 controls; a combo box
with 1 bound column, an unbound text box for a number, and an "update"
button.
Is it possible to update a table with the following pseudo code?
update [table] set [field] = "value" where [field] = "value" for first n
records?
From the form's controls, the user can select these values and then click
"upda...
|
14 |
26.09.2006 19:18:24 |
|
|
Enforce combo box
Hi,
For my Access 2000 application, on my input form, I have a combo box. How
can I force the user, input the data only by select from the list available
not by typing. Thanks for your kindly advise....
|
3 |
26.09.2006 19:07:33 |
|
|
Printing Problem
The portion of code below is attached to the On Click Event of a button on a
form. The idea is to allow a user to preview or print a report. Here's the
problem. When the user selects preview (Yes), the report is displayed on
the screen in perfect format and data. If the user then decides to print
the report by File>Print or CTRL P, the first field on the first detail line
is blank...
|
2 |
26.09.2006 18:42:01 |