Syntax error in "From clause"
dbs.Open before the Loop.
On the Do While, the Percent is being populated now with .5 (50%), so it seems that we have made progress..
Last post Joe, I swear. I'm about to throw this *($)# out the 2nd floor window. Here is the entire code, did I place it where you are telling me -
-------------------------------------
Public mcnn As ADODB.Connection
Private dbs As ADODB.Recordset
Private Sub Command1_Click()
Dim...
I'm selecting an EmployerName from the ComboBox and then typing 50 in the Text1 box (to represent 50%) I have 6 records in the Access db under that specific EmployerName, so it should return a random 3 records from within it.
Joe, Cursor over Percent and Count yields nothing. Should it return a pop-up box with a value? Typing ? Percent (ENTER) and ? Counter (ENTER) in the Immed. Window yields nothing either.
When I place the cursor over Percent and/or Count, nothing happens. Is this the correct place?
count = 0
Percent = (Text1.Text / 100)
EmplName = Combo1.Text
As for the Imm. Window, typing ? Count and/or ? Percent returns nothing. Am I all wet on this?
Joe,
I'm obviously in this over my head- I am not at the point in my VB training that I know how in the heck to accomplish the debug process/run to cursor/etc. Could you possibly provide a bit more detail?
John,
Here is the modified code - I've attempted to dump the results into a Textbox, but I'm not getting any output.
Public mcnn As ADODB.Connection
Private dbs As ADODB.Recordset
Private Sub Command1_Click()
Dim EmplName As String
Dim Percent As Integer
Dim count As Integer...
John,
Thanks. I just want to be able to dump the results out to another blank form for viewing/printing. As I look back into the code you posted, is there any modifications to it that need to be made so that the entire Access record (SSN, FirstName, LastName) will be pulled, or is it in place?
Joe - I'm not being very successful at figuring out how to get the results of the code you suggested, into a form/report that can be viewed/printed. How do I direct the output of the Text1.(LostFocus) event to a form/report that I can view/print? Learning VB is a heck of a lot more difficult...
I've got a VB form with an ADODB connection to an Access table. Each of the text fields are bound to the respective Access table fields. There is a combobox on the VB form that is being populated by an existing Access query. It works great, but here's my dilemna:
For records already in the...
zemp,
Your code worked great, thanks. Question; I placed it within the FormLoad event, and it works fine. But when the form loads, the combo box entry defaults to blank, rather than displaying each records field value within the Access database. The combo box does populate with the results from...
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.