Filtering a query for a form based on dates
Mon, 25 Aug 2008 21:25:16 GMT
I have a query that is used to provide data for a form. The query has a
field that identifies the date an item was sold. That field is specified as
a date field. In the form, I put a value into a text box and requery. The
only thing that will work if there are dates in the text box. If I put in
anything tha ...
|
email function syntax error
Mon, 25 Aug 2008 14:06:18 -0700
I have a simple function to open an email with the recipient and subject
filled in. The function is pasted below. I want to set a button on a form
to use that function and fill in the recipient and subject. When I try to do
that on the on click event for the button I get an error: "Compile error :
Expecte ...
|
Don't Close Form If...
Mon, 25 Aug 2008 13:54:10 -0700
I want to build and event procedure in Close Form that says if field A is
null, don't close the form.
If IsNull(FieldA) then
MsgBox "Field A is Not Complete"
End If
But how do I then state, don't continue to close the form. ...
|
SQL syntax problem
Mon, 25 Aug 2008 13:32:05 -0700
I have a query statement that runs off of the users input in a textbox on a
form. The input is placed in "Var1" and used in a SQL string shown below.
The Append in the string is used to combine two informational fields in the
source table, Project Name and Project Description; to help increase the hits
on ...
|
Secondary Tag
Mon, 25 Aug 2008 13:18:19 -0700
I am using a tag on controls to flag certain controls for certain
programmatic manipulation.
I need manipulate others groups of controls, some already have tags set.
Is there another way to tag controls so I can have two independent sets of
tags, like a tag2 property ...
|
RunSQL problem
Mon, 25 Aug 2008 11:46:03 -0700
I have an unbound text box on a form, that needs the following code to be run:
SELECT Count (*) AS NewTotal
FROM tblIssues
WHERE Risk = True
HAVING tblIssues.Status = "open";
I can't get it to work. I have a button that filters the records for Open
Action Items. I also what the button to do the docmd.Ru ...
|
Export form data to text file
Mon, 25 Aug 2008 11:24:04 -0700
Is there a way to export data from form fields or from code directly into a
text file? Iâ??ve looked at the DoCmd.TransferText acExportDelim option, but
that appears to need the data to be in a table, which Iâ??d rather avoid. I am
trying to feed commands to one of our programs, and they have to be done as a ...
|
|
|
treeView Expand/Collapse problem
Mon, 25 Aug 2008 11:22:03 -0700
Hi,
I have a treeView in my form that works fine but I wanted to add an event
that nodes should expand one at a time. Meaning if 1 of the nodes selected
(HOSP1)it will expand the child nodes normally but if another nodes (HOSP2)
selected it should collapse the first nodes(HOSP1) selected automatically.
o ...
|
on_exit Event Procedure
Mon, 25 Aug 2008 10:28:05 -0700
Hi Everyone,
I have the following code to message the user to enter in an employee's name
if the user forgot to.
Private Sub txtEmpName_Exit(Cancel As Integer)
If IsNull(Me.txtEmpName) Then
MsgBox "Please Enter Employee Name"
Me.txtEmpName.SetFocus
End If
End Sub
This messag ...
|
Every 382 Records
Mon, 25 Aug 2008 09:26:01 -0700
I have a simple line to put a date into a table using a form. The tables
have an average of 300,000 records in them and to put in a pre-determined
date I just run:
Private Sub ID_GotFocus()
Date = "08/04/2008"
DoCmd.GoToRecord , , acNext
End Sub
When it's gone through the whole thing and put in the dat ...
|
