|
Filter by form (Report) problem
Below I am posting my code for a form that should help me filter a
report. I am getting a syntax error here:
' Combine criteria strings into a WHERE clause for the filter
strFilter = "[RCName] " & strRCName & " AND [DeptName] " & strDeptName
& " AND [CountofPolicy] " & strNumber & "([EnteredOn] >= " &
Format(Me.txtStartDate, conJetDate) & ") AND "([EnteredOn] < " &
Format(Me.txtEnd...
|
8 |
11.09.2006 13:53:58 |
|
|
Print date from form into report
How to print the two dates in report which i input from the form.
Private Sub cmd_prntrpt_Click()
DoCmd.OpenReport "rpt_qrywebmail2", acViewPreview
end sub
Query
SELECT WM.CRC, Sum(WM.WM_Amt) AS Totamnt
FROM tbl_WebMail AS WM
WHERE (((WM.WM_Date) Between [Forms]![frmWeb_Mailfilter]![txtdate1] And
[Forms]![frmWeb_Mailfilter]![txtdate2])) OR
((([Forms]![frmWeb_Mailfilter]![txtdate1]...
|
2 |
11.09.2006 13:14:01 |
|
|
combobox - multifield & as record source
hi,
2 questions:
#1: A combobox is based on a table - and when in pulldown mode is showing 3
columns. Once the selection is made however only one column is left showing.
Would like all 3 to remain showing.
#2: Same combobox - there is a value in a 4th column of this table (not
seen in the combobox when in pulldown mode) - - - - once selection is made -
I would like this unsee...
|
11 |
11.09.2006 13:06:02 |
|
|
Filter by form more problems!
Okay I had to take out the date and number information to make it work
but I need to include that....can anyone tell me what is wrong with the
original code and this code.
See the trick is i have dependent combo boxes and I need to be able to
leave one blank to filter as well. The fiter works with the code below
but not if I leave the DeptName combo blank... I have no idea how to
fix it.
...
|
1 |
11.09.2006 12:26:13 |
|
|
SnapshotViewer
Dear ALL,
I have an application written in MS Access XP, I'm using the outputto
(snapshot) function to display some reports. I've built my .Mde file but some
end-users are using MS Access 2003 and in some cases this function does not
work properly (even after un-installing 2003 and re-installing xp). I've
noticed that the snapshot viewer library have 2 different versions on xp and
200...
|
4 |
11.09.2006 11:55:26 |
|
|
many-to-many form
i have 3 tables
Simplified:
PatientTable
PatientID (PK)
PatientLastName
PhysicianTable
PhysicianID (PK)
PhysicianLastName
PatientPhysicianJunctionTable
PatientID (PK)
PhysicianID (PK)
i don't understand how to use a form to input the information.
I want to enter patient info and physician info but am so confused. how do i
use the junction table in my form? do i need to b...
|
3 |
11.09.2006 11:37:02 |
|
|
how can i get rid of signature validation on my machine?
i keep on getting a window when i want to go into a program that says
signature validation, i can't even get into the control panel section of my
computer....
|
1 |
11.09.2006 07:50:02 |
|
|
identical controls on one form
Is it possible to have multiple, identical controls, on the one form to
update a single table. I wish to do this to make an otherwise complicated
data entry sequence easy as the operator will then be able to see where they
are up to...
|
2 |
11.09.2006 05:20:52 |
|
|
transfer subform data into unbound excel sheet
hi all
I want to transfer data from subform(in datasheet view ) in to excel
sheet (as unbound control).Is there any easy way to do it.
My subform is based on query and the data in subform is filtered data
using combo box in form.i.e. from combobox I select a particular
'Location' and I get data in subform for that particular Location.
Now I have excel chart embeded as unbound object frame ...
|
1 |
11.09.2006 05:11:05 |
|
|
Access and VB
Ok I an new to this and need a little help....
I have customised the following code but I dont know how to implement in to
the access form, do I put the code behind a command button? Any help is much
appreciated.
Function OnHand(vProductID As Variant, Optional vAsOfDate As Variant) As
Long
'Purpose: Return the quantity-on-hand for a product.
'Arguments: vProductID = the pro...
|
27 |
11.09.2006 02:49:43 |
|
|
Blank Report
Hi: Is it possible that if i leave the CRC or date blank in my form
(frmweb_Mailfilter) it will show all of the record. As right now if i
am not select any value from the form it shows the blank report.
SELECT tbl_WebMail.CRC, Sum(tbl_WebMail.WM_Amt) AS Totamnt
FROM tbl_WebMail
WHERE (((tbl_WebMail.WM_Date) Between
[Forms]![frmWeb_Mailfilter]![txtdate1] And
[Forms]![frmWeb_Mailfilter]![...
|
2 |
11.09.2006 02:30:44 |
|
|
Prompt to enter date again
Hi:
When i run my report it ask me a prompt to Enter Date, I already enter
date from the parameter form, I dont know why it ask
me to enter date. The date variable is in the query but i didnt define
into the report
Private Sub cmd_prntrpt_Click()
On Error GoTo Err_cmd_prntrpt_Click
If IsNull(Me.ddlcrc) = False Then
WCriteria = "[crc] = '" & Me.ddlcrc & "'"
End If
If IsNull(Me.dd...
|
6 |
11.09.2006 00:00:46 |
|
|
Using a Calendar Control to fill in dates in a form...
Hi. I am using Access 2k and I have a form with two text boxes
that should contain start date and end date. To the right of the text boxes,
is a command button. By clicking this, a calendar form should
appear and the selected date should be filled in the appropiate text
box when I close the Calendar form.
Now, I have made a new form "frmCalendar" with MS Calendar Control 9
that ships with ...
|
2 |
10.09.2006 22:21:47 |
|
|
How to show the record count of the table used on a form ?
How to show the record count of the table on a form ? I'd like to just use
a function to display this number in a text box
I've tried setting the default value of a text box to
=RecordCount
=[CurrentDb].[RecordCount]
=Forms!d_main!RecordsetClone.RecordCount
and other vairatons; I'd rather not use code and record sets. Wouild like
to keep it simple ...
...
|
2 |
10.09.2006 21:48:38 |
|
|
Option Group Not Responding to Option Button Selected
I have had no responses to two similar postings so I am trying to state my
problem more clearly.
I have several Option Groups on a Form with no defaults. The first time I
click an option button, the first option button "On Got Focus" event is
triggered no matter which button is selected. After that first click, the
selected button event is triggered.
Any suggestions?
Thanks,
Ji...
|
5 |
10.09.2006 21:28:15 |
|
|
forms load slowly.
Hi,
I am an MS Access newbie.
I have a form with two subforms. Main form and subform both quries the
SQL db though ODBC link. When I run main form and subforms
independently, they are very fast but as soon as I put them together in
a single form (main form + subforms), it takes 3-4 seconds to load.
There are not any complex calculation involved.
Is there anyway I make this load fast or atle...
|
3 |
10.09.2006 20:46:25 |
|
|
Query
Hi: When i run my query between two dates its not sum WM_Amt on the
basis of two dates
SELECT tbl_WebMail.CRC, Sum(tbl_WebMail.WM_Amt) AS Totamnt,
tbl_WebMail.WM_Date
FROM tbl_WebMail
GROUP BY tbl_WebMail.CRC, tbl_WebMail.WM_Date
HAVING (((tbl_WebMail.WM_Date) Between
[Forms]![frmWeb_Mailfilter]![txtdate1] And
[Forms]![frmWeb_Mailfilter]![txtdate2]));
CRC Totamnt
Acito, Lisa ...
|
4 |
10.09.2006 16:31:38 |
|
|
i need urgent help with command button
i have main from and employee form i need to create command buttonin the main
from that when you click on it employee from but with new record and taking
care of nothing dupplicate the old information
could you please help me with it...
|
2 |
10.09.2006 15:33:33 |
|
|
Form Size
I am creating a main form in Design View. It will just contain command
buttons that open other forms.
When I go to design view, it gives me the form canvas and the window that
the form is designed in. If I wnat the form to be 3" by 4" I can drag the
canvas to that size and it is great. But the window might be open to 8" by
9" for design room. I am making a form with THIN Borders, no...
|
6 |
10.09.2006 14:31:37 |
|
|
Check Against Group
I've got a form with a button to open up a list of management reports but I
want to allow only users who are members of "Management" to be able to click
the button and open up the list of reports. How do I go about doing that?
Thanks
ck...
|
2 |
10.09.2006 10:36:09 |
|
|
retrieving data
I have a table with 2 columns, CoName & CoLocation
CoName allows dupes, CoLocation does not.
On my form I will create a drop box to choose the CoName.
I then want to use a drop box to choose the CoLocation while seeing
only the locations that are relevant to the particular CoName I chose.
I'm not sure how to do this. Does each CoName need it's own
CoLocation table? Seems like it would b...
|
5 |
10.09.2006 04:16:03 |
|
|
I have some informations about your affircan branches
Hello
I recieved an E-Mail about a LOTTORY mail form a company that called himself
one branch of you.
please give and send for me clearly informations about it.
Thank you
pooya_davoodi...
|
4 |
10.09.2006 00:39:01 |
|
|
Form open in the background
Hi: I create a button on my main form. When i click on it the other
form is open in the background of the main form. Can anyone please help
me why it open in the background of the main form.
Thank You.
...
|
2 |
10.09.2006 00:36:01 |
|
|
PREVIOUS RECORD VALUE IN FIELD
HELLO
PLEASE CAN SOMEBODY HELP ME OUT ON THIS PROBLEM
I AM WRITING AND ACOUNTING DATABASE AND I NEED TO GET THE PREVIOUS RECORD
FIELD (WHICH IS SUM( "A" FIELD + "B" FIELD)
E.G
DATE FIELD A FIELD B TOTAL (FIELD A + FIELD B)
9/1/2006 100.00 100.00 200.00
NOE I NEED LIKE THIS
DATE OPBALA NCE FIELDA FIELDB TOTAL
9/2/06 2...
|
7 |
09.09.2006 23:46:11 |
|
|
fill in fields on subform
My main form is for my Contact table.
It includes your basic data of name, Address, City, etc.
I have a field called ContactPatientRelationship.
If that field is filled in as "self",
i want my sub-form (to input Data for my Patient Table) to automatically
fill in the corresponding LastName Field, Address Field, CityField, etc.
Thanks for the help....
|
1 |
09.09.2006 23:17:01 |