Search results

Tried it several times. Can you post it here?

Hmmmm.....Clicked the link, got page cannot be displayed.

Thanks got it working just like I want it to. One other thing and I'll be all done. How would I let the user enter a date range and do a filter on the department selections or employee selections in just that date range, or can you do that?

Everything is type "text". Will your changes work for that?

OK new plan. In the attached WB I have a form in the FE called "Summary Report Multi Selection Criteria" For the life of me I cannot get the syntax correct. Its probably easy but having never done this before its a struggle. Any help, tips, pointers appreciated. Thanks

No the report name comes from the Tag property in the form.

Can someone tell me why this function is asking for a parameter? Option Compare Database Option Explicit Function MultipleValueCriteria(pform As Form, _ pcontrol As ListBox, pfield As String) 'Launch rptSummaryReport using 'OR...

I need to add a Yes/No field to a table. I know I can do this in design view. Next I want to loop through the table and set it to Yes if certain fields are null. What I need help with is the VBA looping part and setting the boolean field to Yes if the fields being checked are null.

Thanks techNellie, that got what i wanted.

OK thanks. Will give it a go.

OK, let me rephrase the situation. I am looking for records that have one of four fields being null. So lets say I want to find where filed 1 is null and the other three have data, next, I want to find where field 2 is null but 1,3, and 4 have data, then the same for fields 3 and 4. Then a...

Im trying to build a query that checks four fields for blanks. If I try to run the query with the criteria Is Null for all four fields, I only get 27 records. However, if I run the query with the condition only on one field I get the right number of records around 1000. I have been having to...

In the validation rule I am using Is Null. Then if it supposedly is the mesaage apprers.

I tried putting in some rules in my form in the validation rule property but am running into a problem. The warning displays as it should but after you enter something in the control, the warning still appears. Or if you change the entry the warning comes back and again it says it is null or at...

I tried commenting out the If statements and changing the IsNothing to IsNull with no luck. Going to post the FE and BE to see if anyone sees something. Hope so, I gotta have it fixed by Friday morning. All help greatly appreciated. The form the code is in is called frmSelectProject. The...

Well I thought that was the case. So I made an entry in every field in the table it pulls from and got no more records loaded to the form than before I filled in the blanks. I suppose if I commented out all the if statements that might work. What is your take on that. Also might try is null...

I was hoping that someone could explain what this code is doing? It looks like it is filtering but my question is if any of the If statements are true, does it filter it so it will not be visible in a form? The form is supposed to show all active records but I think that some are failing some...

Will that change everytime the form navigates to that record?

I need to auto populate a control with the current date and then lock it so it wont change every time the form is opened. Couldn't seem to find anything on that topic. Thanks

That resulted in the following run time error: Invalid use of null on the code below with the bolded line: Private Sub cmdEdit_Click() ' Dim lngReportNo As Long, lngProjID As Long ' lngReportNo = Me.frmProject_sbfrmProjectStatus.Form.ReportNo lngProjID =...