Contact Subform SQL instead of query - Microsoft Access Expert 3


	Back to Access Expert 3 Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Contact Subform SQL instead of query

Zachary Pritz

15 months ago

Expert 3 class 3 time stamp 4:45 I typed in the code exactly from your video into the record source under the form propperty sheet Record Source line, but every time I open the ContactSubform, it always says:

"Enter Parametter Value ?
DateTime
(Text box to type response)
[OK] [Cancel]

Here is what I typed in:
SELECT * FROM ContactT ORDER BY DateTime DESC;

I retried multiple times, some with spaces some without but nothing seems to work. Using access in Office 365 (latest one Jan 1 2025)

Any suggestions would be greatly appreciated!

Also, how do I post screen shots here? Important instructions below in the start new conversation window says to be specific and post screen shots, but I dont see where I can post anything.

Thank you for the help guys! I REALLY dont want hundreds of queries for simple tasks liek this!

-Zachary R. Pritz

	Zachary Pritz OP @Reply 15 months ago

	Zachary Pritz OP @Reply 15 months ago

	Zachary Pritz OP @Reply 15 months ago
LOL I figured out how to attach the screenshots after I posted my question. :D

	Kevin Robertson @Reply 15 months ago
Your field is called ContactDate, not DateTime. DateTime is the Data Type.

Zachary Pritz OP @Reply

15 months ago

By the way... I freaking LOVE these lessons! Thank you Richard for your hard work, dedication and detail in getting these videos out! I am building a database from scratch to run my small machien repair company from after wasting close to ten thousand dollars using, testing and deleting several other pieces of software. Nothign I found did everythign I wanted. My wife finally convinced me to just build my own (which would be a completely impossible task without these classes and this awesome group of people assisting with questions and problems. I'm a machine technician with little computer skills and zero programming knowledge. Tried doing everything in excel but it just didnt do everything I wanted.

	Zachary Pritz OP @Reply 15 months ago
I also tried the builder, same issue. I tried to reformat the DateTime field to General DateTime instead of how I type them in (yyyy.mm.dd hh:nn) No joy on all.

	Richard Rost @Reply 15 months ago
One step at a time. Remove the SQL statement and see if it just works if you make the recordsource ContactT by itself.

	Kevin Robertson @Reply 15 months ago

Zachary Pritz OP @Reply

15 months ago

Thank you guys! I went back in and changed it from the query I made back to the text Richard had in the video, with the correction that Kevin pointed out in my text. That fixed it! I thought in the video when Richard put DateTime in there that it was referring to the data type. I didnt notice that he named his field DateTime.

Thank you guys so much for your help! I cant wait to get to the later expert lessons so I can start working on my parts inventory and order form portion of this database.

You guys have a blessed evening!

Richard, safe travels man! Sorry to hear they made you miss your connecting flight! Growing up I used to love Delta. I dont fly much but am looking forward to how things have changed over the years! Ill be flying up to Minnesota some time this year for some training at Graco's headquarters.

	Zachary Pritz OP @Reply 15 months ago
Kevin, I didnt realize while I was typing my questions and updates that you had responded while I was online. I apologize for missing that! I greatly appreciate the rapid response there!

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Expert 3.

Next Unseen

New Feature: Comment Live View