Search results

Just created a table and it worked perfectly :) Thank you again CJ. EDIT; My revised equation is now; DLookUp("ProductGroup","tblEmployeeForm", "EmployeeID=" & [EmployeeID]) Now I just need to add some code to update this table when I open the Form :)

Hi CJ, Thanks for the quick reply. That has done exactly what I want however it is really slow and I have to click the field to motivate the formatting to change. I assume (and will try now) that appending qryEmployee to a table will improve the speed. Here's what I have in the conditional...

Hi All, I have a form and I am trying to highlight all values that equal the top value. I recently learnt that I can create a query style record in this thread and thought I can apply the same principals. https://access-programmers.co.uk/forums/showthread.php?t=291097 So in the conditional...

Thanks for the comments. To create the reports all I did was open the form and save object as report and then combined them as I did the forms. I've not had much experience with reports but I will look into going this way as you mention the sorting in the record source is ignored i think this is...

Hi CJ, I have the employeeID in the graphical subform which is contimuous. This displays all details across all branches in a neat little chart. I need this to be displayed in the main form and relating the graphical sunbform to the main form via the branchID filters the graph down. That is...

I have got a little bit closer with what I want by creating a midway form containing the EmployeeName in a text box and is linked to the graphical subform via the EmployeeID. Both of these are in the form footer so I can set the form to continuous. This subform is the inserted into the Main Form...

You have it spot on there but I want to see means I really need to repeat the subform and enter the various employeeID as a parameter. I have created a parameter form that works but I just need it to repeat x times as the charts also display data outside that branch as employees often move and...

Hi Uncle Gizmo, Thank you for your reply. When I change the main for to a continuous form I get the error that "You can't view a form as a continuous form if it contains a subform, ActiveX Control, a bound chart or Web browser control" and I am not sure how to work around this? When I set the...

Hi All, I created a subfrom that graphically displays the performance of a certain sector / employee in a business. From this I have created a main form which I can select branch (London / Birmingham etc.) the form then displays the Branch details in the header and the detail displays the...

My statement links to a lookup table where 1 = GBP and I just translated it. I see what you mean though that using a text box for expressions instead of a query is bad practice. The money code is 1 example of 3 different text boxes that use expressions so I believe that will be my first thing to...

Hi all, I have a form that contains an expression field to display the value of sale. It uses an; IIf([Currency] = GBP, "£" & [ComponentPrice], IIf([Currency] = "USD", "$" & [ComponentPrice], IIf(........ for euros etc. The field worked fine yesterday but today displays #NAME? and if I copy...

I see what you are saying here. the OrderID is an autonumber field so that is why my test was successful. I did try using the DateAndTime but it was asking for parameter values. The spellings seemed ok so I just tried the OrderID and it worked. I will have a re-try with your suggestion.

Thank you both for your help. I currently link my db to sql to perform ranking functions for weekly / monthly most valued customers and I believe we will one day use a full sql database so I will keep both your comments on board. The code I used to get my results is below. Thanks once again.

Hi All, I am trying create a query that will look at an employees past sales but I want to add a field that will show the employees last sale value / quantity of products and have tried using the DLast function but it only displays a random value which is the same for all employees. Not what I...

Well that's a little complex to give it all but I have a going query where I have a minimum strike rate and award points based on the numbers, same for distance and track. All these are summed in another query and my master query uses max and pulls the date, time and text (Horse / Track fields)...

The selection is just the horse that meets my criteria for the stats. If there's 12 runners in the race there maybe 2 horses that meet my criteria as possible bets (sometimes there's none but that can't be helped. I have 3 tables (copy and pasted from the racing post site); 1 = TrainerStats...

Hi everyone, I am new to using access but have managed to build a database that I use to find qualifiers for horse racing based on stats I import for all the racers in the days racing. I have a query which shows the date, time, track, horse and trainer but some races have more than 1 selection...