Search results

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

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.

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

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

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

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

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

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

Thanks for your help Chris RR

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.

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?

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!

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

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

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.

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

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.

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

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

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