Search results

Hello, I'm trying to allow users to be able to make a query based on custom/different fields. Here is what I have ---- FORM Begin Date (label): [txtBeginDate] (unbound text field) End Date (label): [txtEndDate] (unbound text field) [Export Contacts] (submit button with event procedure) VB...

Hello, We can't figure out how to do this can someone please assist. Have the following query: SELECT Tbl_Contacts.LName, Tbl_Contacts.FName, Tbl_Contacts.Zip, Tbl_Contacts.Email, Tbl_Contacts.DateCreated FROM Tbl_Contacts; The query results in all contacts on the database, which helps but...

Hello everyone, Before anything, thank you for all that make this such a great place for many of us that need help. Here's my problem. I have a report that responds and works great when PRINTING it. However, when Access converts the report into PDF some functionality needed goes Poof. Here's...

I have the following VBA code to search for a string 'Search by Phone Private Sub CmdSearchPhones_Click() Me.Refresh strSQL = "SELECT Tbl_Contacts.ContactID, Tbl_Contacts.FName, Tbl_Contacts.LName, Tbl_Contacts.Address, Tbl_Contacts.City, Tbl_Contacts.State, Tbl_Contacts.Zip...

I am having a sorting problem that I can't figure out. I have table of Contacts and a table of Contracts Each Contact can have multiple contracts, most of which are renewed but we like to keep tract of old contracts so we keep them. I created a Search interface that allows us to search our...

I have the following VBA code in a form 'Check for duplicates based on LName and warn Private Sub LName_BeforeUpdate(Cancel As Integer) 'Find any matching records based on FName & LName If DCount("*", "Tbl_Contacts", "[FName] & [LName] = '" & Me.[FName] & Me.[LName] & "'") > 0...

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...

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...

Hi guys, I searched around and couldn't find any good responses so here I go. I have a Main form with a Sub form, Main form has Contact data. I use a combo box to go from one Contact to another, of course each contact has a ContactID. My Sub form has Proposal data, I use a combo box to select...