Search results

Hi VBAInet, thank you for your answer. I was afraid, that this is the only solution. But good to know, that I didn't overlook other ways. Best regards

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

Your concatenation looks ok to me. So I just had an idea on the length of the string. Probably you add such a long text, that the string variable can't hold it. Regards. Mary

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, note a view things. A string in sql must be set in quotation marks (simple ones ' not ") second Supply_Log.Date, i.e. strDateField was set in the first else clause als date rather than string. third dates must be set into #30/05/2009# this format. Hope this helps. Regards Mary.

Hi, note a view things. A string in sql must be set in quotation marks (simple ones ' not ") second Supply_Log.Date, i.e. strDateField was set in the first else clause als date rather than string. third dates must be set into #30/05/2009# this format. Hope this helps. Regards Mary.

Hi Kenin, Thanks for your prompt answer. I thought of that as well, but know I found a smarter solution. I had a filter set to the form so that it only showed one record at a time. I did that because I wanted the user to prevent record scrolling by mouse scrolling (what is the english word...

Hi gemma, I have exactly the behaviour you describe - an empty form (no controls) after deleting a record. Do you know how to prevent this. I have a form with a subform (customers (parent) and delivering addresses (subform)) and I delete a customer by clicking a command button which ist just...

Hi, it is a good way to establish relationships first. To do this, you must index the fields, that belong to the relationship. For example: Table T_Clients Field: ClientNumber (indexed) - I would use a number field as master field Field: ClientName Table T_Funds Field: FundNumber (indexed)...

Sorry I missed to tell you that the correct format is between #10/02/09# and #15/02/09

I try to explain it. In queries you can use the sum function. Create a number field in your table that holds how many cats belong to one record (NumberOfCats). Mainly this will be one. One cat filed = one record holding the start date and end date. Field1: sum(NumberOfCats) Field2: start date...

Thanks. I was afraid that Eval wont work. But it's good to know the point. Of course the array solution was in my mind too. Great and thanks. Its Mary.H

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

Thanks Hello ssmithri, thank you for letting me know. The solutions are quite what I've been (still!!!) looking for. Regards, Mary.h

Hi, I've managed a workaround, as the main problem wasn't probably the object handling, but the OLE object can't be changed in report preview mode. What I did was, change to design view and then close the object. I hided the action by using echo. Kind regards Mary.h My Code: Function...

Hi, I found a solution in this MS article. http://support.microsoft.com/default.aspx?scid=kb;en-us;287022 I just need to add the following line to my code: Me.OLEUngebunden0.Action = acOLEClose But their solution is based on a command button on a form. I have a menu button and just cant...

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

Thank you all for the help. 1. I will think about splitting the main table into two - one housing the plotting data (have just given it a minute thought - need to think over the whole thing) (thank you the_doc_man) 2. The Daten variant holds all the data for the statistics before it is written...

Thank you first for your replies. First (to KenHigg), there are currently about 10.000 records but people where just starting to put data in. So I need the same code work for a db size of 100.000 records. Second (to Mile-O-Phile): a) attached modCharts.bas which is the module in action...

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