Search results

Can someone please help me with this. In mu subforms I'd like to reference a control which is in the master form. I need to cross reference the contents of a control within my subform against a control in the master form so that I may limit what displays within the combo box. All help...

Tremendous. Thanks for all your help. Very much appreicated!

Thanks I got it going. Can you mind tell me what you changed. I'm looking to replicate it on my master system Thanks for everything. Really appreciate it. Easy when you know how I guess! :rolleyes:

Thanks but attachment is downloading as read only so i can't make amendments/additions

Can one of you genius' please help me out. I have a form with a combo box in which I choose an option. Upon choosing this option I would like a corressponding field on the form to automatically populate within the user having to enter the data. I've attached a mock up of what I'm referring...

Hi folks, I'm a compentent Access user but know nothing about web applications. My client has approached me about the possibility of putting a system I developed in Access on the web so they can use it anywhere. Is there a way this can be achieved through the use of a third party...

Yeah....place the items field within the Detail Section of your report In the group footer create and unbound field and within it's control source type in the SQL

I have a form where the user enters the name of the Company. I then have a control where they enter a contact for that company. How can I set it up so that the contact list is limited to those against that company and not and entire list of all contact in my table? Any help is much...

The attached assumes respective tables for each year.

Are the sales codes in the same table? Pleas post database if possible and I'll have a look at it.

Your form is working perfectly! The Customer Name pull down merely selects the Customer of choice and pulls forward their record. No changes are made to the underlying table.

In the report creat a group heading and footer for Customers. Drop the Items into the Detail section In the footer section create an unbound field anc enter =Count([itemref]) This should show the number of items per customer. Obviously "itemref" should be set to the correct field name

Not sure I understand completely but should be a straightforward fix. Can you post the database andI'll have a look?

My company have a project management database which has been in use for a couple of years now. On a daily basis we deal with quite a few enquiries from clients which require us to interrogate the database and feedback. We want to develop an area of our site which will enable clients to gain...

I'm trying to utilise the GetUser function to pull through the Users windows login into an Control on my form called Staff Name. Having placed =GetUser() into the Default Value property of the control I get nothing coming through. Placing the same within the Control Source brings the username...

I have two tables. One listing the various Exchange rates between the Euro and Sterling. The other a list of Projects. I have designed a form for the Projects Table which has a Project Budget which is entered in Euro. As I enter these values I want them to calculate the Sterling Equivalent...

Kool mate. Thanks for your help.

Genius...many thanks. Easy when you know how! Would you have time to work through another dilemma regarding euro calculations on a form and trying to prevent these changing when the exchange rate is updated?

Cheers mate. Code doing it's job. However what's happening is the button doesnt appear on load (as instructed) and only appears when the Submission Field is updated (as instructed). As I step through records without amending the field I want the screen to show determine whether or not to...

Thanks Magic Man Almost there. Getting a Data Type mismatch using the following: Private Sub Was_Expression_of_Interest_Submitted_AfterUpdate() If "[Was_Expression_of_Interest_Submitted]" = True Then Me.BTN_EOI.Visible = True Else Me.BTN_EOI.Visible = False End If End Sub