Search results

Yes, that's what I was definitely trying to do. But all that code didn't work so I took it out as I was getting confused going back and forth. So form one (frmQuickDESelect) has the buttons that open form two (frmQuickDE) and filter the record selection. If there are no records to pull for...

This is the form code for the first form that contains the buttons (frmQuickDESelect). I've removed all of the test code for cmdMtAiry_Click(): Option Compare Database Private Sub cmdDunedin_Click() DoCmd.OpenForm "frmQuickDE", , , "QuickDEGroup = 'Dunedin'" End Sub Private Sub...

No it is not. None of my forms are pop ups.

On the second form, I have DoCmd.Maximize on the On Load, On Got Focus, On Close and On Activate events. On the first form, I have a total of seven buttons that call the second form, filling in the query "qryFrmQuickDE" with the location "QuickDEGroup = '[location]'. For example, the Mt. Airy...

My apologies. I forgot I still had this code on the second form's On Open event: DoCmd.Maximize If Me.Recordset.RecordCount = 0 Then DoCmd.Close acQuery, "qryFrmQuickDE" MsgBox "No records found" End If When I take out all but the DoCmd.Maximize on that form AND...

That code no longer gives me an error, but it still opens the form and leaves the form open. Again, this is not what I was hoping to achieve, but it works. So I guess I'll stick with this. Thank you again.

When I try to just count the records, the second form opens (no VB error), the msgbox appears and the second form stays open. Here is the code: Private Sub cmdMtAiry_Click() If DCount("RezName", "qryFrmQuickDE") = 0 Then MsgBox "No Records Found" Else: DoCmd.OpenForm "frmQuickDE", , ...

I've tried all of these with no success. Is it because the code is on the form button but is referencing the query before it has run? I keep getting an error that it doesn't understand/can't find my fields.

Might you have an example of how to use dlookup? I don't know that I've used it before. Would that code go on the first form's button or still on the second form's OnOpen or OnLoad event?

My goal was to tell the user there were no records and not have the user see the empty second form when there were no records. This opens the second (empty) form when there are no records and tells them there are no records PLUS it maximizes the first form when they exit. I guess this is a...

I got that code from another post. When I change the code to what you suggested, it is worse. The second form opens and stays open with the message box on top. I added the extra DoCmd.Close back in and the second form now closes, but the first form still does not maximize.

I figured out what you mean by pop up -- Pop Up is set to NO in the properties of the form that will not maximize.

I don't know what you mean by pop up. The forms work like this in my database: There is a main menu form, with buttons that open other forms. One of the buttons on the main menu opens my form that will not maximize.

I have buttons on a form that run a query to filter the records and then open another form to display the records. I just added the following code on the second form to show a "No Records Found" message when the query returns no records: Private Sub Form_Load() If Me.Recordset.RecordCount = 0...

I found this on the internet, Bob's Free Access Tools: http://www.btabdevelopment.com/ts/freetools

Thanks again!

Thanks, I just figured out the problem with the Ribbon showing again. The database splitter had the USysRibbons table in the back end. I unlinked that and turned it on in the front end and now it works like a charm, my ribbons are being used. :-)

Thanks for butting in! :-) I appreciate everyone's assistance, it is most helpful. One more question ... I lock down my Access databases, turning off the Ribbon and making my own "blank" ribbon for forms and "report" ribbon for reports. When I split the database, now the ribbon is again...

We are going to try to implement the front end/back end, all in Access. In doing this, where is the best place on a Win7 PC to put the front end database file? Our "My Documents" folder is remapped to a network drive, so that is out. Should it go in C:\Users\[username]\... somewhere or should...

Pat, do you have more information on the tools to distribute FEs? Never having done this before (and having written many, many databases that do not have problems) I am clueless. And also could you elaborate on these two comments: There are two reasons to upsize to SQL Server. 1. More...