Recent content by luism

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