Search results

good morning, I do not usually use multidimension arrays but a project i am working on has a good use for it - i just need to quickly compare data. The table is 4 fields and about 168 records. When i use dim reqAP as Variant reqAP = rst.GetRows(rst.RecordCount) it pulls it into an array...

Hello, I have a report based on a query that i inserted into a form. The report has one visible field and two not visible fields. The report just lists identifying numbers (AP Acronym) and when a specific identifier is selected, the form displays all information relevant to that identifier...

I've got a number of date fields but focusing on one where the text box is named "IRPExpDate". I want to display conditional formatting based on the date in the box. The target being highlight when it approaches 60 days from 1 year past the date in the text box, then 30 days and finally when 1...

I have an excel sheet that creates a PDF, then opens it and add's a couple of signature boxes and form fields. All that worked perfectly fine until recently (I believe we just got office 365). Now - for some people the signature and form fields are in their normal location, for other people...

After printing to PDF, I have vba creating a PDF form field. What I'm needing to do (and can't find) is how to set the format of that PDF form field to Date format? I've found this in adobe's DC JS VBA bridge docs that Field SetAction has a ctrigger of "format" but they do not show how to...

I was reading the case about where Clark Baldwin was arrested for the murder of 3 women almost 30 years before. What stood out to me (other than Baldwin's actions) was they were lead to Baldwin via a search of a commercial DNA company and found a familial match. I thought that seemed odd...

https://www.msn.com/en-us/money/companies/americas-business-of-prisons-thrives-even-amid-a-pandemic/ar-BB13KXPB?ocid=hplocalnews

Kind of odd. I have the following code creating a table inside of another table's cell. What is intended to happen is the first table writes a few rows out, then when it gets to a particular cell, it then creates the nested table and starts to populate it. When that's complete, the first...

Here is the source query for my report. qryFamiliesWEnhancements Title Impact Control_main Enhancement Wireless Access Low, Moderate, High AC-18 Wireless Access | Authentication And Encryption Moderate, High AC-18 (1) Access Control For Mobile Devices Low, Moderate, High AC-19...

Good afternoon. I've got a query that pulls values that are sometimes null and other times not. What I'd like to do is on a form have the user select - Show only not null items - Show only null items - Show all items. and use that choice in a query. My feeling is if I can pass Null, NotNull...

for probably no reason at all I banged my head on this for about a week looking at it here and there. Inserting a table of contents was straightforward, as was setting the margins. the table in the header though.... oye. Dim oDoc As Word.Document Dim oWord As Word.Application Set...

Hey folks. I'm a bit tired this morning and excuse me for this but the question seems so familiar - I just can't think how to frame the question properly to search for it, and I'm pretty much out of time to work on this project. I've got a sub that wouldn't compile due to it being 85kb vs...

my VBA dynamically writes several tables depending on criteria and works quite well. For example here is adding a row, formatting it and advancing to the next row. oDoc.Tables(t).Rows.Add 'add a row below control number...

Hello, Having trouble getting access vba to set a word document's header properly. I've got this. oDoc.PageSetup.DifferentFirstPageHeaderFooter = True oDoc.Sections(1).Headers(wdHeaderFooterFirstPage).Range.InlineShapes.AddPicture "C:\Users\mr.helpless\Pictures\doody.jpg"...

I'm following this which works fantastically if I put in what the example says to to call ? NthXDay(dateserial(year(date), 1, 1),vbMonday, 3)But I need to set that dynamically. DateSerial part is no problem, it is the vb(Dayofweek) and the Nth of that day that I cannot get to work. Breaking...

I currently have this set as the forms default recordsource (which works just fine): SELECT TOP 5 tblUsers_Phone_Book.EMAIL_ADDRESS, weightedDL('me@mine.com',[EMAIL_ADDRESS]) AS Expr1and i have this vba to dynamically switch around that email address. Private Sub Form_Load() Dim intPos As...

When trying to match people's names - sometimes with a middle initial, sometimes without - I'd like to try to wildcard each side of it. So this varProblem = DLookup("EMAIL_ADDRESS", "tblUsers", "EMPLOYEE_NAME Like '" & varString & "*'") but also something like this. varProblem =...

I have a bound form that normally is opened via macro. Very straight forward just has the following in the where. [userID]=[Forms]![Home]![txtSelectUser]I'm trying to open the same form via doCmd. DoCmd.OpenForm "frmUserInformation", , , "UserID=" & Me.txtProblemIDI've msgbox'd the...

In my Access 2013 Database I have a form for user information "frmUserInformation" (stored in tblusers) normal details are in there, last name, first name, etc. I have a related table for user submissions and other submissions both tied back to the user id in tblUsers. All normal everyday...

When I run this code to create a word doc - the first time no problem. Second time it pops the Error 462 error. Research on it shows it's usually when ActiveDocument is referenced without specifying the word.Application first. All that is fine I only have that in one location and it's...