From what I noticed there are printing preferences for the image writer driver, under the Advanced tab you can set the default output as a Tif format instead of MDI
Hmmm...
I am having a little trouble passing a variable the fields property (tdf.fields!variablename) but I notice that since you are setting the query recordset, instead of using a select case statement try something like below:
***Code***
'loop through each field in the recordset instead of...
Yeah,
Below is some code that will loop through query collection of the DB and give the query names excluding the system objects. I did not know if you combo box is bound to a table or not but you can write the information however you want.
***Code***
Dim dbs As Database
Dim qrydef As...
Dustman,
Also the type property returns numeric values so here is a listing of the string associated with the numeric value.
AutoNumber
4
Text
10
DateTime
8
Number
4
memo
12
currency
5
YesNo
1
OleObject
11
Hyperlink
12
Hi Dustman,
I have listed code below I think will get you going in what you are trying to do in extracting the field type information.
***Code***
Dim dbs As Database
Dim tdf As TableDef
Dim fld As Field
' Return reference to current database.
Set dbs = CurrentDb
' Return reference to...
Hi
Try the code below, it will allow your user to browse folders and only return the path information without the filename to a string variable for you. Once you pass the information to the variable you can add code to write it to a table.
'***Copy and paste this to a module***
Private Type...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.