Automatically generated number

[jodilees]

Still in Trouble

Hi IMO

I have been through all of your checklist and I still can't find what I am missing.

When I go to add a new record in the Repairer table it gives me an error saying no current record.

If you can offer a solution I would really appreciate it.

Kind Regards

Jodi

 

[IMO]

Hi Jodi,

I've checked your code and all is fine, the only small error was in your counter table for repairs, it was set as '0' and not '1' now it works fine. Don't forget to set the tblCounterRepReg table to '1' if you're going to use it. By the way, my wife is from sunny Queensland (South Burnette) and we'll be visiting in October this year. Where abouts are you? Hope this helps, post back if you need more help and let me know how you get on.

Best Regards

IMO

 

[jodilees]

Next Adventure

Hi IMO

Thankyou once again for your help.

My next adventure is to get the other table to be where items are registered for repair.

So I am planning to create a form that will autofill select client details and the repairer details and then the rest of the information is entered by the user in relation to the equipment that has been received by us for repair.

Can you suggest the best way to go about this. I am not sure if I need to create a query first or just do it all from the form and put lookup fields into the form.

Any feedback would be greatly appreciated.

Kind Regards

Jodi

 

[IMO]

Hi Jodi,

I've sent you a PM in reply to this post

Regards

IMO

 

[MammaJenn]

Wow! I never thought I would find the exact answer to my question before I even asked it!! This is just what I was going to figure out how to accomplish.

Thanks!!!
Jenn

 

[IMO]

Wow! I never thought I would find the exact answer to my question before I even asked it!! This is just what I was going to figure out how to accomplish.

Thanks!!!
Jenn

Glad you found your answer

IMO

 

[jodilees]

Another Question

Hi IMO

Sorry just one more question. When you helped me set the initial tables up there were set up as something like C-0001 for the automatic number. I want to get rid of the dash or the full stop. I have scanned through the programming but can't quite workout where it is coming from. I think it is one of the numbers in there ie the 183 bit of the line that creates it but am not sure.

Hope you have a great day.

Can you please let me know.

Regards

Jodi

 

[IMO]

Hi Jodi,

Yes, you are right, it is the number 183 that creates the dash. If you move this part of the code & Chr$(intA + 183) to the end of the line and set it as a remark (place a ' before it) that will take out the dash. You can delete it but I always set it as a remark for future reference (as below).


strANum = Chr$(intB + 67) & Format$(intNum, "0000") ' & Chr$(intA + 183)


Speak to you soon

IMO