POS form set up

[tristandoo]

OK what about Modifier + LeftClick?
MouseUp?

[June7]

If it's not listed on the Event tab of the Property Sheet, then it's not available.

MouseUp would execute even when the image is clicked.

KeyUp, KeyDown, KeyPress are possibilities. The procedure would test for a specific keycode and act accordingly.

[tristandoo]

What would KeyPress look like?

[ItsMe]

You could build a macro that would then fire some code.
Here is an example for A2003. It is similar in 2010. I would probably intercept something other than the function keys. Also, I have not tried to get a macro to fire code so there might be some special magic you would have to do...

[June7]

Macros can call VBA custom functions, not subs.

[ItsMe]

I started to imagine a UDF... It would be dificult to determin which product to subtract from. Would need an event handler for the control regardless.

[June7]

Right, a different key for each cookie. Not intuitive. Better off with buttons.

[tristandoo]

So right now every time a cookie is clicked (just normanly I haven't done the -1 yet) the entire form is refreshed so that the inventory is updated right away. This cause then entire screen to flash, though not a huge problem it does become slightly annoying, so is there a way to only refresh the inventory values or to refresh without the flicker?

[June7]

None that I know of.

[tristandoo]

alright I got the -1 set up, I also have a log in screen set up (have the table and qry set up too) but I can't Seem to get a new users form to work right. insite?

[ItsMe]

A log in form may be worthy of a new thread since it is a different topic. There are quite a few threads out there on the subject. Have you tried a search?

[tristandoo]

I have not searched yet, I will do so. I was just thinking since it wasn't the whole set up of login I may get something here. None the less I shall search on.

[tristandoo]

I must be using the wrong search terms because I am not finding anything relevant to any sort of account/user set up. Mind pointing me in the right direction or anything?

[ItsMe]

Not a problem

Here is a sample DB. I have not looked at it, may be too complex
https://www.accessforums.net/forms/c...els-40346.html

The topic here is about hiding Nav Pane and various properties but has info on login forms
https://www.accessforums.net/access/...ing-40614.html

Here is another sample
https://www.accessforums.net/sample-...ent-20745.html

My preference is to have a table that stores User ID's and passwords. A splash form (unbound) opens at startup and the user selects their name from a combo and types thjeir password. They hit a submit button and the table is queried, maybe something like Dlookup.

The problem is there is a lot more to it than just having a form open. You need to lock down the program so users do not have access to the tables, among other things.

[tristandoo]

I already have the db locked up until the correct info is entered (well almost left a loop hole for me in case something happened but once distributed it wouldn't be possible) and everything, tbls, qry, form i got it all.