Search results

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.

Is it possible to open a database Form in the Windows 10 Startup folder ? I want to power up a PC and after the 'Desktop' appears, the MS Access Form opens.

Is it possible to send a VBA text message to a cellphone SMS (Text message) ? If so, please provide sample code. Thanks ! ! ! ;)

BigHappyDaddy/Ridders/Arnelgp/Pat Hartman, Thanks to all ! ! ! I used Arnelgp's solution.

Why is no 'Actual_Name' given when no 'Middle_Name' is provided in a select query ? Below is the syntax of the statement. Actual_Name: [First_Name]+" "+[Middle_Name]+" "+[Last_Name] :banghead:

JHB, Thanks ! ! ! That worked. Also, Thanks MarkK ! ! !

Mark, I deleted the RecordSource property of the form, and delete the ControlSource property of the ListBox control, but now no data on the report. I don't understand why Query_Recreate_Survey is not receiving the Name. The query criteria is [Forms]![Recreate Totals]![Name]. Any idea why ?

Can someone tell me why the 'Name' field in the 'Gift_Totals' table is being updated with the last value of the "Recreate Totals" report that was displayed ? Only the first record for the 'Name' field in the 'Gift_Totals' table is affected. The name is selected from the 'Listbox'. Below the...

Pat/Sean, Thanks ! ! !