Search results
-
L
Combobox based on yes/no check marks
Not necessarily, my Tbl_Emps has a few inactive Employees. What I'm trying to do is create a combo box on another form that populates a list of all Active employees only. How can I do this, on another form? I understand how you did yours but it doesn't help me with populating a list of Active... -
L
Combobox based on yes/no check marks
could you please guide me? maybe an example? i tried on my own but couldn't get any results. thank you! -
L
Combobox based on yes/no check marks
I have a table of Employees, tbl_Emps with some basic info, FName, LName, HomePhone, CellPhone and I'm thinking of adding a Active [Yes/No] checkbox. Will I be able to populate a combobox based on Active/Inactive Employees? In addition, I would also like to tell a report to print a list of... -
L
Query Left Inner Join and Null Data?
May have to give up on this interface, I tried and just cannot get it to work *sigh* -
L
Query Left Inner Join and Null Data?
Another option would be to do something like this All contracts expired before today's date to say "Expired" All contracts to end anytime today or after today to show the date it will expire. I dont know if that makes it easier. -
L
Query Left Inner Join and Null Data?
LAST works to a certain degree, especially if there are multiple Contracts (as much as 10 or more from many years ago) then LAST fails. I want it to show Contracts that have either expired (only if all of them have expired of course and the latest one, like 12/11/2011) But most of all to show... -
L
Query Left Inner Join and Null Data?
any takers to help me finish this completely by sorting this last issue i have? -
L
Query Left Inner Join and Null Data?
*sigh* :banghead: Back again, this interface has given me so many issues. A new one has arrived after importing some data from old db to my new one. See the attached please, you can clearly see that everyone has a contract that will end either in a month or so or even next year yet it is... -
L
Query Left Inner Join and Null Data?
Can't thank you enough, this helped a lot. Thank you VERY much! -
L
Query Left Inner Join and Null Data?
NVM, here it is in 2002-2003 format. -
L
Query Left Inner Join and Null Data?
The problem is that I can have multiple Contracts per person so it makes sense that the "SearchAll" form results in duplicates or more being displayed, I'd just like to grab the latest contract created and display that info and if no contract then "none", so something like Jane Doe, Full... -
L
Query Left Inner Join and Null Data?
I have attached my tables Tbl_Contacts Tbl_Contracts I also included my form Frm_SearchAllContacts You will clearly see how Jane Doe and John Smith have multiple results. This causes confusion, my goal is to display each contact once and if a contract doesn't exist to just say "None" Thank you! -
L
Query Left Inner Join and Null Data?
After inputting some data, this is returning multiple results for the same person. I'll post my tables in a bit *sigh* Any help is most definitely appreciated. I'll post it soon. -
L
Query Left Inner Join and Null Data?
duh, why didn't I think of that. i wanted the query to return "none" but i guess it's easier to tell the field =Nz([DateEnds],"None") and it worked fine, even added some conditional formatting colors. thanks! -
L
Query Left Inner Join and Null Data?
Unfortunately, that doesn't work for what I'm trying to do. I am selecting one field from one table Tbl_Contracts (DateEnds) And multiple fields from another table Tbl_Contacts I got it to work as I stated earlier, it does show DateEnds if it exists but I can't get the DateEnds field to say... -
L
Query Left Inner Join and Null Data?
Any way you can give me a code that would work for this? I'm a bit lost! This query is complicated for my skills xD The form is also doing a query of both tables but no Criteria is set anywhere so I'm doing the rest on VBA after "showAllContacts" button is clicked event -
L
Query Left Inner Join and Null Data?
I created an interface to allow users to search records, however with the following code it only displays data when a Contact has a contract and it does not show Contacts that have no contracts linked to them whatsoever. I need it so that it also displays all contacts regardless of Contract or... -
L
filter subform combo box by mainform combo box
You guys are true life savers, my head was spinning trying to figure this out. Thank you! -
L
Help with mail merge function
amazing, that would've taken me days to weeks to figure out. thank you SO very much, now the email TO field works and the email sends without issues. -
L
Help with mail merge function
Here is what I'm doing, I created a report and I'm making a macro email the report and grabbing the contact's Email, however it is creating something like this My goal would be to write a query to remove anything in between the #'s of course along the #'s so that when the macro runs it only...