I am using a VBA code in MS-Access to change the printer dynamicaly.
I have the following code:
MyPrinter = "HP Laser Jet"
APPLICATION.Printer=APPLICATION.Printers (MyPrinter)
But MS-...
I have an Access database that contains over 300 tables. Each table has property info for a town in my state. All of the tables are identical, but the client wants a separate table for each ...
I am using access to try and return an array from a function, is this possible?? I've added example code to try and further explain what i am trying to acheive.
I need code to see if a proposed password meets the following requirements:
Passwords must:
" contain a minimum of nine (9) characters
" consist of a mixture of at least two (2) lowercase l...
I have a simply function that deletes target files based on the file path entered in a text box on a form which looks like this:
Dim strFilename As Variant
Select Case MsgBox("Are you sure...
Would I be crazy to develop with both Access 2000 and Access 2003 on one PC. I will be having two versions to support (one 2000 and the other 2003). I do have another PC that I could use but...
I have a form with 2 subforms (SfrmA and SfrmB). Both are continuous forms. I'm writing code in SfrmB that needs to reference a value in SfrmA. I used Forms!SfrmOppLnGrd.TbxSfrmOppLnGrdOppL...
I have a form that displays records from one table base on a filter( codes below),
I would like to update the [Sick] field for only the records filtered.
Is it possible to update the fiel...
I have a database, created in ms sql server management studio express, that is maintained in access 2003. I have the following columns: LoanNumber, LoanAmount, LoanTerm, LoanDate, InterestRate...
I have a subform (continuous) that has a button on it that opens up a modal form that allows the user to add or modify a record. Once they hit save it closes that modal form and i want the sub...
I would like to create a function:
Copy(MyForm, MyField, MyValue)
that inserts a copy of the the current record of form MyForm into the recordsource of MyForm, and then changes the valu...
A2003 XPHome. I've been programming vb in Access for many years, but I rarely have used a KeyPress event. I'm now using one to capture a barcode and it works just fine except for trying to sa...
I have 10 fields with the same name but different number at the end as a result of a recordset query, CHILDPID1, CHILDPID2.... Instead of writing a code to check each field, I like to look thr...
Hello,
I am attaching the code. So basically I found this code "http://packetguy.blogspot.com/2005/06/excel-xirr-and-xnpv-functions.html" and modified it a little bit to fit my needs. I put...
hi:
please
i need a clear example of the deffrence between passing the parameters with
ByVal or ByRef
Within an access module I run several queries to update a table Once these have been done I export the table using the Docmd.TransferText command in my case this is:-
DoCmd.TransferText...
Hello,
I've created a data entry form in MS Access with several controls and placed a bunch of Yes/No fields in the footer of the form. I want only certain Yes/No fields to appear based on ...
I am using a SendObject to send emails to Outlook and I would like to be able to create the queries on the fly and also name the attached file on the fly. I am looking for the best approach.
...
This weekend I had to reinstall Access 2003. Before that, Ctl-Break worked fine in stopping any running VBA code. Now, Ctl-Break does nothing. I checked Options and couldn't find anything....
Hello, I think I have a syntax error in the following. I get an error of object doesnt support this property or method" and the debugger highlights the entire DCount line in yellow. Hint: I ...
I have 3 unbound textboxes on my form and I would like to write VBA code to Count records against tblCompany with two conditions for each text box on the form. How would I write the VBA code...
Hi,
I just have a new laptop from my company. all instalation is new. but unfortunately i can not use ado in this laptop. it always accouring an error message when i tried to execute a code...
I have a SQL column that stores a BLOB which contains labels and values. I want to search the string for the label and then grab the value associated with it.
for example in the BLOB bel...
Is there a way to make a design like this:
I want to open an Excel workbook from an Access switchboard....
Once the file is open there is a button on the worksheet...
When I click the but...
I have an Access 2003 db form. In the form i have the follwoing to send an email to a receipt after a from is filled out.
Private Sub SendMail_Click()
Dim strTo As String
strTo ...
