Search results

Ok, thanks for the replies: I've tried this and I'm getting #Error coming back at me!! It's driving me up the wall!! This is the code from my module - I know its not the same as I described in my OP but I was trying to keep it simple!! Public Function...

Hi again, OK, so here is my next problem. I've got a query which I'm trying to use to pull information which matches only my criteria. However, I just keep getting this message (only shown partially): The expression is typed incorrectly, or is too complex to be evaluated. What I'm trying to...

Hello all, I'm new to modules and having a problem with the code as outlined below. Basically if ProportionCircuitsFail is a text field (selected from a combo on a form) then the code doesn't work. Public Function LSS3(ProportionCircuitsFail As Single) As String If ProportionCircuitsFail =...

PBaldy, thanks for that - I suppose thats really something I should know, seems kinda simple. Cheers anyway, save me some time there!:D

Hello again, This time I'm having an issue with a calculated field I've got in a query. My form (which is based on the query) has two fields [NumberPostsTested] and [NumberPostsFailed]. The query is calculating [NumberPostsFailed] / [NumberPostsTested] * 100 (basically its giving a percentage...

Okay, so now I'm officially confused - tried adding the function a few times this afternoon at work (where I don't have my Dummies book:rolleyes:), can't get any joy out of it so far! Here's what I've got! Public Function xFactor(DIFF As Double, TEX As Double) As String If [DIFF] < -0.05 And...

I'm trying to restructure this function which came from an excel workbook, I need to put it in my query. No progress so far though!:( =IF(AND(B6<-0.05,B7<0.8),"Substantial",IF(OR(B6<-0.05,AND(B6<0,B7<0.8)),"Moderate",IF(OR(B6<0,B7<0.8),"Slight","None"))) Where B6 is my field [DIFF] and B7 is...

vbaInet - you solved it! thanks so much for your help - have some rep:p I've just started reading the dummies guide to VBA for Access 2007, hopefully that will help me along the way. Thanks to Bob for input as well, this forum is really helpful for me! swift

yep, thats what I'm trying to do. Sorry if there's any confusion, I'm learning all the time at Access! Following your suggestion, I've re-arranged the placement of the Nz function to no avail - I'm not all that sure that its in the right place! TRANSFORM Nz (Count(A1RMMSQRY.DPCode,0)) AS...

Tried that DCrake, did not work unfortunately. Could it be anything to do with the field type of DPCode in my table? - I've just checked and its currently a text field. I'm going to copy the table etc and change the field a few times and see what happens. Have you any other ideas? Cheers for...

Can anybody help with this please? I need to generate zero/null values in a crosstab query where the query is not counting any data. I know about the nz function but I'm not sure where it goes in the query - I've searched the forum and found a few threads but they have not really helped. Its...

Hi, I'm looking for some assistance with a crosstab query I'm trying to get to run. I've tried and tried and each time seem to get a slightly different result (which still is not the one I want!) Basically I'm querying two tables and this is the result: SectionLabel DIR XSP From To TEX CSC IL...

In my database, every new scheme I add has an autonumber field called SchemeID. In the DB, I have a form (ImageForm) where users can add images. On this form,I have a sub form (ImageSubForm) holding details of said (linked) images. I would like to have a autonumber field (say, ImageNumber) which...

Sorry for the delay in replying - Yarp that solved the problem straight away, thanks very much for your assistance!

Hi all, I'm looking for some help with this query problem I'm having. Basically I'm trying to query two tables carrying similar data fields so that the result shows the matching fields together. I've attached an example of what I'm trying to do in xls format as I'm not particularly sure how to...

ok guys, thanks for the replys. I'm guessing that splitting the DB will resolve the autonumbering problems I'm having as well......sort of killing two birds with one stone?!:confused: cheers swifty

Nope, the DB isn't split.....is that something i should seriously consider? That link has some good information, is it relevant to Access 2007? The one issue I may have with splitting is that the shared drive is assigned different ID's on different PC's....I'll have a look around the forum for...

Hello all, I'm looking for some help/assistance with my database. When I setup the database it was being used on one solitary PC, now it is being used on four machines simultaneously; and potentially on three more very soon. I have one minor irritation which I would like to try and resolve. I...

ok here it is in SQL SELECT T_Project.Name, T_Job.Operator, T_Sites.Name, T_Facilities.Name, T_Sections.Name, T_Location.X, T_Drop.Sequence, T_Drop.Number, T_Drop.TimeStamp, T_DropDeflection.E0 FROM T_Sites INNER JOIN ((T_Facilities INNER JOIN T_Sections ON T_Facilities.ID =...

Hello, I'm trying to set up a form which has a combo box on it containing Project Names. I want to use the combo box to select the project name then hit a button to run a query which returns results only for that project name. I have the query which I think is okay but everytime I run the query...