Recent content by kjh

Using the conditional formatting function within a form I am trying to reference a date field to be highlighted when its value is tomorrow. Date()+1 gives me tomorrow highlighted but I don't want weekends in there. I know this must be simple and I have tried many variation of the weekday...

I made the changes to the autocorrect and the table datasubsheets and it works great now. Thank you!!!!!! , what a journey!

I recently split my DB, back end on server on front end on each machine. However when more than one person starts updating the performance all but stops. system says "updating tables" and takes forever. If only one person is on everything works fine. I put both the front end and the back end...

Ok I understand now. Thanks for your help. I did not fully understand the terms front end and back end till now. I will get to work on setting it up correctly. Thanks again.

I am not sure I understand. I have loaded access 2010 on my machine and have downloaded access runtime on the rest of the machines. We all use shortcuts pointing the database strored on the server. What do you mean by their own copy of the front end? bear with me, I may have things set up wrong.

I am running Access 2010. The datablase is split with front end running on my machine and the back end on the server. I have 4 other users using Access Runtime. My settings are set to "Shared" with "No Locks". The users on runtime can use the database with no warnings however if they have...

I am new to the forum and not really a code writer. I have copied the following code that uses the hyperlink function to connect a Field with a file stored on a server: Private Sub Photo_Click() Photo.HyperlinkAddress = "F:\Photos\InProcessPhotos\" & RepairOrderID.Value End Sub It...

Thank You very much!

I purchased a single license of access 2010. I will be using it in a multi-user server-workstatiion environment with runtime libraries. I need to program from my workstation. Do I install access on the server or my workstation or both? I am a low level user so please make explanation as easy...