Trouble with Code - Adding New Record with Form does not function

Hello,

Instructions... Below is the code..

The Form lets the User list add,delete etc....

When you select the Update button - the User is prompted for a Pwd..

For some reason the code "BROKE"... Not able to add new agents to the list.. Here is the code...

Please Login or Register  to view this content.

Any Idea's...

John

It would probably be easier for someone to troubleshoot this if there was a sample workbook with the code and userform in it.

If there is a way to do that on here, I don't know how to go about doing it. If you send it to me only, then others wouldn't be able to see it. Sometimes it's best to have several people troubleshoot these things because the solution I might provide might not be the best one and someone else may know of a better way.

removed attachment

I don't know how the commercial services work, I haven't used them ..........yet.

Originally Posted by JJFletcher

For some reason the code "BROKE"... Not able to add new agents to the list.. Here is the code...

Please explain what "BROKE" means.

• Does the code run?
• Does it run but do nothing?
• Does it produce error messages? If so, what do the messages say?
• Does it produce unexpected/wrong results? If so, what do you expect, and what actually happens?
• Does it hang?

This is long, complex code that is hard to understand out of context. You will get better responses if you attach your file to a post. You can't attach files to a private message, and we discourage using PMs for problem resolution.

Originally Posted by JJFletcher

Well they got my hard earned $20 - for sure!

I think you overestimate the importance of $20. You're in no danger of being ripped off merely because you're struggling with learning how to use the Commercial Services forum. Post a question there and assign the points, include a link to any duplicate threads here in the free forum and they will be removed for you. No drama at all, albeit a little patience with us and yourself getting used to it may be necessary.

Can you please review and advise as to why a new record being added does not function?

U/P = guest

Update = "Password"

VBA = guest

OK, no Commercial Thread, then, you'll continue here in the free forum? The $20 in points you purchased may go to waste if you do not create a Commercial thread and assign points there as a reward for one of our main gurus to attend to it. Just a reminder.

The problem is that you have nothing in column A but you are using that column to try and find the next empty row.

Try using a column that actually has data in it.

Norie,

In the employee column which is Column A has the names of the reps in it - do not understand why you say there is no data?

Can someone tell me how to create a Post/Thread in the commercial section?

John

John

There is nothing in column A on the Ranking sheet in the workbook you uploaded.

See the attached image.

Hi Norie,

That is the Ranking sheet - the record that is being created is in the EmployeeData sheet

select Show and enter Password and see

Please Login or Register  to view this content.

John

You need to reference things properly, especially when you have hidden sheets.

This kind of code is just crap.

Please Login or Register  to view this content.

I have deleted the samples - if you want to see them - please ask

Something like this is simply far simpler to read and edit:

Please Login or Register  to view this content.

CaptureError.JPG
This is the error when running the form

What is the value of that element when the error occurs?

I just ran that code exactly as shown after filling in a bunch of random data, no errors encountered.

The value for that is the Supervisors names selected from a drop down list - you can see it in the form. Also when I take the last reference to the error - The only data that is placed into the row is the fullname

Video of me using the form: http://screencast.com/t/tcUM56zpU6

Please let me know when you are online so I can put the file up

Here is the exact file I am using - I saved it once the entry was made.. AS you can see - only the full name is featured. Please let me know when you have the file - I want to delete it from the thread...

The code only placed the full name

John

See post #27, the code seems fine. I noticed in mine it was putting the data much further down the EmployeeData sheet, so scroll down, perhaps it's doing that to you as well. I cleared all the data from all the cells below the existing data and it stopped doing that.

No, I have no thoughts on a reworked macro or workbook I have never seen.

Not tired at all, was a polite jab at my lack of mind-reading skills and inability to see into the workings of other workbooks I've never seen.

Feel free to post it and I'll certainly take a look, not tired at all, I've been here for years and will be for years more. If the file is too large, zip it up.

I see nothing wrong with your account. I'll ask the Tech Team to have a look, unfortunately that usually takes a bit of time.

Taking out the unneeded "Yes" test is a great. Always adapt the code to only include the tests you actually need. Good stuff.