Recent content by cthaxter

I revoked ALL the permissions to the tables, including read permissions. Is there any way to recover them? Importing them is impossible, unless you know of some way to import a table you don't have permissions to. Any ideas?

Sorry I can't be of help. I thought you were talking about cross-tab queries. My mistake. You may want to re-post your question to the "Microsoft: Access Queries and JET SQL" group here at Tek-Tips. There may be better query experts there.

Maybe someone else has a better answer, but my experience is you can't use Solver outside of Excel even if the computer you're distributing to has Excel. My solution has been to put code in an Excel file that runs on open, then open the Excel file programmatically from Access. The code in Excel...

Try switching to the SQL View. You should see "As SumOfAbc" somewhere in there, and you should be able to modify that there.

In your query design view, in front of the field name in question, put your alternate field name with a colon. So, if your field name is "Price" you don't want the regular view to show it as "SumOfPrice" you should type "[Total Price]: Price" in the top line of your price field in your query...

That certainly sounds possible; however, the way you describe your situation is very confusing. If I understand it correctly, you have two forms open at the same time and, on the press of a button, you want to copy the active record on one form to fill out the fields of another form. If that...

In setting permissions and accounts, I assumed the Admins group had all the administrative permissions. It didn't; the Users group had those. Instead of setting up all the users first and then revoking permissions from Users, I first revoked permissions from Users. I only did this for tables...

I'm trying to transform XML via XSL to HTML using xslt_process(), but I'm getting an error saying the XML or XSL is not well formed, but I don't get any further information than that. Does anyone do this successfully? It's likely that my headers need to be set up a certain way, but I have no...

Then what's the point of using book lists? If that is true, then my question still stands as to how to automate the joining of print jobs.

It seems that book lists always print as separate print jobs, rather than as one. Is that true, or can they be sent as one print job? In other words, if you set up a book list with ten different component files, and then you go to File/Print to print the whole thing and you choose "print...

I haven't read your code thoroughly, but a couple considerations come to mind. Is this an xla, or just code in a regular xls? I've found that since there are no active sheets in an xla, one must craft the code very carefully. Also, I've found that the Error 1004 tends to not necessarily be...

Do you select the correct PPD every time you print to the corresponding printer? In other words, when you select the printer to print to it, a second pull-down menu below the "Printers" pull-down menu should appear, and you should select the correct PPD. Are you doing this? If you...

I agree... and the last column in Excel is IV, so you can use the range "B2:IV65536" to clear everything but the first row and first column. Christopher

If I understand correctly, you're trying to populate a table that's already been created, with data from the array PND(), and you've stored the destination field names in another array PNF(), where each index in the first array corresponds to an index on the second. A better way to do that...

Thanks. Sorry, the problem I was having didn't have to do with naming, as it happens. I was just trying to use Options that weren't compatible with the type of recordset I was using 3 for Cursor, 4 for LockType, and 2 for Options, and I think the Options value was the problem. So, the...