|
Reference to more than one table
I get the following error message when executing the code below:
The specified field '[AcctID]' could refer to more than one table
listed in the FROM clause of your SQL statement.
SELECT tblProvider.ProviderID, tblProvider.AcctID, CCur(Nz(DSum
("[BillPayAmt]","[tblPayDetail]","[AcctID] = " & [AcctID]))) AS
AcctTotal
FROM zAcctNum INNER JOIN tblProvider ON zAcctNum.AcctID =
tblProvider.Acc...
|
5 |
12/31/2008 10:08:21 AM |
|
|
Calculated filed total pivot form
Hi,
I have a master table with employee information with emp ID as primary Key.
Other informations are name, tenure in organisation, designation etc.
I have prepared a Pivot form using the Wizard. I was trying to get the count
of employee with more that 6 months as tenure in the organisation using
Calculated field option in the menu.
Please help me with the corrrect syntax.
Thank...
|
1 |
12/31/2008 9:42:05 AM |
|
|
Prada shoes (paypal payment)www.king-trade.cn )
Footwear (paypal payment)www.king-trade.cn )
Paul Smith shoes
Jordan shoes
Bape shoes
Chanel shoes (paypal payment)www.king-trade.cn )
D&G shoes
Dior shoes
ED hardy shoes
Evisu shoes
Fendi shoes (paypal payment)www.king-trade.cn )
Gucci shoes `
Hogan shoes (paypal payment)www.king-trade.cn )
Lv shoes
Prada shoes (paypal payment)www.king-trade.cn )
Timberland shoes
Tous shoes
Ug...
|
1 |
12/31/2008 5:15:07 AM |
|
|
NIKE AIR JORDAN FORCE FUSION SHOES AJF 5 V JORDANs 5 FUSION NIKE
shoes on
AIR Jordan 1 (paypal payment)www.king-trade.cn
AIR Jordan 2
AIR Jordan 3
AIR Jordan 4
AIR Jordan 5 (paypal payment)www.king-trade.cn
AIR Jordan 6 Rings
AIR Jordan 6
AIR Jordan 7
AIR Jordan 8
AIR Jordan 9 (paypal payment)www.king-trade.cn
AIR Jordan 10
AIR Jordan 11
AIR Jordan 12
AIR Jordan 13 (paypal payment)www.king-trade.cn
AIR Jordan 14
AIR Jordan 15
AIR Jordan 16
AI...
|
1 |
12/31/2008 5:14:28 AM |
|
|
Auto Fill II (for Access 2002)
My questions is similar to the earlier question titled Auto Fill. I am
creating a form and would like to know if it is possible to have the text
boxes on the form auto fill. What I would like to be able to do is choose a
customers name from a combo box and have the information that is tied to that
name in several different tables populate text boxes within the same form.
The combo box is...
|
3 |
12/31/2008 1:38:48 AM |
|
|
2000 - 2003 - 2007 References in Vista - I'm going crazy!
Does anyone have 2000 and 2003 running on Vista? I have some 2003
databases that crash and the 2000 & 2003 VBA reference is the same as
the 2007 reference - all pinting to the 2007 reference! - crashes all
the time.
This set up worked fine in XP.
All installed in separate folders and UAC is OFF!
If someone could check to see if their set up has the same issues I
would greatly apprecia...
|
2 |
12/31/2008 1:31:51 AM |
|
|
Auto Fill
Can you please help me.
I have a master database created, it houses my donor contact history, each
donot has been assigned a donor number. i want to create a table, in this
table i want to be able to type in the donor number and the rest of the field
automatic populate bases upon the information from the master database.
is the duable in MS access 97?
Thanks
...
|
2 |
12/31/2008 1:04:58 AM |
|
|
interface
How can i create a interface (form) which comes up automatically when the
database is
started up.
thx
Daniel
...
|
5 |
12/31/2008 12:39:28 AM |
|
|
Northwind 2007 login form?
I'm creating an inventory database and I would like to use the Northwind 2007
login form. I've created an identical form with the same combo box and login
button. I've recreated the macro on the login button exactly, but when I use
my version, it won't take me to the record I have selected in the combo box.
Is there anyone out there who can explain in detail how the login form is
setup s...
|
2 |
12/30/2008 11:01:01 PM |
|
|
Filtering a Form with a Query
I am trying to apply a filter to a form based on a query. I have four fields
that I would like the user to input from before applying the filter. I am
having difficulty getting the filter to display the desired result. The user
can input from 1 to 4 variables, in this case they are;
- Supplier Code
- Buyer#
- Requisitioner
- Status
So for example, the user could enter their Buyer...
|
3 |
12/30/2008 10:33:15 PM |
|
|
Limit access to tab control page with field
Im trying to block users access to certain fields unless another field (combo
box) contains the word "complaint". The combo box "InspectionType" is on one
page (Inspection Information) of a tab control and all the fields that I dont
want users to access are on another page (Complaint Information) of the
control. I tried putting this into the On Click event of the tab on the
Complaint Informat...
|
7 |
12/30/2008 10:14:15 PM |
|
|
Type MisMatch Error Associated With Dlookup Function On Form
Any ideas why I would get a Type Mismatch error when I try to run this
via code?
Dim MyInt As Long
MyInt = Me.SelectUnAppTicket.Column(1)
Me.UnAppST = DLookup("[Start Time]", "UnapprovedTickets", MyInt =
"[UnapprovedTickets]![PTID]")...
|
4 |
12/30/2008 7:31:50 PM |
|
|
Form entry order
I have a subform which records entries in reverse order. (I am referring to
the record number in the bottom left corner of the form).
For example, I enter record number 1 then click the right arrow to go to the
next record entry. However, instead of advancing to record 2, it goes to a
blank record 1, meanwhile the first record I entered is now record 2.
If I enter a new record and cli...
|
1 |
12/30/2008 7:16:08 PM |
|
|
DLOOKUP - Multiple criteria
Happy Holidays!!
I want to auto fill a text box using two other text boxes as criteria, but
my DLOOKUP results in unrelated data.
The data I need is VendorName
The criteria are Invoice# in tblMASTER (to coincide with Text40 on the form)
and Vendor# in tblMASTER (to coincide with Text52 on the form)
=DLookUp("[tblMASTER]![VendorName]","tblMASTER","[tblMASTER]![Invoice#]='" &
Fo...
|
4 |
12/30/2008 6:11:03 PM |
|
|
Can I make areas on a form hidden, unless...
I have 2 check boxes on my form. Ideally, I'd like for certain text boxes to
remain hidden from sight on the form, unless the appropriate check box is
checked. Is it possible to do this? If not with check boxes, is there an
alternative?
Thanks for your time!!
--
GD...
|
6 |
12/30/2008 6:07:00 PM |
|
|
Expression Builder Help
good morning to all,
I was asked to help with a problem.
we have 1 form (based on 1 table) and want to have 1 text box based on a
field in another table. Using this " = [Viable Tissues]![specimen comment]
" Where "Viable Tissue" is the name of the 2nd table and "specimen comment"
is the field.
we keep getting "#Name?" as a result. Any ideas?
thanks in advance
--
thomp...
|
4 |
12/30/2008 5:54:27 PM |
|
|
Formatting forms in MS Access 2007
I am used to designing databases and forms in Access 2002, but when I started
to use 2007 I cannot format my form's color, size, etc. Is there a setup
that I missed when I installed it?...
|
5 |
12/30/2008 4:55:09 PM |
|
|
Subform counts records in reverse order
I have a subform which records entries in reverse order. For example, I enter
record number 1 then click the right arrow to go to the next record entry.
However, instead of advancing to record 2, it goes to a blank record 1,
meanwhile the first record I entered is now record 2.
If I enter a new record and click the right arrow, the origianl entry is now
record 3, the second entry is r...
|
3 |
12/30/2008 4:41:01 PM |
|
|
Combo in subform
Hi all
I have a main form, frmClient, that has a couple of subforms in it.
One subform is where the user can add the Contact details, name, phone etc,
showing one record at a time with it's own navigation buttons to go to next
or previous contacts and able to add as many contacts for each client (in
the main form) as you wish.
I've got a control to enter the date for a 'follow up' call. ...
|
2 |
12/30/2008 3:35:25 PM |
|
|
Sort data in unbounded combo box
This code will populate an unbounded combo box using the columns headings of
a query. The question I have is: how can I sort the data in the combo box in
ascending order? Right now, it appears that the order to follow the order on
the columns in the query from left to right. For example if the first column
in the query is called Column10, Columns3, Column5 and so on, my combo box
will ...
|
2 |
12/30/2008 3:32:11 PM |
|
|
Need help creating a volunteer time tracking database
I have a form set up with a drop down box for them to chose their name and
then I have a sign in button and sign out button but I'm not sure how to
configure them so that it will log the time in when they click the sign in
button and log the time out when they click the sign out button and be able
total up their time? Need ASAP....
|
2 |
12/30/2008 2:41:39 PM |
|
|
subform not refreshing
When the user types in the main form and then goes into the subform to select
from a listbox item, eveything is fine - the key is correct. However, when
the user then goes to add another record in the main form, the previous
subform data appears. This just happens occasionally. If they save the 2nd
record, go back to the another record and then return to the 2nd record, the
subform dat...
|
4 |
12/30/2008 1:49:01 PM |
|
|
Hyperlink field
I have a form text box linking to a hyperlink field. After setting up the
field it is all fine, I can right click and add and edit links. But if i
close the system and reopen it the hyperlink field only displays the Add to
favourites option on the right click.
I have 2 versions of this system, one which I have keft all the menu options
and toolbars available and this one works fine. How...
|
3 |
12/30/2008 8:10:01 AM |
|
|
Sort unbonded combo box data
The code below will populate an unbounded combo box using the columns
headings of a query. The question I have is: how can I sort the data in the
combo box in ascending order? Right now, it appears that the order to follow
the order on the columns in the query from left to right. For example if the
first column in the query is called Column10, Columns3, Column5 and so on,
my combo box ...
|
7 |
12/30/2008 3:49:01 AM |
|
|
data in variables no longer seen during debugging
Access 2003 : while debugging VBA code (setting breakpoints and such) I used
to be
able to see the value of variables by running
my mouse over them; very useful it was, too. This now seems not to be
working ! Did I throw a switch without knowing ?
How to turn that back on ?
--
Net/Works Consulting
www.networks-cc.com
support@networks-cc.com
...
|
2 |
12/30/2008 2:19:04 AM |