Still having issues creating editable database with autonumber, credential capture, etc.

[Orestees]

I've attached an example of the application I've been working on for data entry, editing, auto numbering, credential capture, and multiple users. I've pieced this Frankenstein together using all sorts of code found all over the internet, these forums, and other forums (sorry, desperate) as well. I've run into a few minor issues along the way and am in desperate need (told you I was desperate) of finishing this project. There are holes in several places where I've tried all sorts of code to fix it but to no avail.

The biggest problems I'm facing are getting the auto numbering to work, editing to properly work, (The editing would actually create an new item with a new ID to show the history of the item) and credentials (two teams with separate login areas) to be properly captured and passed through the form for output. I ended up going the multipage way but am in no way tied to it. I know my code's not efficient in any way, but I'm a beginner who never read the instructions, lol.

Sorry for the rambling. Again, any help at all is GREATLY, GREATLY APPRECIATED.
Example(Errors).xlsm

[Orestees]

Anyone had a chance to take a look?

I know there's a few holes but any help would be awesome. Need the guru's and more cowbell!

[mike7952]

You could use this in cell C2 and drag down

Please Login or Register  to view this content.

[Orestees]

Tried that but all I get is a java style icon and a thick box drawn around the cell with no shown value.

[mike7952]

Is this showing 1 2 3?

Example(Errors).xlsm

[Orestees]

Yes, that works perfectly Mike!! Not sure what I did wrong but I appreciate that quick fix!

Now for the other holes. Any ideas on those?

Sorry Cutter, still not marking as solved unless you think I should repost again, minus the auto-numbering issue?

[Cutter]

LOL - How did you know I was watching?

[mike7952]

LOL Watching Who? What??

[Orestees]

Because you're the ever watchful and helpful eye

[Orestees]

Bump on the topic, minus the Autonumber (Thanks Mike).

[mike7952]

@Orestess,

I have know Idea of what your wanting? You have two Edit forms and none of them match the column headings in the sheet. What form are you needing help with?

[Orestees]

@Mike,

The The userform called Edits is just a menu to enter FileEdits. The original userform will have multiple areas to access, I just minimalized it for the forum. In FileForm, the first tab starts in the excel sheets column F. The prior information comes from hidden textboxes which should capture the TimeStamp, UserID, and TransID (A2A).

I've attached an updated version which includes your fix for autonumber (thanks so much again!), centering the FileForm userform, and creating the IDTag from the UserID, TransID, Autonumber, Agent, and FA values. This IDTag should be what can be pulled up during the editing process.

I know there's some holes in my code and I'm 1,000% sure it could be simplified (I'll get to that in a future step). With that in mind, you all have been the best resource and I greatly appreciate everything you all have done. Still just struggling to get the above issues fixed.

Thanks again for your help and patience!

Example(Errors).xlsm

[Orestees]

Just realized that not all of the userforms are connected to each other yet, sorry. I've been running them from each individual userform. Edit's still needs work which I'll do, it can be ignored. For mapping purposes, it's between FileSelection and FileEdits. Sorry for any confusion.

[Orestees]

Ok Cutter, finally marking this as solved. Any further issues will be a new post. I figured out why my UserID wasn't moving between userforms properly. I used the below code to migrate the data properly!

Please Login or Register  to view this content.

Along with:

Please Login or Register  to view this content.

It looks like the rest of my issues (aside from efficient code and error handling) are minor.
Thanks a ton everyone who looked at it and especially @Mike7952 and @Leith Ross. You both have been instrumental in getting me further along!

[mike7952]

@Orestees

I am still struggling for what you want done. I know it probably makes sense to you but I dont see what your wanting. What do you want to happen when the FileSelection Form loads? What is to happen when the FileEdits Form loads? You have 12 comboboxes with values in them already 1 - 12?

[Orestees]

@Mike7952

You're right, I didn't explain those values 1-12. They were really only placeholder values to state that 1 is question 1 (not shown anywhere in the sheet) and the answer selection was either n/a or had a value which would be in the textbox to the right. I should have nixed some of the pages (non-essentials) before I uploaded the userform. My deepest apologies for all of the confusion. I was in such a rush to get the upload done I skipped some important data removal.

Best.