Mihail, Thank you for your help. It works just like a charm.
@Neopa, sorry for not punctuating my words but you are an educated man i see, as for me not so much. I Know you meant well and i appriciate it. I know your just doing your job sorry next time ill put my questions in the right form.
lee123
lee123
Last Activity: Dec 21 '12, 02:32 PM
Joined: Feb 11 '07
Location: United States
-
Mihail, thanks for the file i will look at it.
lee123Leave a comment:
-
hmm.. Neopa, what's going wrong is that it shows nothing when it is executed everything else shows up but the items in the listbox. the line comes out blank. when you do the textboxes that are on the form the information shows up. but the way i was shown it doesnt work (the listbox information not the textboxes) all i wanted to know is how do you get the information from the listbox to print in notepad. the information i want to show is. (year, make,...Leave a comment:
-
well i have tried that and others but nothing? on my form i have textboxes and they seem to show up but its just the information in the listbox dont so thats why i used the "STRING" function, i guess there isnt a way to do that
lee123Leave a comment:
-
well when i do it, it says "bad file name" but there is some thing in the listbox. so why doesnt it print. i mean if there is something in the listbox it should print right?Leave a comment:
-
How to text file items in a listbox
i have been working on a database and i was hoping someone out there can tell me how i can list the things in a listbox to text file in notepad i have tried everything i know but i still cant do it? i have used
...Code:Dim ff As String ff = FreeFile Me.Refresh Open "C:\AutoMaintenance.log" For Append As #ff Print #ff, "Vehicles Owns" & " " & VehicleList -
maybe you should try this
[CODE]its kinda hard to understand you question, "1stbooks" a field?Code:If Trim(Text4.text) = "" Then clsbooks.SearchBooksFrm lstBooks = "" Else clsbooks.SearchBooksFrm lstBooks = Text4.Text End If
if so then the code should be like this
...Code:If Trim(Text4.Text) = "" Then clsbooks.SearchBooksFrm.lstBooksLeave a comment:
-
Two datagrids
i bought a book and it gives examples on certain controls and this one is with two datagrids, but when you use the code it doesn't work. in this code i used the BIBLIO.MDB to make this work but it keeps on giving me an error and points to the Refresh part can anyone tell me what is going on here
...Code:Private Sub DataGrid1_RowColChange(LastRow As Variant, ByVal LastCol As Integer) Dim pstrSQL As String pstrSQL = "SELECT
-
Thanks You I'll Try This..Leave a comment:
-
Cascading ComboBoxes
Hello its been a while since i have come to this web site and its been a while since i have done any programming but here i am. my question is going to be difficult to explain but here it goes. i have been trying to make a auto parts database but i cant get it to cascade the parts i need for certain cars and years.
in my database i have 6 Comboboxes on an unbound form each one drills down to the next one as it suppose to but when i... -
I Have Figured It Out The Correct Code Was This
Maybe Someone else can use this for an example but it opened it up correctly thanks for your help Horace1Code:Private Sub CloneDVDKey_Click() Shell ("Explorer.exe C:\CloneDVD_Key_12510154.CloneDVD"), vbNormalFocus End Sub
lee123Leave a comment:
-
well it's not on the web i have it in the folder specified but it's a file, like i said i have did this code once but i never saved how i did it. i havent tried your code but i dont think it's going to work. because it's in a folder
lee123Leave a comment:
-
How to use the "Shell" method to open up a file?
I have a program that im making and i want to click on a button to open up file or registration file. i did it once before buti cant remember how i used the "Shell" function to do it. my code i think I Did is this.
I think I Did this...Code:Private Sub CloneDVDKey_Click() Shell "InternetExplorer C:\Program Files\Soft2011\Clonedvd_Key_12510154.CloneDVD.Exe",VbNormalFocus End Sub
-
Thank You for fixing this i have tried it out and it cool...
lee123Leave a comment:
-
ok well i'll try to upload this ok
lee123...Leave a comment:
-
from the response table i have in the response table these are the fields:
ResponseID Autonumber
StudentID Number
QuestionID Number
AnswerID Number
like i said this is from an access 2003 database program i made sometime ago but since i dont have access 2003 anymore and have access 2000 pre i wanted to make it an excutable because i have the developers kit for this
there...Leave a comment:
-
well everthing is working but now i am getting an error from a button code that goes to the next question why is that.
...Code:Private Sub Command9_Click() ' this is to move to the next question Dim db As Database Dim rs As Recordset rs.AddNew rs!StudentID = StudentID rs!QuestionID = QuestionID rs!answerid = AnswerList rs.UpdateLeave a comment:
-
Listbox Additem in access 2000
I did an example of a test in access 2003 to load some questions from a table but i want to do it in access 2000 but the way it is done in access 2003 is like this:
...Code:Private Sub LoadQuestion() Dim NextQuestionID As Long QuestionText = "" ClearAnswerList NextQuestionID = Nz(DMin("QuestionID", "QuestionT", "QuestionID > " & QuestionID)) -
multi listbox control
i have three list boxes and want to know how i can choose from one listbox and have the others fill in with information example:
in the first listbox if it is loaded with names and i click on one. then in the second listbox would produce an age and the third listbox height.
but i tried with an if statement but it didn't work example:
first listbox:
...Code:if listbox1.text = "Frank" then
-
kinwang2009,
thank you for the help. and it works is there anyway you could explain this code to me. because i am not good with recordsets just from the (ADODC1) control way i would like to know a little more about this connection so i can continue to use it and understand it.
lee123Leave a comment:
No activity results to display
Leave a comment: