Recent content by royalrodger

Still looking for help Is there a place online where I can see example expressions? I am still struggling with the fact when I delete a record because a customer has requested to be removed from the db, i lose their entire record and their unique number. All I want is for the record to be...

Thanks for your help mate. That kind of makes sense. Yes we are known as coming from Down under, it just depends where your from, but generally no, we are the only place around who is under anything, as we are at the bottom of the earth next to nowhere. The only place I can think of that would...

How do i manually assign numbers, they are really important as they relate to a card given to people in the program.

I enter data everyday into a table for a loyalty program. I want to create a relationship between two tables. The relationship I want to create involves enterting data into one table and only when a check box is checked to be true do I want that particular record to go across into the other...

Yes, I can delete records, its just I dont want to lose the number sequencing, and I want a new record assigned to the old autonumber of the deleted record. thanks for your help from Australia

I am having trouble with my autonumbers when i have to delete a record. Can anyone help me out with auto numbers?

I am trying to create a function at the moment. The field I want to be set to null is an autonumber non-primary indexed field. I think this may be the problem. Is the expr1 meant to be replaced with the field name? Again, I am trying to create a null value for the customer number field when...

the database contains only one table. Information is entered through the table. It has worked so far. It is not a live database, no users, it is for records only. I want to have a rule which states that when i check the customer as a vip (vip reads true) they are assigned a number. is this...

Hey, I am a beginner with access, but already have a huge number of records. I am trying to validate data on entry. I have two fields which need to have a relationship. One field is a customer number and the other is VIP. I am trying to create a rule which states that when VIP reads...