I have a small vba subroutine that uses an inputbox to collect a fraction,
such as "12.34/56.78", parses the string into numerator and denominator, and
puts the results in a text box--great.  I would like to expand its use so
that I can input a compound expression, such as "(12 ...

I was wondering if it is possible to change the datatype of an existing
field in code ? I was trying something like:
 db.TableDefs("Table1").Fields("Field1").Properties ("type") = dbText
but this does not seem to work.

I have tried many syntax variation but still get 'runtime error 3601. too few
parameters. Expected 1' from the following code:
Private Sub AcctClass_AfterUpdate()
Dim db As Database, frm As Form

I want to specify the number of copies of a report that I need to print. I
tried setting Application.Printer.Copies = 5 still my printer prints just one
copy. Is there any solution to this problem?
Help will be appreciated.

Thank you in advance for your valuable time and expertize in helping me.
I have a master report file which is grouped based on one catergory (owner).
I would like to create a function where I could export this main report in
rtf format for each owner. Eg. If I have 100 owners in ...

hi, i have a table that has names of people with a total number of parts for
each respective name. What i want to do is to total the values together and
use it in a text box on a form as a grand total for the department.
Can this be done with code or should one use queries ?

I have inherited an .mde file because someone has lost the .mdb file. This
file is an Access 97 format. I must now recreate the .mde file into an .mdb
file so as it can be converted to an Access 2003 format. I know that the .mde
file can not be converted. What I need is a way to ...

My situation...
I have a form that is created from a query of two tables.  Within this form
there is a contactID (foreign key to the contact table), giftID (primary
key), batchID (foreign key to the batch table), and now a tributeID (foreign

I am trying to create a pdf file using my pdf writer.  When printing the
report
(using acviewnormal on a docmd.openreport statement), the printer dialog box
comes up.  I have seen where users are using sendkeys to define and close the

Background:
I have several forms using the replace function to clean up a records pulled
from linked table in an ancient dBase III system. Basically I'm cleaning up
/x0D and other formatting characters, and changing from uppercase to

I get a "Type mismatch" on the following lines:
Dim frm as form
   If frm Is Nothing Then
       Set frm = Me.frmList2

I Have an SQL Query which works OK with Access but returns 0 record with VB
.NET. It seems to me that this as something to me with the "like" syntax.
Can somebody help me ?
Thanks so much, here is the example

I am using the following code to execute a Make Table Query to add table to
the database currently open:
Set db = OpenDatabase("ExternalDatabase.mdb")
Set rec = db.CreateQueryDef("", "SQL with IN Clause pointing to current db")

In a table I have defined a field as a lookup combo box and added some values
to eg 1,2,3. If on a form the user needs to enter 4 how can I code it so that
value automatically gets added to the filed value list in the table.
Thanks

Thanks all in advance for your help.
I get really tired of writting the same code to requery a combo box each
time it's activated.  Can/How would I add a property to the stock combo box
that basically has an auto-requery bit (true/false)?  Would this be a custom