Search results

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...

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...

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...

The AutoExec Macro runs some third party code* and opens Form1 which prompts for a valid Registration number (used by the third party code). If a user bypasses the AutoExec macro and opens the Database window**, they avoid Registration and can open any Form they like - effectively - use the...

TextBox1 Validation Rule is >=0 And <21 I would like to replace the error message " The value you entered doesn't meet the validation rule...." I made a start with the OnUpdate Event If Me.TextBox1 <= 1 Then Msgbox "Whoops..." Else End If But, although my message box appears...

I used a couple of Slider controls on my Switchboard. There are instructions about them here: http://www.datapigtechnologies.com/flashfiles/AccessSlider.html They look great and seem great too. THEY'RE NO GOOD! Earlier today, I created an .mde (2003 version) file and ran it on a machine...

I’m probably making some incorrect assumptions leading to incorrect conclusions, so I’ve set out what I ASSUME is right and my conclusion – but you chaps will know better. Assumption I read somewhere that Access Runtime is like a database viewer. It is similar to the Adobe Acrobat Reader...

TextBox1 has, of course, a maximum of 255 Chars. I imagine Unbound TextBox2 will count down from 255 with each keystroke entered to TextBox1 so I know when my limit is getting close. Can anyone point me to the vba for this?

Hello, When converting the Front End of my database to an MDE, Access just hangs and says (Not Responding). I've left it our an hour and there's no sign of stirring. The Back End converts in just a second or so. I am guessing the FE problem is in my VBA - but where!!? Might you gentlemen...

Hello, I’d like to run an Update Query on a limited number (or percentage) of records from a Button on a Form. Big John Booty gave me the idea in his post; http://www.access-programmers.co.uk/forums/search.php?searchid=7976978 But instead of opening a Form (as in BJB’s example), I want...

Hello About deployment. What's your view on Keyed Access from http://www.peterssoftware.com/ka.htm? Is it a straightforward shortcut to deploy my db? Or should I knuckle down and learn how to do it myself from scratch? I looked at http://www.sagekey.com/installation_access.aspx But...

Form1 has a Refresh Command Button. It's been working fine but doesn't now - I get a MsgBox "The command or action 'Refresh' isn't available now." - any ideas? I tried deleting the Command Button and making a new one - didn't work. the new VBA (written by the Wizard (so I don't properly...

Field1 is a number representing seconds. After multiplying Feild1, I want my result to look like, say; 2 hours 20 minutes I imagine Field2 counts number of times the result gets to 3600 for Hours and Field3 counts the remaining number times the result reaches 60, (I'll ignore the...

May I ask your help with this one please? My Form0 has a Field called DueDate in Short Date Format (I’m in the UK). When I click DueDate, I want to open Form1 filtered to DueDate dates. But I get mixed results. Either the records returned have month and day are reversed or I get no records...

May I ask, how can I make a Hyperlink Button on my Form? Of course, my records have a Hyperlink Field. Adding a Hyperlink Field to my Form works fine, but it doesn't look right. Instead I want a button without the http://www... text written in it. I looked at the Hyperlink Field's "On...

Hello, Please help I have a List Box set Simple (I mean multi select). A Button nearby opens a Report which returns the List Box selected records – that works fine. Next, I want an Option Group to perform a filter on Field1 of the selected Records. What’s the best way to approach it...

On a Form, how can I set a time interval between two lines of code? To explain, here is my solution (of course, it doesn't work) Form1 has 2 Labels (arranged to look like a traffic light) their Properties are; LightRedLbl.Visible = False LightGreenLbl.Visible = True The Form Timer...

Field1 is General Date Format - I'd like to query using the Date() Function But that doesn't work. I tried creating Field2 in a Short Date Format with a Short Date Input Mask and used VBA Field2 = Field1 Planning to use the Date() Function to query Field2 and sort Field1 But that...

Has a Spaced Repetition Algorithm been written for Access? As you know, Flash Cards are great for learning Languages, medical stuff, anything at all really. I'm learning all of London to be a Black Cab Driver. It'd be great if Access would show a Forms (flashcard) and calculate from the...

Quick post to say thank you. Your answers really sent me in the right direction. I wanted to post a thank you Gemma the Husky I did need the Tables as you suggested – now I have. What you said about Points and Quarters being the same thing was right. A bit like splitting Managers and...