Search results

Thanks guys. The issue is fighting for printers so I thought about flagging. Esle just let the spooler handle it Sent from my HTC_PN071 using Tapatalk

Hi Peers I have been using a table in a BackEnd .mdb to flag the state of certain transactions in a multi user environment. This means that if the state flagged is true, user have to wait until flag change to false before his request can be processed. I am now thinking dropping this table and...

Thanks guys 🌼😄 Sent from my HTC_PN071 using Tapatalk

Hi Hi I can check in the all forms collection whether myform is loaded or not as follows: CurrentProject.AllForms("myform).IsLoaded Now i want to know if myform is set to visible or not, can i use the following msgbox form_myform.visible = true If not how? :)

😄😂 for the care Sent from my HTC_PN071 using Tapatalk

😍 to my peers Sent from my HTC_PN071 using Tapatalk

Closing recordset is already my constant lookout Sent from my HTC_PN071 using Tapatalk

Pb why do you say I should not be using Dlookup extensively, what is the alternative Sent from my HTC_PN071 using Tapatalk

Lighting Thunder thank you for the tip bits Sent from my HTC_PN071 using Tapatalk

Hi there For some unknown reasons there is another instance of msAccess.03 running which is elusive from the Application tab of the Task Manager. This will be visible in the Processes tab of the same. What can be the cause of this 2nd instance? Is there codes i can use to clean all instances...

Hi guys I was just reading DCrake's 10 commandments and saw the taboo of using LookUp fields; i presume it is has nothing to do with DLookUp which i use extensively to look up a (one) value from a table; is this not ok?

RanMan Thanks it give me good ideas

Hi cloud guys In the Front End i would like to stop for a moment, other users accessing to the common BackEnd, so that i can do some File System Chores on the BE eg compact. I need a denied access on to the whole BE .mdb during the process eg in compacting. I will start this process only when...

My guides I have exhausted finding the cause of 1 pc that require the log off. I have Doc's set tdf = nothing in my script immediately after appending the table. Moreover i ever delete all the table links when i exit the FE. I am sure it is not some unclosed recordset or form.recordset, as...

Doc i replied some time ago that i need to digest the above & is still trying to fix looking at all angles including yours. Thanks for the time being for the care to teach. Meanwhile what fox me is the "before or after" does not give any problem except in one pc. I will certainly look at the...

Hi gurus I did a test wherein the Front mdb does not use any DAO or ADODB recordset. It is a simple form with recordsource to a linked table from the BackEnd \\MainDat. If the link table is already within the front .mdb, any changes from the form to the linked table will not cause the...

Doc just found that Debug.Print CurrentDB.Recordsets.Count will not show an opened adodb.recordset, while the .ldb will, did i get you wrong?

Thanks thanks guys next week I may have something to report as I am already setting up a test with a simple front.. Because I already found a file being denied access that have nothing to do with MS Access Sent from my HTC_PN071 using Tapatalk

Good guys, from your repeated careful explaination i do trust the experts on these 1 OS can't be the culprit. 2 No .ldb in the folder or no msaccess running does not rule out JET is still left with a 'ghost' instance of Access caused by my codes. If my reading of what you say is correct, then...

Doc, there is no hidden form as msaccess is not running at all. It has to be a file system issue as it does not allow anything to do with the .mdb (only the particular one & not all). At times a log off don't work, i need to do a shut down. Also a chkdsk on the drive holding the mdb shows...