Recent content by mary.h

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