Hi,
Would anyone have any ideas on checking if the MSCOMM32.OCX component is installed when running my access application.
The Access runtime falls over if this is not installed but the full version of access still allows the app to run.
I would ideally like some way of checking the system when the application starts and bringing an error if it cannot find the MSCOMM32.OCX file.
Any help...
sajuk
Last Activity: Apr 10 '09, 01:23 PM
Joined: Dec 21 '06
Location:
-
MSCOMM32 Checking if Installed.
-
Converting to Access 2007
Hi,
Am interested in migrating my app to Access 2007 to make use of the free availability of the Access 2007 runtime/developer tools, howver having some problems with the script below.
...Code:Dim db As Database Dim qdf As QueryDef Dim prm As Parameter Dim rs As Recordset Dim inte As Integer Dim strCashier As String Dim strCatId As String Set db = CurrentDb
-
Hi
You can use code below to manipulate your query.
...Code:Dim db As Database Dim qdf As QueryDef Dim prm As Parameter Dim rs As Recordset Set db = CurrentDb Set qdf = db.QueryDefs("YOURQUERYNAME") For Each prm In qdf.Parameters prm.Value = Eval(prm.Name) Next prm Set rs = qdf.OpenRecordset(dbOpenDynaset) -
Thanks, that has worked a treat, simple really after you discover how it is done.
CheersLeave a comment:
-
Dynamic buttons on Access Form
If any assistance can be provided would be appeciated.
I am attempting to populate a form with buttons with button captions which have been assigned through code.
buttons names are btn1, btn2, btn3...etc
The code indicates a query - Query1 which gives a dataset which is populated from the products table with product name and price.
The problem I have encountered is I am unable to change... -
Dynamic buttons on Access Form
If any assistance can be provided would be appeciated.
I am attempting to populate a form with buttons with button captions which have been assigned through code.
buttons names are btn1, btn2, btn3...etc
The code indicates a query - Query1 which gives a dataset which is populated from the products table with product name and price.
The problem I have encountered is I am unable to change... -
Hi, May be able to help, have in the past devised way of manipulating a query recordset to allow for faster printing through dot matrix/thermal printers.
The code I have below will allow you to run your query - which is what your report is based on within vba.
...Code:Private Sub Command20_Click() Me.Requery Me.Refresh Dim strOrderId As String * 8 'specifies width of 8 charactersLeave a comment:
-
Hey Killer42,
Thanks your suggestion allowed me to see through the fog.
Direct printing to LPT1 is still the best way for Receipt printers & allows useage of the ESC codes.
ps Nico5038 - The code you say would be ok for normal A4 printers, however the nature of continuous roll paper for Receipt printers needs fine control in Code.
Te following code works a treat!
...Code:Private Sub
Leave a comment:
-
Manipulate an Access Query recordset in code.
Hi, any ideas for this problem would be appreciated.
- I am coding to enable me to use a receipt printer as the Access Report functionality does not give the correct working function.
- I have a query - 'Query1' which has the recordset result that i am interested in, this has been done through the Access 'Create Query'.
The query contains:
ORDERID, PRODUCTIS, UNITPRICE, QTY
...
No activity results to display
Leave a comment: