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.
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...
I want to be able to have a capture file running constantly, only stopping to save every night at midnight. I believe I can figure out the "capture on" "capture off" part of the script, but am unsure how to specify time.. Other that the 'waitfor' command. Can anyone help?
Its an NGX5500 or a 6400... Its a small DCS Tellabs bought.. I just wanted to make a script including a dialog box that made x-connecting T1's easier for some of our techs.. I love the command line, but some find it easier to point and click..
Do you have any 5500 scripts you use?
Ok.. Let me be more specific..
I have a command I execute on a command line.. Example.
ENT-CRS-T1::VARI1,VARI2:::2WAY:CKTID=VARI3:IS;
I want to run a script that pops up a dialog box that has 3 text boxes. 2 for VARI1 and VARI2, another one for VARI3. And also a button that executes the...
I have created a dialog box that requests 2 different inputs from the user.. I then want to take those 2 inputs and insert them into a command and then run the command.. I have already made the dialog box and really am unsure how to do the rest.. Can someone help, or point in the right...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.