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!

Register Log in
  • Congratulations Rhinorhino 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: *

  1. cthaxter

    All permissions revoked. Recover?

    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?
  2. cthaxter

    PivotChart - Remove "Sum of" in Name

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

    can i use excel solver in access and distribute to other computer

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

    PivotChart - Remove "Sum of" in Name

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

    PivotChart - Remove "Sum of" in Name

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

    Exporting/Moveing record in another access db?????

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

    All permissions revoked. Recover?

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

    XML and XSL to HTML: Problems with well formed structure

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

    Printing Book Lists

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

    Printing Book Lists

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

    Series Problem - Short on time so ANY suggestions welcome!

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

    Printing Problem.....Pagemaker 7.5

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

    Clear Contents in worksheet

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

    URGENT! Help with Variable Field and Values into a Table..? Plz...

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

    Reference Excel fields over ADODB

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

    Reference Excel fields over ADODB

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

    Parameters without stored procedure

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

    Excel Macros

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

    Automation Error

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

    Use an Excel add-in in a VB application?

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

Part and Inventory Search

Back
Top