Search results

alright great, thank you!

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

Unfortunately that got complex for me, I will just instruct the users to delete the file before trying to export a new one. With the exception of overwrite it's working 100%, thanks!

Perfect that worked. It was giving an append data error because some contacts did not have an email on the table. Last item we need please: - Ability to overwrite the .xlsx file that gets placed in "Documents" folder by default. Currently, it doesn't overwrite. If the file gets deleted then...

Ok here is what I came up with so far My Query: SELECT Tbl_Contacts.LName AS [Last Name], Tbl_Contacts.FName AS [First Name], Tbl_Contacts.Zip, Left(Tbl_Contacts.Email, InStr(Tbl_Contacts.Email, "#") - 1) AS Email, Tbl_Contacts.InitialContact AS [Contact Created] FROM Tbl_Contacts WHERE...

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

*bump* Would really like to know if anyone else has any suggestions?

Does anyone have any other ideas/code I can try? Thanks!

I see what you mean now. Under the Properties of the report. There is no On Format available. See screen shot please.

Sorry, I'm not understanding the On Format thing. What I tried to do on the main report (Rpt_hicontarcts) is switch from Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer) to Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) While "Print" still shows those...

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) did not work :(

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

no way, after exporting the table on excel, removing all (xxx) xxx-xxx formatting then importing the data and finally did an UPDATE query on the phone numbers.

i had to update over 11,000 records to change the format. wasn't that easy but this was basically the best option. thanks.

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

Hi mstef and thank you for responding. Unfortunately this takes away the ability to search by name, address, zip and phone number which is essential to our needs. I forgot to add that I also need to display data for users that do not have any contracts. So I am re-attaching my DB. With some...

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

worked like a charm, thanks!

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

My row source is grabbing EmpID of all active/inactive Employees as well as their FName and LName, I dont know how to implement into the query how to grab only those Employees that are active.