Search results

Galaxiom, Got it, but which one is for e-mail notification for answered questions ONLY ?

I don't see a 'Control' panel. Where is it found ?

Ridders, That worked . . . Thanks ! ! !

Is it possible to get an e-mail when someone answers a submitted questions ?

Pat/Ridders, I'm running the code a button on the form. The statement is as follows: Right(Year([NextPaymentDate]), 2) & DatePart("y", [NextPaymentDate]) Unfortunately, I'm not getting a leading zero for two (2) digits dates. If it possible to use the above command for two (2) digits date...

Pat, I tried your suggestion (shown below). Nothing is being returned. What am I doing wrong ? 'NextPaymentDate' is a textbox on the form. Format(NextPaymentDate, "yy") & DatePart("y", NextPaymentDate)

Arnelgp, I'm receiving the below error for your recommended (as shown below) VBA statement. It appears that a reference is missing. Which one(s) is the statement looking for ? Undefined function 'JulianToDate' in expression DoCmd.RunSQL "Insert Into Bills (NextPaymentDate) SELECT...

Ridder, I'll try adding the shortcut to the 'Startup' folder. If this is still slow, I'll re-read your previous comments. Thanks ! ! !

Arnelgp, Thanks ! ! ! I'll try this . . .

Ridders, The report in the database can not dragged into the Windows 'Startup' folder. Also, this report changes (based on the date).

Ridders, I'm referring to the Windows 'Startup'.

No, just answering someone's question.

Static, This worked . . . Thanks ! ! ! . . . But it loads very slow. Anyway to speed it up ? I have a report starting upon opening of the database.

Plog, What I'm looking for is julian date format of yyddd.

Ridders, Sorry for the delay. I have not had time to devote for the project that I'm working on. To answer your question, I'm was referring to ===> yyddd date format. Thanks ! ! !

How can I locate all questions that I submitted for all forums ? Currently, if I miss logging in, then I have go thorough each screen of questions to find mine (no matter which forum).

I have a form ('Form1') that has a listbox ('Listbox1'). I want to double click on the listbox value and select a date from a textbox ('Date/Time' type) and add this record to an existing table. I figured out to get the value from a listbox (see below), but can't figure out how to add the...

Plog, I used the below format for my query. Do you see a problem with this ? SELECT MyDate.Bill_Desc, MyDate.DeliveryOn, MyDate.Category, DateDiff("d",[DeliveryOn],CDate("1/1/2018"))*-1+1 AS JulianDate FROM MyDate;

How can I convert a field (with a date) to a Julian date in a query (SQL) ?

Thanks ! ! ! I'll try this.