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.
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...
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?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.