Search results

thanks for the reply but when is the proper time to make the code work? Is it on form open event?

Good day! I have a frontend and backend linked. When my access application opens, it says error message that the path of the database file was not found. this is because I have moved my database to other location. How can I make a custom error message for that?

I have that old mdb to saved as accdb but it did not change the design. any other suggestion? by design, I mean the form or report view NOT the ribbon or toolbar or quickbar.

thanks ajetrumpet. but I may be needing example in vb6.

ok. I get the point. Ok, I have been studying access, vb6 and vb.net. I am more familiar with the three. With regards to C++ and visual c++, I am not familiar yet. I guess there is a difference between c++ and visual c++. However I am concentrating and studying to ms visual c++ because I...

really? you would prefer c#? I thought C++ was the most use and preferred language? On the phrase that you said there is supposed to be no particular advantage over another language in .net, do you mean that programming in vb.net is as good as in C?

What is the difference between vb6 and vb.net? I have read an article which I google about the difference between the two and it says that vb.net was a replacement to COM of vb6. However, in other forums that I have seen, there was no even one forum for vb.net? Dont people like vb.net? I am...

DCrake I can you kindly give me a vb6 example like Access gave northwind database sample for access. A vb6 example which has objects data connections, forms, report, modules etc. so I can study it like I did with northwind. thanks.

SELECT Last(Table1.bookid) AS LastOfbookid, Last(Right([bookid],3)) AS b FROM Table1; something like that for your "ultimate query challenge".

Hi, Maybe we can put in our database samples a sample like northwind database which has all the objects from table, query, form, report, macro and module. Moreover, maybe we can also put some projects of visual basic. I have seen on some visual basic forum that their moderator have initiated...

Hi, can I ask something from the community? I am studying VB6 but I think the better way that I can grasp how it works is by its examples. As Access has northwind database sample so the user can study its tables, query, forms, reports, macros and modules, can I ask someone from the community...

I see. so creating connection and recordset objects are just like snapshot. So therefore it is not linked tables that the records the flowing thru the link. Am I correct thinking here? Is there a way to make it like that? is dynaset proper term?

same post as above please. thanks.

you can use the append query.

i would think it this way: TABLE 1 Fields: CountryID2 (PK) duplicates allowed - number type Local Suburb/Towns - text type TABLE 2 Fields: CountryID1 (PK) duplicates not allowed - number type CountryName - text type LocalOverseas - yesno type Thereby in...

do you mean you have a combo box wherein its control source is a joined two tables? and what do you mean about your combo box will give you the correct table. maybe you mean your combo box will give you the resulting records filtered by your tickbox.

wait, what do you mean about amend? amend to the table structure or to the records therein? I am presume we are talking about amendments or updates to the records in the table. quote: "If you think that the table may have been amended at any point during the session, then you need to be...

:) I will take your advice DCrake. Thanks for assisting me in this topic.

wow I love it. but you said that is for no need to amend but just lookup. But more often I need to interact and update or add new records to the recordsets. I think it can also be used, am I right?

ok. so you mean it ("When you make an exe from your project it recognises these addtional components and addss them to the package so that when installed on a new pc it installs and registers the said ocx's onto the target machine.") automatically installs the said ocx's onto the target machine...