Search results

My database has a main contact form [Architects] with a Contact button, which, when clicked on opens up an [AIAContact] form. I can search the [AIAContact] form when it opens up in “standard” mode, for example the contact name, but I can’t search it when it opens in Pop Up mode. Any ideas...

I see that now, just didn't understand what you were saying earlier! thx for your help

I fixed it. Apparently, I moved the 2nd column in the form property sheet too far to the right which made it appear as if everything disappeared.

As I have investigated this issue further, it appears I can't change the properties on any query or a form. I have attached the property sheet for the form here. This leads me to believe, I turned something "off" somehow and I don't know how I did it or how to fix it.

database is too large

I tried your suggestion and it didn't change anything. The issue is I can't click in an of the fields under the "General" Tab and make a change in the Description/Format/Input Mask/Caption property fields.

I must have clicked on something to cause this but Suddenly, I can't change the property sheet values in any of my queries. As you can see from attached (.jpg), all the fields under "General" tab are empty, and yet, this particular column has the title "TSDQ-1" as it's column header. I want to...

Bingo! for some reason, under the Event tab/On Current there was an event process advising form to open up the offending query! I am not sure how it go there, but once I deleted it, I could open the form without the query opening. Same old story, garbage in, garbage out! lol Thank you very...

I have a button on the [frm_ASI] which runs the [qryASI-Quote-FU] when clicked. I copied and renamed [frm_ASI2], deleted the button which runs the [qryASI-Quote-FU], debugged the new form. I opened up [frm_ASI2] and the query still opened up with the form

Yes, both the form and query opened up.

Aha! thx Ran DoCmd.OpenForm "frm_ASI" and both the form and query opened up. Again, just for comparison I entered DoCmd.OpenForm "frm_Pawling" and only the Pawling form opened up

I have the database open per your request, and other than the ribbon, nothing but white space is staring back at me. sorry to be such a dunce, but where do I find the "Immediate Window" to type in the code?

thank you for the reply There isn't any underlying code for the form Here is the code behind the ASI button: Private Sub open_frm_ASI_2_Click() Dim stDocName As String Dim stLinkCriteria As String stDocName = "frm_ASI" stLinkCriteria = "[ID]=" & Me![ID] DoCmd.OpenForm...

This has never happened to me before. Top left corner of attached (.jpg) shows the (4) buttons which I created in an idential fashion on my main form. The only time the "issue" arises is when I click on the "ASI" Button...the other three buttons work properly. When I click on the ASI button...

Not sure if this is anything that can be fixed but it's kind of annoying when my database users are looking at records. I have attached a (.jpg) illustrating the issue. I have a Project quote system which aligns each quote for a project (In this Case JT #76925 is the Project number) Each quote...

thank you for your suggestion! Much appreciated

Here is the code I inserted for OnError Event for the Form. It worked but I have not idea why as I am not sure what "Case" means. thx for your help Private Sub Form_Error(DataErr As Integer, Response As Integer) Select Case DataErr Case 3314 MsgBox "By Whom...

I put the code into the OnError even field and when I compile the code I get an error msg "Compile error: Variable not defined" and it is highlighting "Cancel =" Any suggestions?

I put this code in the OnError event box and the result I get is the program advising that "Cancel" is not defined... Private Sub Form_Error(DataErr As Integer, Response As Integer) Dim JPGopher_ID As Control For Each JPGopher_ID In Me.Detail.Controls If...

Yes, I was using it at the suggestion of MajP because he sent me this link with a code to reference.... https://docs.microsoft.com/en-us/office/vba/api/access.form.beforeupdate(even)