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 derfloh 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: *

  • Users: 52
  • Order by date
  1. 52

    ODBC connection works once

    That did it (save password) - what a weird thing. Funny that it's sitting on the network and works for some people and not others. (Now it's VERY slow, but better slow than not work at all) Thanks for all the help!!!
  2. 52

    ODBC connection works once

    No, it's definately not a "user id" error. There is only one user id for the oracle connection. As for the PC's, I doubt it, all PC's are configured exactly the same. Going to have to look at the VBA that cmmrfrds posted (That was a helpful post). Very strange - the ODBC connection works...
  3. 52

    ODBC connection works once

    I'm really not sure what it is - I just moved up to Access 2003 (from 2002). Also found this article from Microsoft, almost seems hopeless: http://support.microsoft.com/default.aspx?scid=kb;en-us;325835#kb3 from microsoft: "Microsoft has confirmed that this is a problem in the Microsoft...
  4. 52

    ODBC connection works once

    I have an Access db that uses Oracle linked tables. Very strange, the connection works once and when I close the app and open it, I can't connect to the Oracle table anymore. (this also happens in a brand new Access database with only an Oracle connection). I've tried deleting the DSN and...
  5. 52

    Export to Excel

    I'm trying to save Access data to Excel. I will need to have spreadsheets with each name: (there is a field in the table with each name in it) Bob Joe John Each spreadsheet needs to be named their own name. In this example, I'd have Bob.xls, Joe.xls and John.xls -- each with their own data...
  6. 52

    vba sql delete query problem

    Thanks for your help. Here's what finally worked... I tried the single quotes and couldn't get that to work.. CurrentDb.Execute "DELETE FROM tblCurrent WHERE [Year] = " & """2005""" & " AND PID = " & """" & Me![PID] &...
  7. 52

    vba sql delete query problem

    My 'year' is not really named year - it's baseyear, but to be more clear in explaining, i used the term 'year'-- sorry for the confusion. Also, When i change to single quotes, it's read as a comment out. Yes, it's my goal to delete a record from a table from an opened database that meets two...
  8. 52

    vba sql delete query problem

    Both of the deletes work individually - not sure if it's possible to do this or not... tried makeitso's code - thanks - (but didn't work.)
  9. 52

    vba sql delete query problem

    I'm trying to delete from a query where there are two fields that must be matched. This works with one variable (or the other), but when I add the second, it doesn't work - I get a Run-time error 3061 - Too few parameters. Expected 1. CurrentDb.Execute "DELETE FROM tblCurrent WHERE [Year]...
  10. 52

    Inserting images (from links) into reports

    The files open fine - I've tried the ones the errors happen on, I notice that someone else had the same problem about a year ago - it wasn't resolved. I have no choice about the type of file because there are a lot of pics in this system (with the query it's narrowed down to about 18000 in the...
  11. 52

    Inserting images (from links) into reports

    I've used this code for images (tif) - works great except about the 10th image (not always the 10th - not always the same file) is loaded, I get an error message: Run-time error '2114': database doesn't support the format of the file -path.tif, so it can't load the picture. Thanks
  12. 52

    Can this be done in CR 9.0?

    I'm looking to e-mail a report once a month to several people (and would like this to be automated). Do I need Enterprise for this or is there a way to write a program that will do this for me? Thanks!!
  13. 52

    Forms Print on C drive, not on Network.???

    In case anyone has this problem, my form was set to a pop-up (and it was filtered). I took the pop-up off and everything was fine.
  14. 52

    Forms Print on C drive, not on Network.???

    I have a database that has windows security (wizard) added. It runs perfectly on my hard drive, but when I move it to a network drive, my printing functions don't work correctly. My form has a tab control on it. I need to print Page 1, and Page 2, so I used: docmd.goto Page 1 printout...
  15. 52

    Hiding Path in Shortcuts

    Is there any way to hide the path in a shortcut --- or create a shortcut without listing the path? Thanks!!
  16. 52

    Brand New to Macromedia

    I'm going to be putting together a web site. I'd like to develop the main website and the company to have access to another page (with password) where they can enter and update data which will be viewed and searched on the 'public' page. What will I need to do for the 'private' page? Am I...
    • 52
    • Thread
    • Replies: 2
    • Forum: Adobe
  17. 52

    running total or variable in subreport?

    I got it!!! Thank you SO much.
  18. 52

    running total or variable in subreport?

    I've used the subreports. Now I have two variables being passed to Group 2 - once a value shows in a group it continues to show until the numbers in that group change. Also, I'll need the total my two variables to be combined for Group 1 for a grand total. Thanks for all the help so far!!
  19. 52

    running total or variable in subreport?

    Ok, I tried to simplify my problem and was hoping there was a simple answer. I need to include all customers from both OrdersOnHold and Orders - So I needed to add a 'dummy' Customer table to link to one. I also need to read all records from OrdersOnHand and from Orders - so I changed the...
  20. 52

    running total or variable in subreport?

    This is going to make me crazy: I have 2 tables (as an example): tblOrderTable, tblOrdersOnHold (same fields in both tables) CustomerID, ProjectID, CostOfItem. The other table is tblCustomer: CustomerID, Name, State Here's what I'm looking for our of my report: In short, I need to combine...

Part and Inventory Search

Back
Top