Search results

Ok, I have been programming in VBA for quite a while on Excel. I am pretty new to Access. So I decided to take an existing template in Access 2010 (a web template that I converted to a client one), brought the modifications here and there. Added a bit of VBA and, after some learning, modified...

Ok! Thank you guys!

Hi, I have 3 tables: Employees, Skills and EmployeeSkills. Each employee has a set of 40 skills that are either "not trained", "in training" or "acquired". I want to create a form with employee name and the 40 skills with either combo boxes or check boxes to select one of the three variables...

Thank you Jdraw. I made sure the record was created from the subform so that it generates a record in the parent table as well.

Hi, I have a Form

Hi, I have been looking for a solution but I don't find: I have a form with a subform (continuous) with cascading comboboxes. All this works fine. cboCollectionID filters cboLineItemCodeID. What I would like is to be able to generate an entire collection by choosing the collection in the...

I am stuck here! When I create a new order, I have a Form linked to Order tables and a Subform linked to OrderDetails table that get created and data is sent to both tables accordingly. For invoicing, I would like exactly the same to happen: An Invoice table and an InvoiceDetail table with...

Solved at http://www.utteraccess.com/forum/Access-Database-Engine-F-t1995964.html

Hi, Attached is a modified version of the Goods database from Ms. For the moment, the tool is invoicing per order, but I would like to build the structure so that per item invoicing becomes possible. For example one order would have 3 invoices. The user should be able to select items to...

Yes. Linking field is ID in Orders table and OrderID in OrderDetails table

Hi, I am using the Goods sample database from Microsoft. I don't know what I did but I suddenly get the message: "The Microsoft Access database engine cannot find a record in the table "Customers" with key field(s) "CustomerID". This only happens when I try to create a new Customer Order...

Thanks for the link... That was the missing piece... Which method do you feel is better? Roger's method or the overlaying text box method?

Hi, I have read a lot about the issue. The problem is that when you have one combo box (cbo1) filtering another one (cbo2) on a continuous form, making a change on row2 will affect what appears in row1 cbo2 (even if the record on in the table is not affected. What I don't understand is why when...

Hi, The option Auto Expand for combo box on the Northwind database is not available. Is that because it is a web database? Any work around? Thanks!

I think it does. But how would you do? You still need the QR code to be generated.

Hi Pat, QR codes are 2D barcodes. The activeX or the VBA actually code the information into that scannable 2D barcode. If you want to see how they look like, type QR code in google image.

Hi, I'm using a web database with Access 2010 and Sharepoint. I would like to insert QR codes based on field data. The problem is that all the add-ins I have found so far either are ActiveX objects or use VBA, which don't work with Web Databases. Does anybody have an alternative? Thank you...

Hi, I love Excel and VBA but I am getting more and more into Access development. Guess I will end up loving it as well.