Recent content by Steve C

Thank You jdraw Thank You Galaxiom Thank you arnelgp Fantastic and brilliant and so helpful - all Apologies for not getting back here to thank you sooner. It took me ages to understand your answers and apply them - now my query is perfect.

May I Please ask for your help with this? From tblGrid I want the record with the top FieldX AND the top FieldY value. As two separate queries would look like these: SELECT TOP 1 tblGrid.GridName, tblGrid.FieldX FROM tblGrid WHERE tblGrid.FieldX <532917 ORDER BY tblGrid.FieldX DESC; SELECT...

Me.txtTest1.DefaultValue ="Here is the monthly invoice # for " & [Contacts]![Company] & ". Please confirm if we may collect the payment from your wallet. Please contact me if you have any questions. Thanks"

Consider a combo box. Users choose from a list of existing records or may create a new one

Thank you very much JHB & pbaldy. two elegant solutions which I would not have figured out on my own - thanks again. Steve C

Hello Doryas This answer is straightforward - so I think I might be able to answer. But, to help me please can you break the question down into bite sized pieces? If your Form had just two fields (I know it doesn't) what do want on your report? Field1 Field2 Field1 or Field2 (depending on...

Hi Crash_Ndie I think an Access Table is like an Excel spreadsheet but, better. The first thing with Access is getting your head around Tables. Each different type of thing goes in it's own place - a Table. So you might have a Table for customers called tblCustomer, another Table for your...

I found this useful when creating a search form http://www.access-programmers.co.uk/forums/showthread.php?t=188663

I want to call MyPublicFunction from a Control Before Update event, MyPublicFunction() If MyGlobalBoolean True then MsgBox “Some message.” Me.undo End If Of course, MyPublicFunction doesn’t know the “Me” in Me.Undo. How can I pass the "Me" to MyPublicFunction so it knows what to undo? Of...

you might have a look at DroidDB.com. it will sync to an Access backend

Some queries return un-updateable data. I can't find my link to how I know that or remember what the circumstances are which produce the problem. I have a query field which takes the "The" off of the beginning of a field (if any) and puts that "The" in brackets at the end of the field - for...

Hi Jass. Convert your Query into an Update query. set the "UpDateTo" field (where you want the comment to be written) in the Update Query to: Forms!YourForm!CommentField YourForm is the name of the form where the comment is being entered CommentField is Text Box where the comment...

Where have I gone wrong please? My code (below) gives Run-Time error "The server rejected the sender address the response was 530.5.5.1" gmail's answer is at https://support.google.com/mail/answer/14257 - but I don't understand what I am being asked to do. I have tried changing...

Sorry Gemma-the-husky, you are right. I didn't mean to offend Peters Software or suggest they'd done anything wrong. For clarity, Peters Software does exactly what they say it does. Instead, I was aiming a joke (which wasn't funny) at my own naivety, May I ask you to understand, it was...

WOW! I’ve got goose bumps, Bob Fitz!! THANK YOU!!! I could not have done this on my own, it’s brilliant and perfect. I spent all afternoon on this problem and all I got was a headache – I’m so grateful. Thank you again. Here’s what I did for anyone following; Opening Bob Fitz’s db with the...