Search results

Thanks for the solution. Here's what I put in the On No Data event of the report. Private Sub Report_NoData(Cancel As Integer) 'If no data in the query, just gives message box. MsgBox "No records to display." Cancel = True End Sub

I have a report that opens in acViewReport from a command button on a form. When the report shows no data from the underlying query, I want the text "NO DATA" to appear. Currently I have a label showing "NO DATA" with the Visible property set to No. In the report's On Current event, I put the...

Thanks MajP! It worked out great for what I am trying to accomplish.

I have a query that I'd like to count the number of records. Seems easy enough but, I only want the number of records where the FYID is equal to what I have on the open form Main_F. I'm close, but not there yet. Can someone lend a hand?

Thanks to all! Here's my solution that I can not put in every subform to check if the parent form has a ProjectID already created.

Maj P, I'm getting this error. Not sure what I'm doing wrong here.

How would you set this module up to check for the parent form creation of the ProjectID, (which is the primary key of the parent form)? I have eight subforms where I want to use this. Maybe I just need to place the code in all eight, since the Me.Undo is going to change also? Thoughts? It...

That worked ebs17. Thank you.

That is correct. The engineer we submit a PA Request that is generated from the F_PANumRequest form only once.

I have a form with some project data on it called F_Project. I want a command button on that form, to open a new form call F_PANumRequest. I only want one record on this new form and the ability to open it again and see what the request is. The F_Project has a record source of T_Project with...

Thanks Doc Man. You are correct, I need to normalize this table. This brings me to another problem that I'll post separately.

Thanks Pat the parallel relationship explains it.

How do I explain why this query is not updatable?

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