Search results

Thanks for the response. RepNumberField and UserNameField are fields on my main form. The user name field is a field generated by the computer login. The database is being used in my workplace. When we have a sales rep leave the company, we need to reassign all their territories to another...

Incorrect? So here is the scenario: I have a list of sales reps that are assigned to regions. I want to be able to open a subform and filter it by the sales rep. When I reassign it to a different sales rep, the record disappears from the subform (because the rep from the filter criteria...

Hey all! I've been messing around with this for some time and I can't seem to get it to work. I'm trying to make it so when a subform is updated, it will email the contents of that subform to me. I've got it all working, except for the content of the email part. Any ideas on how I can implement...

Hey all! I've been searching for a while for a way I could make this work.. I'm trying to make it so I could filter a subform from the main form and it will hold those results and allow them to be edited in the subform without it refiltering it. I want it to still be able to update the table...

Hey all, I'm having issues with this one. Table name is CompDates Subform is ViewByMarket Start date is Text13 and End Date is Text15. I want it to filter out any matches between the 7 fields. Here is my code: Private Sub Command19_Click() Dim strFilter As Variant, _ strSDate As...

Thank you HiTechCoach. A co-worker got it to work, but now we have run into the issue where we have too much information in the table and Access will not work. "This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many...

Yes I did. When I open design view on your query, it opens the SQL. When I open the design view on my query, I get the builder page. I know nothing about SQL/Coding.. and can barely get by with the formulas I'm putting in (until this one). I copied/pasted and edited in the SQL from your sample...

This didn't work. It returns all records regardless if checkbox is checked or not.

When I used that formula, it won't return anything when the checkbox is checked, but when it is unchecked, it returns all records. My field is set to text formatting, could this be why?

Thank you :)

When the checkbox is selected, I want only the records that have the email filled out. If the checkbox is not selected, I want all records.

When I use that code, I get "The expression you entered has too many closing parentheses." And I put a parenteses after the = and regardless of if the checkbox is checked or not, it returns all fields (blank and non-blank).

We're getting closer! :) Now regardless if the checkbox is checked or not, it shows all records.

Thanks! But when I use the following, I get an 'invalid arguement' error: IIF([Forms]![AdvancedReporting]![Check230]=-1 and (Detail.[E-Mail] is not null,True,False)= [Forms]![AdvancedReporting]![Check230])

SELECT Detail.*, * FROM Detail WHERE (((Detail.Primary)=IIf([Forms]![AdvancedReporting]![Combo216]="ALL","*",[Forms]![AdvancedReporting]![Combo216])) AND ((Detail.[Asgn...

Hi Everyone, I'm having an issue getting my query to ommit records with a blank field - in fact, it ommits all records. What I'm trying to do is: I have a list of customers, with phone and email addresses. I want to filter via query for only customers with their email address's entered...

Anyone know how to do this? Any help would be MUCH appreciated.

Is the Event setup for this button? If so, can you paste the code?

Try: =DLookUp("[Train_Description]","[TrainAdm]","[Training_Number]= '" & [Forms]![TrainForm]![CB_TrainNo] & " ' ")

Hey guys, I have a form that has a ton of checkboxes. 1. Select Product (combobox) or All Products (CheckBox) 2. Product Type (3 different checkboxes) 3. Includes (10 checkboxes) What I need is these checkboxes to filter the selected data from my Details table and export it to a new...