Search results

  1. M

    Frustrating subform

    Hi, I have looked through every book I have and spent hours on this but just cant get it right. On the "menu" tab, select a customer then go to the "Calls" tab. Within the top subform is the list of telephone calls. In the below subform is the detail of the calls taken. The problem: When I...
  2. M

    Stock Control Conundrum

    Hi people, I have an existing stock control database that has evolved over the years from the "Inventory Control" sample supplied with A97. We (until now) supplied spares from one manufacturer. The spares items list was provided to us in an excel sheet and easy to append to a Access table. We...
  3. M

    I'm completely lost!

    Yes, I understand the repeating field and will correct (least of my worries at the mo). but thanks. I very much like to see the all the information in one place on that main form using the tabs (very easy on the eye without pop up windows everywhere). "You should have a separate form to enter...
  4. M

    I'm completely lost!

    Database structure - it's not as easy as you make it look! Good afternoon all, Really struggling with my structure and have been looking at it for so long my head hurts so any advice would be great. (see attached) Basically, I want a DB for keeping track of service / repair of electronic...
  5. M

    Customer History

    Hi, I had a similar situation. I adapted the sample database supplied with A97 "Contact Managment" db (I think this also ships with later versions of Access). On the main form is a "Calls" button. Change this to "comments" and adapt the related form and subform for your requirements. Hope...
  6. M

    Sample DB structure ok?

    Many thanks for your comments ScottGem - Will make those alterations. Although I still cannot seem to work out why the following is occuring: > If I create a new record in the existing form, why can I not enter both UnitID and EmployeeID? Relationship conflict? > Should I be building forms on a...
  7. M

    Sample DB structure ok?

    Hi all, I am on my way to building my first relational DB. Is anyone able to look at the attached sample and tell me if I am on the right track? The DB is being desined to record Repair information carried out on a machine. (TblRepair) The DB will also eventually record refurbished machines...
  8. M

    Calculating a subtotal - Should be easy?

    Cracked it!!! =Sum(Nz([Repair Cost])+Nz([Acc Cost])) I did not enter brackets to the expression Thanks all for your input. As allways a great forum!!!! :)
  9. M

    Calculating a subtotal - Should be easy?

    Is it really as complicated as that? Is this how access is designed? Eg: To calculate a figure from a bound control: =sum[subtotal] To calculate a figure from a calculated control: Code: Private Sub UpdateParent() '-- Update the Parent Form txtBox for this subForm Dim curValue As Currency...
  10. M

    Calculating a subtotal - Should be easy?

    Sorry, I might have confused you in my last post. The link and expression you sent me has helped me with the final part. Thats great thanks! It is the addition of all the "SubTotals" that is not currently working. see attached. This scr shot is of the subform in form view. I will later of...
  11. M

    Calculating a subtotal - Should be easy?

    Thanks RG, that link will be useful for future reference. I am still struggling with this very basic problem. I have cut out all the unnecessary bits to the underpinning problem. I can perform equations when the control is bound to a field, but have never yet had to calculate a control to an...
  12. M

    Calculating a subtotal - Should be easy?

    Hi all, I have a subform within my form for quotations (see attached). A user will manually type in "Repair Cost" and "Accessory Cost". The subtotal field is calculated using this expression =Nz([Repair Cost])+Nz([Acc Cost]) in the Control Source box This is all Ok. I want to subtotal these on...
  13. M

    Forgetful Users - A solution anyone?

    Good afternoon all, I have a A97 Db. On one of my forms (see attached screen pic) I have a field "Payment type" for either Cheque, card of Account. There is no code or functions behind it, it just stores a value. Trouble is my users keep forgetting to fill it in! My first (and easiest)...
  14. M

    Reserved Words

    SJ McAbney; Many thanks for that, it will be most useful. Quote It gets more complicated when you start adding references to your database. If, for example, you added Microsoft ActiveX Data Objects 2.7 Library (ADO) to your database then every method and property within that also becomes a...
  15. M

    Reserved Words

    Hi all, Does anyone have a definitive list of reserved words in Access? I understand certan words are reserved because they cause a problem when using vba. Is this correct? It would make sense because I used to have a field called "Name" and my controls never worked correctly. I have since...
  16. M

    Relationships & update of records

    neileg, Your a star :) 1 more Q if I may? I want to be able to have a Combo box in the form, so when I select the model from the list, it automatically displays the make and type (associated in TblUnit) in the other fields. I have played around with the query, but I can only get it so it...
  17. M

    Relationships & update of records

    neileg, thankyou so much for your input. :) I have made the changes you suggested. Quote: I'n not sure about the 1 to many relationship between Tbl_refurb and Tbl_Unitdetail. I don't know what you are modelling. Will the same units be going in and out so that Tbl_Refurb can hold details of...
  18. M

    Relationship woes

    Hi all I am also having the "Relationship woes". Is it possible to post a A97 version to compare my Db with? Many thanks
  19. M

    Relationships & update of records

    Hello all, I am in the early stages of building my 1st relational database (see attached). Ones I have built in the past were built on a knowledge of the sample ones provided with A97. I have since realised (from this excellent site) everything I have done in the past was completely wrong! One...
  20. M

    Some sort of button?

    Although, Would this work? (Value="null") if I wanted the button to react to a empty field? Private Sub Form_Current() If stt.Value = "null" Then Command8.ForeColor = vbRed Command8.Caption = "Out Of Stock" Else Command8.ForeColor = vbGreen Command8.Caption = "In Stock" End If End Sub
Back
Top Bottom