Recent content by stuartam

hi guys, i have this sql that filters 2 tables to give me the highest number against a record and then i want to update the 1st table. but it dosnt seam to work it brings back the correct data but the sql has generated a non-updatable query. any ideas? UPDATE [SELECT ARCtblErrorInfo.Uber...

thanks for the reply. the query works as its a make table query. i cant link the 2 tables because they are in workgrouped mdb's and the one that has the above code in isnt workgrouped. thanks

help, i have 2 database's in each is a table and i need to connect to both with a join and run some sql. i have the following that connects to each DB but i cant work out how to get it to run the sql. Dim dbe As PrivDBEngine Dim wrk As Workspace Dim dbs As Database Dim dbs2 As...

thanks for the "help"....

anyone? please

help, i have forgoten my workgroup password, can anyone recomend some free software that will allow me to recover the password. thanks

Help, i am trying to compact and repair a workgrouped DB from within anohter DB, but i cant work out how to do it, if the DB is just passworded ( using the set DB password ) it works using: DBEngine.CompactDatabase DBLoc & DBName, DBLoc & "BKUK\" & DBName, , , DBPass but this wont work if its...

Help, i have a set of databases ( containing back end data ) but its not workgrouped, so what i want to do is now workgroup them. i have created a blank database that is workgrouped and i want to create some code to copy each table from the un-workgrouped database to the new workgrouped...

copy the functions i have created into a new module and save then create this: public function createmymenu() call CreateMenu("MY Menu") call AddMenuMainItem("MY Menu", "msoControlPopup","&Form") call AddMenuMainItem("MY Menu", "msoControlPopup","&Settings") call AddMenuMainItem("MY Menu"...

thanks thanks it worked great. just have a new problems with combo boxes on menus in getting it to show the selected item in the onaction....

thanks for the reply, i will have a go with it later today. thanks again

have a look at this topic, you should be able to use the modules i have already written: http://www.access-programmers.co.uk/forums/showthread.php?t=122373

thanks for the reply, "&popup2" - is the popup menu on the main menu "&Batchs" - is the popup menu on the "&popup2" menu what i want is Main menu | | File menu Popup2 > batch bnt1 bnt1 btn1 bnt2 bnt2 btn2 hope that makes sence. thanks for the...

Thanks for the reply. the error is here: Set mycontrol = menubar.Controls(MainItemName) when this line of code is called: Call AddMenuSubItem("Main Menu1", "&Batchs", "msoControlButton", "cap", 0, "=docmd.openform('frmcap')") i corrected the mycontroll mistype ( thanks for spotting it ) i...

Can anyone help, i have written a "few" functions to allow me to create menus but when i try to add a button to a sub menu i get this error: any ideas, this has got me really stumped. thanks Function to create main menu bar Public Function CreateMenu(MenuName As String) Dim menubar As...