Search results

Thank you all for your replies. I took all this into consideration and began experimenting. I was finally able to get the results I needed. First, let me say this. I already had the procedure set up using initials and signatures. I typed them into a text field in the Job Coach record in the...

It's been a while but I am able to get back to this. I changed the data types to OLE Object for the images. I ran the procedure and all the images are in the table in the right places. When I open the report, the images still will not show. I have tried using the field as it is. I have used the...

I have databases set up that are used internally and externally. Externally, we were using VPN and ran into connectivity issues and other limitations of Access. To solve one of my major problems, my team needs data from various records for the same customers. I set up a small database on their...

That makes all the sense in the world. I will try that and get back to you.

I have some procedures in place that generates a report with a subreport. I have a coaches table and I have a trainee table. After the coaches meet with the trainees they enter information into the database, which is a log. They enter a narrative, the date of the meeting, the start time, and the...

Thank you for your quick response. Type of file here is not important. The sort process has first priority. I would simply like the last in to be at the top of the list when making the link. They will be making the link immediately after saving it into the storage folder. Once the file is linked...

We are trying to find a more efficient way to link files to a record via a form. Currently, we save the files with today’s date, record number, and a short description. For example, one saved there today may be like this: "5-9-17 56789 Order." I have a process set up to allow the users to link...

That's what I was looking for. I tried a few variations but did not include all the controls in identifying them on the subreport. I used the following code and it worked. Thanks for everybody's help. START OF CODE Select Case Reports!rptDAILYLOGMONTHLYPREVIOUS!rptMRDDMONTHLY1.Report!Day1...

I am using image control. They are on the report itself. There are 128 small images, .11 X .25, because there are that many options. I tried several ways to do this, but this was the only one that got the desired results. However, I will try your way. Thank you.

I have a report named rptMRDDMonthly1. I am using Select Case to display images on it. The images are initials. The controls involved are days and number 1 to 31. If a day in the table has initials, the corresponding image will display on the report. In the example below, if Day1 is populated...

That was a bit confusing. I did find a way to use the image control to do what I need to do. Thanks.

I have searched but cannot find an answer to my dilemma. I am trying to use an OLE Object as you would any other data but have had no success. Can the following be done? I need signatures on some of my reports. I have stored them in tables as jpeg, bitmap, and png files using 2002 and 2007...

After some debate, the group agreed to allow me to reformat rpt1 as Landscape. This resolved the problem. Thank you for your help.

I have been asked to take an existing report, rpt1, which can be one or multiple pages, and add a page to it from another report, rpt2, which is one page. rpt1 is oriented as Portrait. rpt2 is oriented as Landscape. I have done this and rpt2 stays as a Portrait report and displays as two pages...

I have an Access front-end database with a SQL back-end. Some of the users use VPN to connect to the network here at our base when they are out and about. All the programs are slow to load, especially Access. Also, Access seems to bomb out frequently. One user got a message today that said...

The End If was missing. Thanks for your help.

We are on a large network. I have users that work in remote locations. When using the database, a fresh login removes all the data in the tables behind the forms they are filling in. Occasionally, the connection is lost. The fresh login was the only thing they could do. Now, I have figured out a...

Thank you for your help. Right now I needed something simple.

I got it to work. Thanks for all your help.

No. I just have a text box with Hyperlink as the data type. As I said, the instructions to this point are: Right click on the Hyperlink field. Left click on "Edit Hyperlink." Then it opens to the folder where our front-end database is located. That is different for each person as we each...