This is a great video! Please can you do a followup to this video? I'd like to see from here at print time when the report is selected all the reports fields in a in and out listbox; the user can select what columns to print, sort and group options, and landscape / portrait toggle; print the report; and finally save the settings of the report under a new name to be recalled at a later date? I know that's a lot...LOL...but it would help out greatly!
Is there a way to have the listbox autosize according to how many reports are in the list? So if you add more reports you don't have to go back and resize the box to fit.
You could dynamically resize the list box based on the number of items in it I cover something like that here: 599cd.com/ResizeForms. But honestly though for this boxes that's what the scroll bars are for I would sit at the one size and then just have the user and down.
Hi! Thanks for your videos, I am learning a lot from them. I want to use Access to better manage my stock. However, I have more than a 1000 different products, which, one same product sometimes are located on many different locations (shelves) and quantity. For this reason, my stock table has duplicated values of quantity, shelves no. and product no. As the access do not accept duplicate fields (in this case, the product no. is the primary key), do you have any suggestions or templates to help me? Thanks for your time.
Good question. Perhaps have a StockLocationT table that would be LocationID (front counter, back shelf, etc.) and then a ProductID and Quantity. Now you can see which location has how many of whatever product.
I have suggestions Can u make ur video by to methods 1. By Macros only 2. By VBA Because some of people thire VBA is disabled at work for Security Reasons
I cover a lot with Macros in my Advanced series starting with 599cd.com/ACA1 - but I don't do a lot with macros outside of that. I personally don't like them. Sorry if you have an overzealous IT staff where you work.
Hello! I am currently trying to create a form to where I select a specific report from the several I have and then it allows me to filter by company name once I select it. Very new to access but you have any ideas?
Hi, Is there a way where I print records (data) after a specific date? Example: I have 80 records from the beginning of the year until now. I want to be able to print 10 records from 01-August-2021 until 28-August-2021. If the above is possible, can I have a field near the list box where I enter the date and select the report from the last box and print? Thank you so much for all your help
What is wrong with this (using queries instead of reports) Private Sub RunQuery_Click() If IsNull(QueryList) Then Exit Sub DoCmd.OpenQuery QueryList, acViewNormal End Sub
all thumbs up to the most useful tutorial as always. wish i could subscribe millions times to Richard. thanks
Talk to a million of your friends. :)
Thanks
Welcome
thank you so much for this one
You're very welcome!
This is a great video! Please can you do a followup to this video? I'd like to see from here at print time when the report is selected all the reports fields in a in and out listbox; the user can select what columns to print, sort and group options, and landscape / portrait toggle; print the report; and finally save the settings of the report under a new name to be recalled at a later date? I know that's a lot...LOL...but it would help out greatly!
I actually have something like this coming up for a Developer class or Seminar. Stay tuned.
Good Work .. Thank You
You are welcome
Sir!
My Form is Pop Up "Yes"
how can i open report in Window Mod as Dialog from Combo Box to Display Specific Reports.
I don't like Popup forms. Difficult to work with on multi-monitor systems. Reports have the same properties and work very much the same way.
Love it!
Thanks!!
i want to save all invoices in table list then if i click one then edit and print..
Shouldn't be too hard to set that up.
How to blank a listbox when form on loaded
Depends on the listbox
Well done
Thanks. I like to hear that... just not when I'm cooking a steak. Medium rare for me. :)
@@599CD hhh,I don,t mean that
You are genius
10 out of 10
Is there a way to have the listbox autosize according to how many reports are in the list? So if you add more reports you don't have to go back and resize the box to fit.
You could dynamically resize the list box based on the number of items in it I cover something like that here: 599cd.com/ResizeForms. But honestly though for this boxes that's what the scroll bars are for I would sit at the one size and then just have the user and down.
make a video on dropdown button list
I have no idea what a "dropdown button list" is. Can you elaborate?
God of ACCESS
You or me? :)
Hi!
Thanks for your videos, I am learning a lot from them.
I want to use Access to better manage my stock. However, I have more than a 1000 different products, which, one same product sometimes are located on many different locations (shelves) and quantity. For this reason, my stock table has duplicated values of quantity, shelves no. and product no. As the access do not accept duplicate fields (in this case, the product no. is the primary key), do you have any suggestions or templates to help me? Thanks for your time.
Good question. Perhaps have a StockLocationT table that would be LocationID (front counter, back shelf, etc.) and then a ProductID and Quantity. Now you can see which location has how many of whatever product.
I have suggestions
Can u make ur video by to methods
1. By Macros only
2. By VBA
Because some of people thire VBA is disabled at work for Security Reasons
I cover a lot with Macros in my Advanced series starting with 599cd.com/ACA1 - but I don't do a lot with macros outside of that. I personally don't like them. Sorry if you have an overzealous IT staff where you work.
Hello!
I am currently trying to create a form to where I select a specific report from the several I have and then it allows me to filter by company name once I select it. Very new to access but you have any ideas?
If you're new to Access, I'd suggest starting with a simple query criteria: 599cd.com/Criteria
Hi,
Is there a way where I print records (data) after a specific date? Example: I have 80 records from the beginning of the year until now. I want to be able to print 10 records from 01-August-2021 until 28-August-2021.
If the above is possible, can I have a field near the list box where I enter the date and select the report from the last box and print?
Thank you so much for all your help
Sure. Just use a query criteria.
599cd.com/Criteria and 599cd.com/FormName
That is great
Thank you so much for all your help 🙂
thanks for sharing , is it possible to pay by crypto
599cd.com/payment
What is wrong with this (using queries instead of reports)
Private Sub RunQuery_Click()
If IsNull(QueryList) Then Exit Sub
DoCmd.OpenQuery QueryList, acViewNormal
End Sub
If QueryList is the name of a query, then you can't use IsNull to evaluate it. That only works on fields.
@@599CD QueryList is my listbox that gathers information of Query Names stored in a table.
@@599CD Can you please help and tell me how to do this with a list of queries instead of reports as it is not working. Tried many different things.