Opening and populating a premade Report with a DAO recordset.
Mon, 18 Aug 2008 15:00:02 -0700
I can access the fields I need from the SQL query, but I am having trouble
opening up the premade report and populating it.
Note: sSQL is a functioning SQL query
dim db As DAO.Database
dim rSet As DAO.Recordset
set db As = CurrentDB
set rSet = db.OpenRecordset(sSQL, dbOpenSnapShot)
If rSet.RecordC ...
|
making an Excel code work for Access
Mon, 18 Aug 2008 14:45:01 -0700
I have an excel code that I would like to transfer into my access database. I
replaced the cell numbers with the field names (like so [FieldName]). But I
get a syntax error.
Anyone know where I can some help with this?
=IF(D7="SW",((IF(E7<25,C7*F7*G7/92903.4,((IF(AND(E7>24,E7<38),C7*F7*G7/92903.4*1.5,((IF(AN ...
|
Duplicate records of subform based on main form
Mon, 18 Aug 2008 12:59:02 -0700
I have a subform that i need to duplicate records for but duplicate them to a
new set of records based on the main form.
Main Form Name is WAR
SubForm name is WebFarm
SubForm of WebFarm is WebFarmAIs
If the user goes to the subform of WebFarm and adds data in that subform,
that works. What doesn't work ...
|
Tab control indexing
Mon, 18 Aug 2008 12:56:56 -0700
I have a tab control being used on a sub form that has 10 tabs. Within each
tab there is aproximately 10 questions that the user will need to fill out
for entry of a record. what I need to do is when the user clicks off their
responces the code underneath needs to send the currently active location of
which ...
|
Subform not displaying data
Mon, 18 Aug 2008 12:17:07 -0700 (PDT)
Hi There
I have a three table setup for storing a list of events each person
has attended.
1 - Person
2 - Events
3 - Attendee
I have set it up and it is working and I have a subform on each
person's record that shows which events they have attended. However,
on the table, it only shows the person's fi ...
|
Auto Refresh
Mon, 18 Aug 2008 11:51:07 -0700 (PDT)
Hi there
I have a form and a sub form. The main form is used to add an event
to a table and the subform has a combo box that allows the user to
select and event from the table.
When I enter a new event into the form, it doesn't show in the subform
until I close it and then open it again. Is there anyway I ...
|
Pass name of calling form to pop-up form
Mon, 18 Aug 2008 14:40:33 -0400
In advance, sorry this is so long. I cannot think of a way to compress it.
I have a vendor database. There is a main Vendors table, and a related
PhoneNumber table (since there could be several phone numbers).
There are two forms. One lists all vendors; the other is a subset of
vendors. The forms displ ...
|
|
|
Default value via dlookup doing a calculation instead giving the v
Mon, 18 Aug 2008 11:39:01 -0700
I'm not sure if this belongs in this section or not.
I created code to set the default value of an unbound combobox based on the
following expression:
DLookUp("[tblReportYears]![DateYear]","tblReportYears","
right([tblReportYears]![DateYear],4) ='" & Year(Now()) & "' and" &
"[tblReportYears]