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: gustavvs
  • Content: Threads
  • Order by date
  1. gustavvs

    Changing View to view leading zeros in a query

    I have a problem downloading a specific field with leading zeros to an Access table. Is there a way to add adjust the view in the query to show the leading zeros? I'm banging my head against the wall trying figure this out. The source has the field set to Numeric and it can not be changed. The...
  2. gustavvs

    Keeping the schema when exporting a query to a text file

    Hi! I have figured out how to create the text file and schema so I can export queries to text. My problem is when I put the database into production it seems to lose one of the text conversion schemas and starts to ask if you want to delete records (a very odd error if I might say). It...
  3. gustavvs

    Problem Adding Machine User into form

    This should be something simple: To expand on http://www.tek-tips.com/viewthread.cfm?qid=1099785. I try running the recommended function (http://www.mvps.org/access/api/api0008.htm) within my form however I keep getting a #Name? error. I'm setting the Control Source of the field to the...
  4. gustavvs

    Connect a master table to repeating fields within other database

    I've been building a database from a series of databases to our groups ownership information in one location. I managed to combine the names of the owners into one table that I want to use as a master. The problem is that the other tables have need for name and ID information more than once...
  5. gustavvs

    How to link data formated by a module to Excel

    I have a piece of code in a module that coverts the date to month and year. When I go to link the database to an Excel Pivot Table I receive an "Undefined function 'MonthEnding' in this Expression'. It works fine in the query. Any suggestions on how to fix it?

Part and Inventory Search

Back
Top