Search results

Same way - just put the form into design mode and open the properties for the relevant control and you can add your format to the format property.

This is automatic in Access to a point. Here are a couple of scenarios: If two users are both on record 1 and on the same field and one of the users updates that field and then leaves/saves that record. The other user won't see that change until they either leave that field and then re-enters...

Hi, Sorry but this isn't something I have done so my knowledge ends here. A quick look on the internet returned this page that may help: http://stackoverflow.com/questions/10191506/internet-explorer-automation-with-vba-input-events

I don't think you can use any old pc as a server (but I may be wrong). I think you would need to purchase a proper server and install it with something like Windows Server 2008. Then it would act similarly to a normal PC except you would be able to set up multi-user logins. How many users do...

Can you clarify what you want to know more about - buying your own server or renting a server i.e. paying per month?

Also think you might need to add the name to the ID of the element like this: <input type="text" id="phone_login" name="phone_login" size="10" maxlength="20" value="" />

Try this: ie.Document.all.Item("phone_login").Value = "XXX"

You could switch edits back on when the user clicks in the status box and then turn them on or off again depending on the status they choose. This could be done via the Got Focus event.

If you rented a hosted server then this could get costly with that amount of users as you normally have to pay a fee per user per month and extra for software licenses. Having your own server would seem the better option though this would mean you would have to maintain it and if you required...

In my experience the best method is to use a hosted server. On this you can install (or the server can do it for you) whatever software you want. This could be full MS Access or just Runtime Access (for extra security) then everything will run as on your local except users will login to your...

Sorry, didn't explain that very well but the code in the previous post is VBA and would probably be used on the OnCurrent event. Something like this: Private Sub Form_Current() Dim Path As String Path = Application.CurrentProject.Path & "\Images\" Me![Image1].Picture = Path &...

If you switch the Cycle of the forms properties to 'Current Record' this will stop the user being able to tab off the current record.

If the Excel file is linked to the database as a table then you can create a recordset based on the table and add any filters etc there.

If the images folder is in the same folder as the database then you can use something like this: Application.CurrentProject.Path & "\Images\"

You need to send the colour in a format Access can understand. Take a look at this: http://www.endprod.com/colors/

Not sure of the limit but if won't let you enter anymore then I'm guessing that's the limit. You could split them into separate boxes and then concatenate them back together afterwards.

I'm not 100% clear what is or isn't happening but at a guess the problem is at this line and the button should get enabled? NavigationButton140.Enabled = True MsgBox "Should be Enabled but isn't!", vbOKCancel if so try this: me![NavigationButton140].Enabled = True

I've done something similar to this in the past and ended up having to use a table as the basis of the report. So, set up a temp table and when you run your report populate the table using the results from the query. The key here is that the temp table has a memo field in it which the report can...

Glad you found a solution - just be careful not to type into the first record and I'm sure it will work well. Re setting the thread to solved I think there is a 'Thread Tools' link at the top which has this option in.

Open your form in design view and open the properties for the field. Now look on the Other tab and make sure Allow Autocorrect is set to Yes.