Search results

Morning all, Hope everyone doing great. I have a question relating Access 2003 Database. I would like to know what does the following error messages mean and if I can get any help on this. (I have searched the internet including MS Knowledge base but could not find any information on this)...

Morning Banana, There is no add files option under Project however there are other options like Add windows form, user control, module, class etc. I did manually added the mdb file under bin -->debug folder and used MyConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data...

Yes! it did ask me if I wanted to add the mdb file into the project but at that time I said No. Now I don't know how to add it back into the project. Any ideas will help alot! Regards J

Thanks Banana, however, I do not wish an end user to locate the file as they have no clue about computers (0, nada). All I want is to setup a path in my code so that when an application is installed onto their machines, the application should pick up the source/destination file automatically...

Dear all, as always I am back with yet again a simple question. I have developed an application in vb.net which has VB interface as front end and access 2003 as backend. The application path which I setup initially is : Dim MyConn As ADODB.Connection MyConn = New...

Thanks for the quick and informative response. I did use it as a string and it is working now. Many thanks Kind regards J

Morning all, I am a new user to access database so you got to bear with me. I have created a table in Access 2003 where I have defined a field "Time In", this field should contain only time and not date. I setup the format of the field into Long Time and setup the mask as hhnnss (checked on...

Oh ya! how could I forget that. I'll try it on tomorrow. many thanks Regards Jay

Right as far as I understood you want to create a program which will insert values from VB into the database and at the same time will show the inserted entries into the datagrid which is in VB. The database as the above person said needs to be created with different tables for each category...

Afternoon all, Firstly thank you mission2Java for sharing a wealthy information with us. I have a question regarding the code you have provided. When used, VB.net(2005) says: End Function ~~~~~~~~ Function Establised Connection doesn't return a value on all code paths.A null exception...

Opening these things is bit hard as there are so many hidden places (hinges, some are screwed up and some are plastic hinges in awkward places). If you really want to open it, make sure you have a small screwdriver, a box where you will keep all the screws (screws are really small and most of...

OKi, I need to show the records using a query. The query should show the results from all three tables. Query results should be ================= Number - Population - Table 1Genes - Table2 Genes - Table3 Genes Number 1 - India - AB48 - BD34 - HG65 Number 1 - Pakistan - AB35 -GF45 - LK98 etc...

Hello! i have created three tables and inserted different records in them. I want only "genes" records from table 1,2 and 3 to be shown. The problem I am having is that when I design the query and ran it, it shows me all the possible combinations of records instead of showing only 1 record...

This thread can be closed now as the issue has been resolved. If it is not going to be closed then spammers will spam it just like (example above).

Yepeeee!!! It worked. I am not sure why it was doing this but it is now worked. I closed the db and reopened it and now it is showing the correct records in one table. Many Thanks for your help! Regards

haha I think we are chating like msn over this forum but the forum gets it updated bit late. Sorry for the delay I was making a sample db and then did the same query to show here.

Here i just created a sample (example table) just to show. INSERT INTO Table1 ( class, [group], alle ) SELECT Table2.class, Table2.group, Table2.alle FROM Table2;

Yep did that! but when it ran it says a warning message I pressed Yes and then nothing happend. Let me give you example what it holds [This is solely example and does not reflect my real records but shows the pattern] Table1 ------ Fields - Class - Group - Alle - Alle Frequency Record- A...

Update query updates the records in the fields but before doing that it asks me what to update it to. If i enter "test" it will update every record with the record name "test"! which I dont want to do. I think I dont know how to do it. Would it be possible for you to tell me how to use it. Many...

Just tried that and it didnt work. It asks me the which table to append to and I selected table 1 after selecting the record fields from table2. When I ran it noithing happend.