I am still stuck on this. If anyone could help me out, It would help me a lot.
Thanks
jesse07
Last Activity: Nov 13 '07, 03:47 PM
Joined: Sep 14 '07
Location:
-
How to assign all fields returned by a SQL SELECT statement to an array?
Hello, I have a listbox that list the names and phone numbers of clients. I want to look up in a large table (84 fields) off of the phone number from the listbox. My question is how do I assign all 84 fields to an array from a table, so they can be easily used to fill out variuos reports.
[code=vb]
Dim strSearch As String
Dim strSQL As String
strSearch = Me.lstCompanies .Column(5) ' set strSearch... -
SIMPLE SQL ? Large insert
my SQL statement works when I do a small part, but I have 83 fields I need to insert into a table in Access and Im try to remember how to do this. I know it is really easy.
strSQL = "INSERT INTO Table1 " _
& "(user_comp any, user_fname, user_lname) VALUES " _
& "('" & arrFill(1) & "', '" & arrFill(2) & "', '" & arrFill(3)... -
I was hoping to do this with out buying a program. I want to create the pdf at the end, but how would I reference the 6 forms as 1 pdf because my version only allows you create the pdf of the current form through the print button. I was hoping to do this with just writing some code in VB...Leave a comment:
-
Merging 2 PDF Files into 1
I have a program that allows the user to fill out and load in various information onto a form from Access. I save the information on each form as a PDF file (primopdf used to create the pdf file from Access*great little program*), but now I have 6 different PDF files (one for each page), and I would like to merge these. Instead of have InsuracePage1.p df, InsurancePage2. pdf, etc... I would like them to all be saved as 1 pdf file Insurance.pdf that... -
Creating a PDF file from a form in visual basic
Hello, I have form that I have created in Access with VB 6.0. Instead of printing the form and information enter to a printer than faxing it. I am trying to save all the information entered + the form layout as a PDF file, so the form can be faxed electronically. Any suggestions? -
I can do a message box but the same prompt comes up when I execute the delete from the table
*************** *************** *************** *****
You are about to delete 1 row(s).
Once you click Yes, you can’t use the undo command to reverse the changes. Are you sure you want to delete the selected row?
*************** *************** *************** ******
I do not want this prompt...Leave a comment:
-
Running SQL statements with VB 6.0
I would like to customize running my SQL statement. At this moment, I am using->
DoCmd.RunSQL strSQL
This statement will deletes from one of my tables, but instead of getting the standard message box:
"You are about to delete 1 row(s).
Once you click Yes, you can’t use the undo command to reverse the changes. Are you sure you want to delete the selected row?
... -
Im using 6.0. Is .dat the file extention that most people prefer to work with. I am trying to put the finishing touches on my program and have a long term goal of putting it in a hand held device to run independtly, so any suggestion you have on saving or how I start my next process. I would appreciate it. I have it working through a tranfer data to excel, but again- Independent is the goal....Leave a comment:
-
Saving items from an array
I have a program that allow the user to populate an array from a listbox. I want to save the material. I have transferred the items to an Excel worksheet where they can be saved, but my goal is to have the program run independently from any other programs. Should I save the different rows from the array to a .dat file?
What is the best way to save the information? I want to give the user an opportunity to save in the middle of the... -
It worked on my version at work. I will try it when I get home. I swear I did this last night but my eyes & brain were a little strained at that point.
ThanksLeave a comment:
-
unselecting a listbox
I have 6 seperate listbox and I want the user to select 1 value from 1 of the 6 boxes. The problem is after the user clicks the listbox1 then listbox2, listbox1 still says highlighted. I want to "unclick" or deselct the line from listbox1 when the user selects listbox2.
Any suggestions? -
Thanks everyone for your input. I figured it out. I went to the control source feature in Access and put in this code to reference it to a text box. As soon as I had the value linked to the textbox everything else is easy.
=[cmbPlayer].[column](1)
I haven't done much programming the last 5 years, it is amazing how you forget little steps. Thanks again.Leave a comment:
-
I've walked away from this, and I am trying this again. I still can only display the number from the combobox of the listindex.
Ex. Combo box has (mike, jim, alex, and pete). When I select Alex it is displayed by the listindex of 2. I want to show the name alex, and then store this in an array.
I cannot refereence cmbbox.list.(cm bbox.listindex) because my version of VBA doesn't have a .list property....Leave a comment:
-
lblCurrentPlaye r.Caption = cmbPlayer(Index ).Text
I still get an error. I have tried that syntax before, but I still don't think I am referencing the right part of the combo box. Does the cmbPlayer(Index ).Text refer to the selected item from the combo box?Leave a comment:
-
I will play around with an SQL insert.
Thank you....Leave a comment:
-
Referencing a listbox in an array
I am trying to change a value in an array when the user selects a name a from a list or combo box. Also, I want the highlighted item to be displayed in a Label for the current selection. After all the names are selected from the boxes than I going to write those to a file or table. It sounds real simple and it probably is, but I am having a brain fart.
lblName - label
lstName - name of listbox
arrName (1, lstName)... -
I have a similiar problem I have an multidimentiona l array that I would like to enter the data into a new Table in Access. Did you figure this out yet? I also find the text file to be redundant, but Im not sure how to do this too.Leave a comment:
No activity results to display
Leave a comment: