Search results

Hi all, I want the switchboard being prevented from any attempt to print it out. Assume that the switchboard has the focus and the user presses the print command button on the Access-Menu, than the it should just do nothing. Currently the form view is switched to print preview and the user can...

Hi, I use Lebans calendar since lately and love it. But know I want to use them on a form with several subforms and that is not working. My situation. I have a parent form with a tabcontrol. Each page of the tabcontrol is showing a subform (except the first which has textbox controls to enter...

Hi all, does someone know if it were possible to use the Eval function to do following, and if so - how to do it. Cause I am failed. Thing is I store strings in 7 different variables. They are named strValue1 strValue2 strValue3 ... strValue7 And for a specific output I want to join this...

Hello, with this little code, I am exporting a chart from a report to a gif-file. The code does not give any error, but after exporting the chart, when I am going to close the active report window the following error message appears and I can't close my application any more. Errormessage: "The...

Hi, I've built a database in Access with frontend and backend db where all users have the frontend on their PC and accessing data which is hosted in the backend on a server computer. The database task is to generate statistics as charts. That I've realized as reports with an OLE.Graph object...

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, 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, 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...

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...

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

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...

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...

Hello, I've a database compiling statistical Data which will then be displayed in a diagramm, which is a OLEunbound object in a report. My code works fine in Access2000 but gives an Error in Access2002 when processing following line: DoCmd.OpenReport stDocName, acPreview Has anybody an idea...

Hello, I want to hide (change to asterisc) what a user types into a textbox in a form. The form asks for a login and password. And as usual the password shall not appear in real letters but as *****. Please can someone help here. It doesn't seem to complicated first to me, but I can't think of...