Search results for query: *

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...

I'm trying to connect to an Excel file through ADODB and manipulate it like any other database. The following code from http://support.microsoft.com/default.aspx?scid=kb;en-us;Q195951 works just fine: Set objConn = Server.CreateObject("ADODB.Connection") objConn.Open...

I've tried in vain to search for examples using the parameter object of ADODB without using a stored procedure. How do you use a SQL statement in one's code, using parameters? See this Microsoft Support topic to see what I mean: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q200190...

I would copy all the modules and forms into VB and change the code so that you create an Excel.Application object and call it with With clauses. Then, just run the exe. You may need to alter the code slightly in order to create a startup form and include a button or something to run the excel...

Does it happen when opening a specific document? If so, then try accessing the code in that document. If not, then maybe your Normal.dot file contains code for some reason. Unless someone put that code there for a purpose, it shouldn't be there, and you should delete the code from Normal.doc...

I'm trying to utilize the Solver add-in from Excel, within a standard EXE. I can't get the Solver code to compile. If I were in VBA in Excel, I might have solverreset solverok SetCell:="$C$6", MaxMinVal:=3, ValueOf:="180", _ ByChange:="$C$4:$C$5&quot...