Code:
=(IIf(IsNull([rptPath]),Null,"FILENAME / DOC #"))
however, if the value in the first row of the report is null for this field (or any field with the...
mindbenderz
Last Activity: Apr 3 '12, 07:50 PM
Joined: Oct 6 '11
Location:
-
Label Visibility Based On Field Count In Report
This is a 2 parter, but right now I want to focus on the second part. I have "labels" which are text boxes, and the text for the label is only visible when there is a value in the field its related to. here is an example of one of them
however, if the value in the first row of the report is null for this field (or any field with the... -
ok, I think I almost have it working. what I notices is, though, is that when I enter text in to one of the fields and it updates the subform results, the text I enter in to the field actually writes in to FormQuery's criteria fields. when I clear the fields on the main form, how can I get it to remove the criteria it set in to the query? also, it isnt completely displaying all the results in the subform display. Ill keep playing with the module,... -
I did all that. It still gives me the "Expected variable or procedure, not module" error. Is there a way for me to actually attach a stripped down copy of the db here so you can see what is going on?Leave a comment:
-
I just renamed it to "mod_ReWriteQue ryDef". Should I put ReWriteQDef in the vba event, and not ReWriteQueryDef ?Leave a comment:
-
when I do that, and enter a value in the field I get the following error "Expected variable or procedure, not module"Leave a comment:
-
Ive tried
=ReWriteQDef
=ReWriteQDef()
ReWriteQDef
=ReWriteQueryDe f
=ReWriteQueryDe f()
ReWriteQueryDef
in the AfterUpdate event, and they all pretty much give the same error. Either it cant find the object, or the expression has a function name it cant find.Leave a comment:
-
I did that. I created a seperate module outside the form, a public one, and saved it as "ReWriteQueryDe f".Leave a comment:
-
ok, nm that part. I got the module to work with the sqlWHERE fine. when, on the form, I add =ReWriteQueryDe f() to AfterUpdate for the 3 fields, it says "The expresion you entered has a function name that Database can't find". Did I call it wrong in the event lines?Leave a comment:
-
the sql in my posts showed the tables full names. at least thats what I can see (i.e. tbl_documents, tbl_content_typ es, etc). I guess there is a character limited on the vba lines. does it allow carriage returns in the code?Leave a comment:
-
In these lines, Im guessing I need to change the table names to the correct names? I just noticed that
...Code:Public Const sqlSELECT As String = "SELECT docs.root_id, cont.cont_type, docs.[Content Type], rigs.location, docs.[Assigned Location], docs.Title, docs.[Revision/Version Date], docs.[Asset Number], docs.Vendor, docs.Vend_ID, docs.Manufacturer, docs.Manuf_ID, docs.Model, docs.[Serial Number], docs.[PO Number], docs.[Pressure Rating],
Leave a comment:
-
when I try the ?sqlWHERE
it says 'ambiguous name detected'.Leave a comment:
-
Here is the last working version I have, just using criteria in the Vendor and Manufacturer fields of the query on different rows
...Code:SELECT tbl_documents.root_id, tbl_content_type.cont_type, tbl_documents.[Content Type], tbl_rigs.location, tbl_documents.[Assigned Location], tbl_documents.Title, tbl_documents.[Revision/Version Date], tbl_documents.[Asset Number], tbl_documents.Vendor, tbl_documents.Vend_ID, tbl_documents.Manufacturer,
Leave a comment:
-
Here is what I have so far, it just doesnt work where it is now
...Code:SELECT tbl_documents.root_id, tbl_content_type.cont_type, tbl_documents.[Content Type], tbl_rigs.location, tbl_documents.[Assigned Location], tbl_documents.Title, tbl_documents.[Revision/Version Date], tbl_documents.[Asset Number], tbl_documents.Vendor, tbl_documents.Vend_ID, tbl_documents.Manufacturer, tbl_documents.Manuf_ID, tbl_documents.Model, tbl_documents.[Serial
Leave a comment:
-
no combo boxes, just text fields on the form. something typed in to one or all of them fill filter the query more. I can get 1 to work, for the most part. but when I try making any of the others work it not only messes up the first one, but they also dont work. and I dont know how to code any of the stuff you mentioned. Im still learning vba and have quite a ways to goLeave a comment:
-
Single Criteria With Multiple Parameter Query With A Twist
I have a form (frm_docs_looku p_list) with 3 field controls: equip_sr, po_sr, vend_sr
the form has a subform attached to : subfrm_docs_loo kup_list
the results in the subform display based on what text a user enters in to the controls on "frm_docs_looku p_list". multiple fields in the subform refer to each of the 3 search fields. those are listed below
equip_sr: Title, equip, notes
... -
I attached the database with the necessary forms to see what I trying to do and enough information in the tables to work with. Ill answer all questions you have while working on this issue. Thanks so much....Leave a comment:
-
I will put together a stripped down copy of the db when I get in to the office tomorrow. viewing it and reading what Im trying to do might make more sense. I do realize that sometimes my explanations can be a little unclearLeave a comment:
-
Running a query and referencing some of its values in VBA
This is the last challenge I currently have, and its taken me days to get to this point. I have finally figured out how to make a query that will run some calculations I need. The query is called
qry_hardcopy_ca lcs
In a subfrm I have 2 fields which will run this query and some extra VBA on an event. I will try and explain what needs to happen as clearly as I can, and the controls associated.
subform =... -
got that too. I added Refresh before setting Dim in the VBALeave a comment:
-
nevermind, I got it. I created a hidden dropdown linked back to tbl_documents that pulled up the Path and doc_filter info. The control source for the dropdown is [Forms]![frm_hardcopies]![Filename]. Then, based on the value in the 2nd column of the dropdown (doc_filter), the DblClick event opens the form accordingly. It works so far, however when I go to the next record on frm_hardcopies and try clicking on the field again, nothing happens. I have...Leave a comment:
No activity results to display
Leave a comment: