Recent content by supernova

Thanks. This worked great but can you explain why we need a submacro and can't do it in a single macro?

I have disabled "Allow Default Shortcut Menu" for security purposes but now I can't right click on my form and filter data. Any idea? Data type is date/time if this helps. Thanks in advance

Thanks for your help. Much appreciated

Thank you so much. It worked great.

Because I don't know vba :confused: but I think a little bit of vba will not kill me . What would be your approach?

I have an invoice table and a continuous form which shows all invoice numbers, delivery date etc. I have a notes field in this table which I don't want to put in the continuous form. Instead, I want to be able to double click on the invoice number and another form pops up where I can write my...

I tried hard applying your code to mine but I couldn't because I have no knowledge of vba. Is it possible for you to make a query based on SumQ and do the concatenation in that query? I guess in this case, the code becomes universal and doesn't need INNER JOIN stuff. I know its not a proper way...

Thanks for your help. This is exactly what I want but I don't know how you did it specially that module1. This is just a demo db I made to explain my problem so I need to apply what you did to my actual database. In the actual database I have made data entry using forms and comboboxes to avoid...

Well I want to see the sum of purchased products in all invoices (lets say we have 5 Computer sold) and in the next column the invoice numbers i.e. 101,103,106 (I realized I have misspelled computer and I have 2 products now one competer and the other computer so I have 5 computers and 9...

Here is a quick db file I made to show you what I mean. If you go to the SumQ, you see computer is repeated multiple times. If you go to design view and delete InvoiceNumber, you get it right but invoice numbers are not available anymore.

I did that but didn't work. When I add the invoice number field, it separates the products and doesn't sum them. For example, it shows 3 computers for invoice 102, 4 for 204 and 5 for 250. I want to show the sum of computers sold and in the next column show the invoice numbers like 102,204 and...

I have 3 tables: CustomerT, ProductT and InvoiceT and I have related these tables together using foreign key and primary key. Each customer has multiple invoices and each invoice contains several products. I can sum the products of certain invoices in a query using Totals but I can't see which...

I know how to export to excel but I don't want the user to export the whole table to excel, only selected fields. Can I use the "show" checkbox in query design view in my form? If I can uncheck the "show" checkbox somehow in my form, I suppose the report will not export those fields to the excel...

Hi everyone I am an intermediate access user and don't know much about vba or sql. I have an employee table and I want to make a form for my end user who knows nothing about access so he/she can generate multiple reports from that form by choosing different fields of the same table using check...