Search results

hi Paul, I have attached the sample DB. Let me know if you were able to access it. Really appreciate your help. Thanks!

Hi Paul, The barcode fonts are readable if the subform is being executed in a separate form window. But if its in the main form, the subform barcode isnt readable. Any thoughts? Thanks!

Hi guys, I wasnt sure why the barcode font isnt working on my subform. The generated barcodes arent readable. However, looking at the subform's (mainform), the barcodes are working fine. Please help... thanks!

The numbers arent similar. And the size of the textbox are the same. Barcodes are showing up but not readable. And I noticed that same barcode appear as invoice number.

Hi Paul, I was able to fix the issue re the printing and the subform is set up. I am on my next step in designing the form and I need your help if you can. I am trying to make the the invoice number and order number barcode font. I am successful in making my order number in a barcode font which...

Hi Paul, can i create a subform from a form query? I created a form based on a query. I tried creating a subform but the subform wizard isnt showing up.

I tried to save the object as report but it is not updating. My form contains subform that is continuous view. Its says "the recordset is not updatable". Is better to report based from the table and add a subform?

I see, can i do a report based from the form I created?

Hi Paul - Do you know how to set the form size to 8.5 by 11? So if we need to print the form, it can print to PDF with a letter size format. Any thoughts? Thanks in advance

Hi Paul, I was able to create a subform and it worked. I just wanted to check if there's anyway I can make the form view other than DataSheet view. Thanks in advance!

Thanks Paul. Yes, the id number is on the order table, where it appears to be duplicated due to related invoice number. I will try to create a subform that will show master/child link. Thanks for your prompt response. Im new to ms access and still learning.

Hi Paul, Thanks for the reply. I tried to use subform but, im not sure how can it pull two data related to the order number. For example, my order number id is 1 and the related invoices are 100 and 200. How can i create a form where i can enter the order id number and it will pull up both...

how to design a form that can pull multiple invoices data related to the same purchase order number? any ideas? Thanks!

Hi guys, I am currently working as a project manager in San Diego, CA. I am interested in learning more of MS access. I am trying to design a barcode system for our production process. Hopefully, MS access is a great tool to help improve our daily workflow. Thank you!