Search results

Hi, Why is that so? I need the data from the table linked to the form. e.g. I could not make a query on a form. It means I need the data from that table. Thank you

Thanks. It works on the form but it does not update the related table attached to the form. I mean on the form it does keep the data but the same values on the table do not get updated. What am I doing wrong? When the columns are numbered, you mean that the numbers must correpond to those from...

Hi, I cannot find how to inherit values from one row of an item. I explain if I have an item ITEM1 that has various values in various fields F1, F2, ...Fp. I have all these fields set in a subform. How can the values in F2, F3,...Fp be automatically updated once I have selected the value of F1...

I am trying to stick to one table. My problem now is that I cannot produce the fields I need in my subform. I explain I have a table Products, which is made up of a final product. That product is decomposed into individual parts which belong to the Raw materials table. The idea is to calculate...

Hi, I have set up a query e.g. query1, it produces 5 fields with stable data. I use one of these data unit Cost price to produce a cost related to an added field Quantity that i fill in by hand. The cost price is calculated as unit Cost price * Quantity this cost price is then set in the form...

Good afternoon, Thk you for your reply. If you look at my previous posts that is what I thought to, but then the problem of aggregating and apending automatically multiple tables into that have a similar structure remains. Plus my other questions too. But I will also take a look at the...

I use more than one table to avoid having to create a subcategory that would be empty for most items. In that sense each table could use the field category with whatever data suits best. But I guess I can go around that problem and stick with only one table for all raw items. These items are now...

Thank you for enquiring so quickly. I am not good at programming in VBA and I find it quite strenuous to program macros. I am having a try at setting up a database for a friend who makes handicraft knives. The idea is that I have multiple tables that have identical structures and that are better...

Is there a simple way from access 2007 application to combine two tables into in an autonatic fashion. I mean by using a control button that would update the produced table at any given time? Thank you for your support

Thanks Trevor. Eventually I did manage to open it. I had to choose the button Open without restrictions. I guess I now have to work my way out of this rather complete database. Rgds

Hi, One friend has recently asked me to work out for him a sale and inventory management system, which would certainly need more in depth functions and macros development. I thought that by loading the northwind database and with the help of specialized literature, I would come about all the...

I am retired and enjoy developping simple access database applications. I have never used VBA and limited the use of macros to the strict minimum. One friend has recently asked me to work out for him a sale and inventory management system, which would certainly need more in depth functions and...