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!
-
Congratulations IamaSherpa 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: Devilboy916
- Order by date
-
Access Documenting Tool
Hi all A database in our company is being shipped up to the company that bought us out in a few months. I've been charged with providing a user guide and data mapping for the database itself. I know that there is a tool in MS access to allow you to document the tables etc. I was wondering if...- Devilboy916
- Thread
- Replies: 2
- Forum: Microsoft: Access Other topics
-
Importing Blank Dates From .CSV
Hi everyone I am trying to import a .csv file into a SQL table using DTS. In this file is a date field with null values. This is correct data, but when I run the DTS, an error returns saying it cant put text values into a date field. I have 'allow nulls' ticked on the date field in SQL. i...- Devilboy916
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Data Transformation Services
-
Make Table Query Confirmation
The problem I have here is that there are upwards of 800 queries to run in this procedure. So converting them all to VB is not at all feasible. Each macro contains a set of queries that the user needs to run, and do some manual calculations in between. So the only way I can see of doing this is...- Devilboy916
- Post #3
- Forum: Microsoft: Access Other topics
-
Make Table Query Confirmation
Hello All I have a macro of make table queries in access. These are to run automatically overnight. If I add setwarnings=false into the macro, I do not get warned if one of the queries fails. So, I have added some code in the macro to turn the three options off in access for query confirmations...- Devilboy916
- Thread
- Replies: 2
- Forum: Microsoft: Access Other topics
