Search results

I am having an issue with data being reported as though I've asked for it to be grouped on one page, but I don't think I have. (Locker_RFI_5-Notes.pdf) is a one page report when there are only 5 notes. (Locker_RFI_8-Notes.pdf) shows what happens when more notes are added. They all shift over to...

I'm using the following code to grab a customer's email address which I grab from [Me.Text7.Value] and create an email which appears as detailed in the attached "Current-email-msg.jpg". Everything is working fine, except for the text in the body of the email (as shown in RED below). This text...

Thank you very much for the detailed explanation. I'll work on this some more and see what I can come up with.

This is the code I've used to create an Outlook email in Access. Perhaps I can't automatically pull a (.pdf) that I have created in Access and I'll just have to attach it manually? Sub SendEmail() Dim oOutlook As Outlook.Application Dim oEmailItem As mailitem ' prevent 429 error, if outlooknot...

Perhaps I didn't fully explain what I am trying to accomplish. I'm trying to attach a (.pdf), which I've previously created using Access and then attach that (.pdf) to the email I create in Outlook using the steps I have already set up in Access. Excuse me if I misunderstand you, but the method...

I have set up my database to create an email in Outlook. You mention in your comment that "emailing with attachments is easy". Can you direct me to a link which explains how to do just that? Thank you.

No I have not. I Google Sendobject and quite a number of videos came up in YouTube. Thank you for the suggestion

Having a hard time searching this forum to see if there is any thread regarding this subject, so I thought I'd start one. I'm just wondering if there is a thread on this forum that someone could direct me to which shows how to take a (pdf) report developed in MS Access and bring it over to...

I was able to design the report exactly the way i needed. Thank you again for your help

No, it never dawned on me to try that. I'll research that option and let you know. thx for the suggestion

Please see attached (.pdf). Currently, I can accomplish having my report printout as shown on page 1. Goal is to have same style report except to have the project notes print out underneath all the quotes. I have simply typed in how the notes would look like but I haven't been able to...

Thank you, Bob!

I used your first suggestion and it worked perfectly! Thank you for the help!

Doing some of my own research, I found the following query which lets me automatically pull up data based on my [DocCreated] date field: Year([DocCreated])=Year(Date()) And Month([DocCreated])<=Month(Date()) And Day([DocCreated])<=Day(Date()) What sort of modification should I make it I want...

Thank you to everyone who replied to my question. I appreciate the help and direction

Ok. What I don't understand, though, is that this issue has only started to occur in the last few months. The "setup" I have been using, i.e., database on the network and each person has a copy of MS Access on their computer to access the database on the network, has worked literally for many...

I have read a few other posts on this topic and each individual who has access to my database has their own copy of MS Office 2016 residing on their computer. The main program resides on our office network and they access it using their local MS Access 2016 copy.

I don't expect anyone here to fix my issue, I'm just hoping for some guidance as to what direction I should look to fix the issue. I have a database which works fine when only one person is working in it on my office network. The issue described below does not happen when only one person is in...

I by no means am a master programmer. I've adapted my original program over the years as issues have developed. The first issue I had years ago was when employees would start to change information on the main form page. That's when I added the Add/Edit button which opens to the specific record...

My issue has only developed as a result of a new person using my existing database program. My other employees understand how the Add/Edit function works, but this person did not; even after having explained the process. I can't seem to find a way to resolve the issue on my own, hence this new...