A module is essentially used for reusability of the code. also you can use a class module to implement object oriented programming.
you can add a module(standard/class) by right clicking on the project->add in the project explorer or by clicking on the arrow adjacent to ADD FORM button on...
as far as i understand your problem your concern is with building the SQL depending on whether the user checks some of the boxes. you can use something like the code below.
mySQL = "select * from journal_status"
if chkmonth.value then
mySQL = mySQL & " where month = " &...
you can either change the SQL to "select * from ..." and then open the recordset and execute the delete method of the recordset object or you can directly use dbsNorthwind.execute MySQL check the appropriate syntax. it will delete all the required records from the database unless you...
do the machines on which you face problems have registered/ licenced versions of the activex controls that you are using. this is the typical reason for error 429. you can check which control is giving you the error by trying to insert the components on a blank form on the comps that give...
you have to explicitly update the database. truedbgrid doesnt do it automatically. if you are using a recordset to populate values into the grid then invoke the update method of the recordset from the afterupdate method of truegrid.
to connect to a remote database on a server you can use the ADODB object. to use this you have to add the Microsoft Activex Data object to the references. for the connection you can specify a connection string to connect to any remote database using approproate JET/ODBC driver.
as for the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.