Search results

Re: An Attention Seeking Database I guess I was warned, right in the thread title...

You're welcome, glad to help! :) But to clarify -- you said it's not a "publicly accessible" database... if you're referring to my comment about changing the sub from Private to Public, you may have misunderstood: Public Sub - can be accessed from any module within your database Private...

@Steve2020 - If..Then..Else can be on one line (without an End If) if you're only giving it one statement to execute, like shown on MSDN. If 1 = 2 Then Msgbox "Uh-Oh" Else Msgbox "Universe Intact"Select..Case is a good idea as long as you only need to meet one set of criteria, so that wouldn't...

You can call a button's subroutine from a macro, but there's probably a better way to accomplish whatever it is you're trying to do. Usually any code that you want to be "publicly accessible" would be moved to a module, where it can be called by any sub or form. With more info, we could...

Welome to AWF! :)

Very cool but indeed it's awfully slow.

Check it out (if you haven't already): Karl E. Peterson's Monitor API tricks and here's a keeper: API Cross-Reference (hopefully something in there will inch you closer!)

Something else I noticed; I'm not sure what exactly you need to display but I suspect there's a mistake in the filter criteria (possibly unrelated to the error you're getting). I think a fairly common mistake when comparing date-parts like you are is to "not compare all date-parts equally"...

Is the report's Record Source set to Qry_CARenew or is there more to it than that? What is the SQL behind Qry_CARenew ?

"dang regional date settings"... déjà vu (Just to mess things up, I prefer the 'none of the above' setting of yyyy/mm/dd specific to my region of a 3-foot circle around me. Makes sense to me since it can be sorted as a date, text, or numbers, with the same result.)

You're a little vague. (It can be tough to visualize what someone means over the net, in writing.) If I understand correctly: You have a form called Stockout with a textbox called Qty? A separate table called StockIn has a field called TotalStock? The form Stockout creates new records in a...

Ah yes, the good ol' 'Stack Overflow' error, which can be caused by various things; I'd describe it as usually caused by a coding error that uses up a part of memory that's set aside for remembering where the program is, with recursive processess... including nested If statements that aren't...

This should do the job...Select tbl_MainBooking.[ID], tbl_MainBooking.[CustName] FROM tbl_MainBooking WHERE NOT EXISTS ( Select [ID] FROM ( Select [ID], Call_Date as [ContactDate] FROM tbl_PhoneCalls UNION Select [ID], Email_Date as [ContactDate] FROM...

I think you're close. The "full URL" method is: Your examples like ftp://user:password@ftp.site.com must not have @ or ftp more than once in any case. Correct: ftp://user:pass@subdomain.domain.ext like ftp://myusername:mypassword@mysubdomain.ucoz.net You...

2014? Bah, there were no such thing as analog clocks that long ago. I invented it, okay? Pfft. "2014," he says...

In which kind of ActiveX control do you need a subhyperlink?

Put this before your msgbox: DoCmd.SelectObject acForm, Me.Name

hmm, I'm still not clear what you're dealing with... (some db's are harder than other to describe over a forum!) I made a quick Excel sheet showing what I *think* you mean. If that's what you're heading towards (I called it tblVehicles), with an attached combo box then you're pretty close to...

It's tough to picture your setup without a better idea of the data you're dealing with, but it sounds like what you need to combine the Four ID tables into one, so you can compare it to another table. If so, that's where UNION queries come in. I assume the reason you have 4 table with ID's is...

I love-to-hate figuring out recursive procedures! ...but are you aware of the JOIN function (the opposite of SPLIT)? It does the same thing as both your joinArr and joinStr functions: Join(arr, "\")with any mix of data types, and can skip blanks with: Replace(Join(arr, "\"), "\\"...