Search results

I have a form which has a button to take the user to another form. However I wish this button to be invisible unless another control on the form is ticked. I know it's an If then else..statement but not sure of VBA syntax or where to place the code. The conditional control is a Y/N field...

Thanks DCrake That's not a million miles from where I'm at. But how do I stop the historical records updating every time the Euro exchange rate is amended?

Sorry Folks, really struggling with this. Can anyone post a sample database showing how to achieve this. Basically I want an automated function which calculates and stores euro values from Sterling which remain static once calculated according to the exchange rate at the time of entry...

Thanks Statsman Thats kinda where I was going with it. However I want the Rate value to populate dynamically from the rates table picking the one marked current.

I'm developing a project database for a client. Projects are priced in sterling but converted into Euro. How do I set this up so that each value within the Euro field stays at the rate it was calculated on entry and does not change as the rate is updated? Thanks Fozi

seriously? It's impossible to do? How frustrating!

thanks Dave. My form shows continuous records. What event property should I insert this into?

Hi I'm trying to do what I beleive should be a simple routine. I wish to hide certain fields and buttons based on the contents of another field in the same form. So for example if the field has "Yes" in it these display if "No" then they are invisible. Thanks Fozi

Thanks Thanks Gemma. I'm thinking of heading down the route of establishing a Calendar Table and then some unmatched queries. Cheers for the advice

Hi I've got an activity logging system in which users add their daily activity. As an information check, I would like to generate a report which identifies days where the user has omitted to enter activity for given dates. Is there an inbuilt function that Access has or can anyone point me in...

Thanks for getting back to me. I'll give it a go but I'm a VBA numpty. Are there any routines you could point me in the direction off to adapt? Cheers

I have a query that lists clients due to submit claims. From this list I'd like to automate an email for each client informing them of this. Struggling to work out the best way. Tips appreciated. Thanks :)

I have a button in a form which opens up Outlook and drops in autotext for To and Subject - so far so good. However user now wants the email to open up with word as the email editor rather than plain HTML so they can use Autotext. Any message created within Outlook are already set to this and...

Two files, one to many relationship. In the Parent Table everytime I create a record for a particular project on saving I would like a record created automatically in the Child Table containing the same project reference. Any clues would be much appreciated.

I have a combo box which linked to a subform which display records based on the value selected in the Combo box. Straight forward enough. However I have added a selection for ALL. When the user selects this value I want the return to display all records. The code is bound to the AfterUpdate...

I've got a start date and a completion date with an internal target of completion within five working days. Should we receive it on a Friday and it's now Monday, how do I write the code to exlude weekend days in the day count? Clues would be much appreciated. :)

I'm working on a sub-form set to continuous and would like to amend a memo filed so that it autoexpands when entered. Have tried amending the height of the field through the on enter an on exit functions but this alters the size of the form. Any clues would be much appreciated. Fozi

Guys and Gals I'm trying to get my access field to autoenter the user's network ID. Working with Access 2003 and Windows 2003 server. Any clues would be much appreciated. Thanks F

I'm looking to write an audit control module which captures users activity on my system. For each activity the system records user name and date/time of update. Ideally I'd like the user name fields to autofill with the users network login ID. Any tips would be much appreciated. :)