Search results

Sorry, It does work. How do I specify a line break? How do I highlight something?

This does not work

Using VBA in excel I want to place a string in an email: With newEmail .Body = "Approval Instruction are as follows:" End With I want 'Approval Instruction' to be highlighted and made bold. How do I do this?

Good solutions...Thank you.

My form has a text box which has a control source pointing to a different form. When I use me.dirty = false and it automatically writes to my table, the text box value does not get recorded because of the control source. How can I ensure that the text box value gets inserted into the table?

No, the server is not my machine and I am using the correct path for the be. I believe the form is corrupt cause I can open other forms fine.

Its has runtime...to relink don't I have to go into the linktable manager in access. The client doesn't have access to that?

The client machine doesn't have access on it and so I cant open the fe to relink the back end. When I open the fe I can see the be data.

I compiled the application...same issue. I will try to create a new form and see if I can open it. If that works I will build the form and test as I go. Thanks for your help.

To compile -> run compact and repair or is there a compile function?

Its exactly what I did...I copied the front end to the client and created a folder from which I ran a shortcut on the clients desktop. The backend points to the same location as my computer and when I open the app the data from the backend is visible. Don't know why this form is such trouble???

I moved the app to the clients machine and ran it from there...same issue!!!

OK...I do have the front and back end split. Do I just copy the front end accdb file to the users machine? Do I have to create a shortcut or let them double click on the application?

The app resides on the server. I created a shortcut on the server which I copy to the clients machine. Even if I go to the folder on the server from the clients machine and I double click on the accdb file to run I get the same issue. The application runs just this one form would not open.

Modified the code accordingly...works on my PC but doesn't on client side. Task manager shows that the form is open but I cant see it and the application is locked.

I working on a multiple form access application. On my machine, where I am developing the app all works fine. When I copy the shortcut to a client machine one of the forms that should be opening locks the application. When I go to task manager the form looks like its open. I use the following...

Thanks Colin

My forms have popup -> yes and modal -> yes. When I close my current form I get the save window pop up however it does it on the parent window and the current window is now behind the parent window. How can I ensure that the Parent window doesn't appear until the current window is closed?

Colin, Thank you...I finally figured it out...works great.

So what you are saying is not to run the application in minimized size, make the access background invisible through code and the pop up for printing would work.