Search results for query: *

it's my first time to use datagrid and im still trying to discover some of its magic - if we can call it that way :) ok - i am using a combo box (contains list of filenames - which are in excel format) and once i selected one... it will be imported into a temporary table - and from there it...

Here's my code... Set rs = New ADODB.Recordset With rs .Open "Select * from tblPartNumber", conn, adOpenForwardOnly, adLockPessimistic For i = 1 To flgPartNum.Rows - 2 If !PartNumber = flgPartNum.TextMatrix(i, 0) Then !PartNumber = flgPartNum.TextMatrix(i, 0) !GenDesc =...

i want to import xls into my table (i mean append not create a new table) the code below creates new table ... the solution that i have as not to receive the error MyTable already exists... table will be deleted first... Question: Is there any other way to solve this? Dim conX As...

Function Connect_Dbase() Set Conn = New ADODB.Connection ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & App.Path & "\dbSys.mdb;" & _ "Persist Security Info=False" Conn.Open ConnStr End Function Dim rsX As ADODB.Recordset Dim strRs As...

Greetings! i have 4 drives (partitioned) let's say C:, D:, F: and G: ... I just installed service pack2 and guess what?!!! after installing SP2 when i was about to open my files in drive G it says the disk is not formated, do you want to format it now (something like that) ... i don't know what...

hello pipz! i am having problem with my computer and i don;t know if it was infected by a certain virus... everytime i ON my computer at start up my screen keeps on blinking - but will stop once it is in the windows mode... i dont know if it is a hardware problem or what ... because this is my...

i am not an expert in vb6 i just code when i need to do so and i am having a problem... i am importing an excel to my database(mdb) using thread222-691548 as my basis... my problem now... that code creates a table... and when i run it again i receive an error the table is already existing... so...

hello people... i think my computer was infected by the so called hackerdefender... i am using a dial up connection and once i got connected after less than one minute or more it disconnects and created a new connection and named it as start_xxx and some popups appears something like online show...

Greetings! Is it possible to import an excel file without considering the fieldnames? Like from the excel file the fied name is LastName and in my table it is Lname... when i import i receive an error.

I made a database using access 2003. But the user of the databse complained that she receive such run time error whenever she loads or run the program. I know for sure that the database is working well and i even tried in 3 other computers and it works very well... Now i don't know what went...

i want to import an excel file... DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8, "Transaction", "\Transaction\" & cmbTrans.Value, -1, "A1:C1" but then the field names of my excel file and field names in my table are not exactly the same at a certain field they are not and i...

greetings! I don't know if I'm thinking possible or impossible here... i am using a simple query that will add or subtract... With the subtract function i want to show a message box if the Qty (difference) is negative... coz my table should not contain a negative value... it should show an...

I know for sure this is just a simple problem - but i just can't figure it out on how to solve it. I am using a query to import a result query to xls but what i want to do now is that - i want to change the field names of the table. My query consist of some expressions so the Fielname consist...

I am using a query to update/delete/append my table - but the warning messages really drives me insane! how can i avoid it? like if i want to delete perhaps - it will just delete without showing the warning blah blahs... anyone - please advice.

i have multiple mdb let's say 5 working mdb and i want to make a one mdb that will serve as the main menu so the user will not open all the mdb every now and then... like there would be 5 buttons in myMenu.mdb so if i click button 1 it will run 1.mdb and close the myMenu.mdb and if i clik 2 it...

hello geeks! I need your help... i have multiple mdb let's say 5 working mdb and i want to make a one mdb that will serve as the main menu so the user will not open all the mdb every now and then... like there would be 5 buttons in myMenu.mdb so if i click button 1 it will run 1.mdb and close...

i'm working with 3 mdb connected with each other... scenario: from mdb1 upon clicking 1 button it should open a form of mdb2... Is it possible? How? Please advice. Thanks in advance

In Access we can export an .mdb table to .xls format with this code: DoCmd.OutputTo acOutputTable, "Table1", "MicrosoftExcel(*.xls)", "\MyTable\" & "WorkSheet1.xls" I want to do the same thing using VB6 but don't know how? Please guide me on how to do...

i made a program in access and im converting it using vb6. but i encountered a problem --- in access it's easy to convert a table to .xls format - but in vb i dont know if it's possible. if so... anyone can teach me how? thanks!

Greetings! Is it possible in VB6 to view reports with the way Access can do - the priview type? (without using crystal reports)I dont know much about reports in VB... Please help me thanks! ...