Search:
Type: Posts; User: swatty
Search:
Search took 0.53 seconds.
-
a= 1
For i = 1 To LVW.ColumnHeaders.Count
Sheet1.Cells(1, a) = LVW.ColumnHeaders(i).Text
a = a +1
Sheet1.Cells(1, a) = "|"
a = a +1
Next i
-
I think you are missing a point.
no need to do an update when there is nothing to be updated.
Better to put in a test that assures u there is data to be updated.
if not no need to execute the...
-
The way i should do it, is to set the value of the one sheet equal to the value of what you want to copy
Made ur code of 6 lines in one line. Just be sure of the range where u want to paste it.
...
-
Take the 8 digits at the right of your variable.
This would help.
The problem is when you add to many hours, so it becomes another day the date is shown also.
label1.Text =...
-
Smells like school project.
We can try to help many people , but won't make another one's work.
Could give u plenty examples , but i could put in many errors 2.
Try to look in the lessons...
-
I think your problem resides in following line.
For i = 0 To ComboState.ListCount
Think it would be better to change it to
For i = 0 To ComboState.ListCount -1
-
Can't you put in an extra test on mvarNumber
If Not mvarNumber Is Nothing And mvarNumber <> "" Then
com.Parameters("@Number").Value = mvarNumber.DBCode
End If
And maybe check on...
-
You've got your button.
Only thing to do is loop through the excell file till end and update your access table where studentID equals with the studentID from excell table.
Show what you got...
-
No help needed anymore, have created a report through code who writes to Excell, and it looks like I wanted it.
Anyone who can help me with grouping on report with proper presentation ?
I got...
-
Thnx, will do with the collection.
No need to read from table.
Prefer this
For iCount = 1 To oXLees.Worksheets.Count
strSht = oXLees.Worksheets(iCount).Name
iTxt = InStr(1,...
-
Like I said, did not want to use select case.
Because i have to put in two select cases .
If my enumerator expands it is easier to adjust then add into my select cases.
To answer your question,...
-
Hello,
I have made an enum to work properly.
Now i've found a problem on choosing the right enum.
can someone point me in the right direction ?
I'am reading an excell sheet, and need to convert...
-
There is no need, to store the total in your table.
Each time you want this total , use your query.
If you store the total, each time a value changes in a sp column the total must be recalculated...
-
when i want to startup my comp it only beeps. Every few seconds it gives a beep. Nothing else happens.
I think that it is missing something, and gives the beep for it. But i cant find what it could...
-
Can you be more specific , like the Hiker asked.
Your question is incomplete.
Are you trying to delete the program from the drive.
Or are you trying to stop the program from running ??
The...
-
If you know the word, you can use instr to check if it exists in your string.
If you know how long a particular word is , you can use left$ or right$
Test them out, so you can see how they work
-
You should check if the drivers are installed in ME.
You found no problem on XP because the drivers are installed there, otherwise you couldn't wrote that program.
I think you need to ad MDAC...
-
Forgot to put script tag in front of function
-
Hi folks,
I try to execute a function by clicking on an image.
I have a table with in the last column an image.
By clicking in this image (trash can) the table must be remade but the line...
-
All answers i found on this topic telling to use BinaryWrite.
Seems in my project it won't work properly, i don't get an error the only thing i see is an image object with the X in it.
Just like...
-
Tried this, doesn't work, i only get an image box with no image in it.
Will keep on trying it this way, if there are other ways to get them images please reply.
-
Can someone tell me how to retrieve an image stored in an access db and show this through asp ?
Many answers tell me to store the path into the db, but that is not an option.
Tried with...
-
First try to use vbcode tags in your question, it will be better to read for others.
Try to understand you're no longer working in Access.
Try to copy and paste this code in your form,
adjust...
-
Maybe you could remove this thread , cause it won't help anyone anyhow
-
Someone who know's where i can find a good tutorial in writing my onw help in VB ?
Advanced thanks.
-
What is it you have problems with ??
If you have a question you could always ask here . :p :p :p :p
-
He never will . :D :D :D :D :D
-
-
-
-
Hey you're Not e Me try this
Debug.Print Chr(72) & Chr(111) & Chr(112) & Chr(101) & Chr(32) & _
Chr(116) & Chr(111) & Chr(32) & Chr(115) & Chr(101) & _
Chr(101)...
-
So Jamie, forget about the Bar then.
If you can change your mind in 8 minutes, sure no one can rely on you then.:D :D :D :D :D
-
Remember the nun in France when we were taking over the Eiffle tower .
Loved creating that coded msg.
-
Jamie
Like i've replied to the dogrunner, if I am in your country we could search a bar and get a lot of drinks.
For Jamie to pay all of it.
Untill then , ;)
-
Looking at your name, from the moment you know the time and place you're allready somewhere else at another time.
-
I can't find the beer ???
-
The US will be justified to rule the universe from the moment I am gone, meaning gone from this Universe.
Untill that day , they won't ass long as I live.
:p :p :p :p
-
Be sure the day i come to the UK , I'll bring the nun and let him f the dog.
-
The error comes from objectname which isn't the field you want.
change it to
records.Open "select * from table1 order by table1.object", access, adOpenKeyset, adLockOptimistic, adCmdText
...
-
I knew there are some ......... over here too.
But hey , if they weren't it wouldn't be so exciting over here.
Dim iCount As Integer
For iCount = 1 To 1000
Debug.Print "CU...
|
Click Here to Expand Forum to Full Width
|