Recent content by Weekleyba

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