Search results

Because I don't want to be at fault... :) Seriously, I'm not sure. Here's the best I can do to explain: -When my DB opens, you have to login (using a form I created). -After logging in, it takes you to the Main Menu (the one with 4 tabs). It opens in acFormAdd mode (is this the issue? and if...

Hi everyone. I could use your help. Nutshell: My user DB has one menu with 4 tabs (2 for adding records, and 2 for searching/editing records). Since the form opens up in the acFormAdd mode, Access already creates a new record (blank) before they type anything. It is resulting in blank false...

Unfortunately, that isn't an option here. I could always just hide the back end - somewhere where they can access it of course. But I'm still wondering, if I create a login requirement on the back end and only allow me, will they be able to update the front end and have it transfer to the...

Hi, I have a database that I just split into a front/back end, and have a question about protecting the back end data. I know that the back end must be in a place the front end user can access, but do they have to actually be able to open and access the back end for the links from the front...

Fixed it! The field that I was wanting to update with a default value on the two tabs was sending the info to the same field in the table (Item_Type). For some reason, it was only allowing one value instead of the two. I created an OnDirty event for each tab to change the value to TypeA or...

No subforms. Just separate tabs with text/combo/check boxes for data entry/editing.

Thanks for the quick reply. That's the way it's setup. My main menu has several tabs, two of which are for adding a new "Type A" record and adding a new "Type B" record. The default value is associated with those tabs. My main menu form also has four more tabs - one each for...

I've looked all over and can't find the answer... My DB has one main table where all the records are stored, and one form with multiple tabs allowing for data entry and editing. There are two distinct "Data Types" I have in the tables, so on the two distinct form tabs, I created a text box...

I will look into splitting. I haven't done that yet since this is a small DB. There are 20ish of us that can use it, but only 3 or 4 use it regularlly, and it isn't a daily usage - maybe several times a month. But, I will take your advice and do it. Thanks!

So, I found the culprit. I was using Allen Browne's method for logging user activity found here. It tells you to create 4 events for your form in the Before Update, After Update, On Delete, and After Delete Confirm fields in the properties. I removed those events and now everything works...

To answer. .. yes for the first, no for the second.

Hi, First, I wish I had more details as to what happened, but I'm at a loss. The short of it is that my forms will no longer allow me to add/edit records. It gives me this error: You can't save this record at this time. Microsoft Access may have encountered an error while trying to save a...

Awesome! Thank you. Would have never thought of that. I disabled the shortcut keys, but had no idea there was a bypass. Thanks again!

Forgive me, but what is the "Shift-Bypass" you speak of?

I answered my own question. I just disabled the modal property of the form. Works like a charm. Thanks for all your help.

I tried on my work computer, so it may be a problem here. But, I do have another question. I did read that if you try to call this code (the code you shared above) from a modal form, then it will not work. My login form is modal. When reading, it said that this can be overcome, but it did...

I could do this, but that means I would have to change the extension every time I wanted to make changes to the DB, correct? It would lock it down to a runtime version for everyone, right?

Sorry for the late reply. I was out of the office Friday. I tried to download your attached DB and it told me it was corrupted and would not open. I've seen the code you shared and tried it multiple times, and nothing seems to happen. I wonder what I'm doing wrong since it seems to work...

JHB, thanks for the reply. I've tried variations of that code, and I just tried the specific code you posted, but it doesn't work. Doesn't seem to do anything actually. The ribbon hide/unhide has always worked, but the code to hide/unhide the Navigation Pane doesn't work. I'm running...

Hi, I would like to disable the Navigation Pane completely, based on the security level of the user that logs in, of course. I have code that checks their level (I'm an "Admin" and everyone else is a "User"). If they are a user, then it hides the ribbon and minimizes the nav pane. If the...