Recent content by Mik3

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.