Search results for query: *

I am building emails in VBA and would like to define the overall font for the body of the email. I would also provide text that would actually be a hyperlink, such as: go to this our SharePoint site and it would go to that site, or People names that would be a <mailto> link. I currently have...

I have this question posted in another area of this forum and didn't get any responses so I am posting it again here. Hi, I've been successful in sending emails using Outlook templates (oft) for only text and hyperlinks. But now I have a template that contains a table with images and text in the...

Hi, I've been successful in sending emails using Outlook templates (oft) for only text and hyperlinks. But now I have a template that contains a table with images and text in the table and it only creates the email with the text remaining in the email. Is there something else that has to be...

Hi, I had a thread a while back thread702-1783846 ["Access 2016 append query "long text" field is being truncated"] and was helped with a workaround. Just curious if anyone knows if Access 2016 has been provided a fix for this issue and would know the release number? I am continuing to...

I have a table with a field [Table].[LOBManager] and I need 2 queries where in 1 I need find out if the record has one of these values and another where the record does not contain any of the values. Values = “Cheri West", "John Smith", "Peter Brown, III" I tried: In “Cheri West" Or "John...

Hi, I have an update query with the following criteria: Like "*OS:*" Or Like "*Firmware:*" Or Is Null and when there is a match another field gets updated with "ECS Shared". The logic finds the OS and the Firmware but does not find the Null. I also tried putting the Is Null on the 2nd Criteria...

For Access 2016 is there any difference between copying a database to another name when you do a file - save database - save as..... or if you just use file manager to copy the database.accdb to database2.accdb? It is taking forever the 1st way and I have already compacted the DB. I do work...

I have 2 tables with a 1 to many join and the key id is the join. The many table has a date and I would only like the record with the most recent date to be joined if there are more than one. I built a query where the date field criteria is max([date field]). That field could be Null but I...

I cannot find the Developer Tab in Access 2016. It displays in all the other office products but not Access. My Help desk has not been able to determine why either and want to down grade me to Office 10. Has any one encountered this? I am new at this company and wanted to build an Access...

I have a spreadsheet that is linked to 2016 database and when I append it to access table it truncates the data. I've read this is new in 2016 but have not found a resolution. Does someone know of one? The linked spreadsheet table contains all the correct data. Thanks!

I am hearing from people who do not develop in Access/VBA saying there will be massive changes both from a user perspective and developers while using Office 365. Is there a website with any idea of what those changes might be? Thanks!

HI! I have this code below that I have referenced in another thread but that thread was not trying to solve what I am trying to resolve in this thread. The other thread is http://www.tek-tips.com/viewthread.cfm?qid=1775583 What I need to resolve is in this code below is that I am setting up to...

Hi. I am using Access 2013 and using DoCmd.TransferSpreadsheet acOutputQuery to output a query of a table to an excel template that has all the columns formatted and I call a routine that I use for many different reports. Each report has it own template but they all use the same export...

Hi, I am Using Access 2010/VBA. I am having problems creating inline SQL INSERT. Here's my code. The strSQL contains the sql and it doesn't like it no matter what I do: Set db3 = CurrentDb() Set rst3 = db3.OpenRecordset("tbl_Mass_Upload_Template_Specialist", dbOpenDynaset) Do...

Hi, I am trying to call an excel macro from a Access 2010 DB and am getting a "Run-time error '9': Subscript out of range" at the obj.Run statement. I am certain it is how I am referencing the macro. I've tried changing it multiple ways and the errors just get worse: Dim macrofile As...

Hi, I have a form and a subform. When the form opens it displays all Item Numbers that are for a particular project which is determined when the form opens. That all works correctly. I then have a hyperlink on the Item Numbers and want to open a detailed form for that particular Item number...

Can the where condition in the Open Form argument contain a field that is defined as Text in the table used in the form or does it have to be a field that is defined as Number? I have 2 different forms that have subforms and on the subform one of the fields is a hyperlink with an on click event...

Hi, Has anyone experienced Access 2010 VBA code not working for Access 2013 users? I have an export procedure that I have in many databases but now that Access 2013 is being rolled out by our deployment group the code doesn't work. It is basic VBA that exports a query to a xlsm Template and it...

Hi, I thought that the following would only add 10 to the week days (business days M-F) but it is adding 10 days including weekends. Is there another way, easy way? I've seen a lot of coding examples but I thought there would be an interval setting that could be used? Here's my example...

Hi, I have added a Text field and filled it with blue color just so it will display at top of form. I then have a title, logo and buttons that I've placed on top of the Text field and have positioned it to Send to Back. But every once in a while when I click on the Blue text box it moves it to...