Search results

This is all very helpful. I'm playing around with it now and I will land on good solution. Thank you all!!

I'm trying to lock down my database after a user went in and changed some table records. :mad: My database is split. The Back End is encrypted with a password. The Front End opens to the Main form. All forms are not able to go to Design View. Also, the FE has the Navigation Pane and the Use...

I'd like to have the ability to delete records in a split database. How can this be accomplished given that the database has forms with subforms and subforms with subforms?

Evening Pat. I apologize if I have insulted you by asking the forum if there’s another way to accomplish this. Your help with what I had was great, but I know there are other experts, like yourself, on this forum that sometimes have solutions that others don’t think about. I’m just surprised...

Isn't this a common desire? A form with records in descending order, with command buttons to go next and previous? I would think it would be, so I'm surprised it's not easier to set up. I have a database for projects that has subforms (on tabs) that will use this type of form set up for: 1...

Thanks Pat. I did swap the previous/next back to how I had it, and turned off the navigation at the bottom of the form. I want to this to make sense to the user, so when they click the Previous button, it goes to the previous update. And yes, this does get confusing on the developer end...

I've tried a bunch of different things and I'm close to what I want but still no sure this even close to the best way of doing this. I have several forms that will use this set up so I'm trying to develop a solid standard for it. Attached is a sample of what I have so far. A form that show...

Recall this is a subform that I'm talking about here. Namely, SF_Update. The link between the F_Project and SF_Update is the ProjectID. But this has nothing to do with problem. It could be any form. The update number is only for the knowledge of how many updates have been provided. I have...

That is true, but in this case, since it is in descending order the next record is the previous one. Example: Say you are on record 12. You click next record, it goes to record 11 and not 13. Do you see what I'm trying to convey? When you get to the last record and click next record, it does...

To clarify, the subform SF_Update, has table T_Update as it's record source. The fields are all part of each record in the table. See below. The table has 1,573 records.

When placing command buttons in a form to navigate to the previous or next record, is it best to use the embedded command buttons for the 'go to next' or 'go to previous', when you want the records to appear in descending order? The reason I ask is, they behave as they should, but to the user...

If others are new to Error Handling as I am, check out this short video by Richard Rost. https://599cd.com/blog/display-article.asp?ID=2401

I decided to close the form, via VBA, where the Email command button resides. (F_PANumRequest) This seems to work. If someone else sees a better solution around this problem, let me know. Private Sub cmdbuttonEMAIL_Click()...

Frustrating for sure.... If I close the from with the command button and reopen and click the Email button, it will continue to work. It appears I need to some how refresh the form or something like that.

Perhaps I spoke to soon.... I tested this over and over with no trouble and now... the error message pops up again. To cause the error, you have to cancel the email form, ie. not send it, twice in a row, without closing the form that the Email command button is on. So why doesn't it work the...

When the user clicks the Email command button, it opens the Outlook email form and stays open for the user to decide who they would like to send the email to. That's way no To, CC, BCC. See below. It doesn't send it out right away but rather displays it first. I have not learned much about...

Just coming back around to this. This is nice. I was looking for background change, but this would work for the font change in color. Thanks Pat.

I managed to make it work, although I'm confused on exactly how the error handling works. Here's my solution. Please chime in on: 1. How this error handling steps through this? 2. Is this is a solid solution? Note the error 2501 only happens when you cancel the email from the Outlook dialog...

I’d have to research that but would the work for a split db? Currently the FE is on each of the users PCs. I’d have to be sure that each PC could store it in the exact location, right?

I have a form with a command button to email a report. The criteria for the report is based on the ProjectID on the form that has the email button. This may be all wrong but it is what I've come up with so far. See code below for the command button. Initially I had a problem with error code...