Recent content by sramelyk

Whatever I enter in the dialog box.. Or in the cell directly.. Sometimes while experimenting just random characters.. maybe I don't understand.

Nothing.. For example.. I I have the first 20 entries already there.. And I delete one of them.. I would expect that when I enter new info in the dialog box it would put the information in that new available cell.. Does that makes sense?

Clear contents definitely worked. I can handle this just fine.. But I am afraid other user will just delete the information.. No way around this? I KNOW SPACE IS A CHARACTER.. But I am making this for several users and was just trying what I believe others would try.

I tried a couple of different ways after your post.. Highlighing every cell then hitting delete and also just hitting space bar.. Now its starting in a18.. I can delete a18 and it starts there again.

Its strange.. It made no difference. The first empty cell is A6 which is the first cell on the spreadsheet.. It always puts the information in A17 if there is nothing there.. That to me doesn't make sense.

Where would I insert the particular code you are referring to?

Here is my code.. I am very inexperienced with VBA.. Private Sub cmdAdd_Click() Dim iRow As Long Dim ws As Worksheet Set ws = Worksheets("louisvilleinv") 'find first empty row in database iRow = ws.Cells(Rows.Count, 1) _ .End(xlUp).Offset(1, 0).Row 'copy the data to the database...

I have an excel sheet for entering inventory. I have created a dialog box for user input for rapid entry. I have a problem though. If I clear the worksheet of all data and enter more data using the dialog box it doesn't enter it in the upper most empty cell. If something gets deleted I want the...

Ok. I am the telco on this problem and am looking for suggestions for the vendor/customer. This is not VOIP. We are providing the BCM 50 with a PRI and they have digital sets. Randomly when someone calls in the Customer hears themself echoing, but not the incoming call. Also, the calling...

Ok.. I am going to try and understand some theory here.. I have been trapping calls all day and have some interesting results.. Only problem is that I don't know how the Meridian should be responding, maybe you guys could help.. Here is what is going on. A call is placed to this customer (THE...

Actually.. Now that I have done some more testing.. It appears that the phantom calls are due to a disconnect failure. Occasionally, and I mean maybe a couple of times a day, after a call completes and the calling party hangs up the line doesn't disconnect. This seems to be in association with...

I actually work for a CLEC. We have a customer who owns a Nortel Norstar key system, I believe a meridian. It has software revision v1.1 We are having intermitant dropped calles coming in.. We have done way to many things to list here to try and find the problem. My question is this, how...

No, I don't think so.. What is strange, is that during the crazy restart, turn this connection off, restart, try this, restart, at some point I did connect fine to the router and could access the internet.. i lost the connection and never have gotten it to work again.. I have in the past...

The easiest answer to that is.. NO.. When I first got the wireless router, my first inclination was to try out the wireless card in my laptop without WEP.. I actually connected with one laptop, one time.. I got up and moved to a different room and the connection dropped.. I havne't seen it...

I just bought a d-link 514 wireless router. I already have a 'WIRED' home network using a linksys router/firewall.. I put the d-link on a port off of the linksys router and I can connect to it wirelessly with my IPAQ and can access the internet fine.. My problem.. I have a Buffalo wireless...