Search results

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.

I've tried it and it kind of works. I getting the 'duplicate' message for any record that I want to enter duplicate or not. It actually does not let me enter anything at all. For Example I have Item ID: 123CCA on the inventory, it would give me the 'duplicate' message if I try to enter it...

It does not work because I do want duplicates on the main table, I just don't want them on the form.

Thanks a lot for your patience and help. I apologize for not being very clear. This code, would be applied to the table, but I want to apply it to the ‘before Update’ on a text box, and only to the form, not the table.

The record gets saved on a main table, from that table I have several queries. From one of those queries I get an inventory form that it's updated everyday. On that form is where I do not want a duplicate because it's an iventory that tracks each item in the office. The items leave, go and might...

The thing is that I do want duplicates on the main table, because each unit would have a history, I just don't want duplicates on the form where I enter daily inventory.