Recent content by jwa6

using visual studio 2008 V3.5 sp1 i HAVE A TARGET FLD DEFINED: xfld (DT_STR,30,1252) I HAVE A FORMULA HERE for xfld: Im comparing 2 year fields IE: 2008 = 2008 (CAST([YEAR] AS VARCHAR(4)) == CAST([CUR_YR] AS VARCHAR(4)) ? [STATUS] : "CLOSED" if they are = then xfld = STATUS if <> then...

thanks... Dagon for the post Ill look it over later today and let you know jim

select column_name from user_tab_columns where Upper(table_name) = 'AFACT' MINUS select column_name from user_tab_columns where Upper(table_name) = 'VW_AFACT' / THIS DID find the 3 fields missing in the view. this is great. But this leads to another question. For every table and view I...

thread1177-795377 http://dev.fyicenter.com/faq/oracle/oracle_managing_user.php jim

select column_name from user_tab_columns where table_name = 'afact' minus select column_name from user_tab_columns where table_name = 'vw_afact' THERE ARE 3 FIELDS IN THE TABLE THAT ARE NOT IN THE VIEW CREATE or replace view vw_afact ( nsc_ps_enr_fact_key ...

Hello I did try the minus from user_tab_columns as suggested. The sql pulled all of the fields from the table. Not just the 3 missing in the view. I then added all the fields from the table to the view The results from the sql were the same as before. All fields selected from the table jim

yes this is the approach we have here... Create or Replace view test_view as select field1,field2 from my_table) Im not sure how your solution here works( but thanks for the response by the way) Lets say I have only one table in the view and the view is missing added fields in the table. How...

oracle 10g I have views on tables in oracle that I need to check to see if the views are current. Sometimes we add a new field to a table and recompile the view. But, the view wasnt changed to reflect the added field in the table. this is on our dev DB... We have many contractors thru here and...

got it! thanks john for the code Dim Criteria As String Criteria = "([OffTypeDesc] = '" & Forms!fCBox.Form!cboOffType & "') AND " Criteria = Criteria & "([FileTypeDesc] = '" & Forms!fCBox.Form!cboFileType & "')" DoCmd.OpenReport "rptqCBoxes_w_Years_exp2", acViewPreview, ...

yes it does show the correct records

neither have a quote in the field but thanks Ill keep this for future reference Seems using 2 feilds is a no no in Access based on this board and ITtoolbox as well. Access is a funny beast -- I have problems using the wizards to open a form ( single record) based on a subform. I was...

good suggestion There are now 3 records on the form( filtered) I have copied your code in - fired off the report - but only 2 of the 3 records show. Same results as the code I was trying before I have heard of others having issues w/ a 2 parm docmd. thanks for your effort. jwa

I noticed that as well its something w/ this editor that put those in but thanks for noticing jim

this is pretty straight forward. I want to open a report based on the same qry as the form. I am using the form filter values ( which work) to open a report / the same record set - which isnt working. this is the command. DoCmd.OpenReport "rptqCBoxes_w_Years_exp2", acViewPreview, ""...

You could create the county totals all in one query with a subquery. I'm not sure a report would allow you to use this result from the subquery as the control source for sorting and grouping. Ill try and let you know thanks for the list of books -- and I appreciate it jim