Recent content by slowmike

I'm trying to find a way to work around the limit of 3 conditional formatting formulae. In other words, if there are more than 3 items in the comma-delimited list, I get a application error. Any ideas?

I have a list of items that I need to check. I also receive a list (comma-delimited) of items that have already been checked, so I am trying to design a macro that cycles through the second list and highlights the items in the original list so I know that they are OK.

Great. Thanks for the help. Now, is there a way to freeze the formatting so that if I put a new list in c7, the previously highlighted (highlit?) cells remain so? I tried copying and pasting formats, but that did not work. Thanks again.

Somewhat along these lines, is there a way to highlight all the cells that contain a value within a list of values? So far I have: Sub Highlight() findme = Split(Range("c7"), ",") For q = 0 To UBound(findme) Columns("a:a").Select Selection.FormatConditions.Delete...

I am having a problem with getting my DTS package to import multiple sheets from an Excel workbook. I have set up a connection for each sheet, so my DTS package works if there are 10 or fewer sheets, but I have no way of knowing if the workbook has more than 10 sheets. Also, if there are fewer...

I noticed that if I import the sheet without using the field names provided in the sheet, Access calls everything text and does not choke on fields with alpha/numeric mixes. I can then assign field names and types in Access. All I have to do then is pray (or add code to verify) that the field...

Well, I have almost 100 files to go through now. After that, it will be a weekly routine, but I would like to get it as automated as possible. I was thinking about writing a code that opens an Excel sheet that opens the file and saves it as text, but if you don't think that would work or have...

So I guess there is no way to change the automatic field type assignments without going in to each individual sheet. Shoot. I guess that's why they pay me the huge coin. Thanks for your quick responses.

I am trying to import an Excel spreadsheet into Access, but I cannot change the field types that Access automatically assigns to each field. Apparently if the first few records are populated with numbers, it calls that field a number, but if there are alpha characters in that field for...

I'm trying to export a number of tables with a variable number of fields and field names to a tab-delimited text file using VB code. If I use the TransferText method, I can only export to a comma-delimited text file if I do not have an export spec. I tried to create an export spec on the fly...

Me again. I think I have everything set up correctly, but when it tries to establish the connection to open the catalog (catDB.ActiveConnection = ...), it cannot because the database is already open. Is there an easy way around this?

Shweet. Won't I be cool if I get this to work. I'll let you know if I run in to any problems. Thanks a lot for your help.

I am not. I know how to used the docmd.runsql command to run update and select statements in VBA, but I don't know how to get it to export a query that I haven't created and named manually. Ideally, I would like to run a line that looked like this: DoCmd.OutputTo "select * from " &...

Thanks, that helps. If only there was a way to automate the query creation. Anyway, thanks a lot for your help.

Thanks. I have a code set up that runs through the 100 or so tables in the database and exports them to Excel. Do I have to create a query for every table I have in the database? Is there a way to automate this in a module or macro or do I have to do it manually? Thanks again for your response.