Search results

@Spike: check my signature, it's not a joke! Thinks you will loose: - automation; - reports events handling; - at least with mine, cannot save in other Access listed version. - no Activex controls (for me it meant couple projects on hold). And if you don't believe me, check with Gina...

@Swan: a Utility module is kind of a fourre-tout, a module where you keep all kinds of unrelated procs. Add a public UserPermission as Boolean. So when the user logs in, fetch the yes/no field and store it in UserPermission. When he opens a form, in the open Event use it to set the form...

Check the Dir function: it does every thing you need...

You not familiar with the concept of relationships. Since you have 2 monitors you need 2 records but not in the Wires table but in the Monitors table. At this point this can be a solution: Wires Wire: PK Monitors Monitor: PK Wire: FK So 1 entry in Wires point to 2...

I think you should first make up your mind and then, ask for help. Is this form your talking about exists? If so, post screenshots of it.

@Lukas: I think your initial schema is right. I find some of your relationships strange. May I suggest: Wires --> Users Wires --> Desktops Wires --> Monitors (if desktop connection can be omitted) Wires --> Printers Wires --> Phones For unconnected equipment, create a dummy WireID.

@Arnelgp post #10: from MS download site http://www.microsoft.com/en-ca/download/details.aspx?id=39358

Before switching to SharePoint make sure you understand what it is for: you will be disappointed! If your internet connexion is that bad, forget about remote access to your app...

Your making your live very complicated in trying to bypass normal Access features. Your 4 command buttons are useless: use the navigation buttons for the subform! WO in the subform is useless move it to the subform footer and make the footer invisible. For the WO filter combo I suggest something...

'Access' doesn't have to be installed on all machine to run Access app. Download Access runtime (proper version) , it's free! Note that quick access toolbar is minimal so you have to create a custom ribbon...

Sorry, but your last post is so obscure... Could you attach a snapshot of the app relationships? And one of the form your describing?

After every mods, make sure you compact your app. Some times, Access is very misleading in executing a statement that will be rejected after compaction. Why do you need to execute that DoCmd???

You can also use 'Remote desktop connection' (in Windows services) but make sure you encrypt with password your app (and keep your password secret).

A simple way to do that is to create a second equivalent (to you) user on your PC. You can then, at any time, simulate 2 different users. What are the 'problems' (error messages)?

@Galaxiom: most of your points are right. The idea behind this is a post where a novice user was using a modular intermediate to achieve the same purpose. Experienced prog. will not learn anything from it but a novice will learn how to initialize public var when a form is loaded, trap ALL the...

You have 3 attached files. Are you blind!!!!

For those (a vast majority?) not using A2013, here are pics and docs that will help you implement it. Good day, JLC.

Here is a possible solution to a simple issue that occurs quite often: entering data, one realise that an item in a query is missing or misspelled. To illustrate my solution, I have used a typical case Suppliers -> Parts. I think I have covered all possible case (even not recording the changes)...

Plog is right; Ranman is wrong; Spikepl:p: keep your silly comments for your friends...

Here is my solution to the shift key issue (Office 365 - A2013): [ '------------------------------------------------------- ' Shift key property '------------------------------------------------------- ' Public Function ShiftKeyProp(bl As Boolean) 'This function enable/disable the usage of...