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 Chriss Miller 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. JumpinJimRivers

    PMP Exam - preparation course question

    I hate it when someone posts a question, noone ever responds, and then someone finally posts with "yeah, I'd like to know the answer to that question too!" Well, sorry about that... but I would.
  2. JumpinJimRivers

    Want to delete an xls file

    thank you! that worked
  3. JumpinJimRivers

    Want to delete an xls file

    I've tried Kill "C:\path\file.xls" ..and nothing happened I also tried SystemObject.DeleteFile "C:\" ..but DeleteFile is not even in my list of methods (which may mean I don't have the dll referenced) Any suggestions are appreciated! Thanks!
  4. JumpinJimRivers

    AutoNumber Crisis

    I just realized how this happened. I'm such an idiot, when I rolled out their last update six months ago I did an 'import' of those two tables to the back-end from the instead of linking them. Moron. Michael, yeah that's true. That will help a little. Thanks
  5. JumpinJimRivers

    AutoNumber Crisis

    For now I'm just going to use excel and vlookups to fix this. Talk about a pain in the hiney. But I sure would like to know if there is a better way. Thanks
  6. JumpinJimRivers

    AutoNumber Crisis

    Hello everybody, It was just discovered that in my client's Access database there are two tables in each user's front-end that are NOT linked to the back-end like they ought to be, so each user's data for these two tables are being stored locally. This is an accident, and I need to somehow...
  7. JumpinJimRivers

    AutoNumber Crisis

    Hello everybody, It was just discovered that in my client's Access database there are two tables in each user's front-end that are NOT linked to the back-end like they ought to be, so each user's data for these two tables are being stored locally. This is an accident, and I need to somehow...
  8. JumpinJimRivers

    sudden glitchiness occurs on certain PCs inside Access

    hmm, ok, I don't like the sound of that. Do you mean the front-end mdb file might be corrupt, or the back-end? If it is corrupt how can I limit this from happening all the time? Would making it a MDE file help any? Now a bunch of questions are hitting me. I wonder exactly how stable Access...
  9. JumpinJimRivers

    sudden glitchiness occurs on certain PCs inside Access

    Hello everybody, We're all of the sudden encountering some strange phenomenon with Access. It has only happened on two PCs now but we're concerned it may start happening more frequently. Here's what these 2 infected PCs do: 1. A particular continous subform all of the sudden will not display...
  10. JumpinJimRivers

    don't want subreport to disappear when there's no data

    Hi Ann, gee, it's been a year, right on the nose nearly, since I had that problem...honestly I don't think I ever got that one figured out. It seems like I resorted to a pretty dirty solution and put the labels on the main report instead. You have a good idea referencing the label from the main...
  11. JumpinJimRivers

    can I make entire database read-only ??

    Hello, I need to make ALL my forms read-only when a user re-links to an "archive" database. Since all of the forms need to be read-only, it doesn't make sense to have to figure out what forms are open and then reset its RecordSetType. There must be a more efficient (and less...
  12. JumpinJimRivers

    troubles referencing embedded form's property!!???

    I figured it out - just needed to add another ".form" at the end. details. details. Forms![frmJobDetails_Module]![frmJobDetails_Tabs].Form![frmJobDetails].form.RecordsetType = 3
  13. JumpinJimRivers

    troubles referencing embedded form's property!!???

    Brackets may help you understand the names of my forms better: Forms![frmJobDetails_Module]![frmJobDetails_Tabs].Form![frmJobDetails].RecordsetType = 3 'set form to read only
  14. JumpinJimRivers

    troubles referencing embedded form's property!!???

    Hello, I need to reference the following embedded form from a general module, but it's not working and I don't know why!! Forms!frmJobDetails_Module!frmJobDetails_Tabs.Form!frmJobDetails.RecordsetType = 3 'set form to read only I've tried it these ways too...
  15. JumpinJimRivers

    Archive in existing DB or Separate?

    Hello, I am trying to relink my tables to another db and found this old thread. The initial code posted here is exactly what I need but I tried it and I keep getting an Invalid Operation error on: tdf.Connect = ";DATABASE=" & strLinkToDBname And I don't know why! Any help is...
  16. JumpinJimRivers

    ability to archive data to another database

    A "Job" consists of many records, 49 tables, actually. We need to archive ALL the data associated with a job - billing, RFIs, Submittals, Change Orders, Transmittals, Memos, Contracts, Supplements, etc.. Here's the breakdown: - One table (tblJobs) is a general Job info table that...
  17. JumpinJimRivers

    ability to archive data to another database

    Howdy, I am finishing up developing this project management package for my client in the construction industry; they want a data archiving scheme where they can transfer all the data of a completed job (based on JobID) to another database of their choosing, for purposes of archiving and proper...
  18. JumpinJimRivers

    requery listbox automatically

    Ok! That's just what I was looking for. Thank you!
  19. JumpinJimRivers

    requery listbox automatically

    Ok, one more time: Wemeier, tabs controls do not have a Got Focus Keph, I'm already using mylistbox.requery BUT IT DOESN'T EVER WORK FOR THE ON CLICK EVENT OF THE TAB. questions are not always as they seem on the surface, especially if you're just looking at the subject! I suggest reading...
  20. JumpinJimRivers

    sub or function not defined

    CajunCenturion, I'll try not to take your assumption personally - you've probably helped people who have misunderstand that before. Evidently something else is wrong but I do not have the luxury of time to figure it out. So I'm content putting it in with the modules. A sincere thanks for your...

Part and Inventory Search

Back
Top