Easy One - How to reference Label in report from Code
Wed, 26 Nov 2008 16:58:01 -0800
I need the caption of a Label in a report to change depending on whether or
not a combobox on a form has data typed in or no data typed in.
Help? ...
|
Copy SQL from query - paste in form
Wed, 26 Nov 2008 17:57:24 -0600
Hello there,
I have two query's; one to get totals for pallets received on Mondays
and the other to get the average from the the first query...
Query one - Week Day Totals - SQL VIEW
SELECT RecyHistory.DateRec, Sum(RecyHistory.PalletCount) AS SumOfPalletCount
FROM RecyHistory
GROUP BY RecyHistory.Da ...
|
Referring to a Subform's ControlSource
Wed, 26 Nov 2008 15:40:34 -0800
I want to refer to a subform's ControlSource (Access 2000).
What is the code?
Thanks.
...
|
Auto Fill field - No answer yet
Wed, 26 Nov 2008 14:28:04 -0800
Hi
I'm using access 2007 and I have a form to enter the products info. the name
of the form is "frmProductInfo".
I have two fields that I want the 2nd field to be filled automatically if
the 1st field have certian value. the 2 fields are from different lookup
tables and no relation between the two tables ...
|
VBA filter not working in form
Wed, 26 Nov 2008 17:24:25 -0500
I have the following code set up to filter a form, but the results are
always blank...
any suggestions on what might be going on?
lsFilter is a listbox with a simple mulit select
the values are a string
the field [Catagory] is in the data source for the form and is also a string
strDelim = """"
...
|
syntax error (missing operator) in query expression
Wed, 26 Nov 2008 14:14:23 -0800 (PST)
I have a NotInList that is not working. If I enter in something in the
text box such as SALTY'S #3 it will return the error. If I take out
the single quote it works fine. It is suppose to accept the new text
and add it to the list. Here is the code:
Private Sub Disposal_Site_NotInList(NewData As String, Respon ...
|
Form Resize OnLoad
Wed, 26 Nov 2008 16:55:00 -0500
I have my frmMain form maximized on load. I need it to stay that way.
When I open any other forms, they all maximize too.
I added code like this to set the form's size but they all still load
maximized anyway.
InsideHeight = 7200 ' Five inches high
InsideWidth = 4320 ' Three inches wide
I trie ...
|
|
|
Loop through objects changing background color of certain kinds of
objects
Wed, 26 Nov 2008 13:44:46 -0800 (PST)
I think that sums it up. If someone can help me, TIA.
Just to clarify- I have several forms- and I want to run a program
that will look at each one, and on each form, if the type of object is
a Header, Form, Footer, or Label, change it's background to a given
color.
Something like For each object in objec ...
|
How to bypass the first time user ID dialog with Access 2003
Wed, 26 Nov 2008 13:12:50 -0800
I'm setting up users on a terminal services box (windows 2003) with an
Access 2003 application. For each of these users, the first time they
run the db, it's also the first time they've run Access on that box, and
they're asked to provide user name and initials. That's an Office thing.
How can I make that di ...
|
phone formatting
Wed, 26 Nov 2008 12:59:31 -0800 (PST)
Can someone please tell me how to format a text field that i have
combined other fields in so that the phone number has the following
format (999) 999-9999
design view =
=[First Name] & " " & [Last Name] & " PHONE:" & [PHONE] & " EXT:" &
[EXT] & " TOLL FREE:" & [TOLL FREE]
form view currently =
COLIN C ...
|
