assign autonumber & form copy

[pirsein]

I don't know if this is possible or not. I know you can assign your own autonumber by working w/ an append query. But my question is, if I have a number that is 1.0 - can I change the 10th spot after the decimal? I tried it myself w/ the append query but it changes the 1 to a 2.0. Is there a way to do that?

My next question is - I know there is a copyobject. I want to be able to click on a button, & it copies a form. BUT, you have to enter either a destination for the form or a new name for the form. But the problem is, I want to keep the current destination and the form name will change each time there is a new form created. Is there a way to have something pop up for me to rename the form?

Thanks in advanced.

 

[boblarson]

The answer to your 1.0, 2.0 quandry is that Autonumber is a LONG and as such uses NO decimals.

The second part of your question creates a question for me - Why do you need to copy the form? What are you trying to accomplish? There may be a better way to do what you are trying to do, if we knew why it is you are needing to copy the form.

 

[pirsein]

Here's the reason I'd like to copy the form. But in my thought process I don't think I'll be able to get around it for other reasons. What we wanted to do was trying to eliminate me having to go in each time and copy and rename the form. Here we have a series of tests that are done. We manufacturer plastic hang tabs(the tabs that are on gift bags for example) and we have many different adhesives that need to be tested. So, what we wanted was to be able to have the user click on a button and copy the "template" if you will. This template is using 1 table for several tests. There could be 20 tests for the 2006 year. That way I wouldn't have to go in, copy and rename the test. But when I was thinking about this, I don't believe it can be done due to the fact I will have to place the new test on switchboard. So it'd just be easier for me to go in copy, rename and place it on the switchboard. So that's the reason for the copy.

 

[boblarson]

Sorry for the delay in responding. I haven't had time to pop onto the website here in the last few days.

I know that if I were doing it I would only use one (1) form and change the recordsets bound to the form at run time, after someone selected which form they would like to run. I would not get myself tied to the internal switchboard form, which can be nice at times, but is very limiting. I always program my own main form, from there I can put selects in that will let someone choose the form they want from a combo box, which lists all forms available for them to open, and that makes it dynamic so if I add a form, if I use a particular naming convention it is always there right away in the combo box.

So, you may not be at a point where that would be something you would want to do. But, I think you should know that, after learning how to assign different recordsets to a single form, it makes things actually a whole lot easier.