Search results

thanks for the help i'll see if they can print a couple of cheques with a lot of 0's for you :)

Is it possible to somehow get a name and the respective amount of money to be paid from 2 columns in an excel file and put them in a report to print onto cheques?

Problem solved. Thanks all :)

Hi, I got a problem with the cancel button in my form. I made a macro which sets all values to Null and then close the form. However, an unwanted blank field is created in the table each time the users opens the form and closes it using the cancel button. Any ideas?

I see. It is the Abs function I needed. Thanks.

Hi, I have a question about the Mod function in the Expression Builder. Is that the modulus of number (ie. returns the positive value of any number)? What is the syntax to use it? Brackets, square brackets...?

I tried that, but I still got the error msg. However, I solved the problem otherwise. Thanks all the same.

it's not the links in the queries either. I tried to delete them all and still got the same error. Any ideas what relationships is it talking about? Can they be hidden or something?

Hi, I need to change the Data Type of a field from AutoNumber to Number, however I'm getting an error message that the field is in one or more relationships. The thing is that there are no relationships linked to its table. I checked the relationships windows, tried "show all", but still no...

I'm gonna shoot myself :) I set the default value - now I need to set the ID as a number instead of autonumber. Problem is - it won't let me..it says I must delete any relationships from the relationship table. And there are no relationships in the relationships table - I tried Show All, but...

The dmax("Tool","Tools Table") + 1 posted by Waltang should solve the problem. Many thanks for your help guys.

Many thanks for your replies. There won't be any records deleted, only modified. I will try the DMax, but only next Monday since it's closing time at work. I will keep you informed. Thanks again.

I need the primary key (the auto number) to be the same as the record number since I would then need to go back any modify a record from a form by going to record = [Tool ID] That is why I need it to be sequential, without any gaps.

What if I compact the database each time a user tries to enter a duplicate value? I know it's not such a good idea, however this shouldn't happen very frequently. What is the command to compact a db as if the user had clicked Tools > Database Utilities > Compact Databse..such that he won't be...

hmm..that's a BiG problem :confused: I don't know how to write any coding. I found that procedure from a previous thread, posted by Vassago if I'm not mistaken.

Coming up with a code won't happen as well :) I guess what I need is to check for duplicate entries without trying to add the value in the table, such that the auto number would not increment. Anyone thinks it's possible?

Hi, In the Before Update event of a text box I put this procedure, such that the user would get a message if he tries to enter a duplicate entry. Private Sub Tool_BeforeUpdate(Cancel As Integer) If DCount("[Tool]", "Tools Table", "[Tool]='" & Me.Tool & "'") Then MsgBox "This Tool already...

I found this thread and it worked fine. :) However the auto number still increments by one every time a user tries to enter a duplicate field. :eek: Is there a way of preventing this?

Hi, I need a validation rule that checks all values in a field for duplicates, before writing anything to the table. I already have the field set not to accept duplicates, however the form would try to write the value before checking it. If the value is a duplicate, the auto number set as...

dunno. if u find another method post another reply.