sherylnance
Last Activity: Jan 12 '07, 08:02 PM
Joined: Oct 3 '06
Location:
-
Once you put a right join in the mix it starts getting picky. If you change all your lefts to rights then it should be good. just make sure you are getting the data you want. :-) -
You can highlight the fields you want to make the primary key in the table design view and then click the primary key button on the tool bar.
:-)...Leave a comment:
-
VB in access to format data in Excel
I have a need to "export" data from 1 table in access to multiple excel spreadsheets. I have conquered this part and now what I would lilke to do is create the pretty column headings to replace the ugly column names. This is probably a pretty simple thing but I am hacking at VB and just dont know what words to look for. Any help would be greatly appreciated. I really dont want to individually edit 123 spreadsheets to put in these column... -
Parse data from 1 table into multiple txt files
I am trying to write a module that will basically loop through a list of values, execute a sql statement based on the value and write the query results to a file with the filename being XXvalue.txt
I have gotten to the point where the sql statement is built and I can print it out in the immediate window. But I can't for the life of me get the darn SQL statement to execute. Here is my code:
Sub loopSchool()
...
No activity results to display
Leave a comment: