Search results

Re-reading my threar it just dawned on me that on page 2 the created pivot table is based upon the one of page 1. So maybe I had to refresh twice for the second table to react on the first. And Yes Bingo it worked. Still would be interested to be able to get a better solution in code. Just...

Hi, ever run into this problem/challenge? I create some tables in Access, all kind of good calculations etc. Then I link the outcome tables in an excel sheet over differnt pages in differnt pivot tables. From the program I give a refresh as follows. Where I supply the exact location of the...

Thanks for your excellent suggestions. :D I'm done! here is my rough result for the people interested. table 1 is the tick table first column needs to be called name the other columns can be any name. table 2 is the result table column 1 needs to be called name column 2 to needs to be...

I know stuf like For Each fld In rst.Fields Debug.Print rst(fld.name) Next fld to print each field of a recordset line however I do not know a way to also get the column name for it. Would you?

Ok, but how do I get the name from the field where it did find a one. Since I do not know these field names in advance. They are chaning from input to input. So I guess I have to get the field names before I can make the query and do the check. :confused: the name of the input table is always...

Can any body lead me in the right direction or pref. show me an existing thread or program code. I need to change a tick list to a 2 column file as below Tick list has the following fields. name-A-B-C-X-F-G JanZ 1 0 1 0 0 0 JanB 0 1 0 1 0 0 Etc DB 2 has to look as follows name-fields...

I found it myself:o Thanks you all for your help. for the people interested on how to add a subform. Dim frm As Form Dim frmS As SubForm Dim ctl As Control Set frm = Forms(strForm) Set frmS = frm.Form(strsubform) Set ctl = frmS.Controls(strControl) ' now we set the...

:DThanks SOS this is what I mend. It works fine. One little issue left. The control is on a subform how do I address that in the "frm" string?:confused: Thanks DK keep yours in mind as well.:)

Thanks for all your help but it did not solve my problem yet. I'm creating a form for dummies. Every time when my info db growth I'm translating the info into colored boxes. These boxes can be clicked by the user. A click will take the box name and jump to a new routine. This routine will show...

I'm trying to update a form using the eval function in a program. However there is a part that I can't get to work It will not change the back ground color to white. I use the eval function since I will do this many times and the form automatically add textboxes when more data is available...

Thanks Bob for your help. Did some reading up about it and I guess I understood it since the program is working fine now. Thanks again.:)

Bob, does this also work in an mde file? and would you maybe have an example on hand. If not I will search the forum. Thanks for your help

Thanks all yes it was a refernce question. I made an outlook and Lotus notes option to send the data back. I now found out that on the PC's where it did not work there was no form of outlook installes. Thinking about it it was rather logical :o only the error message did put me on the wrong...

Yes it is a missing reference issue. In the mean time I found out that it has to do with Outlook that is not installed on these pc's. As standard Email program we use Lotus Notes (Yes I feel bad about that as well) however in the past Outlook was installed on the pc's as well. Later they stopped...

I face the following frustrating problem:mad: I made a small program using VBA in access to structure some internet information that I want people to look at and distributed it to differnt (80) people to play with. Now there are about 10 people that get constant error messages. stating that the...

I managed to send Emails from my Access Db using Lotus notes as Email program including attachments etc. However now I would like to create LN "To do list" entries from my Access Db and send them as well still using Lotus notes. Can any body point me in the right direction? I can't find a VBA...

Lissa, I would put in under event lost focus for LaborCategory1_Hrs me.<namesubform>.requery (assuming the subform is part of the same form as LaborCategory1_Hrs.

I converted my well working mdb in a mde and now ran into a problem. The sign of for the user is over a view froms and can only be done once. I made this by setting a value in the first form As follows Private Sub Form_Load() 'INIT Dim db As Database Dim rSt As Recordset Dim sql As String...

Kiwis Rule!! Brilliant it works like a charm. Thanks a lot. Great fun to that somebody from beautiful but far away NZ helps me in Holland. Thanks again.