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!

Register Log in
  • Congratulations TouchToneTommy 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: *

  • Users: DataEmbryo
  • Content: Threads
  • Order by date
  1. DataEmbryo

    Convert a number to a date

    Howdy folks... How does one convert a text field in a table to a date field? e.g., my date field has 06012007 123120 stored as text, but I'd like to convert the field type into a Date/Time field. I know its easy, but I can't figure it out... must be late.
  2. DataEmbryo

    Passthrough Criteria from a form to SQL for a report

    Hi All, I have read the previous posts on creating passthrough querys with parameters, but for I just can't seem to make it work for me. Here's what I want to do... I have a form where you select from a list box that queries from a table. When I click a button on the form, I want to use the...
  3. DataEmbryo

    Passing a date variable to a SQL backend?

    Hello, I have a MS Access Form that has a date text box which is used in a number of queries for a report. The criteria used in the queries was similar to this: Select [Date] From tblblah where [Date] Between [Forms]![Process]![txtDate] And [Forms]![Process]![txtDate]-13 The txtDate variable...
  4. DataEmbryo

    =Environ("Username") returns #Name?

    I've tried all the fixes I could find here and on MS, but I still get this error. I checked that the environment variable "Username" is set. I have two computers, both running Windows 2000 and Access 2000. It works on one, but not the other... I have =Environ("Username") in a forms and...
  5. DataEmbryo

    Type Conversion Error - Importing

    Hello, Could anyone help me figure out why I get Type Conversion Errors when importing? I am importing csv files into a table. The field in question is a number field set a Double in the target table. It appears that when the number in this field hits ten digits (e.g. 3,223,322,624) it...
  6. DataEmbryo

    Access Training Courses

    Hi all, Can anyone recommend a good training course for Access. Online or on CD would be okay. If anyone is local to Bellevue, WA any classes I should sign up for? I'm already using Access, picking it up as I go. I also have help from a friend who knows Access inside and out. I just need...

Part and Inventory Search

Back
Top