Search results

in fact it's right at the very top of that link. thank you.

take one value and see if it matches another.

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...

Hmm. I could never get the query's sort method to pass through to a report? But in any case. I opened the form, selected the sub-report and set the order by field and it's working. Not sure why, I did this several times before i thought, although i may have just done that in the report...

Thank you, I agree, it's a long story but sums up as being lazy. When trying this DoCmd.SetOrderBy "[Compliance Status] ASC" I get the same error. Changing the field name to Compliance_Status gives me the same error. I verified (in VBA) that it reads as Compliance_Status as well...

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...

oh for crying out loud. Date()>=[IRPExpDate]+365 man where was my mind on that one.

i had handjammed it - rather badly. I updated the post and included a screengrab.

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...

appreciate you taking a look

i think you mean scale? We've made sure it was set to 38% (and zoom 100%) before printing - the locations differ. Scale needs to be at 38% to ensure it fits on one page wide.

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...

well what I've got is the following. I have some code above this that sets print ranges and declares the array to print. After creating the PDF the VBA add's in two date fields and two signature fields. The desire is to add in the action trigger on when a signature box is signed - the...

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'm one of the ones that believes that for the most part - there aren't a lot of differences between the two parties. Or rather as years go on, more evidence supports they're the same, just arguing for different dollars. I think as a kid I was liberal, in my early 20's I went fiscal...

I never liked giving up our own ability to get into space. I get the systems were old and costly and never lived up to their intended hype. I very much love what SpaceX has done. they've made space fun again.

In this particular instance, the person arrested didn't.

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...

I was talking about this to my wife the other day. About 6 months ago, when the market came up enough we sold her Apartment.. She bought it before we met at the height of the bubble before the crash. We had been renting it out and at best lost about 250/month, when we didn't have a tenant we...

The entire, write laws to appear tough on crime is a self-feeding situation. Tighter laws which pose more "criminal" situations, which equal more people in prison, which equal less opportunities for not only the imprisoned but their offspring as well... which leads to more criminal actions...