Search results

To prevent the shift bypass copy the following code into a new module (naming it whatever you like). Option Explicit Function ChangeProperty(strPropName As String, _ varPropType As Variant, _ varPropValue As Variant) As Integer Dim dbs As...

How is that a problem? When a form is opened it is in form view. If you are concerned that unauthorized users will use it as a backdoor, you can can go to Access Options and disable the menus, make sure to display your switchboard form on open. This way your users cannot get into the design...

Here is an enhanced version, which prompts for the password using a masked inputbox, if the password is wrong the inputbox will prompt the user for the password until the right password is provided, clicking on cancel will shutdown the db.

I've successfully used that before, if you post a sample of your db I'll take a look.

There are multiple solutions, depending upon how robust your solution must be. For a simple (and not so secure) way of doing it you would do the following: Private Sub cmdEditMenu_Click() Dim strDocName As String Dim strLinkCriteria As String Dim strPassWord strPassWord =...

cplmckenzi, Thanks again for the personalized attention you are giving my question. I only put the Guarantor SSN in the tblAccountsso in can be linked but I see you have a better idea, so be it. moishy

cplmckenzie, First of all I apologize for the late response, I was busy putting out life's little fires all week. I can't believe the effort and time you are putting into helping me, may you be an example to others of kindness and devotion. Generally, it all seems good, except for the...

cplmckenzie, Thanks for your help. I've given considerable thought to the the assignment you gave me. I'm still not clear on what kind of data would be in the following tables: tblAccountHolder tblTransactionType Attached You will find a sample db, with my progress (I hope!) so far. There...

Is it not better to use one table for all contact information, and have three y/n columns (Guarantor, Borrower, Depositor)?

cplmckenzie, Yes, that is what I had in mind for the transaction types, is there a better way to setup that part? And, yes, the Guarantor is a CoSigner. I thought to use the tblContact to store their details, and transaction type would be Guarantor (CoSigner).

All the above, if possible. I miss the old macro location, although I do understand that the new macro system is a lot more powerful.

Is there a way or tool to extract all macros from a 2010 accdb file?

Pat, Thanks for your willingness to help. I'm not very good with words so instead of trying to describe the structure of the tables I have so far (which most probably is doomed to failure) I'll post the relevant mdb. I'm aware the many people are hesitant to trust files from unknown sources, I...

Hi folks, I'm trying to put together a db that can keep track of what happens in our free loan foundation. There are depositors and borrowers (at times the same person may be both) most loans are given in monthly installments. I'm not sure of the table structure necessary to allow multiple...

stopher, Thank you very much is does the job. The only problem is that if any records are empty (no amount for id) that whole line is full of #error

Hello all Experts, I've inherited a .mdb with hundreds of thousands of records the problem is that there is no structure to the tables. The issue I'm dealing with now is the following: The table includes 5 columns, ID, Month1, Amount1, Month2, Amount2. The problem is that each one of the Month...

Thank you, the trouble is I'm dizzy from reading so many tuts. and yet accomplish nothing.

Hello Experts, I have a form that uses two cascading combo boxes (cboCity and CboStreet) to filter records in a subform. The code I use for that is: Private Sub cboCity_AfterUpdate() sfrmDonorInput.Form.Filter = "[City]= '" & cboCity & "'" sfrmDonorInput.Form.FilterOn = True...

Sorry for the late response, the issue I was having was no issue at all only a silly mistake of mine. I had set the Auto Resize property of the form to No and re-sized the form by a click on each page setting the Inside Height and Width. I thought that the click event was only for the 'tab' not...

Hello all Experts, Is it possible to disable automatic Tab resize on double clicking?