Search results for query: *

So looking back at my various databases, I see that I have not used this before. The interface is actually quite simple because the main TabControl is the full screen of the main form and the first tab is the data entry form and the second tab has the reporting with some report filtering...

This is driving me nuts! I have a simple form with a two tab tab control. I have another tab control form that I need to embed in the first tab of the main tab control. I have done this successfully multiple times but for some reason I cannot create a new tab control inside the main tab...

When I pasted in the code I had left the acFormatRTF in the code. I had been tinkering with RTF in a word table format rather than the Excel format. The info in the link by Darrylles gave me the direction that I needed. I needed to add the acFormatXLSX format to my object library. Good post...

The subject pretty much says it all. I need to be able to export a query to an Excel spreadsheet but I can't have it drop all characters above the allowed 255. Please help with either a workaround or direction to make this work. Thank you in advance! The code that I am using is as follows...

I am using the following code to rename a report when it sends the object in an email. The issue is that if there are more than two words in the VendorName field it drops the last letter of the vendor name. eg. The saved file name is "PO 15-1192-1r0 Prysmian Powe 20151120.pdf" in lieu of "PO...

I have been using the following code to email a report after changing its name. The key is that it takes the first two words in the vendor company's name and truncates the rest. The issue is that if the vendor has as a comma in their name the name violates the MS naming rules and cannot be...

This is probably the most basic question but I am stumped. I have a table for cost codes, a table for purchase orders, a table for freight costs, a table for budgets and a table for time sheets. Each of the tables has a Project Name and a Cost Area and Cost Code. I want to create one query...

Hello... I am trying to add an access report to an email using the .attachments.add method but I would prefer to not save the attachment outside of access. I am getting the "Object variable or With Block Variable not set" error. Any help is greatly appreciated. My code is currently: Private...

MajP Your code is simple and works like a charm. The only thing that I did was to change it from a public sub to a private sub since my intent is to use this to populate the Contacts table that is linked to Outlook. This is what I ended up with and it works perfectly... Thanks If...

Sorry me again... I have replaced the original code with a new bit of code that is sort of working. It is returning a truncated string but I cannot figure out how to make it delete everything before the space for LastName and everything after the space for FirstName. This is what I have...

All, I am trying to run some code that splits a Contact Name field into two separate fields. This is what I have so far. I don't usually manipulate data this way so I am stumbling around. Your help is greatly appreciated. Excuse the table and field naming methods... This is a very old table...

I have tried multiple databases and multiple computers but I have not set the references. I will try that and post the result.

I have an access database with several forms. I need the users of the database to be able to use the MS Speech Recognizer but any time that it is turned on, Access locks up. Has anyone ever ran accross this issue? I am looking for a library, reference or Add In that can fix the issue. As...

Duane, I was using this in a make table query which was very slow. The update query is much better. Thanks for your help. Johnnycat

I have a project where I need to concatenate data (employee names) from a field in a table where the field for cost codes in the table match the field for costs codes an open form. I have used the following sql in a query based on a module that PHV and MRemou helped me with years ago. 'This is...

brocsman, This is an event at form level. you need create an event procedure on the After Update event. One of the issues that I ran into was that I had to write some logic to deal with the scenario where one of the filters was blank and I only wanted to filter on the one combo box. That is...

MajP, Thank you!!! Your fix was perfect. This is a huge help.

I have been trying to filter the data in a subform using multiple filters in the main form. Each of the filters work individually as I have written them but my efforts to combine the criteria of the filters has me stumped. The goal is to filter the date in the subform based on multiple combo...

I am dealing with the same issue only on a Dsum not a Dlookup. I have been fine making it work when using a string value but have struggled becuase the criteria that I am using is an autonumber integer. When I change the PPID to a string value it gives me a type mismatch and when use the...

Thanks Randy