Search results

another instance where old advice worked for today. I've been plugging away at a create nested tables vba and this error kept popping for me even though the document appeared open to me. Low and behold there were some orphan word instances open. Killed them all via task manager and no issues.

@The_Doc_Man I'm familiar with various Fed audits - although not of the accounting nature. And in my past I've had to uncover/prove theft which I largely did based on invoices. I get it but to me it just seems like an information security gap. Granted not as bad as having a predictable order...

Very true - and law as far as VAT is concerned. Probably doesn't apply in this, but just an example. Personally, I shiver at the thought of allowing - nah, making it Law to follow a predicable numbering scheme when it comes to doing business. @Micron just make sure nothing refers to that...

What's in the "blah blah" is the core of America. By and large most people understand the seriousness of it. Here in my State only essential business's are open. I can still go to the grocery store and try and find something to eat. I can go to a hardware store and get stuff to fix broken...

a subreport did work. Additionally I set the On No Data event to cancel=True to suppress the subreport if no data was to be found.

attached, just close the form that shows automatically then open rptRSCDGuidance. Enter "moderate" when it prompts you. I think what's going on is, I have txtControl set to not show duplicates and that makes it work in report view. For some reason that doesn't carry over onto print view. it...

i'm running into another issue with sorting & grouping on a report. in report view it correctly orders and groups - I put it into print view and it doesn't. frustrating.

You cannot do anything to a system that cannot be undone (short of killing the system) by someone with physical access to it. You're allowing physical and administrative. Change DNS? i'll change it again. Password lock it? i'll crack it. Bios lock it? I'll unlock it. Give me physical...

that would explain it I guess. I'm sure there's some reason for it, not one i can think of though haha. thank you.

Interesting, I put this in the on Print event and it works. Is there not one that would work for both print and screen? Private Sub GroupHeader3_print() If IsNull(Me!Enhancement) Then Me!Enhancement.Visible = False Me!Text9.Visible = False Else Me!Enhancement.Visible = True...

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

In a manner of speaking. I ended up needing to rewrite the query SQL. End of the day it looked very similar to what arnelgp put.

Thanks folks, rewriting the query certainly worked. Not sure why I didn't think of it to begin with.

... although I suppose I could do an event that rewrites the query's SQL..?

Thank you Doc. Not that fancy, (adding a screenshot of the Query design and the form where the value would be selected from. The "Via" field is where I want to have the criteria based on the form frmSelect cboType field.

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

you're right, I meant to add the dim's but alas, I forgot.

it's pretty awesome and personally I think this site is more useful than StackOverflow for this particular application. And that's saying quite a bit.

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

that is fantastic advice Doc and I had originally intended it to be like that of sorts. end of the day I wound up with a rats nest that works. I'm damn near ashamed at how terrible it is but I'm just out of time.