Recent content by ptr_turbo

Linking pictures to despatch numbers I had a similar problem recently. However we found that having a folder for each job number quickly became very cumbersome. Soon we had hundreds of sub folders. We overcame the problem by prefixing the picture file name with the job number, eg if the job...

Auto fill Text field Why not set the ControlSource property to a function, ie =getmembershipstatus() Function getmembershipstatus() dim age as byte age = Forms![FORM NAME]![AGE] select case age case is between whatever and whatever getmembershipstatus = "Junior" case etc etc case else...

Try setting the focus to enddate before assigning a null value to it. I noticed you assign null to endate and then setfocus to it. I recall that Access would remind you that it cannot assign values to some controls without first setting focus to it.

I am trying to use the .Execute method in an openfiledialog object. Each time I open an openfiledialog box and double click on the desired file I get the message"You already have the database open". I am confounded by this message and when I click on Help I get a blank help screen. I am using...