Search results for query: *

Duane, thanks for your help, this works. Im very surprised to hear though that there's no property to change this setting. Thanks again. Reinier

Hi All, To ask this question feels like I'm a real dumbo, but I just can't find a solution for the following: What is the equivalent setting of "continuous forms" for a report? Having a report in column form, that is 1 record per page, I would like to change it into a tabular form, that is...

Thanks for the reply Harley. Hmm, I see my question was not clear. What I meant was that I would like to skip the whole classmodule behind the form (property hasmodule=false) and only use a module level function. Reason is that this way improves maintainability and speed. This solution works...

I stumbled upon this when I was looking for a way to use a module level function trigerred by the before update event that I would like to return a value (cancel =true or false). Is there a way to accomplish this?

Hi Skipvought, thanx for your reply. Of course I meant to say I defined the range to refer to the series, so that was not the problem. What I see now is that you use the sheetname in the reference to the named range. I totally forgot that! Adding the sheetname solved the problem, so thanx for...

Hi, I need some help with the following problem: I have some tables in Excel that are updated monthly. The data is plotted in charts, which I know can be made dynamic to capture the new data every month. To create the dynamic chart I've created a dynamic range using an offset formula...

Hi Bob, Nice that I could help. About closing the workbook: you can actually close it silent by : oWb.close, false (try the help on the close method for more info) Do not forget to clean up properly: set oSh=nothing Set oWB = nothing Set oXl = nothing In the order from "child" to "parent"...

Hi Bob, Yes this can be done through automaton using OLE. See the following article on how to create an excel object: http://word.mvps.org/FAQs/InterDev/EarlyvsLateBinding.htm Then look into the excel object library on how to manipulate the formatting of cell-ranges. I'll type some pseudo...

Thank you all for your replies, they cleared up the things I didn't grasp completely. Yes , (of course) we have access to the local harddrive, but only the mydocuments folder. We also have a HOME drive, I think that is the best place for the FE then. For maintainance I think of a central...

Hi again , i guess the PHV solution worked already. Selecting a particular interval can be done bu something like: SELECT Sum(Table.Amount) AS TotalAmount FROM [Table] WHERE Table.Date Between [Startdate] And [Enddate]; for the total amount in the interval. To add the total amount per ordernr...

Hi, Just had a quick read of the question, but try replacing the format(date) statements in the sql PHV posted with datepart("m";[date]), as mMonth, datepart("yyyy";[date]) as mYear Will try this myself right now.

Hi, At work we're running an acces db that I developed and have to maintain now, with approximately 30 users. Actually it's working quite alright for a month now, but I'm still bothered with the installation for each user and a nobody when it comes to system/hardware configuration. The problem...

Hi, I've setup a db in Access 2000 in which about 15 persons should work. After testing it thouroughly I split the db into a front and a backend. Both reside on the server (according to the IT department this should work. After a while a new user opening the frontend get's the message that...

Hi Kysterathome, From what I understand you need the subform's controls (sbfrmAttendees) to be set to the values of the listbox on your search form? I'm not sure what you mean, since in the code the COntactsform is opend. Above you wrote you got the part of filling the listbox, so I think you...

Ok correct, but it isn't exactly what I had in mind, which is because (probably due to need of sleep) I didn't post the question right. Suppose the user closes the form instance. Is it in that case enough to clean up the form object from the form's on close event? so something like [code] some...

Hi, If I would like to open a new instance of a from, I would something like: set frm = new form_MyFrom frm.visible=true and closing/cleaning up later on with set frm=nothing. If I would like to trigger the opening of the new instance from another form, how can I make sure the object is...

Hi XLBO, Thanx, it worked and I'm feeling really dumb now :)

Hi, My problem is an awkward one: after opening the excel workbook I am always using I discovered that columns A and B are invisible. Tried to unhide them of course, but no result. Tried applying the standardwidth, but also no result. The most awkward thing is that selecting cells in these...

Thanx for getting me started on this one, I'll post it when I have produced something usefull from this.

I need help with the following: Using Access 2002 it is possible to link an outlook contacts folder (currently using xp version). Using the menu file, import, linked table and altering the file type to Outlook() an easy wizard is started. Is it possible to launch the wizard from code, or...