Form filter
Tue, 30 Sep 2008 11:15:01 -0700
Need help with filter
My database has a table called â??Mainâ? with 3 fields â??Lot Numberâ? â??Pack
Serial Numberâ? and â??Board Serial Numberâ?. At the end of each batch I need to
filter records for a report to be sent with the packs to our customer. How
can I set this using a form where the person at f ...
|
Print Button for specific Printer (PDF)
Tue, 30 Sep 2008 10:47:08 -0700
I would like to add a Button to my form to print a report (rpt-TestRpt) to a
specific printer which is not my default printer. One of my printers is
"Adobe PDF". When I "print" a document to this "printer", it will actually
create a PDF file. This is what I want the button to do. How can I code for
this? ...
|
Unbound Textbox calculation not showing a result
Tue, 30 Sep 2008 16:58:49 GMT
I have 3 bound controls txtBW_Ver with a control source of BW_Ver, txtOE_Ver
with a control source of OE_Ver & txtTW_Ver with a control source of TW_Ver.
I have an unbound text box with a control source of
=[txtBW_Ver]+[txtOE_Ver]+[txtTW_Ver]
The unbound box is not showing the calculation at all. I have a ...
|
Error Message in a Form
Tue, 30 Sep 2008 09:15:01 -0700
When I switch a database to OFICCE 07, I get in one of the forms after any
botton is clicked the following error "The expresion On Click you entered as
the event property setting produced the following error: User-define type not
defined."
I have to terminate the application because not even the 'Close' but ...
|
No scrolling records on form in 2003
Tue, 30 Sep 2008 09:05:00 -0700
I created a form and don't want users to be able to scroll to the next
question without answering the one they're on. I was able to use the
mousehook module when I run 2007, but when I run 2003 it scrolls through. I
have the dll file in the same folder and the modules in the on open and close
events of the ...
|
Sub Sub Form Query Will not wait for main form to be populated.
Tue, 30 Sep 2008 08:22:06 -0700
Dear All:
I have a query in a sub sub form that, on the result of the value input into
one of the fields in the main form populates a dropdown list with the names
of pets owned by the customer who is the focus of the main form.
How do I make the impatient sub sub form be patient.
As soon as I open the ...
|
Selecting a record
Tue, 30 Sep 2008 08:03:01 -0700
I have created a form that accesses a table. This form should allow a new
record to be added or to update and existing record. How do I select a
record from a list of all opportunities in the table or add a record if that
is the intent? Should I create another form that has a drop-down control and
then op ...
|
|
|
Data Sheet View with Hover Overs?
Tue, 30 Sep 2008 07:35:02 -0700
Is that possible? I have a database that is basically and tracking of issues
in my office. I want to keep a list of items in a datasheet view based on a
query that shows only the open items on my list of issues. When the list is
displayed I'd like for each issue have a hover over similar to a website and
...
|
How do I code VB to go to a new record, for an event in a form?
Tue, 30 Sep 2008 06:02:01 -0700
I have a db with a combo box for searching for a given invoice #. If not
found, I would like to go to a new record. How would I code this in VB? ...
|
Dmax problem
Tue, 30 Sep 2008 03:52:00 -0700
I have a control, txtmemnumber, which is a number and which I want to advance
the last value by 1 when I create a new record. I have used the Dmax function
in the Default value like this:
=Nz(DMax("txtnextnbr","tblmemnbrs",""),0)+1
However it doesn't work. I want the numbers to start at 2001 so have made
...
|
