Search results

I have ASSET_TYPE, MANUFACTURER and MODEL tables. I have a Table ASSET_COMBO that links to the above tables. I have a form to create amend an ASSETS table. The form uses combo fields to filter the options available to the user. I.E the User Picks Manufacturer then selects from list of Asset...

I have a very simple problem but can't seem to find a way to achieve it. In the form "Assets" I want to flag a warning when an asset date is entered that is before the start of the current financial year (01/04/2013) I tried using a table with date attribute so that the user could change this...

I have 2 tables ASSETS and GENERAL PRACTICES and 2 corresponding Forms. In the Assets Form I have set up a text box and used a command button to let the user search for a particular Asset. The code I used for the on click event was Private Sub SearchBox_Click() Dim strSearch As String On Error...

I have a database and want to record the Maker, Product Type, and Model. I have successfully used 3 combo boxes to ensure that the user can only Model within Product Type, within Maker. My problem is that when I go into the Maker and select an Maker from a list e.g Toshiba, I can then go back...

Hi Thanks for the help with the combo box, but I knew I'd be back. I have a table of Asset Types that I'm using as a combo box to populate an Assets table. The Assets Type contains Asset Ref and Asset Description. Using a combo field I can select the correct Asset code and insert it into the...

Any one know of any good online courses for beginners in Access?

Hi I am very new to Access and this is probably a very simple problem but it is baffling me. I have 2 tables Assets and Asset Type. There is a one to many relationship. Asset Type has 2 fields Asset Ref and Description. I have created a form for the Asset table with a combo box for the Asset...

Hi There I'm an old style IT Guy. I started programming years and years ago using COBOL PLAN and DIBOL (anyone remember that?) I have spent most of my career as an analyst and am returning to do a bit of programming and tidying up of databases. I have some experience of Access but it is limited.