Search:
Type: Posts; User: hondaboy24
Search:
Search took 0.04 seconds.
-
hi i have a mshflexgrid and i am using the clip function but is there a way in which when a user clicks any column of the grid, i can get the whole data of the whole row? is that possible?
-
hi i have a data report in vb6 that is attached to a data environment, but i have a problem with my query.. my query will consist of a where clause for example: WHERE date = '" & form1.label1.caption...
-
yup i did and it worked thanks.
-
hey how do you stop the exe file at run time? i have an exit button with unload me as the code but all it does is closes and it never really stops. is there like a system.close for vb?
-
isnt there a way around it? i want to retrieve all the other fields as well.
-
yea i tried that already but it does not work, it inserts everything to my table instead of just distinct box numbers.
-
hi i have this code:
x = "SELECT ArtNo, Name, Quantity, DateIn, UserIn, Distinct(Box) , Section FROM inventory WHERE Name = '" & Label4.Caption & "'"
Set rs = getRecordSet(x)
Do Until rs.EOF
...
-
-
hi i have this query:
x = "SELECT ArtNo, Name, Quantity, DateIn, UserIn, Box, Section FROM inventory WHERE Name LIKE '%" & txtname.Text & "%' OR ArtNo = " & txtname.Text & ""
this query is...
-
i found it already it should be & instead of + . thanks guys
-
i tried it but i am getting a type mismatch error
-
hi. how do you insert a variable in a msgbox message? i have this ryt now but it does not work.
MsgBox "Incomplete Set. Box + i + missing.", vbCritical, "Error"
i is the variable. thanks!:)
-
yea but i need the id column because it is the column where the user will have to click then whatever value it is i transfer it to a label. i am using the mshflexgrid1.clip
is there a way where i...
-
my query just selects all the data from the database and puts it in the grid and sorts it by id.
-
how do i get the last record number from the grid? so that i can put it in my where clause in the delete query. :)
-
I do not know the condition for my WHERE clause, i do not have or i do not know the last entry so i do not have anything to compare it with.
Let's say i have four id's: 3,4,9,11 stored in my...
-
hmm you have a point. so my question should be how do i delete the last record on the database without using the WHERE clause?
-
Yes to both questions. :)
-
hey how do you delete the last row in a mshflexgrid? for example i have 5 fields and i press a button to delete it so it will delete the last row then when i press the button again it again will...
-
i want my program to check for duplicate data in a certain column then highlight the entire row. so let's say i have 3 rows with the same column data how do i highlight and check these 3 rows?...
-
hi i have a datagrid where the data comes from a database, is there a way in datagrid where the user will just click on a cell then the selected text on the cell will transfer to a label or textbox?...
-
-
hey yea this worked fine thanks! i have another question.. whenever i click the button or whenever this code is implemented, the excel file opens, is there a way for it not to open?
-
oh yea i totally forgot about the last parameter. thanks you
-
i currently have this line of code and it works fine
Set xlSheet = xlApp.Workbooks.Open("C:\Documents and Settings\cheng\Desktop\IKEA\excel\AL010_08-01-20.xls").Worksheets(1)
but my system...
-
hi i have this query where it imports the values from an excel file to ms access there are only 2 fields i need the first one is a number and the next is a word with apostrophe's in them so this is...
-
hi, i have this code where it will import from excel to access but it won't accept fields with apostrophes in it, is there a way around it? i remember a code, something like replace? but do not know...
-
will this code work for an update? if i already have an existing table and whenever the user uploads the data will just append? and what if i only want 2 columns out of lets say 8 columns in the...
-
yes i did, this is currently my code now:
Private Sub Command1_Click()
Dim strSQL As String, j As Integer
Dim xlApp As Excel.Application, xlSheet As Excel.Worksheet
Set xlApp =...
-
ok i am trying to import excel to access and i have been looking for sample codes to help me do it and i found one
Private Sub Command1_Click()
Application.DoCmd.TransferSpreadsheet...
-
hi i used this code but i am getting an error message which is : data type mismatch in criteria expression
-
hi is this possible? import an excel file to ms access through vb6? i already have the code to browse for files, all that is remaining is for the user to click a button then the data in the excel...
-
yea but the data in my datagrid comes from the database.
-
how do you resize a column of a datagrid to match the length of the text in it? and is it possible to change the style of the header to bold? thanks :)
-
-
hi, i am using vb6 and ms access and I can't seem to get the syntax for the like clause to work. i currently have this query:
"SELECT * FROM inventory WHERE name LIKE " & txtname.Text
is this...
-
-
yea but what i mean is that initially i do not know what the user will be inputting but i want to make sure that whatever he inputs, if there are special characters it will still be saved with the...
-
hi, i am trying to insert special characters from a text box to ms access and i am using visual basic 6. special characters like ' . / and letters with lines above them. How do i save them directly...
-
hi.. i have a combox box where the texts come from a database.. is it possible to color code the text in the combo box? let's say i have 5 data in the combox and i want each of the texts to have...
|
Click Here to Expand Forum to Full Width
|