Search results

Hello, I have set up a report with an OLE-object which is a MSGraph.Chart.8 . The chart data comes from a query to a table which data (statistics) is written new every time a user starts the report (in fact I run code for compiling the statistic data first and then per VBA open the report)...

Hi Pat, I've found these two posts interesting and one of them will be my solution I guess. Access security via workgroup http://www.access-programmers.co.uk/forums/showthread.php?t=4001 Registration process http://www.access-programmers.co.uk/forums/showthread.php?t=61171 Thank you for...

software registration procedure Thank you all for your comments. At the end I think it will be what Pat Hartman stated. Because all the above mentioned will not secure the db from being copied (file copy!), even so I understand that copyrighting would make it illegal (but who cares!). The db...

Hi, I've got written some code in Access, which now seems to interest people from other companies, but I'd like to sell it and don't know how I can prevent them from just copying my database. Any suggestions out there. Mary H.

Hi, you need to loop through the selected items and set an object var to the listbox. The code is like this: Private Sub cmdDeleteFile_Click() dim varElem as Variant dim lstCtl as Control Const conPath="c:\\FilesToBeDeleted" Set lstCtl = Me.lstFiles If lstCtl.ItemsSelected.Count < 1 then...

Hi, Set QtyBrk = Forms("YourFormName").Controls(sTempString) Hope this helps. Mary.h P.S. I would do it the other way round. Loop through the textboxes and assign the corresponding value from the recordset, like this: dim m_rsQtyDet as dao.recordset 'or ADO what you prefer dim QtyBrk as...

Hi, what I want to do is, that a person fills in in a table , i.e. form new members of a group named "Pool" and then this new members shall be dynamically set up as new users in my system.mdw I get an error message, wenn appending the new member, saying "Operation not valid". What is wrong...

Hi, you could try the following: Dim StrSQL as String StrSQL = "INSERT INTO GeneralInformationTableArchive " & _ "SELECT * FROM GeneralInformationTable " & _ "WHERE (((GeneralInformationTable.[ClientID])=" & Me.ClientID & "));" DoCmd.RunSQL StrSQL Me.ClientID = Me.ClientID + 1 Mary.h

Sorry sorry sorry Sorry to all who have given time to my question. It was all my fault. I doublechecked and indeed instead of defining strswitchboards as string, it was an integer. So much shame on me. I feel really bad. The guilty Mary.

Hi, 1. strSwitchboards is defined as string in the Declaration part of the module. But what I do is adding a number (me.SwitchboardID) to the string, as the string shall be the map of the menus the user has gone. So "123" stands for: started at SwitchboardID 1, then went to 2 and then to 3. But...

Hello, I am desperate, as this keeps me now for more then 3 hours. I run a switchboard which shows different items depending on the users login i.e. rights. That's why the "back"-Button cannot be fixed with one value for all users, but needs to be dynamic. Therefore I've written this code...

wow, it worked. My colleague has received them. Muchisimas Gracias. Mary.

hello fuzzygeek, would you please try it again with email OptoSys.CO@t-online.de Have many thanks. And sorry for all the huzzle. Best regards, Mary

Hi Pat, well that link to the microsoft website is correct, but I definately can't find where to download the sample files. So please email it to me mary.leagh@gmx.de (but my mailbox is only 5 MB - please send a zipped file) Thanks so much for your help. Regards, Mary

Thank you Rich, I tried DeveloperSolutions but had no success as well. So your offer to post a copy would be great. Again thanks in advance. Regards, Mary

Hello ALL, I am desperately looking for the solution9.mdb which should be downloadable at microsoft.com but isn't and it should be included in my office pack but isn't. Can anybody give me a link from which to download the file. Have many thanks for your help. Best regards. Mary

sorry that one prior was posted to early by error. code ... and so on... closing - of course the ifs and next loop. So my problem is how to refer to the datatype of the control. I am very greatful for any ideas. Thanks in advance. Mary

Hello, I am trying to rebuild the Query-by-Form menu function in order to have it working in a runtime version. I try to run through my controls-collection of the form and add all the user inputs to one filter criteria. In order to do that I have to check, whether the datatype of the control...

Hi Pat, thank you for your reply. Sounds as if this is exactly what I was looking for. - Grandioso! Mary.h

Hello, my users do only have the runtime licence of access2002 and this does not support the linked-table-manager (german: Tabellenverknüpfungsmanager). But my Admin-User must have this tool. Is there any way to solve this problem, without having to install the full access licence? Can I...