Search results

Anyone know the answer? I'm testing something out but I'm using another querying tool to get the data which is greater than 65k (excels limit), so I can't import the data I have to manually copy/paste.

Just ask it here, we don't bite... hard.

any suggestion or criticisms on the way I am doing this?

Here is my code, not sure if this is the best way to do it... Private Sub cboOrigin_AfterUpdate() Dim varID1 As Variant Dim varID2 As Variant Me.cboDestination.Requery varID1 = Me.cboDestination.ItemData(0) Me.cboDestination = varID1 Call...

So would I do this code 6 times for each box?

I do, I have this for my first two boxes... the remaining boxes also have similar code Private Sub cboOrigin_AfterUpdate() ''''''''''''''''''''''''''''''''''''''''FILTER START Me.cboDestination = Null Me.cboRoad = Null Me.cboJunction = Null Me.cboTC = Null Me.cboLE = Null...

I have cascaded 6 of my combo boxes. So the second box is dependent on the first box, the third box is dependent on the first and second... so on and so on. When my form opens up all the boxes are blank. What I want to do is when the user chooses from the first box to show the first item in...

Okay you'll read this and think this is a really dumb question but bear with me please! I have a table with about 100k records. There is a field called "SN" and this feild is unique to it self. Although it is not a unique record in the table, this is because "SN" is count EVERY time it passes...

thats hot ././././

can you take a screen shot? I'm not to sure what you're talking about.

Something has to be broken to be fixed!!!!!

wow great advice. I'm not too much of a gambler so I think I will look into mutual funds. Right now I guess I'll have to be content with my 3.5%.

Pretty good job, I started about 2 months ago.

Well it is around 3.5% annually but it is compounded monthly.

currently I'm in a MM savings account with my bank. The real interest rate is around 3.5% (it is not set). So I guess I'll stick with it for now.

Really? I found some online bankers that will give up to 5%, but I just don't feel like opening an account with another bank because I was to be fluid with this money and I know most bank will charge if I want to close my account. Just don't want to deal with all the hassles as well.

Yes, how could you tell?

I currently use this code to open a query based on listbox criteria. Dim ctl As Control Dim varItm As Variant Dim stItem As String Dim strString As String Dim qdfTemp As QueryDef Set ctl = Me!lstT For i = 0 To lstT.ListCount - 1 If lstTrains.Selected(i) Then If...

lol... he is going to be maintaining this database after I leave and he is used to counting his records like this. So if I can do this in a query let me know!!

lol i can't change the title but i meant INVEST