I made so far 2 GB database, forms, queries, reports etc.; first used a book, then expanded it into to the next level using your demos, tricks and tips. Simply the best tutorials from scratch to the expert level... Thank you!

Thank you Richard. Your tutorials are priceless. I can't believe it took me this long to find you.

@599CD

Жыл бұрын

Welcome. :)

Very informative. Haven't used access in a while, so I needed a refresher, and this was excellent

BTW Richard, I purchased your Work Order DB seminar over a decade ago and created my own version of it and sold a copy of it to a construction company who requested some major upgrades and now it has morphed into a completely new product! A friend of mine and I are now working on a whole new version and it will include this lesson (at least a version of it!), meaning I will take this idea and expand on it to include a lot more information than what you show here. Of course you are just showing a simple concept, but the beauty of showing a simpkle concept is it sdparks an idea for more complex features for peracticle use!

Great tutorial. I like to build these in C# or VB. Create the form first, which serves as the flow chart, then configure the controls and link to the database.

@599CD

2 жыл бұрын

Cool.

You Sir are a star. Fabulous enthusiastic explanations that will help me design and create a database for servicing in-house equipment at work.😁 Thank you very much for sharing your knowledge. BH (England)

@599CD

2 жыл бұрын

Welcome. (Florida)

What there could be is a button for the color to add the new color to the list for future use. I personally like doing that so that 5 different people don't have 5 different abbreviations of different words! I like combo boxes for that reason! So that the choices people make are always spelled the same!

Hello Richard, I really enjoy your videos. I have learnt a lot from them. I have bult my first data base after watching your videos. Excellent learning courses.

@599CD

2 жыл бұрын

Great to hear!

Great Tutorial. it helps me a lot. I want to keep learning from your tutorials.

@599CD

Жыл бұрын

Thanks

We love your work instructor Richard Rost. Thanku

@599CD

2 жыл бұрын

Welcome. I appreciate that.

What a fantastic resource, thank you so much I am enjoying these tutorials :)

@599CD

2 жыл бұрын

You're very welcome!

OK Creeps! Who the h311 can dislike this!!!!! This guy pours out FREE videos that are actually useful. Come on folks.

@599CD

3 жыл бұрын

I know, right!? Then again, I do that to other peoples' vids that I don't like... especially when I can't understand them, they talk too slow, they're boring, or they teach something wrong. So... probably my competitors. :)

This is awesome! I decided to follow along and build this for my car history that I’ve been keeping in excel for years. I even added an ‘add new record on top’ using unbound txt boxes and a append query then an add button that runs the append query. But I’ve run into a problem. The new record I’m append wants to add the new record 264 times to the table. I’m not even sure why or how I would go about fixing it.

@599CD

Жыл бұрын

New Record on Top: 599cd.com/NewRecordOnTop

Great way Thank you very much Sir

@599CD

2 жыл бұрын

Most welcome

Thank you so much

@599CD

3 жыл бұрын

Welcome

Hello, Great video this is exactly what I am looking for except for it to be tracked by Truck number not by customer and I can not seem to figure out how to do it.

@599CD

Жыл бұрын

Just use a truck number field instead of a customer field

Nice video!

@599CD

3 жыл бұрын

Thanks

Thank you my instructore

@599CD

3 жыл бұрын

Welcome

@abdulhamidalhaddadi2255

2 жыл бұрын

@@599CD I love this post :)

Nice Video , Thanks for uploading

@599CD

3 жыл бұрын

Welcome

i love your videos. I have a question, how can I build microsoft access log to track the maintance of kiosk POS in a laundry service?

Wow ur grt

Hello Richard, I have been having trouble getting the Model query for the combo box to work, it asks for a parameter value ? and displays [Forms]![tblVehicle]![MakeCombo], I named my tables with a prefix of tbl. Don't know what I am doing wrong, Yes! I watched the Cascading Combo Boxes video. Thanks

@599CD

2 жыл бұрын

599cd.com/EPV

@rayt6867

2 жыл бұрын

@@599CD I figured it out, I had tblvehicle instead of frmVehicle. Many thanks.

Learning a lot from your videos. Thanks a ton. Question: I did something similar to you in this video, I attached a continuous form to my boat form so I could see all the service done for that boat. Within my service form, I have an "employee name" field. When it displays in the continuous form attached to the boat, it shows as the employeeID rather than their name (which is how it is displayed on the actual service form). Is there a way to change the display of a field on a continuous form?

@599CD

10 ай бұрын

599cd.com/ask

Great! However all my vehicles have same services but due at different miles and/or months. How do I set up?

@599CD

8 ай бұрын

599cd.com/Ask

Hello Richard, I love your work man. My question is I want to create a registration form that if a person needs to register he must have a list of 5 people. And you can't be allowed to register if you don't have the full five members. How am I going to that please help

@599CD

3 жыл бұрын

I cover checking for a MAXIMUM number of attendees to an event in the Extended Cut for this video: 599cd.com/EventEnrollment - to do the MINIMUM like you said, it would be a very easy change.

Followed video and everything works just fine except that the maintenance history does not change when I change vehicle. I've gone through the video several times and cannot figure out why the maintenance history doesn't change. It is like the form/subform relationship doesn't exist. Figured it out. It did not create the link between the master field and child field.

@599CD

2 жыл бұрын

There you go. It's always the little things. Access (programming in general) is very detail specific.

Sir, In my salary database, I have an append query that updates records in payroll table from salary table whenever I run this query. But it appends duplicate records also. Is there any way that automates the entire task of finding duplicates and delete them from original table. I want to avoid manual option because this database is used by novice users, who do not know the handling of tables and queries etc.. Thanks in advance.

@599CD

Жыл бұрын

Yeah I'm sure it will be possible to find duplicate records first but without seeing what you got there it's impossible for me to tell you what's going on

So I have a question for you I am a gold member on your web site is there a way to access the KZread member content or am I limited to the web site only.

@599CD

Жыл бұрын

If you signed up on my website, you have to watch stuff on my website. I have zero control over KZread memberships. See 599cd.com/KZreadVme

great tutorial but i cant find your template i would like to see it to go along with your video

@599CD

Жыл бұрын

Link is right in the description: 599cd.com/Vehicle

Is there a way to make it so end-users only see the forms? Let's say access was running on a server and The user had on their desktop a "Add Vehicle" icon. That opens up to only the form?

@599CD

3 жыл бұрын

Yep: 599cd.com/SimpleSecurity

Hi Sir, We have to submit Bank Management Database (Basic) in the next 2 weeks. It's real pain in a** because I don't have enough time to study Access from scratch. Sir, my question is how can we put conditions in form and how can we pass the value by entering the specific field in another form?

@599CD

2 жыл бұрын

599cd.com/FormName

How I count deductions if the equipment down?

@599CD

3 жыл бұрын

Mark the item "down."

Hi sir can I ask for help?

Can I get this download file? could you please give me the price ?

@599CD

Жыл бұрын

Vehicle Maintenance: 599cd.com/Vehicle - Gold Membership is $9.99/mo.

The combobox name thing is seriously annoying.🤯 It would make live so much easier if the wizard would ask for a name.

@599CD

5 ай бұрын

Agreed

😂23:16 you didn't select the VehicleID

@599CD

3 жыл бұрын

Yep. You're right. I missed it in that instance... however just watch... half the time I select multiple fields there are usually one or two that DON'T change.

"CAMADO!! ... "Camado...???" HAHAHA

@599CD

3 жыл бұрын

It happens. I once typed my own name wrong in an Excel class (live) and didn't catch that it was up on the screen for most of the class. At the end, people were leaving and saying to me "goodbye, Mr. Root." After like 3 people said that to me, I was like WTF? Didn't realize what I did until everyone had left and I was cleaning up. LOL