Search results for query: *

I have a DB that works to output stored files with MS Outlook. To make this work I had to add a Reference under VB Tools. "Microsoft Outlook 15.0 Object Library". I then tried to do this again in another DB...same computer. I also added the same Reference in VB Tools. When I Debug the...

Let's say I have a text box on a report that is 1/2 inch high and my text is 1/4 inch high. When this text box is populated the text shows at the top of the control unless it is longer than the control. Then it wraps. What I need is for the text to show at the bottom of the control and then...

In a DB I have a report that is opened from a Button. No problem with this part. How ever some fields on the report are populated from a query. I have one text field on the report called Combined2, where the text in the field can vary in length up to about 100 characters. The field is not...

I have imported a form into an access report and sent it to the back. I over lay this form with text fields that will contain data computed by my DB. My problem is - the text fields move depending on the screen I use. I set this up on my main monitor but if I use just my laptop screen the...

I have a DB that is set to open to a specific form. This part works. One of the Command buttons on the Form outputs 4 reports to my C: drive into a Folder. Three of these "EOC", "1097A", and "PTEAR B rpt" always work. The fourth, "CLEAR", is failing with "Run-Time Error 2046. The command or...

In my DB I run code that loads a table. I have a Report that sends the data from the table. In VBA I am using DoCmd.SendObject to send the report as Excel to my users. It does not arrive the same. On Label is incorrect. Troubleshooting by exporting the report from Print Preview to excel: The...

I have an Access Db on a server (a storage server not an application server). There are multiple users using the Db from time to time. In my Db I need to export reports in PDF to their C: drives - to a selected folder. If I code the export to save a file to "C:\Special" folder, as an...

I have built code in my DB to send emails to selected locations (2) with an attachment. This works and the email is sent without showing the email page. I know the email screen will show if I do not have a To: email address in the code. But I do have the Address/s in the code. Now my users want...

My DoCmd.SendObject to send a report in PDF to selected individuals. And it works if I type in the email address into the DoCmd.SendObject code. However, I need my form to select the "To:" person with a Combo control. The Combo control then holds the correct email address. In the...

I have been using send object to send email from my DB but I can only send one attachment at a time. I need to send more. I have found some articles about using Outlook coding in VB to do the job because it can handle more attachments. Question: On the VB screen, in Access, on the tools menu...

From a form "Microsim Work Form" I open an update form. After completing the updates I will close the update form. On the close event of the update form I want to refresh the "Microsim Work Form". How would I do this with VBA in the Update form Close event? Also, is Refresh the best code to...

The DB I am working on will create two reports that I need attached to an email. I will provide a Partial To: for the email but I need the email to open in the creation window so I can add another To: person. I am looking for code to help me attach the reports to email (Outlook) as PDF files...

I have a db that contains a main form with one sub-form. The main form shows a customer that requires periodic audits. The sub-form shows data from each audit. After an audit is complete and data is entered in the sub-form I have a button, on the sub-form, that updates the "Last Audit" field...

I have been asked to set up a DB that shows employees and their managers. This will requires all managers in the management chain to be included. There are 6 layers from the employee to the top. The data available includes: employee ID, employee name, managers ID. This data is consistent...

I have two cells on my spreadsheet that have time values HH:MM. Formatted [h]:MM. I have a third cell that uses a formula to show OK if they compare and NO if they don't. However one of the cells could be 1 minute +/- from the other. If this occurs I still want to show OK. So,I need a...

I am using a SEARCH function like this: =IF(ISNUMBER(SEARCH("LOS",$A6))=TRUE,$C6,"") But, what I really want to do is to SEARCH for "LOS" OR "DTS" in the referenced cell. Can anyone show me how to format this? Thanks, John

In my DB I have 6 linked tables based on user unique ID (BEMS). These tables are set up do be able to show user/management hierarchy. This tends to change many times over a year. I want to be able to show all 6 tables on a form and be able to change any one of them. But, my query will not...

Is there a way to set DB read only for certain users and remove read only for others. I have a table of authorized users allowed to make data changes. Thanks, John

I am running an update query. I had help with another one recently and it worked. This one is a bit different and I tried to mimic the earlier versions. Earlier working version: UPDATE [IPSS Classes] SET [IPSS Classes].Complete = Yes WHERE ((([IPSS Classes].IPSSClassID) In (SELECT [Related...

I have a table with a field named "Complete". When I update data in this table I also want to check to see if work has been completed. If it is completed I don't want the user to see the completed items. The users work on items that are not complete due to errors. Not all items have errors...