Search results

Well believe it or not, sometimes people forget to enter information, and when I have the reports viewed I need to have them in a descending order by date. So when I have to go back or someone else goes back in and inputs the data it has to be in the correct descending date order.

I have been playing around with this unbound and bound DB Mr. Arnel uploaded and I am having no luck on one thing. On the report I am unable to get it to sort by date. I have tried grouping and sorting on the report itself, I have also tried to sort within the query but I am having no luck...

Thank you all for the help. I will take all the suggestions into account. Also thank you for the database upload. I have no doubt in the midst of all this it will all solve my issue. :)

Hi again, As the title says I have no idea what I should have titled this to fit in the space allotted. I have started to make this, but it is no where near finished, it is mostly just thrown together at this point. Okay, so here is the situation. I need to have 2 forms and a single report...

Honestly that is not an issue, there is always someone in the building 365 days a year, 366 on leap years.

Never mind I figured it out. :)

Okay, so doing it this way, I have 2 other buttons I need to make invisible on the 1st only. How would I get that done using the one line of code? I figured out how to do it using Eugene-LSs code, but without the true/false ability I have no idea how to make it work.

That worked perfectly thank both. All the help has gotten what I needed accomplished.

Hi, I have a form with a command button on it, and I need it to only appear on the 1st day of every month and hidden every other day. I have no idea how to accomplish this at all, so I have no code to start with. I have googled and searched forums but I am having no luck with my search. I...

bastanu, I will try to set it up to use the bcc it is a great suggestion. GPGeorge, thank you for the concern, I have my customers permission to send them the emails that I am. Also I will check with my ISP and verify their guidelines. Thank you both.

Yes, I found some code that works. Private Sub Command0_Click() Dim strEMail As String Dim oOutlook As Object Dim oMail As Object Dim strAddr As String Dim MyDB As DAO.Database Dim rstEMail As DAO.Recordset Set oOutlook = CreateObject("Outlook.Application")...

Wow that is a nice database. Way to advanced for me to understand how all that works with those modules and things. I appreciate you attaching that database, I was just hoping to use the regular old outlook program to send my emails out, but I did not want to make my email address book...

I am fairly new to microsoft access and I need a lot of help. I made a very basic database, I have a table and 2 forms. One form is letting me input some basic information that I am wanting to store, like customer names, phone numbers, addresses and email addresses. I then have a second form...