Recent content by Access2007User

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...