Search results

I can't see where to get to this, I can't find it in the query pivot chart or when I create the chart in Report Design.

Yeah that'll definitely do, how can I get it to look like that in access?

this is what the graph currently looks like; and this is what happens when I add in the 2 other fields that I want; I would ideally like 2 seperate columns, one with the Red and Blue fields and one with the Green and Purple fields. I've tried looking at the multiple chart options but...

Hi All, I need a little help with my pivotcharts. In my query I have a couple of calculations that works out the percentage capacity used and the percentage capacity left for 2 different things, ordered by week number. In my pivotchart, I wanted a stacked column to show how much percentage...

Yeah that's got it, thank you very much! Mainly because the data spans across several years and the built in function for a weeknumber only gives you that so when having to work with data that goes across that length of time, I wanted something a little more specific and also something I...

Hi All, In my query, I have the week number and year arranged like this - "Y14-W11" I want to return a value in a text box on a report if the string contains, for example, W11. In this textbox I've put the expression =IIf([Y##-W##]="*" & "W11" & "*","2100000","BLAH") But this just...

Ah that's what the save function I built in is for, nothing is finallised until that save button is clicked. All I want is txtJobNo to search for a duplicate and then go that duplicate record if there is one. Combo58 is just a quick search function, allowing us to find a job and tick it as...

Sorry my mistake, I meant the combo box in the detail, Combo58 is just a macro search that searches by ID. On the after update event of txtJobNo, I want to check for duplicate records and then if there is one, I want to find that record. Thanks for the help so far!

No, this is just a small part of it stripped down. This section is to provide packing and goodsout instructions to our warehouse and to keep track of all jobs going through.

I can't quite see what you've done here? The search at the top is literally just a quick search, nothing more. The textbox in the form (txtJobNo) is where I originally had my code and the combobox cboJobNo is the one you said to put in.

Attached stripped down database. The form is called Packing, the combo box you suggested is the very first one in the layout.

Nope, still can't get this to work!

Didn't change anything although got to admit I didn't even notice that. No it's a bound control on a form.

The form is already open when it makes the check, I tried adding DoCmd.Close before the check but obviously then the function stops because the form is closed. Because I need it to check after I've entered in the Job Number, as very occasionally there may be a need to repeat that Job Number...

Hi All, On my form I've got an afterupdate event that checks if the information entered already exists and this works absolutely fine. However what I would like is the option to go to the existing record if one is found, but I can't get it to work. This is my code currently; Private Sub...

Hah yeah it certainly is!

I managed to fix it thanks to that, I didn't even think of creating a query and relating to that rather than the actual tables. Whether this is a work around or fix I'm not sure, but it's doing the job so far so thank you!

It's Allen Browne's concatrelated function, the idea is to concatenate the records in the Instruments field where the User is the same.

Ok so I've changed my table relationships to how you suggested and I can see how that would work, except now I'm getting a 3601 error, too few parameters, expected 1, and I can't see for the life of me where this error is occuring. This is my query; with the following SQL; SELECT...

Ahhhh ok, that makes more sense now, thank you, I'll give it a try now and see what happens.