VB Libary Components

Aug 16, 2005

Hi,

I have made a database for use by some of our sales and marketing team whom all have laptops. The database works fine on my PC, but when I try on their Laptops they do not appear to have the correct VB library's installed. The follwing does not appear to work:

Transferspreadsheet
Date
Left([Field], 2)
Right([Field],2)

There may be others also, but these are the ones that have not worked so far.

I can probably get our IT Helpdesk people to reinstall it on their Laptops(in about 6 months time) with the correct options selected, but as a quicker measure, does anyone know which .dll or .ocx are used by access, so that I could just send them a copy of mine, to see if that resolves the problem.

Any help would be much appreciated,

Cheers

View Replies


ADVERTISEMENT

Relating Assembled Part Numbers To Their Components

Feb 10, 2008

I didn't know which forum to post this in.

I'm stumped.

The inventory table has both cabinet assemblies and their components (tblInventoryMaster) in one table and a table that has what components go with each assembly (tblInventoryAssembly)

When a cabinet is sold, I need the ordering process to commit the components to ship (but still show the cabinet only on the order)

I've attached part of the database in question (Inventory tables, Order Form & relationships)

View 1 Replies View Related

Problem With Query Based On Form Components

Feb 17, 2005

I have a form with a combo box (sup_numbers_combo), which has a list of supplier numbers in it. (on a master form).

In a sub form, i then set the row source for a combo box (product_numbers_combo) to this:

SELECT [product_number] FROM Supply_link WHERE [Supply_link].[sup_number]=[FORMS]![myForm]![sup_numbers_combo];

Hence, "Sup_number" is a PK in Supplier and an FK in Supply_link.

I want the product_numbers combo to be filled with the values of product_number in Supply_link, where the sup_number is equal to the number selected on the form.

Im pretty sure I have the query correct. If I enter it as a query and then force it a value for: [FORMS]![myForm]![sup_numbers_combo], it works fine.

However, when I set it as the row source for "product_numbers_combo", "product_numbers_combo" is never populated with any values.

Can anyone help?

View 5 Replies View Related

Modules & VBA :: Changing Stock Levels Of Multiple Product Components By One Command

Feb 11, 2014

I have the following form and subform combination:

The subform is linked to the main form by way of the "ProductID" control. (It's hidden in the subform).

Basically, each product (the finished article) is made up of many components.

What I would like to do is this:

1. Increase the stock of a "Product".
2. The Stock level control on the main form will then increment as much as selected
3. Contrary to that, I would like each component to decrement the relevant amount based on how much of the component is used up to make the product.

E.g. If I have Product A and it contains 2 components of which component A is used once per product but component B is used twice, then when I increase stock of product by 1, then component A goes down by 1 and component B goes down by 2. But If I put two of a product in to stock, I would obviously need component A to go down by 2 but component B to go down by 4.

I am thinking I need some way to loop through each record in the sub form for the current form, such as "Do While Not", or a "For Each". And then stick an Update query within the loop, but to be honest I can't think of how I need to address it!

View 10 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved