Subform Combo Record Source Issue
Tue, 25 Nov 2008 08:47:02 -0800
I have a main form called PurchaseOrders and a subform called
PurchaseOrdersSubform. The main form is opened using another form called
frmPOList. On frmPOList there are two cmd buttons, cmdEdit and cmdEditAll.
There is also a list box that displays all of the open Purchase Orders.
The subform is for the par ...
|
Efficient method of updating DISTINCT
Tue, 25 Nov 2008 08:04:02 -0800
Perennial problem here. I need to add a note to an invoice based on whether
that invoice has a particular item in one of its related InvoiceDetail
records.
1. I cannot simply join & filter on InvoiceDetail.ItemID, or I get an update
to the invoice for each detail item; the note would be posted multiple time ...
|
Inputbox
Tue, 25 Nov 2008 06:36:32 -0800
Hi!
In excel i have Application.inputbox
how can i in acces be sure that my inputbox contains a Number
because if i cancel my inputbox i get an error
Thanks
...
|
barcode scanner
Mon, 24 Nov 2008 16:52:01 -0800
I have to build an inventory identified with barcodes. Is there anyway to
capture the input from a usb barcode scanner with vba? Optimally I would
like to scan 1000 or so items into a table without having to touch the
keyboard. I started using excel, but It was scan, enter, scan, enter,
scan........
...
|
Check for diskette in A: drive
Mon, 24 Nov 2008 13:51:28 -0800
Is there VBA code that will allow me to test whether or not there's a
diskette in the A: drive? Thanks in advance. ...
|
call VBA code of another DB
Mon, 24 Nov 2008 15:44:02 -0800
How do I call or run VBA code found in a separate, already open, DB?
Thank you for your help.
...
|
Update code not running
Mon, 24 Nov 2008 13:43:03 -0800
Looking for ideas on things that might be wrong w code for a button on a
form. I'll simplify the description a bit, but I think this should have the
main points. I'm not an expert programmer, so any suggestions on better ways
to do this are appreciated.
I have a database with a sequenial index number. A ...
|
|
|
Close Shared Access Appication(s)
Mon, 24 Nov 2008 12:45:01 -0800
I have a Front End database that multiple people open each day. I want to;
#1. Be able to close all opened versions of the DB. No matter who has it
opened.
and
#2. Send anyone who has the DB open a notification that their DB is about to
close.
I know it can be done, I just couldn't find again the discuss ...
|
Launching a Report
Mon, 24 Nov 2008 12:43:01 -0800
I created a form to get certain data and then I want to display a report. As
the form closes, I issue the instruction:
wherephrase = "Some appropriate selection"
DoCmd.OpenReport "rptName",acViewNormal,,wherephrase,acWindowNormal,Args
No Report appears on my screen; instead it prints. I was explicit about
...
|
Re: Trapping errors and creating custom error messages
Mon, 24 Nov 2008 12:06:02 -0800
The new web address for Allen's page on Error Handling is:
http://allenbrowne.com/ser-23a.html
Allen--thanks for giving those of us just learning Error Handling a place to
go. :-)
Kari
"Allen Browne" wrote:
> To achieve your goal, you need to add error handling to each procedure in
> your database ...
|
