Search:
Type: Posts; User: ganeshmoorthy
Search:
Search took 0.31 seconds.
-
try this statement
DAO.RepairDatabase ("MDBFileName.mdb")
-
one option would be to have control array
-
Im not sure whether it will be a good practice todo like this...anyway just give a try to using environ variables; set the value from one vb prog and access it from the other...you can search lots of...
-
To check whether if the file exists and write, you can use just the Append mode as below
Open "G:\test.txt" For Append As #1
Print #1, "abcdefghi"
Close #1
it will take care of...
-
may be you can use a common public file to store the values you want to access from other program...may be you can generate a txt file and write your values from com1 and from com2 access it.
or...
-
to move it you need to increase its value ....ProgressBar1.Value = ProgressBar1.Value + 1
but you need to have proper value to increase the value..for example if you are executing a set of...
-
To print a file anyhow you need to get the full file name....
how do you find that this 1234567 is linked with a specific file name...do you have any database to fetch this details....
after...
-
no probs as you both posted at the same time without your knowledge...it happens at times...;-)
-
Can you try opening the recordset with a query to see a record exists...
Sql = "Select * From tbl_Table Where Field1='Field1'"
rs.Open Sql, Cn, adOpenKeyset, adLockOptimistic
If rs.EOF Then
...
-
Or use a query to return values like this
Set mrs = dDB.OpenRecordset ("Select * From [Available]")
-
yes, by copying you can create an array of controls as mentioned in the previous post, else try the below
1. Set the index of the first text box to 0 (for ex. set txt1.Index = 0 'at design time)
2....
-
do you have any unload commands for unloading any of your forms when you are done...
-
Use the Query like the below...
Select * From YourTableName
Where [Name] = '" & txtUserInput.Text & "'
Or [Address] = '" & txtUserInput.Text & "'
Or FaxNumber = '" & txtUserInput.Text & "'"
-
Do you have any specific requirement to use the cursor from VB, If not why dont you use just SQL statement from VB to get the result...
sSql = "Select FN1, FN2, FN3, FN4 FROM MY_TABLE Where FN2 =...
-
Using recordset...
rs.Open ("Select * From glActivity Where CheckFieldName = ValueToBeCheckedFor")
If rs.EOF Then
MsgBox "Not processed earlier !"
Else
MsgBox "Already Processed !"
End...
-
Could you post some example data of what you have and what you need to get from the table...this will help us to understand you clearly...from your thread I have understood that you want to get top...
-
For reading from the magnetic card you dont need to write any code as its just a keyboard wedge. When placing your cursor and swipe the card in the reader will get the value from the card to the...
-
this function expects an argument (a key name) to be passed to it...so try with passing a key from the keyboard, for example GetAsyncKeyState (vbKeyEnter)
-
are you not able to click on an item in the combo box or when you click on an item in the combo nothing happens...whats the actual problem...
-
what do you want to do after you remove an item from the combo box...if possible please post your code here, so that we can understand it better..
-
you have to assign the .Text again to have the display, probably you can do like this Combo1.Text = Combo1.List(0)
but the combo should have atleast one item to display without any error
-
you can use ReDim and Preserve to reassign the number of elements in an array....I did go thru your full thread...this is just for the last reply...
-
Dont worry, I have fixed it by downloading msrepair.exe from microsoft site. It has fixed the prob.
-
I have installed a project which i have developed on an XP system, onto a windows 98 PC. It replaced the oleaut32.dll file to a latest one and due to that now, Im getting an error, oleaut32.dll can...
-
can you just try removing the resume next statement and make it as On Error GoTo ExecuteSQLa_Errorand then tell us which line it gives error
-
Im not sure how to call the macro for SAP, but if you can execute the same steps in vb, you can get it done. Like Object.<YourMacroStatement1>
Object.<YourMacroStatement2>
'and so on
-
Can you point out on which line this error occurs
-
Do you have any macro in SAP to do this task
-
Use a Group By Query and when each group changing add a row to the flex grid and then add the employees' names. Hope you understand this.
Dim sPostName As String
Sql = "Select EmpName, PostName...
-
Use an ADODB connection and bind it to your access database. Then run Connection.Run statement with this sql, it should help you to do what you wanted to do.
And for the common dialog use it like...
-
Yes, the post in number 7 would solve you issue,
Just out of my curiosity, how these values got saved into your database..
-
Smitas,
you need to add a reference of your required database object to your project.
What database you are using and what is the technology you want to use...
If DAO then select Microsoft DAO...
-
If I have understood you correctly, you want to construct a query from two dates selected from the listview...
-
penyakittable.Open "Select * from penyakit where [Nama Penyakit] = '" & Combo1.List(Combo1.ListIndex) & "'", conpenyakit, adOpenDynamic, adLockOptimistic
If Not penyakittable.EOF Then
If...
-
if you want to copy a specific form then just use FileCopy App.Path & "\Form2.frm", "C:\Form2.frm"
-
this will convert it to date...CDate(24026)
-
if you try with 00000.00 or #####.##, then you will see the difference
-
The user on the server decides what to send to client...
My bad....
-
ppita,
thank you very much for your work...let me check the code and get back to you..
-
Thank you very much for your interest in making a sample for me !!!The user will select multiple files from a flexgrid and click on the send button.
|
Click Here to Expand Forum to Full Width
|