Recent content by DanielR

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.