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

    Export data from Access to Fixed Width Text File

    I'm not sure what the problem you are having. Can you try to explain in further detail. For example - Do you have records which are completely null? When I use this technique it works just fine. I do not have any extra blanks.
  4. gustavvs

    Connect a master table to repeating fields within other database

    I forgot to post thanks for y'all help.
  5. gustavvs

    Problem Adding Machine User into form

    Well I discovered one problem. I was missing advapi32.dll. Now that is loaded I'm receiving a whole new compile error. "Expected:line number or label or statement or end of statement" when I try to run it in debug and I still get the #Name? when I ran it in form. Now I put a watch on it and...
  6. gustavvs

    Problem Adding Machine User into form

    Thanks for the replies. I am still having problems. I had previously ran the code in a Module without success. But I created a Module and copied the code over. I ran in debug and got a compile error, Expected Variable or procedure, not Module. I entered the Module Name with () and still get...
  7. 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...
  8. gustavvs

    Connect a master table to repeating fields within other database

    LesPaul - Here you go: Names Table Last Name, First Name, Employee ID#, Department Jones, Bob, 123456, IT Smith, John, 987654, Accounting ID# is a primary key Items Table Items ID, Desc, Status, First Name, Last Name, ID#, Alt First Name, Alt Last Name, Alt ID# (Alt is alterative...
  9. gustavvs

    Connect a master table to repeating fields within other database

    Thanks PHV but this does not help in my problem. I've tried using different relationships to try to get around my problem but none worked. To keep Names unique I need to be able to access it from the other tables others every the user will be entering Names in every table. Because of the type...
  10. gustavvs

    Connect a master table to repeating fields within other database

    Maybe to clarify the question: I have need to reuse names multiple times in a single table (say column 1 is first name, column 2 is last name, and column 3 is ID. Column 4 would first name, etc...). They represent owners and contacts. I would like to have it so I can do a drop down so the users...
  11. gustavvs

    Email problem

    If you are worried about the size of the report or is it a user preference or do you want to be able to e-mail directly from your database?
  12. 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...
  13. 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