Recent content by medranoestraaadriana

On the field I put: NumDays On Criteria I put: DateDiff("d","Inventory Date","Exit Date")

It does not let me do it, I get the following error message. "This expression is typed incorrectly, or it is too complex to be evakyated"

Where would I put it?, on the criteria?

I have a query with a starting date and an ending date. I need a day count of the total number of days. For example if the starting day is 11/01/10 and the ending day is 11/04/10, I need a formula that would give met the total number of days in these period. Help Please.

I have a db that was created a long time ago. It's protected with a user name and password. Is there any way I can remove or retrive that username and password. We have lost contact with the person that created the db, and since it's self protected we are not able to make changes. thanks,

I want to be able to get a report that would show the inventory for a specific day. Let say that on 7/01/10, I had Item A and Item B. I do the inventory and I see that I have Item C and Item D so I add them up. Any day after that I want to be able to get a report that would show me all the...

I've did it, but it would only show me the items that I've entered for that day. It would not show the ones that have been entered previously.

I've have one more question. On this same db, If I ever want to go back and see the inventory for just one day. How would I do it? Should I save a copy of the inventory by entering a code on the 'On-close' event.

It's highlighting 'Private Sub form_beforeupdate(cancel As Integer)' and gives me the compile error 46. Oh my God, I got it. I change the name of the text box and label, and IT'S WORKING!!! IT'S WORKING!!!

I've checked my field names, and everything on the database I'm still getting the same message. I just give up!!!, I've been trying to fix it the whole day and nothing!!, I don't know what else to do. Thanks!! a bunch, eventhough I've not acomplished anything, I've learned alot about access.

Thanks a bunch!! I've tried it on my original and I get this message 'Compile Error: Method or data member not found'. and it highlights this, "Me![Item ID]".

I posted it as a new thread, can you check it out

Prevent Users from entering duplicate data on a form Here's a dummy database of what I'm doing. Look at Item 123AAA on the main table. It has been in and out 3 times. Let's say it was back on 07/08/10 and I checked it in in the inventory. So today as I do the inventory, I see that item and...

I've tried it and it does not work. Can I upload the database on the forum, that way you could take a look at it.

Would it make a difference if I told you that my property source for this form is not my main table but a query.