Recent content by JumpinJimRivers

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.

thank you! that worked

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!

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

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

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

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

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

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

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

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

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

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

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

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