Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. chuck001

    Office Document Image Writer

    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
  2. chuck001

    Is there a way to determine a field

    Yeah, your "Smart Query form" sounds it might be pretty interesting and useful, I would like to see it. My email is charles@databindinc.com
  3. chuck001

    Is there a way to determine a field

    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...
  4. chuck001

    Is there a way to determine a field

    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...
  5. chuck001

    Is there a way to determine a field

    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
  6. chuck001

    Is there a way to determine a field

    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...
  7. chuck001

    Retrieving a Folder`s Path

    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...

Part and Inventory Search

Back
Top