Search results for 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...

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

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.

I forgot to post thanks for y'all help.

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

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

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

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

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

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

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?

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

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?