Search results

Hi everyone. I have a parent/child form setup as seen in the attached image. My forms are bounded to related tables. Is there anyway of dynamically calculate the totals for each item and grand total in upper section that is invoice total as user enters the details of each item? I would like to...

It works perfectly fine. Thank you very much. I will have to spend time studying your codes because there are some parts that are different from your sample. Anyhow, I appreciate your help.

Thanks for the answer. I used your method but unfortunately I couldn't make it work. I copied all your codes and modified its variables and objects accordingly to my tables and fields. The only step I skipped was the invoice date/number generator because I was writing the invoice date manually...

Hi, Should I start a new thread? I still have issues with my combobox. Please let me know. Thanks

@ arnelgp Thanks for your respond. I changed my parameter accordingly and the error is not coming up anymore (:D) but my combo_units doesn't take any click. I mean when I click on filtered items listed in combo_units nothing happens. Here is my modified parameter...

Hi I have a master/child form as invoice and invoice_details respectively. I've created a nested combo box that resides inside the subform. This pair of combo boxes are taking their values from two tables. combo_item shows a list of all items and combo_units lists measuring unit of each item. In...

@ Pat Hartman I found the issue here. When I looked at Master/Child properties as you mentioned I realized it was set incorrectly. As you can see in the image here Access had selected inv_date as Master Field and invoice_id as Child Field where as it should be invoice_ID and invoice_id as Master...

@ Pat Hartman I've setup my forms as parent/child relationship. I am not sure why Access is not saving parent/child records the way you are saying. Could you please help me to fix this issue? Thank you

@ Pat Hartman Thanks for time you and other folks spend to explain. The reason I removed the relationships was to test form T_invoice and form T_invoice_details are working together properly without errors from other fields that might left empty or entered a wrong value during the test. This is...

@ theDBguy Hi, I want to save that value in another table. I did put destination table/field in Control Source and then a new issue came up. Since the new generated Primary Key in T_invoice is not saved yet so the child table doesn't let me to save the related record because of missing a foreign...

@Pat Hartman: I think once I feel comfortable enough with access and all features involve in a DB then I will switch to a different platform. For now I continue working with Access and some VBA. I will ask more questions about automatic features when I have my project being tested. Thank you...

@ theDBguy: The Control Source of that Combobox is empty. I am not sure what should be there as Control Source. As far as I know the Row Source is where the list is taking values from and Bound Column is the column number that its value returns. Please explain. Thank you

Hi everybody. As you all recommended I started my project with bounded forms. I created an invoice form that shows details of the store on top along with the transaction's date. I also created a sub-form that is supposed to list all the items in that transaction. Having said that I am working...

Thanks all you guys for discussions. I am going to do this project with bound forms and if the issue came up and I did't know how to solve it I will ask you. I am working on tables and relationships now. When I said user(s) I meant person who is entering data either myself or my family members...

Hi everyone. I am about to start a simple project to save all data from my grocery shopping and/or Gas, Millage and car services in a 2016 MS Access Database. I know some VBA or none-VBA data manipulating in Access. What I am not sure how to do is here: A data entry form saves data in related...

I just realized my computer does not play any sound except for the videos and some other applications and I didn't even notice that until you told me to check the control panel. Now I need to figure out how to fix that before I can solve this. Thank you

I know my computer runs on a 64-bit Windows 7 Pro. I am not sure how to use your code. I copied and paste it in my VBA module as it is but it gives me compile error. Thanks for helping.

I created a new simple database and created a form. In the form I have a button and this following code behind it. Both cases tested. It doesn't create a sound at all. Private Sub Command1_Click() 'Beep DoCmd.Beep End Sub

Nothing happens :((

No. It doesn't create any sound. Here is my screenshot: