Search results

Yes..it looks like it is Autocorrect. I found that I can go up to edit (Access 2000 db) and select undo autocorrect and it goes away. I don't mind turning it off per user because only one person uses this database. Any idea how to turn the thing off? I am still looking.

I have a strange one that I am sure no one will have an answer for but...thought I would toss it out there as I am not finding much when searching the web. I have a form that has a text box that is used to perform a string search on a field. As the user types the results are displayed and the...

The answer to this may be posted elsewhere, but after considerable time searching I am not quite finding what I am looking for. I also suspect that others can learn from this so...will post the question that has probably been answered several times already. I have a table that has some customer...

I got it...think I actually knew that once and sort of forgot.

Thank you both for the replies, I am pondering now. I do have one question for Bob: Are you saying I should not use lookups at the table level? That may be fine but how do enter data in the underlying table when I want to have the user select a value from a combo box? I have a data entry form...

Probably bad explanation for the title. What I have is: I have a table where one of the fields is a lookup field. It looks up a value from another table, like open, cancelled, awarded, lost. Then I have a query that is used on a form for a list box. The lookup field on the list box shows the...

Yep, that's all it needed. My problem is I am way better at the overall concept of how to build a database to accomplish a task than I am at the fundamentals of sql, correct syntax and the like. Anyway, I will have to figure out when to use a . versus a ! thanks!.

OK, here is a stripped down version of the db. If you open the form - frmNewClaim you will see the form and subform. When I enter items on the bottom/subform I want a cumulative dollar value total to display on the main form in the field I have highlighted on the attached image file. Please see...

Check that...I do see why it did not work before.

David, That seems to have done the trick. I don't understand what it was doing before but, hey, it works now. Thanks for the long distance help.

I have a query that calculates the age in days of open orders. I am trying to produce a query that allows a user to enter a parameter - days old - as in how many days old do they want to look at data for open orders. I am getting very inconsistent results. Looking at the attached database, and...

Ugh, still not working. I think I am going to have to upload a stripped down version of the db and if anyone would be so kind as to take look that would be great.

I see - that does change things. But I am still unsuccessful. Possibly a personal problem but, I still need to figure this out. Here is my form and subform (see attached image) the red is my syntax for the control on the main form where I would like to disply the subtotats from the text box on...

I tried this...still not working. Any other ideas?

This should be an easy one - just not for me I guess. I have Googled it but not finding the answer, or else it is not working for me for some reason. This is similar to a recent post of mine but slightly different: I have a form (frmNewClaim) with a subform (frmClaimItems). The subform is for...

I may be able to upload it. But, for the time being it seems to have settled down. I went in and changed all the buttons on the main form to use macros to open the forms associated with them, instead of using VBA to open the forms. And after that it has been good. I don't know if there is a...

So..I have a database that we have been using for some time. I made some minor changes today. Now I am seeing weird random error messages, usually when I try to open a form. Sometimes I get the parameter prompt thing, like it is expecting a field but cannot find it (as if you had removed it from...

Ah...interesting. I understand. Perfect...thanks!

You are correct, I did and it did not like it one bit. I have put it in the correct place and it now works! Thanks!

I tried this but now when I enter a value in the deposit% text box Access gives me a warning (or error) saying: Database can't find the object 'me.'