Search results

Thanks spikepl I tried converting the BE to MDE Just to see if it would - no reason apart from that. About Compiling. I may not have done it right. I pressed Debug and Compile in the VBA window, thinking about it, I'm guessing it only compiles that that little bit of code. I will read some...

Hi GTH, Peter's Software say that resetting the computer date doesn't fool Keyed Access. They call the feature "bullet proofing". I haven't tested it. Thank you for this Post

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

I went ahead and bought Peter's Software Keyed Access Programme And it seems fine. The only small glitch I have had so far is that to generate the registration numbers requires temporarily setting User Account Control to "never notify" which once I received an email back from Peter's Software...

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

I'm going to do as you suggest JTH (thank you) - and have a go myself. It's not really about saving the $300, instead, it's that the db will be better the more I understand it. I've no plans to maintain the Back End (that's Tables right?) each user will write their own data. And, no copy of...

Thanks for your answer Beetle. Sorry – sometimes I say too much, other times, like now, not enough. I need to distribute a stand alone application with licence key. No LAN. How would you do it? Thanks Gemma-The-Husky. You know I’m far from being good enough to write the code to create a...

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

Thank you JHB. sorry I didn't say thank you straightaway. I've not been on the internet due to a berevement.

Cool - good luck BLS

Thanks JBB - way WAY better than my effort. Good luck Alvis - next time somebody asks this question I'm gonna give JBB's answer and pretend that's how clever I am. (not really). Well, a bit really

First of all, there are some big hitters on here that know a very lot more about access than me - I might only be one page ahead (or behind) Alvis in the manual, but please don't have a pop at me for an inelegant solution. It's my best effort. There I've apologised in advance. Here goes then...

Righto Alvis, I'll work something up, and reply tomorrow.

Are you in the USA? (I mean do you use US format Date/Time display MM/DD/YYYY)

In your table of ResponderInsAndOuts (or whatever you call your table for that) you need two Fields called TimeOut and TimeIn. Format for the fields is Date/Time. On a form you need 2 buttons (don't use the Wizard to make them) Button1 is called "TimeOutCmd" Button 2 is "TimeInCmd" You also...

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

Does this help http://support.microsoft.com/default...b;en-us;210504

Hello Alvis, JBB's solution is perfect, however, might it be you want the user to decide how many records he wants? if yes, here's how I might do it Create a query with column to count the records set the criteria for that column to read off your user's form Text Box I haven't got the...

Sorry GKing, my software is (I think) too old for .accdb files - I can't open your file to have a look at your DB. Might you post a screenshot of the Relationships window?

Very useful Post Dave Thank you -I've been trying to find a way to DoCmd.OpenForm,acViewCONTINUOUSFORMS,, - But that's not an option (just acViewDS and Edit). When I saw your solution for Hey Lucy - the form looked right, so I made a mental note to come back here - but couldn't remember...