Search results

Hi JHB, thanks for the speedy response (I was hoping that someone would be active even on a Sunday !!) Unfortunately that also displays a "#Error" in the textbox ... (I had tried that one before, I think!) Cheers D

Hello all, I want to be able to use the Count function that will reside in the header of the main navigation form that will count the records in each navigation sub form (of which there are 6 sub forms) Each sub form has the same primary key which is what I am doing the count on. I have done...

Hi burrina, thanks for your replies. To try and explain myself better .. I have a form that has a textbox at the top of it set to =Now() and the format set to dd mmmm - dddd .... so this displays as : "15 May - Thursday" I then have a weekly schedule sub-form that has a field in it that is...

OK Thanks guys for putting me on the right path... I've not played with conditional formatting as yes, so giving it a go. So far it's not working, and I think this is because the date text box on the main form is in the format of dd mmmm - dddd which is what I want to see, but the textbox of...

I hadn't decided on that yet !! but either by changing the background colour of the cell or the text colour to red or yellow. D

Hello all, How would I go about writing some code to highlight the current day if a day field in a form matches. i.e. I have a schedule form that has a field that has the day manually entered, so Monday, Tuesday etc. And on the top of the form I have a text box set to =Now() and the date...

OK sorry Brian, disregard the first part of my last question, I think I was the thick client :) For some reason I couldn't get it to work on the first attempt, but I re did it and now it's working. just adding some extra WHERE clauses to refine things a bit more. One last question, is it...

Hi Brian, Just got a query on the syntax: Select sum(iif(devicestype="thick pc",1,0)) as countthick, sum(iif(devicetype= etc etc From stockdata Where status ="waiting repair" Should the bit in bold be Count as "thick" ? Also what does the ..,1,0 part do ? Many thanks for your help Damob

Ah I see, yes that would be better for what I intended, OK I will try both methods side by side. Thanks Brian

Thanks plog ... the answer looks so simple when you see it in black and white !! In attempting to learn Access, VBA and SQL it does seem that there can be quite a few ways of getting similar results, Because the query I built worked for one lookup (and I tend to start with the simple solution...

Hello, I am trying, and failing quite spectacularly to create a single query that will contain multiple expressions on the same field. Please see attached jpg for example. SQL: SELECT Count(StockData.status) AS FaultyPCs FROM StockData HAVING (([StockData].[Status] In ("Waiting Repair") And...

:) thanks Galaxiom that was it. Proof that doing things when tired is not a good plan !! Cheers my friend. Damian

Thanks Galaxiom, that sounds like the right command to use .. I have tried putting that in as the control source and get the same error. I have also tried doing it through the expression builder, and specifying the table the record derives from but I can't seem to get the right syntax. I think...

Hi Galaxiom, I looked into DCount but from what I understand is that it counts records only ? So if I have for example: Optical mouse - microsoft - 25 Optical mouse - Lenovo - 10 DCount will only return a value of 2 if I use : DCount("Peripherals.PerType", "Peripherals"...

Hello, I have searched through this and other forums for an answer to my puzzle, but so far everything I have found is overly complicated compared to what I want to do !! Basically what I want is to be able to display a total count of a particular product type into a single text box, so that I...

Hi JHB, Thanks for that explanation regarding the GoToRecord command, that makes sense now that I see it in front of me. I'm enjoying this learning process :) Hopefully once this blessed database is up n running I'll be able to take the time to learn VBA from the beginning and start a new...

OK solved :) yay. After playing with the breakpoint and then seeing what values were being assigned, I discovered that vbNullString was always returning a value of "" even when I actually put something in that corresponding input box. Which led me to believe that it wasn't needed, so now I have...

Oh poop, I hadn't realised that I had missed all those & vbNullString) = 0 I got distracted half way through and thought I had done them all correctly. Sorry guys :o less haste and more speed and all that ! Thanks for the links spikepl, a lot of stuff there that I didn't know about. I think I...

Thanks AccessBlaster, I never really thought of it like that, just thought that closing and then opening one form from another was the way to do it !! I'll certainly look at recoding things if it make a difference to the speed of things. Cheers Damob

Hi all, Hope there is not a maximum amount of questions I can ask on my first day !! Also sorry if this question is not in the correct sub forum. Right what I am trying to achieve is this: I have a search form that has 8 criteria fields, of which the user can fill (from combo boxes and txt...