Search results

The *.mdw file This is where the security for Access comes form. If you need to have different security for different databases then you need to create another MDW and when you log into the databases pass the correct mdw as a parameter. The access files are okay on this at best.

Images in Forms Just as an addition to the thread. Users will get bored waiting for images to load if this is run on a network and the images are stored centrally. Better to give them the option of seeing an image or not. If it is on a single PC then it will work so long as the PC is not...

Image Field and Forms You can use this Sub getFileName() ' Displays the Office File Open dialog to choose a file name ' for the current record. If the user selects a file ' display it in the image control. Dim fileName As String Dim result As Integer With...

Me Too I've never seen it work but thought someone may have. My thanks and appologies for PM.

Links You need to look at the links between the queries. EG All from this and only where equal from the sub. It might helps here.

Thanks... but Not sure where to write this code. Should I run it on the OnOpen Event. I understand if it is in a Form but in a Report? From a Glaswegian in London

Webpage in a report Any ideas out there? :confused:

WAN and Access I have several clients who run a front end locally and a backend on a server. Unless the network is fast and reliable the users have to log off and on every so often. The first sign is CurrentUser has a null value. If you want to run on a WAN there are 2 options. 1) Re-write the...

If only all questions... =Time() And then I had to add this sentence to get past the too short a reply.

Try Error trapping The probability is that this is caused by null values in the calculation so trap these or On Error Resume Next and ignore the problem

If all scores are between 1 & 3 why use the between bit. If it is a number field then default it to 0. If the bewteen bit fails then you have null fields or a zero. UPDATE monitoring SET CS_Score=CS_Score/3 WHERE CS_Score > 0 and CS_Score < 4 but UPDATE monitoring SET CS_Score=CS_Score/3...

Can you re-write them as a BAT or VBS file and then just use the scheduler in your server.

I have a table with locations in it including the web address of a map. I would like to add the map to a report of that location so that the users can just run the report as a full guide to the location with all the other information they need. I have tried adding the ActiveX Web Browser object...

show the image I ssume you have a field for the location of the image.## ;) If you have an image frome on the report then hide it to start with so that it only appears fro an employee with an image. Private Sub Report_Activate() showImageFrame If IsNull(Me.Photo) Then...

You'd be better to create a Custom Tool Bar which is enabled on the OnOpen Report Event. This way all users could do the actions that you think they will need, such as resize, Close or Print. Just a thought. :p

Try Accepted.MoveLast before you add .. Mind you i don't know why you need this either.

I've seen this before but can't remember the elegant solution. You could try checking the order of the events, or even use the events to send the report to the printer from a preview instead of direct to the printer.

Try this as I have seen it before. Does the link have http:// as part of the string On the cmdWeb_click event const sHTTP = "http://" if isnull(Website) then cmdWeb.HyperlinkAddress = "" Elseif Left(Website,Len(sHTTP)) = sHTTP then cmdWeb.HyperlinkAddress = website Else...

OnOpen Events 1******* If you test for the date in the event onOpen and then open the new form and close the old If Now() > TestDate then DoCmd OpenForm("NewForm") DoCmd.Close acForm, Me.Name End if 2******** Set the timer interval event to x (000) in millisecs Then in the Timer Event...

Thanks. You made me a happy man!