Create Path and Open Editable Doc in Word From a Report
Mon, 8 Dec 2008 12:58:09 -0800
I am trying to run then export a report to Word so that it opens on a form
button click and is editable in word.
Using my limited knowledge I can create the report but then keep on getting
a msg box asking me where I want to save the file before I can view it. I
want to avoid this message box appearing and ...
|
RaiseEvent isn't raising
Mon, 8 Dec 2008 12:55:01 -0800
I'm trying to synchronize two forms using withevents, but nothing happens
with the command line 'raiseevent'. Here is my code:
MainForm
Public Event NewCustomer(strCustomer_Id as string)
Private sub txtCustomer_Id_afterupdate
RaiseEvent NewCustomer(me!txtCustomer_Id)
2ndForm
Dim WithEvents ...
|
Printing with functions (staples)
Mon, 8 Dec 2008 09:52:13 -0800
Hello,
I´m trying to program my printing function to chose staple but I don´t
know how to do it. I also want to print on both sides.
Can any one help me? I´l be wery grateful!
BR
Mia
My code so fas is (It´s a loop)
Sub Spara()
'
' Spara Makro
' Makrot inspelat 2006-11-28 av Mia
'
D ...
|
Opening Outlook address book from Access form
Mon, 8 Dec 2008 09:03:02 -0800
Hi,
I need to maintain an Access application written by somebody else. We got a
form where there is a dropdown that has a list of user name. By the side of
this dropdown there is a send button. When a users chooses a dropdown contact
list and clicks send outlook form opens up with the corresponding fields
f ...
|
Accessing <sic> External data
Mon, 8 Dec 2008 08:15:01 -0800
Access 2003
I need to save data from an Access APP with no TABLES
====================================
Is that possible?
------------------
I've an App that has NO tables and NO queries
(I'd have written it in VB - but I don't have a copy of VB that works under
VISTA)
I have a "Master" form which cont ...
|
Type mismatch and reference
Sun, 7 Dec 2008 15:59:00 -0800
I just updated a DB from Access 2000 to 2003. It was a very basic conversion
and took two minutes, but afterward I got a type mismatch on the last line
below:
Dim strSQL as String
Dim rsInvoice As Recordset
strSQL = "SELECT InvoiceNumber from PetroInvoice WHERE Status = 'Ready'"
Set rsInvoice = CurrentDb.O ...
|
Between Dates on Combo Form
Sun, 7 Dec 2008 12:08:00 -0800
I have a form for user to pick multiple and/or parameters for a report and
can't quite get the programming for the between dates working correctly. I
keep getting the error: Run Time error 3075
Syntax error (missing operator) in query expression â??strDateField = &
tblSession.StartDate ([tblSession.StartDate ...
|
|
|
Populate Combo Boxes using Form_Current Options
Sat, 6 Dec 2008 19:34:32 -0800 (PST)
I've got 3 unbound combo boxes on my form that are used to narrow
down
and find results in a couple of tables that are used in an Insert
Process. The combo boxes work as expected except when cycling through
records they do not show the values that should be associated. I've
tried using the Form_Current function ...
|
Re: "DINAMIC" command buttons
Sat, 06 Dec 2008 16:14:44 -0600
IT-1957 wrote:
>If you mean on "myquery" I have 20 records.
>Do I have to bound the form to "myquery" as data source? (i did but still
>the same problem)
If there are 20 records, then the code you posted requires
that there be 20 buttons named Button0, Button1, ...,
Button19
--
Marsh
MVP [MS Acces ...
|
"DINAMIC" command buttons
Fri, 5 Dec 2008 19:57:01 -0800
Hello every one,
I'm creating a little POS, I'm at the point where the cashier has the option
to look up a product, What I did is that the user clicks a button {look up
product} a form opens, what I need to do at this point is that all the
products on a table (or query) like "fruits" will appear on this for ...
|
