Search results

that works! thank you Ari! :)

Thank you for the response! Perhaps I have done a poor job of explaining the situation. I have a FE and a BE for my Access Application - the BE is hidden in a hidden network folder that every user essentially has to be given "Read" and "Write" access to. I have distributed the FE to all of...

Does this mean what I am trying to do cannot be done?

Yes I created this :) That's exactly what I am having a hard time understanding. I use MS Access for applications in a network - essentially it is a Contact Center with 200+ employees. This particular application was initially split; however I removed the links via the Linked Table Manager...

Hi Bob! Please accept my apologies for the delay in getting back to you; however we have been celebrating Eid-ul-Fitr here in Pakistan. I would be happy to send you the file on your e-mail address. Let me PM you :)

I rely heavily on Microsoft Access in my office environment and there are multiple applications that have multiple concurrent users. End-users always seem to find a way to use an application in a way other than actually specified. Attrition here is high so people keep changing and simply...

Hi Gina! Yes I tried holding down the Shift Key from the time I double-click the file until the time the file is completely open; however I am having no luck. I reviewed Bob's other solution as well; however I have not deactivated the Shift Key so that technically should not apply.

Yes I know the password but the problem is that the database does not open when I hold down the SHIFT key - I am never able to make it to the VB Editor. That has been the whole problem.

I want to create a command button that will "print" the current worksheet (i.e. an evaluation form) an evaluator is working on as a PDF and attach that PDF (i.e. the evaluation form) to an e-mail that will be sent to the person he/she is evaluating. The command button should also pick the name...

I tried that and it hasn't worked as well :( I am sorry for the delayed response but I was on vacation and this took a backseat to eating a lot of exotic food and taking pictures with the family :) I am thinking in the amount of time I have spent trying to get this issue fixed I could have...

I would love to do that. How can I enter code in the VBA editor when I can't even open the file itself?

What do you mean it must be open to do *anything* to it? I just want to recover my forms.

Bob I tried doing it exactly as you suggested but I am having no luck. I had already tried the SHIFT key but I was letting up on it before. This time I held the SHIFT key down for a couple of minutes even after the file opened - I know that was excessive but I am getting a little desperate...

I just tried the "File Open" option and that didn't work either. The other option you mentioned, about moving the back-end, I already tried that and for some reason it isn't connecting. I never moved the back-end in the first place, I actually changed the file name of the back-end and even after...

Bryan I am trying to open the front-end file by double clicking the front-end file itself - I also have a MDE file for this particular front-end and that is giving the same error. What exactly happens is that Microsoft Access opens but the file itself does not - it just brings me to the...

GinaWhipp that is a great suggestion and I would love to get to the part of the file where I could access the VBA Editor but the entire problem I am facing is that the front-end file is not opening properly. I have attached a screenshot of the screen that opens when I attempt to open the...

I have tried opening the file while holding the SHIFT key but that didn't work - the same thing happens. The standard Microsoft Access page opens - the page you open when you open the application without opening a specific file. I thought that as well about the VBA password, but I am attaching...

I cannot use the "Linked Table Manager" because the front-end file will not open - is there way to access the "Linked Table Manager" without actually opening the front-end file? How can I delete the links if the front-end file will not open? I also tried to import the "objects" (i.e. forms...

I was successfully using a front end and back end setup for the past two years. Today I needed to push through some changes and "deactivate" the previous back end database and setup a new back end database. The new back end database has been sent; however the front end is not recognizing the...

The following code, in red text, is giving me the attached error: Sub ShowUserRosterMultipleUsers() Dim cn As New ADODB.Connection Dim rs As New ADODB.Recordset Dim i, j As Long Set cn = CurrentProject.Connection ' The user roster is exposed as a provider-specific schema...