Видео

Thanks for videos. I'm using inputbox to get a string to add to a sql query. I get 3464 data mismatch error. The field1 is short text and I set dim s as string. Sql is ... field1=" & _ s & " and field2 is null" It's driving me crazy. Thanks for any help.

Hey, Great videos Can you copy from the selected text field without writing the textfieldname? If you have multiple textfields an only one copy button. Can this be done in VBA?

Can you tell me how you got the Address Type Combo box to connect to the CustomerXAddressT and show the Address Type and not the AddressTypeID? You don't show it in the video. I can't get it to work.

I’m the same with parentheses, even when not strictly necessary it makes it easier to read, which makes it easier to change in anyway.

Yeah I would like to have seen how to apply the discount to the order another excellent video very educational

I spent the past 6 hours this morning pulling my hair out trying to figure out how to do this. Turns out I was using the wrong phrasing with Google trying to describe what I wanted to do. Anytime anyone tells me that they think I'm smart I'll probably tell them about this morning, but I probably won't be able to describe what happened making me unsuccessful in convincing them that I am an idiot.

Hello from Australia. I would love to see the next lesson.

Your mission will fail ... lol, I prefer and use dd-mm-yy .. pet hate the other way around ... sorry ... lol 🤣🤣

Thanks

where can Hyper snap available

Next game lottery numbers sir

Will this work on a compiled shared database file?

Fond of BT BT BT rather than beep.

Thank you

Well Done Very clear teaching without puzzles Very much thanks from Egypt Thanks a lot

YOU SPARKED A NEW IDEA IN ME

CREATIVE PERSON

WOOW :)

GREAT SIR

CAN I DO IT WITH MS EXCEL TIME SHEET?

Great content with excellent delivery. I'd like the next lesson , please.

how can I send the missing data only, instead of send all data to update.?

Good morning and yes how are things without a license

Whoah😮

Thanks

I set up the DOB field with a default value of 1/1/3000, if you don't mind having a strange DOB. In the BirthdayQ change the DOB criteria to <date+1 This will show all except for the dates greater then today. Then you can create the Birthday lookup query and all will be displayed except for the birth dates that have not past yet. Create a form either (Form or Continuous) from the table and then create 2 conditional format rules for the DOB field. 1) "Has focus" and set background to white and foreground to black. 2) "Value" = 1/1/3000 (or what ever date you pick) foreground and background to white. This will hide the date as long as the date value is 1/1/3000. once the DOB field is clicked then the text becomes black. If the value is anything else the text will be black.

Richard - I love your videos. I spend many hours trying to decipher Microsoft's page and one of your 20 minute help videos on vba cleared most of my questions (I'm still working on syntax between SQL and vba and internal Queries). In my database I'm trying to figure out how to keep all the links straight in my head. Sometimes the relationships look like spaghetti code. any tips for getting them aligned so they are readable?

I love Richard's personality

This is brilliant video thanks very helpful I used a sort order field in the table to achieve the same thing but very good learning a bit of SQL is also very helpful as always I really enjoy your videos

What Shadow.Dragon said. Have more of statement than question, would think runtime not required if db is compiled, ie. An exe (compiled) database is created for distribution.

Great one

Best god damn series on RUclips it’s like a nostalgic vid from the 2000’s and so easy to understand

Thanks

I have a Union query that is supposed to combine Sales profits with Service fees for a defined time, to get a combined profit. I have separate sales and service queries but if I add those two totals together, it’s different than the union query total. Not sure why but I’m trying to find it!

Thank you!

I made an Email Template especially for this form, how can open it as an email body and current Customer name?

In the extended cut we will auto buy a random Amazon gift based on aggregate data about preferences under $5 and have it delivered on their birthday!

What path do you use if you want it to export to the users desktop

This is lovely

Tks. Some queries gave the exact problem explained in this video, and yes, the second quey is not always the salution, especially for a report or form with a complex recordsouce! So, i then go back and re-Eval the output and go from there... SIMPLIFY!

If this were a form, I’m assuming it would be possible to do this using SQL statements (perhaps one statement) in VBA instead of queries ?

How to find the SQL for a book table cause im not fonding it

Why is the first letter at position=1 instead of position=0 like it is in coding?

You lost me at "I love Picard more." Just kidding 😉 I'm a huge fan too, but Kirk will always have a special place in my heart, growing up with him. Great video as always!

This reminds me of auto vin numbers.

Enjoy watching your vids!

Thanks 🙏 so much

Great tip! I use all the time querys from querys from querys... It' much more easy to debug. 😊

Oh I thought I had found my answer but it’s not worked for me ; I have a time field in an access table, shows 17:01:45; I then used the hour function in my query but it just didn’t work, comes up with a very unhelpful comment …. There was an error compiling this function . I just want to see the hour part