Looking for DAILY news and commentary? Join us on my other channel “Coffee With Steve” for daily videos where we discuss Technology, Software Development, Politics, Culture, and many other things. Coffee With Steve: th-cam.com/channels/eXAUvo5xxDY_b-lSknPC1A.html
Hi, I can't say how great this tutorial is, I am currently binge watching it while making the Service Inc database. The database that I will want to make is for inventory control and management (I am roughly a supply officer in the US Navy, you would think they would have made something like this by now) and when someone receives something from us, they need to sign a subcustody form showing that they actually did get it. I need a way for them through their account login to digitally sign the form. How do I do this?
Hi Steve, I have been working through your tutorials and they have been very helpful and informative. I'm wondering if it's good practice to have all similar types in one table or would it be easier to work with to combine them in the same tables. Any pros and cons. (Example: Having all customer and vendor company names in one table or phones and addresses through one table instead or building a customer address table then building a vendor address table.) Thanks a lot. You have been a big help with learning Access.
+kong vue That is a personal choice, however I tend to stick with like with like. If it's an address it's an address. You can add a column to the address table that indicates what company type it belongs to. Splitting it into two different tables means two different locations for the same type of information.
Hi Steve, Thanks for all the help on these videos. I do have a few questions about forms. 1) When you did your forms it showed all your results in column and row sort of format. How do I make it so that each (I havent seen if i can do grouping in form as you did in report) "grouping" is in a different form page. For example, I am creating a table with companies and another table with addresses. I want in 1 form page to show me the current address. and 2) give me the option to add a new address to that company. (I think I have my tables set up correctly, on table for companies and one for addresses and they have a one to many relationship) Cheers Thanks Martin
Martin Villegas You can click on any of the Header or Footer bars (Except the form header and footer) and change the Property "Force New Page" to before or after. That will cause the content of that section to start a new page either before or after it. This is good for things like form letters and such. Put the content of your form letter in the details of the report, then change it to "Force New Page" after each details section and you'll have a form letter for each recipient.
Steve, Can different forms make use of the same module? Or is it just specific to one single report/form? Also could you do a video specifically explaining the difference between standard modules and a class modules. When should we consider using a class module instead of a standard module? Thanks alot
I talk about classes later on in the course. They are very different from regular modules. As for using the same module for different forms, yes and no. You would need to create a custom module that watches events on different forms.
Hello, and thank you for these lessons, i have a problem with access, i have a form with a lot of fields, when i open it with another form, i got and error msg: "can't open more database". we tried everything but couldn't solve it. Any hint?
Hello There my question about VBA this is my database Table “PMACustomer” contains all records for all Branches, (separate by Branch No. are like 01, 02, 08….) By Making Query “PMACustomerQry “able to ask by Branch No. to show just that Branch records. Form “PMACustomerQryFrm” is an end-user data Form entry. If you open “PMACustomerQryFrm” form 1- 1st ask you Branch No. user type 01,02 or 03) 2- It has a Red Button on this form (Upper Right) 3- I want when I press on this Button “Uncheck “all Checkbox name “Invoiced” 4- But I want just those checkbox showing in this form with that Branch No. 5- If Branch No. change to others still have checkbox clicked (not change other branch checkboxes) If you open VBA on this Button I did some code but I cannot find the argument/code right for it too. My Table contains: PMA_ID AutoNumber PMAName Short Text PMABranch ShortText Invoiced Yex/No My Query SELECT PMACustomer.PMA_ID,PMACustomer.PMAName, PMACustomer.PMABranch, PMACustomer.Invoiced FROM PMACustomer WHERE (((PMACustomer.PMABranch) Like [Please Type Your Branch No like 01, 08])); And My Form: it has Just all field and Default View Continuous Forms but I add a Botton in this form for unchecking all " Invoiced " Checkbox for each record. my problem start when I used this button all record includes records belong to other Branch get uncheck as well, what I want each branch able to uncheck just own checkbox Private Sub Command17_Click() CurrentDb.Execute " update PMACustomer Set Invoiced =false" Me.Requery where????????? End Sub I know my code has missing where or when an argument Could sone one Help me on this code thank you all
Seamus Dillane Not sure I understand exactly what you're asking but I do go over splitting up your database into a front end and back end. When you do that then multiple people can be on the database at the same time.
I need help in developing data entry forms for my access database. I am not sure where to start. Tables and relationships are completed. I want to have one page for name, member status, gender, etc, 2nd page for address, 3rd page for contact infor, etc. Creating a data entry form for one table is ok but that is not what I am looking for. Thanks
Looking for DAILY news and commentary? Join us on my other channel “Coffee With Steve” for daily videos where we discuss Technology, Software Development, Politics, Culture, and many other things.
Coffee With Steve: th-cam.com/channels/eXAUvo5xxDY_b-lSknPC1A.html
A gift that keeps on giving, year after year.
Thank you my friend. I wish there where more people in the world like you.
Thanks for your kindness
Thanks for all your videos. I have learned a lot.
you are amazing thank ypu so much!
Hi, I can't say how great this tutorial is, I am currently binge watching it while making the Service Inc database. The database that I will want to make is for inventory control and management (I am roughly a supply officer in the US Navy, you would think they would have made something like this by now) and when someone receives something from us, they need to sign a subcustody form showing that they actually did get it. I need a way for them through their account login to digitally sign the form. How do I do this?
Hi Steve,
I have been working through your tutorials and they have been very helpful and informative. I'm wondering if it's good practice to have all similar types in one table or would it be easier to work with to combine them in the same tables. Any pros and cons. (Example: Having all customer and vendor company names in one table or phones and addresses through one table instead or building a customer address table then building a vendor address table.) Thanks a lot. You have been a big help with learning Access.
+kong vue That is a personal choice, however I tend to stick with like with like. If it's an address it's an address. You can add a column to the address table that indicates what company type it belongs to. Splitting it into two different tables means two different locations for the same type of information.
Hi Steve,
Thanks for all the help on these videos.
I do have a few questions about forms.
1) When you did your forms it showed all your results in column and row sort of format. How do I make it so that each (I havent seen if i can do grouping in form as you did in report) "grouping" is in a different form page.
For example, I am creating a table with companies and another table with addresses. I want in 1 form page to show me the current address.
and 2) give me the option to add a new address to that company.
(I think I have my tables set up correctly, on table for companies and one for addresses and they have a one to many relationship)
Cheers
Thanks
Martin
Martin Villegas You can click on any of the Header or Footer bars (Except the form header and footer) and change the Property "Force New Page" to before or after. That will cause the content of that section to start a new page either before or after it. This is good for things like form letters and such. Put the content of your form letter in the details of the report, then change it to "Force New Page" after each details section and you'll have a form letter for each recipient.
Steve, Can different forms make use of the same module? Or is it just specific to one single report/form? Also could you do a video specifically explaining the difference between standard modules and a class modules. When should we consider using a class module instead of a standard module? Thanks alot
I talk about classes later on in the course. They are very different from regular modules. As for using the same module for different forms, yes and no. You would need to create a custom module that watches events on different forms.
Hi Mr bishop i searched alot but didnt find your any video on splash screen for access 2013.please do a tutorial on access splash screen
I'll put this down for a future video.
Hello, and thank you for these lessons, i have a problem with access, i have a form with a lot of fields, when i open it with another form, i got and error msg: "can't open more database". we tried everything but couldn't solve it. Any hint?
Hello There
my question about VBA
this is my database
Table “PMACustomer” contains all records for all Branches, (separate by Branch No. are like 01, 02, 08….)
By Making Query “PMACustomerQry “able to ask by Branch No. to show just that Branch records.
Form “PMACustomerQryFrm” is an end-user data Form entry.
If you open “PMACustomerQryFrm” form
1- 1st ask you Branch No. user type 01,02 or 03)
2- It has a Red Button on this form (Upper Right)
3- I want when I press on this Button “Uncheck “all Checkbox name “Invoiced”
4- But I want just those checkbox showing in this form with that Branch No.
5- If Branch No. change to others still have checkbox clicked (not change other branch checkboxes)
If you open VBA on this Button I did some code but I cannot find the argument/code right for it too.
My Table contains:
PMA_ID AutoNumber
PMAName Short Text
PMABranch ShortText
Invoiced Yex/No
My Query
SELECT
PMACustomer.PMA_ID,PMACustomer.PMAName, PMACustomer.PMABranch,
PMACustomer.Invoiced
FROM PMACustomer
WHERE (((PMACustomer.PMABranch) Like [Please Type Your Branch No like 01, 08]));
And My Form:
it has Just all field and Default View Continuous Forms
but I add a Botton in this form for unchecking all " Invoiced " Checkbox for each record.
my problem start when I used this button all record includes records belong to other Branch get uncheck as well,
what I want each branch able to uncheck just own checkbox
Private Sub
Command17_Click() CurrentDb.Execute " update PMACustomer Set Invoiced =false"
Me.Requery
where?????????
End Sub
I know my code has missing where or when an argument
Could sone one Help me on this code
thank you all
Just as a matter of interest....have you gone through having multiple different forms in multiple different access files but all the one database?
Seamus Dillane Not sure I understand exactly what you're asking but I do go over splitting up your database into a front end and back end. When you do that then multiple people can be on the database at the same time.
Can I get access to your Slides for this course?
Unfortunately I did not think to save during the course.
no worries. AMAZING job!
How much can i help you raise in capital to do more videos?
It doesn't cost any money but it does cost time. I would love to make this a full time gig, but the money isn't good enough yet.
I need help in developing data entry forms for my access database. I am not sure where to start. Tables and relationships are completed. I want to have one page for name, member status, gender, etc, 2nd page for address, 3rd page for contact infor, etc. Creating a data entry form for one table is ok but that is not what I am looking for. Thanks
+First Baptist Church Deerpoint Have you watched the entire series from the beginning?
you have a typo in the slides.. cars have brakes applied..
the spelling you used is in relation to working, you take a break.. or you break an object.
Classic programming typo... "ApplyBreak()" instead of "ApplyBrake()" lol!