trey3143
Last Activity: Sep 27 '12, 05:09 PM
Joined: Jan 22 '10
Location:
-
It works, thanks you so much for your help, the only reason I didn't think it worked that last time was because there is another query that counts and pulls out data equal to another table but I think I can get that one going. I really appreciate your help you are a life saver. -
I think you might have it right, i will let you know as soon as i get through testingLeave a comment:
-
This code works if all parameters are filled in but if I leave one blank it returns no data. I tried to leave user employee type blank and it did not error this time but it returned no data. I am going to test to see if it returns people that have null values in these fields.Leave a comment:
-
K without the where clause it does work, when data is inputed into the parameter, I took out all the other where clauses except the Iif statement and I got the same error. I am going to try and change up the Iif(isnull statement) to see if I can get it to work without all the other parameters.Leave a comment:
-
I tried the code and changed a little syntax to run it. After I ran it it pulled up parameter boxes, so I input them with the data to test to see if it would pull out any data. I made all equal without leaving any blank to test it before I left a field blank. I still got the same error saying that it was too complex. I tried earlier in a test DB making the 5 other tables have a common key and puling the data out but even distinctly I was running...Leave a comment:
-
Yes sir, then she designed the form fields drop down box to pull from a query in the smaller tablesLeave a comment:
-
This is going to be used with the IT department to give user provisioning rights. So when a new employee comes in they fill out areas on a form for department, employment status, etc to pull out the access rights for that specific user and the groups they need to be imported into AD. I didn't create this database they came to me after it was built and said this query doesn't work. So I am thinking I might have to make changes to how it was created...Leave a comment:
-
I am trying to pull data out through a form that runs a query, but I want to be able to leave a form field blank where it will ignore the parameter or this form fieldLeave a comment:
-
So I was thinking about adding a primary key like user id to these tables and making these joins, do you think that would work?Leave a comment:
-
I got the same error about the query being too complexLeave a comment:
-
K i changed the code in the first where clause to test and it will query now but if I leave a form field blank i get an error that says This is typed incorrectly, or it is too complex to be evaluated. It will run if all form fields are fillled out.
...Code:WHERE ((([tbl-UserEmployeeType].[User Employee Type]) Like IIf(IsNull([Forms]![User Profile Query].[UserEmployeeType]),"_"*"",[Forms]![User Profile Query].[UserEmployeeType]))
Leave a comment:
-
Returning Null Values and Blank Criteria in Form
Hello,
I am trying to get a query that runs off input values in a form in access 2010. I would like to return null values in fields and if a box is not filled out in the form to ignore this parameter. I whave been trying to do this without creating a union query. But this is what I have so far but it keeps saying I have a syntax error and sometime I have gotten you are missing an operator. I know what those errors mean but I am getting... -
thats exactly what I did, thanks for all the help, bytes.com is a life saverLeave a comment:
-
That makes sense, I will have to go back and change that. ThanksLeave a comment:
-
for any future people that use this to check duplicates, change the boxID to a double and the table field to double, if you dont you get an error with over 6 numbers in fieldLeave a comment:
-
I plugged that in and it didnt work and I though about what you said and I changed stLinkCriteria to string and left boxID as integer and it worked. Thanks so much, you saved me alot of time today.Leave a comment:
-
data type mismatch duplicates
Have this code to check for duplicates and if I change my BoxID to a text and run it as a string it works, but I need it to be a Long Integer. The data mismatch I am getting is underlined there are two. Thanks
...Code:Private Sub BoxID_AfterUpdate() '********************************* 'Code sample courtesy of srfreeman '********************************* Dim BoxID As Integer -
When I converted Macro in a module of the main form this is what it gave me
...Code:Option Compare Database '------------------------------------------------------------ ' Mainform_Close ' '------------------------------------------------------------ Function Mainform_Close() On Error GoTo Mainform_Close_Err DoCmd.Close acForm, "Main" Mainform_Close_Exit:Leave a comment:
-
I transformed the macros into modules but I am a novice and unsure how to use the new modules to get rid of the error that still occurs. Also sorry for breaking forum rulesLeave a comment:
No activity results to display
Leave a comment: