Search results

I am wanting to learn and do it the simplest way, but If am a little confused. Since the Switchboard has an Exit button where do you put the button with the DoCmd.Quit code in its On Click event? Sorry for being so dense.

thanks Bob. Here is the procedure I finally came up with: Being a novice I could not understand what I was reading as advice on how to make changes neccessary to exit the Access 2010 software, not just the database, thru the Switchboard. So I finally came up with a procedure I hope will help...

Being a novice I could not understand what I was reading as advice on how to make changes neccessary to exit the Access 2010 software, not just the database, thru the Switchboard. So I finally came up with a procedure I hope will help folks: 1st = Create a Macro -click on Create at top of...

When I click on the Exit button on my Access 2010 Switchboard, it exits that DB, but leaves Access open. Is there a straightforward change I can make such that when I click on the Switchboard Exit button, I am taken out of Access? I have looked at a number of suggestions, but am unable to get...

table 2 only has the tables that have been rented out. only table 1 has all 50 apartments preloaded. Table 2 would have to be able communicate with table 1 that apartment x, space a or b has been rented. Then when a query is run against table1 it would look for the fields that are vacant and...

I have a two table Access 2010 database. The 1st table is preloaded with 80 apartments, space A and space B. This means that someone can rent apartment 50, space A & B or simply apartment 50, space A or apartment 50, space B. So I have a table that looks like: Apartment...

Access 2010, ver 14.0.6112.500 32 bit. It is a single table that has 3 query and 3 forms. I found I could finally open exclusive again by pointing to the DB and right clicking the mouse, then click on "Select". That brightened the OPEN button with the arrow. At least it is a work-around...

Now I have the problem in reverse. I can't simply highlight the table (db) I want to open in order to get the "Open" button to light up so that I can click on the arrow. Instead, I have to actually click on the db I want, then it asks for the password. Once opened I can't decrypt the db...

Yes. Ok, I see what I was doing wrong, I need to simply point the mouse to the table I want to open and not click on it. then the "Open" box is brightened and allows me to click on the down arrow to be able to select "Open Exclusive". The procedure never says not to actually click on the...

I have read the procedure for opening an Access 2010 table exclusively and seen what the Access Open screen is suppose to look like, but I don't have such a screen. When I clike on "OPEN" in the FILE column I get a regulare Windows Open screen which does not have the opportunity to choose "open...

I have an Access 2010 Table with a data entry form and two inquiry screens. I have to install these on a user's computer who also has Access 2010. The user needs for the Data Entry and two Query screens to be icons on his Desktop such that when he clicks on any of the three he sees only that...

I have a table with 15 fields. Using a form with corresponding 15 fields, assume I key into 10 of those fields the first time I enter data for a particular customer. Some time later (days, weeks, etc) I will need to key data into 2-3 of the empty fields for that particular customer. When I...

-Table A has a field that shows the "Niche" number that has been sold in a columbarium (a resting place for urns holding human ashes). In other words, who has purchased which niche. -Table B also has a field that will show the niche number that an urn has been placed in. So, the question...

-Access 2010 -I have created two Tables, A & B -Data is always entered into Table A first -both tables have Field X -when a value Y is entered into Field X of Table B, can VBA code be written that can check Table A to ensure value Y is present in that table's Field X? I am obviously a newby to...

Thank you for the reply. As you can see on the "access-diva.com/d9.html? " site you referred me to, the illustration shows all tables under the "Tables" section, and all forms under the "Forms" section. In my Access 2010 Navigation Panel I am only able to display 1 database with it's...

I have Access 2010 and on it's Database Window, which contains all the ribbons there is a Navigation Pane. At the top of that Pane it says "All Tables", but it never actually lists the 3 tables and related views I have developed. It only handles one table with related views at a time. How do I...

I was trying to change the call code in the "ON LOAD" event line for Access 2010 and did something that now will not let me do anything relative the module. I get the message "You do not have exclusive access to the database at this time. If you proceed to make changes, you may not be able to...

Thanks RODMC. i did what you suggested, but since I am new at ACCESS 2010 I am messing up elsewhere, I'm afraid. After I did as you suggested, I closed the form, then reopened, but got the following message: "Microsoft can not find the object called 'call fSetAccessWindow(1)'" Obviously, I...

RODMC I have entered the code into a module and also put the code in my form's ON Load field. The note also said to change the value to suite as above. At that point I got lost. Where do I change the value and is it literally to "suite"? thanks again for your help

hey, RODMC, hope you are right. thanks for the info. I will give it a try.