Can I Set Tools/Options/Edit-Find/Confirm In VBA?
Jun 9, 2006
Hi Guys & Gals,
I have a report that runs a number of queries via a macro in the on open property. These queries populate a table used in the report. The on close property runs a query to clear the table contents.
When a user ran this, he had a flurry of warning notices which I tracked down to the Confirm settings in the tools/options/edit find tab.
Is is possible to set these using vba?
I guess that this could be achieved using send keys, but this would probably be a bit clumsy - to say the least.
Can it be done so that the settings are changed only for the current session so that users have the original settings?
Any thoughts welcome.
Regards,
Keith.
View Replies
ADVERTISEMENT
Dec 17, 2004
I wanted a Switchboard page in Access to open automatically when the database was opened. I've done that but, as I did it, while in the Tools/Startup to set Display Form Page (in this case a switchboard page but it's not opening full screen and I ow have no way of editing anything), I stupidly de-selected the options there...
Display database window, Display status bar, Allow built in tool bars allow toolbar/menu changes.
Now I have lost the tools Menu, the View Menu and others (where one sees, File, View etc at the top of the window) and I can't work out how to get them out. I can no longer view my Access pages in Design View so I can't amend the any pages.
Can anyone tell me how to get my View and Tools menus back on my Access app window?? It's a bit of an emergency... been up all night and have to hand this in as coursework at uni in about 3 hours and I've screwed up right at the end and can't do the last couple of things before putting it on a CD for my tutor to mark.
Help!
I'd also like to know how to get it to open the first form at full screen.
Thanks.
Ceri
View 1 Replies
View Related
Sep 12, 2005
Can someone point me in the right direction?
I have added a popup menu to my form to reduce the number of buttons needed. I would some of the options only available in the add or edit mode. Because its not a traditional button i dont think conditional formatting applies. Can someone give me a hint where I should be heading?
View 1 Replies
View Related
Jan 19, 2006
I'm building a database with supplier information. Some users prefer to use the supplier names, but it is sometimes hard know how foreign suppliers are spelled, therefore some users prefer to use supplier numbers.
I want my form to show all supplier data based on either the supplier number or the supplier name, which can both be chosen from 2 comboboxes.
In addition, and here's the catch, I would also like the two comboboxes to update eachother. So if I choose supplier 2 in the first box, the other box should automatically show me the name of vendor 2 and vice versa.
I think the example form shows my problem best ..
View 4 Replies
View Related
Mar 10, 2007
I have designed a data entry form in MS Access 2003. One function I find frustrating is when I want to find a particular record while using this entry form. If I use the Edit>Find facility, for instance, looking for someone with the last name "Jones", eg, I must page through all the Joneses in the database by using either the "Next" button or by pressing the "Enter" key. This works but if I pass by the Jones I am looking for, I have to go all the way back to the first record and then slowly repeat the above process to find the Jones record I was looking for in the first place.
I am wondering if there is some VBA code somewhere that would pop up a table, for example, of all the Jones records in my database. Then I could simply click on the Jones' record of interest in this pop up table and go directly to this record in my data entry form.
Thanks in advance for any help you can give me.
View 1 Replies
View Related
Aug 4, 2005
I was just editing my Access database (stored on the intranet) when a message popped up saying "Disk or network error".
I clicked the only option ("ok") and closed the DB. When I reopened it, it said someone else was viewing it and I only had read permissions. I close it again, and see that in the directory where my .mdb file is stored I have the .ldb file remaining even though it isn't open.
I restart my machine, and try and open it again. I have to compact and repair the DB at Access' suggestion, yet now I only seem to have limited functionality....??
I.e. there is no Tools menu, I can't right click on forms or tables to choose Design View (although if I highlight them in the database pane and click the BUTTON for Design View I am able to proceed)....
What's going on?!!
I've tried going to File > Open and in the little arrow on the Open button choosing "Open Exclusive", but it opens and does the same thing as above...!!
I've checked a different database in Access, and I don't seem to have gone potty, in every other one I'm able to see the Tools menu, etc...?
Anyone got any clues as to how I can get my lovely database back on its feet and functioning properly? :confused: :eek: :rolleyes: :mad:
View 5 Replies
View Related
Aug 15, 2005
hi there...
where can i find free access developer tools? please help..
thanks
View 4 Replies
View Related
Mar 22, 2008
Hello All,
I have made a critical error with my system, in tools on startup i unticked all the boxes, and now when it loads it brings up the system only and not the design view tables etc,
Is there anyway that this can be undone??????
View 14 Replies
View Related
Apr 13, 2007
*Can anyone tell me if or how to reffer to the options from Tools-->Startup in VBA code? I`m asking that because i want to open a database in different ways
taking in account the logged user.
*And another question: in access 2000 is possible to make .mde files? Because the option is dissabled in tools--> database utilities menu.
Many thanks,
bogdan
View 2 Replies
View Related
Aug 2, 2007
Hello,
I created a database, and was trying to get the welcome form, to load full screen. So I unchecked all Menu bar and Shortcut bar (allow)
So I now have locked my self out.
Any ideas, I once remember something like ctrl while opening the database, but that does not fix it.
Thanks,
Ranger
View 3 Replies
View Related
Mar 8, 2008
Although I have been using access for a year or two (self taught) I have only recently noticed that the form toolbox (the one with combo boxes and buttons etc on it) appears to have a library of procedure calls for calendars and all sorts of things sitting there waiting to be used. Is there a list somewhere of what all this lot does? I have been playing with a couple of date pickers but I don't particularly want to go through all of the rest to see what they do or if they would be useful.
Thanks
View 2 Replies
View Related
May 31, 2006
Could someone please give me a link or place to find a descreption of all the "More Tools" that you can use when building a form. If I had a list I could pick what is best for my database and explain things better to management...thanks.
View 3 Replies
View Related
Aug 29, 2007
Hello,
I've read most of the General category on Toolbars and Startup Menus, but still can't figure this out. I have no VIEW or TOOLS on my toolbar, so I can't get to the startup menu, toolbars, or anything else. When I go to Customize, one option is Built-in Menus. When I try to drag the VIEW or the TOOLS to the menu bar, it won't happen. I have tried the Shift trick, but it did not work either. Can someone help me?
View 1 Replies
View Related
Sep 7, 2013
I am building a tool rental data base.I have places a delete button on my Transfer form so the operator can erase any mistake that he/she just made on a Transfer ticket.When I push the button I get an error message saying that I can't delete the record because it is associated with 2 tables. I have one table the tracks the transfer and another that tracks the tools associated with the transfer.How can I delete the transfer and the associated tools records?
View 2 Replies
View Related
Jul 21, 2005
hi,
can any i tell me how to create a form or a simple messege to show the user, whe click to close the db???
for eg, show a messege like " Are you sure you want exit" Yes for Exit and No for carryon.
thanx
View 2 Replies
View Related
Aug 29, 2005
I have a bug in Access. Despite having turned off the confirm record changes (Tools>options>edit>Confirm) the prompt still appears in the app after it is converted to MDE and packaged for distribution.
My solution will be (if I can find it) to set the 'confirm record changes' setting to off in VBA code immediately prior to my update.
My problem is how to do it. I have looked everywhere without success.
Can anyone suggest the necessary code.
Thanks .
View 1 Replies
View Related
Jan 17, 2015
I want to hide external data and databasetools tabs only from my access program. How i do it ?
View 3 Replies
View Related
Jun 14, 2007
I am automating a mail merge with Access to Word. Does anyone know how to stop the Confirm Data Source dialog window from coming up and just except the default (orginal) data source? I have users that do not know they should just click the OK button, some are clicking NO and then I lose the connection because they dont know where the table link is. I dont know what else to do but tell them to always click the Yes button when confirming but not everone listens and then i have to do it all over again.:mad:
View 2 Replies
View Related
Apr 3, 2006
I have "unchecked" all the confirm options under tools, but when I run the make table query it still displays "The existing table will be deleted before you run the query, do you wish to contiue? I would like it to just run without this message, or at least give a message of my choosing. Is this possible?
Thanks!
View 3 Replies
View Related
Apr 2, 2005
I would like to have an update (requery) button on my form, that when clicked opens a message box that asks "ARE YOU SURE YOU WANT TO UPDATE?", if yes, a yes button is pushed, which requeries the record and closes the message box. If a no button is pushed, the message box is closed without requerying the record.
Can someone walk me through the process?
View 4 Replies
View Related
Nov 29, 2004
I already turned off all the checkboxes for running query confirmation (in the tool/option/Edit&find) but the users of my database still receive the pop-ups every time they run the queries. How can I fix this problem? (My database is for multiple-user environment.)
Thanks in advance,
View 1 Replies
View Related
Jan 17, 2015
i want to hide external data and databasetools tabs from my access program.
how i do it ?
View 3 Replies
View Related
Jan 8, 2014
I have created a simple login form that is based on User Name and Password.the table contains UserName, First Name, Last Name, Password and User Role(dev, admin...ect.)How can I change who can access different parts of the database?I want all the Development tools only accessable to People who have "dev" as a "User Role".Admin can only access the forms related to data entry and managers can view all forms but not the tables, querie and tools...ect.
View 3 Replies
View Related
Mar 3, 2008
I use the Access 2007 runtime to run my Access database on a few client machines. How do I turn off the confirmation of Action Queries? On clients that are also running MS Access, I can simply open Access, go to Access Options and uncheck the box. When I make this change in Access, the same settings apply for the Runtime on that computer. Which makes me think perhaps there is a registry entry I can modify someplace? If anyone has an idea as to how to turn this off for the runtime please let me know.
Thanks!
View 3 Replies
View Related
Nov 10, 2006
I have a small procedure I'd like to include in my database. I want to confirm with the user with some sort of modal popup message (I think that's the right term) when they abort data entry on a form (anywhere on that form which consists of several pages, and a linked subform on one page). I think I can use the "on undo" event, but I don't know what code to include to make this happen...
Tried searching for this to no avail, but I would think this is a common procedure to prevent users from accidental data entry abortion.
Thanks,
Brad
View 4 Replies
View Related
Jul 15, 2014
I have a Multi user Access Database which has been split into a Front and Back end. What I am noticing is sometimes when the user enters data into the Front end form, it is not being saved in the Backend tables....
How to confirm when the user clicks save that the data is actually being saved in the backend tables.
View 10 Replies
View Related
