Search results

RPC not available I was (am) struggling with the error message 'RPC does not exist or is unavailable' when running my code more than once. I have managed to find a work around which although it's not ideal, it works for me. rather than use the following, WordApp = New Word.application or...

When you place a button on a form in design view the command button wizard allows you to set the button up to open an application.

Travis, That worked a treat thanks. Pete

Hi, Does anyone know if it is possible to tab from one subform to another when they are set as continuous forms. The forms are set to allow additions and what I would like is if a user leaves a field blank then on exiting that field they will tab through to the next subform. I have tried...

This may be useful to others. Use the DateAdd function but set the value to '-'. eg. DateAdd("d", -3, Date) this will subtract 3 days from todays date

Thanks Marion. that worked. Its easy when you know how. Pete

Can anyone help me with this ? PLEASE!! I have a form based on a query or table ( I have tried both) showing results in continuous form mode, each record has a checkbox to select it for inclusion in a further query, when all the required records are selected I click on a button and call a...

I'm a bit confused with what you are asking. Do you want to tab from field to field irrespective of whether a field is in the main form or subform? If so try this. in the OnExit event of the field you want to tab from Forms![YourForm].[YourControl].SetFocus where YourForm is the forms name...

I have had problems opening forms for the first time. (taking between 5 and 10 seconds)Some of the reasons are. i)running application across the network. If you have a limited number of users you could perhaps install local frontends and just have the tables on the network. ii)Having lots of...

Carol, thanks for the quick response. I'm not sure if this is what you meant but I just figured it out by using an expression and it works a treat. Click on description field. Condition 1 choose 'Expression Is' from drop down list in the next field type [Status] = "status 1" where status 1...

Hi can anyone Help? I want to set a fields background colour dependant on status. My problem is I have a table containing 2 columns "Description" and "Status", I want to put the description in a continuous form and set the background colour dependant on status. I have used conditional formatting...