Search results

Hi all. I have a combo box ( cbxCode) with 8 rpt names Example ( Pending Affidavit, Affidavit approved etc). Within the form(A continous form) I have a ck box (CKFlag) which is selected for flaging current record for printing. I would like to add a cmd button that once a rpt is selected from...

RE: crosstab Hi uncle-lai It works great, I pasted it in the column properties and it works perfect. thanks so much have a nice weekend Dennis Chicago:) :)

Re:crosstab Hi uncle-lai It works great, I pasted it in the column properties and it works perfect. thanks so much have a nice weekend Dennis Chicago:)

Re:Crosstab Hi Peter, and uncle-lai Thanks for your quick replied, I created a new table Type* (Primary key) =t, A, E Val, number I linked it to the recordset in the query, I'm still getting the fields that are current ( A, T) E is missing because there was no entry for this type. I know...

Hi All; A report based on a crosstab query that when run it shows how many employees type (T, A, E) are on l conference leave on a particular date. my problem is that the report only runs when all three types are present, if one type is missing in a particular report date. It just does not run...

Re: Thanks for your replied I done security before so I can relate to that. Because I'm sort of new with this everything else you mention "went over my head" sorry Dennis

Hi All, I would like to create a logname of people using the database, and being able to report their transactions by date How will I do this thanks Dennis

Selecting forms from a cbx Hi all' "never mind" I figured out myself. It works out fine now thanks Dennis

RE:Selecting The code shows reports and opens it as selected. Now I would like to do the same to open forms. The code might be a little diferent for forms? Which that is my question. thanks Dennis

Hi All, I have 15 Small frms that I would like to select from a combo box. as needed. I have similar code to open reports, but now I is forms So any help will be greatly appreciated. Dennis <code> for reports SELECT [MSysObjects].[Name] FROM MSysObjects WHERE (Left([Name],1)<>"~") And...

Well I understand with his approach and see his point. The reason I need it to update those fields is because it will populate the query that feeds a monthly report based on a report date. So the more the codes takes care of it the easier it gets. So how you would approach this Pat would...

Re: thank you Dennis

Hi All, I have a combo box [Pytable1] with the following values( 01, 02, 09, 15, 23, ) Based on these values when selected I need to update couple other fields [ Position]and [ID_L] provided [EffDate] and [CompDate] are present (Not null) Now in order for the update to take placed [Lane...

Hi All, What will be the best approach in this case.. 1.) I have a combo box with these values (name of combo bx) cbxPytble [1, 2, 23, 32, 9] Example; When I select Pytable [1] I want to update a field called [ Position] with [Regularly Appointed Teachers] and a field called [ID_L] with the...

Validation HI It will be easier for me to post a sample database so you could see what I trying to achieve. Thanks Dennis PS. You will see on the form thats comes up, I would like to click on each combo bx (3) and get the final value based on what I selected.

Hi All: I have 4 fields Id AutoNo. A. text1 B. Text2 C. Text3 Once these 3 fields are validated I would like to see field D. populated with the correct info any help would be greatly appreciated thanks Dennis

Code >>>> Thanks so much for you reply, I will test this over the weenkend to see how it goes. I'm a (newbie) when it comes to VBA , thats why I rather ask for help and learn in the process, but I'm beginning to pick up things here and in books. After I read something I need to see what it...

Hope Pat reads this one ( need your help) I have six fields in my form Only 3 are required When Approved then Effective and completed date is required, if Approval is missing but Effective and completed date are not then I need a warning. Approval, Effective,completed dates, triggers...

great Thanks Pat. My question is now how do you link to db2 tables from Access? When it comes to Db2 I'm lost. But If I connect it to Ms Access I can survive Thanks Dennis

Hi there Does anybody know about a Sql Query builder that can be interface with DB2 QMF). After getting common tables loaded into this interface, (database) being able to create queries by dragging fields oppose to typing everytime? Or any other suggestion will be appreciated. Our mainframe...