Search results

Sorry for not replying earlier. Thanks for the advice.

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...

When I was at Polytech the ICL 1900 was taken down for (I think it was a week) to upgrade the memory to 128k words. The lecturers assured us that this was going to be a really powerful computer. As regards chad patching, we called them silver stickies.

That worked fine. Yes you're right I go back to COBOL and punched cards. I even used DIBOL. Anyone remember that? At the minute it's a bit like learning a foreign language, I see a cow and think cow before remembering that the French for cow is vache.

The reason for the confusion is that I go back many many years and am thinking in terms of having a systems parameter file (and I use the term File because that's how far back I go). It probably would be better to calculate the financial year end relative to the current year. I would be grateful...

SELECT Finance_Year.FinYear FROM Finance_Year; There is only ever going to be the one record on the table.

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...

It's a database that I have inherited and the naming conventions are all over the place or rather non-existent (there's one field called "System / Version"). I changed the name to Practice_Code_Regional and it worked. Looks Like I'm going to have to change a few more. Thanks.

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...

Thanks, I've found out what I was doing wrong. I had assumed that as it let me type in a value that the form would accept that value. I've set the limit to list value to Y and will let them get the error message.

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...

Thanks, it worked fine.

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?

Thanks Now I have to use it to display a couple of other fields. Who knows I may be looking for help again?

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.