Search results

:)

theDBguy - Yes. I have code to disable to close button. I will now punish myself for my stupidity.

I have an Access 2016 accdb database that refuses to close when I click the X in the upper right corner. It will minimize when I click the minus sign but will not close when I click the X. I tried a Compact/Repair but no luck. I have to either end the task through Task Manager or right click the...

Yes. Thank you Gemma!

Definitely interesting. Thank you jdraw!

Thank you to all for your help! I decided to use a label and make it visible from the On Open event of Form2. It seems that controls obey the proper sequence of events. Message boxes - not so much!

Interesting. Microsoft docs contradict that (Regarding On Current, On Activate and On Got Focus). Thanks for the tip about the timer. I'll either use that or a label to display my message.

I have Form1 and Form2. If a user is on Form1 and they click a command button to bring them to Form2 I want a message box to appear in certain circumstances. I tried putting the message box in the On Open, On Load, On Current, On Activate and On Got Focus events of Form2. In every instance the...

Yes. As you can see, it has duplicate entries.

Is anyone aware of a diagnostic tool that can be used to trace activity and help determine what's causing the corruption in MS databases? I remember using two tools many years ago to trace an issue with SqlServer.

Hi Doc_Man - It's definitely corruption. That's how I'm alerted to the problem. The users can no longer use the application. The question is: did the fact that the primary key allow dupes create the corruption - Or did the corruption cause the dupes? Either way it's a problem - and it's...

Hello All, I have a program in which users create progress notes for clients with disabilities. When they begin writing a new note a Note_Id is assigned to it. This along with the client’s basic infoformation is then appended to a table called tbl_BasicInfo. Also, for each new note, five goals...

moke123 - My code is not only to requery listboxes but your code is very elegant and helpful. Thanks!

Thank you all very much for taking time with this. cheekybuddha's example above (via DBguy) definitely should have worked. Unfortunately it didn't along with everything else I've tried. It seems Access cannot recognize a variable used in this way. I will follow Pat's advise and take a completely...

Globals.glb_CurrentForm = "Forms(" & Globals.glb_CurrentForm & ")" I removed the bang, included "Forms" in my variable and enclosed it with parentheses. Now I get the error below. Not sure how to qualify lst_Tasks.Requery. I tried the bang and a period in my variable but no luck. It errors out...

Thanks DBguy. Unfortunately, that didn't work. I tried: Forms!(Globals).glb_CurrentForm!lst_Tasks.Requery Forms!(Globals.glb_CurrentForm)!lst_Tasks.Requery and now I get this error:

I'm trying to use a global variable to hold the name of a form. It works great and returns the correct form name but I get the error below when referencing it from within the form collection. Does anyone know why? 'On Open event of frm_X Dim frmCurrentForm As Form Set frmCurrentForm =...

Why do Brits say "In six week's time" instead of "In six weeks"? We know you're talking about time!!

CJLondon: Sorry. I didn't answer your first question. I grab the transaction ID (which is a unique primary key of another table) and insert that into this table.

MajP: Yes, the table is corrupt. That's why a CR works. But I've rebuilt the table several times from scratch by exporting the data to a text file, creating an entirely new blank table and importing the data back in. The table then becomes clean. But a few days later the same thing happens. So...