It sounds like the SELECT isn't finding the record that you are looking for. Try:
rs.Open "Select * from Landlord where Landlord_Name='" & Trim(cboName.Text) & "'", adoconnection, adOpenDynamic, adLockOptimistic
If Not rs.EOF Then
rs!Landlord_Name = cboName.Text...
I ran into that problem a while back. Try this:
1. Make sure the dll (MSSTDFMT.DLL) is on the system that you need to run your application on.
2. Run this shell command from within your app that calls regsvr32.exe followed by the dll name, so:
[code]shell "C:\winnt\system32\regsvr32.exe...
I am trying to "POST" some XML stuff to a webserver, using the Internet Transfer control. When running the Execute command, with "POST"... the StateChanged event never occurs.
Here is a portion of the code that I have:
Inet1.Protocol = icDefault
Inet1.AccessType =...
Try using the RowSel and ColSel properties.
Adding the following code:[code]
MSFlexGrid1.RowSel = 0
MSGFlexGrid1.ColSel = 0
[\code]
will set cell (0,0) to be "Selected" and therefore highlighted.
I'm trying to open and display an existing Word document without starting the Word application. I simply want to display it as read-only in a window on my form.
I would like to keep the Word formatting.
I have tried reading the file line by line using Input, but since it's not a text file...
When displaying the form using form.show, make sure to specify it as being modeless as in the following:
Sub main()
frmMain.Show (vbModeless)
End Sub
If vbModal is used, the form will not show on the task bar.
(:I Yeah - I did mean:
[code].RecordSource = pc_select[\code]
I will try using Ucase to make sure the field entry gets capitalized, but it still doesn't make sense to me why the string in pc_select didn't match what was in .RecordSource.
Thanks for the tips!
I'm using the ADO data control. I build a string for my SELECT statement to look up a user name, such as:
pc_select="SELECT * FROM user WHERE username='" & UCASE(username) & "'"
I then assign pc_select to .recordsource:
pc_select=.recordsource
When running the program with...
I've recently upgraded from NT3.51 to NT4.0. Now when I start my old Foxpro 2.0 application, I get the errors "Source Not Available" and "Too Many Files Open". Any help/information would be greatly appreciated!
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.