Search results

Thanks I'll give it a go

Guys I'm having a problem removing duplicate records from a table. It should be easy but I can't suss it. This is an example of the data in my table: Ref Date Status 1130071 11/06/2015 Do Not Pay 1144543 06/07/2015 Do Not Pay 1157607 14/05/2015 Do Not Pay 1165207 05/05/2015 Do Not Pay...

Fair enough, thanks

I have solved this problem. The '#Error' problem was caused because the name of the text box on the report was also Sort Code, so referring to [Sort Code] in the IIF function caused some kind of ambiguity error. Changing the name of the text box to 'txtSortCode' made the IIF function return the...

Hi that doesn't work, the correct syntax is a comma, it just changes it back to a comma

Hello all, can I run something really simple past you? I can't for the life of me figure out why it's not working. The source query for my report has a field called Sort Code. If I put a text box on the report and type its Control Source as [Sort Code], sure enough the report displays the Sort...

Knew that looked too easy to be true...the 15 year old version of MS Access I am confined to using with my employer appears not to have .WindowLeft, so I fell at the first hurdle of getting the start position. There's no doubt an API I can call, like I had to do to circumvent the fact the...

Thanks Mark that looks straightforward, I'll give that a go.

Guys, sorry it's a along time since I posted, and I only ever seem to post queries. The short tale is that I've written VBA code that hides or shows certain fields on a form depending on whether the user ticks a checkbox in the form's header. I've already written code that shuffles the columns...

Whoops, not sure what happened there.

Thanks I'll do it that way. Unbelievable that it's missing a basic function to scan the keyboard without having to use an event. But if it is, it is.

Thanks I'll do it that way. Unbelievable that it's missing a basic function to scan the keyboard without having to use an event. But if it is, it is.

Thanks I'll do it that way. Can't believe it's missing a basic function to scan the keyboard without having to use an event. But if it is, it is.

Guys this should be simple, but isn't. I have a button on a form and I want the On Click event behind it to check whether Shift is also being pressed when the user clicks the button (or Ctrl, or Alt, in fact any damn key will do). I can't believe that there isn't a function in VBA like the old...

Morning chaps I have another query regarding recordsets and reports in Access 2003. I have a report linked to a query. When the report opens, I want to use some VBA behind the scenes to interrogate its recordset. I’ve done this before without difficulty by opening a report’s query as a...

Thanks that's great I can work on that. Strange that Microsoft still hasn't given us a forms-property which temporarily disassociates a form from a table during data-entry. The other convoluted method I'd used with success is to link the form not to the destination table but to a table with a...

there must be an easier way of doing this I have a form linked to a table. I want users to be able to enter data in the form but I do NOT want the form to update the table until the user clicks an 'ok' button. Ie I don't want the table updated if they cancel out of the form. What's the easiest...

I've tried that but if I put it in the textbox's KeyPress event it still doesn't detect if <Enter> was pressed, because the textbox looses focus before it invokes the KeyPress event. However... I think I may have solved it: when the textbox looses focus, focus is transferred to the form's 'Log...

HI John I've previously tried that but it isn't invoked when the user hits <Enter> If there isn't a specific event, maybe I could use the Lost Focus event and test to see if the <Enter> key has been pressed, but I'm not sure how to test for specific keypresses: VB doesn't seem to have the...

Hi guys...another query to test you all :) What event happens when someone is typing text in a textbox and then they hit <Enter>? The textbox is set to receive a single line of text, so pressing <Enter> causes the textbox to loose focus. Obviously the 'Lost Focus' event happens but I want to...