Search results

  1. L

    access97 to access2000 problem

    Here is the situation. I used Access97 to create this but I have had to recreate it on Access2000, and can not get it to work. A user opens a ticket once a day and that date is captured in a date field and used as the primary key. They enter numbers in text boxes and that is all totaled up in a...
  2. L

    Dimming a db

    I have a very stupid question I am sure. I am used to using Access 97 but I tried to use a recordset in Access2000 yesterday and ran into a problem. I usually do this "Dim db as Database" but that doesn't accept that in Access2000. Can someone tell me how to declare a database in 2000.
  3. L

    Update Null Values

    I have 78 records that have a field that is null. I want to create an update query to replace these null values with the value "NULL1" for the first record, "NULL2" for the second record and so on. I know how to replace the null values with the word null, but how do I get this last number to...
  4. L

    Concatenating fields

    Thanks it worked! I used idea #1 and it worked great.
  5. L

    Concatenating fields

    I have a main form with a Revision History field. I created a button on the main form that when pressed opens a Revision Hisory Adding form for adding new details. There is three fields on my Revision History Adding form, name (which gets it's value from the main form), date (which defaults to...
  6. L

    trying to display info

    Unfortunately that did not give me the results that I was looking for. I created an employee report with the contact info subreport, the problem is that because there is two contacts associated with that one employee, I get 0ne page with employee info and it's two contacts and then it repeats...
  7. L

    trying to display info

    I have a form with all the employees info and when you hit a button another form appears with that employees id and all the different contacts that employee has. Each form is stored in a different table. I created a query that brings back all the employees info and all his related contacts by...
  8. L

    updating report

    I have a form set up so that when I hit a button all the fields are displayed in a report. The problem is that when I change a value in a textbox and then hit the button to go to the report, the report still shows the original value from that textbox. The only way that I can see the changes from...
  9. L

    two tables, one report

    Thanks for your help Chris RR
  10. L

    two tables, one report

    I have two forms contected together by an id number from form A. I have generated a report showing all the info from form A. How can I also show the info from form B on the same report.
  11. L

    Standard Deviation

    I run a query and use the avg to return a value of 18 and use StDev and get a value of 36. Does this mean that 36 is the maximum value of the standard deviation or am I suppose to divide that by two to get my range on either side of the 18? Does anyone know what that value is?
  12. L

    Numeric Values

    I have a text box on my form that is bound to a column in a table that is a number data type. How can I ensure that the user is only allowed to enter a numeric value on the form. Thanks for any advice!
  13. L

    displaying record from combo box

    Thanks very much, but I figured it out by using the default value property
  14. L

    displaying record from combo box

    How can I get one of the values in my combo box to appear on the form load
  15. L

    text box display

    How can I get a text box on my form to automatically display "Enhancement" but I want to just store "E" in the table that the text boxes control source maps to. I do have a record desription table that has two columns, record type = E and record description = Enhancements, if that is any help.
  16. L

    queries brought over to excel

    When I open my excel sheet and go to "get external data" and bring over the info from one of my queries, something weird happens to the comment field. I set the cell in excel to "wrap text" and everything looks great, but when I look at it in Print Preview all the text in the comment cell drags...
  17. L

    tracking changes

    I want to be able to record the date in a text box whenever someone makes any changes in any of the forty text boxes on my form. Can anyone give me some advice.
  18. L

    counting

    -Fornatian I tried this and the first part is OK but nothing is appearing in my footer. As far as the running sum property is concerned, there was no yes to pick from, just "Over Group" and "Over All". I tried both and still nothing. Do you have any other ideas?
  19. L

    calculation

    it was requested that way, I think I found a solution anyway. On the change event of [Actual] I made [Estimate to Coplete]= [estimated]-[actual]then I just left the control source of [estimste to complete] linked to the table. Thanks for responding
  20. L

    calculation

    I have three fields on a form and the same three are stored in the table. There is 1)Actual 2)Estimated 3)Estimated time to complete I want to put times in the first two text boxes and in the third box I want the value of ([Estimated]-[Actual])to appear. The value that appears in this third...
Back
Top Bottom