User Profile
Collapse
-
thanks, but i need to disable add new rows at Lenght SubForm, not Form, sorry.
So there is no Allow Additions property...Leave a comment:
-
Disable add new rows
How to disable aadd new rows at lenght type form?
i need only output it, and chenge current rows, but not add new
thanks -
-
-
open self database
hi
using selects queryes with DAO works well.
i've got a code
Set MyDB = OpenDatabase("C :\folder\voyage s.mdb")
but i want make datebase with independent path, so user can put it into other folders and it must works.
is any methods to open self base, don't using self path?
or is any methods to determine self path? -
thanks, this code is works.
i think the reason of error was at the dbOpenDynaset key. i don't assign it to function befor...Leave a comment:
-
i turn on it,
now, other error at line
Set WorkRS1 = WorkBase.OpenRe cordset(SQL)
"Runtime error 13, Type Mismatch"Leave a comment:
-
Make a simple select query
how?
i need get some data from table, at the action
i try anything DAO and ADO, it doesn't works((
for example, this code
Code:Dim WorkBase as Database Dim WorkRS1 as Recordset Dim SQL as String Set WorkBase = OpenDataBase(“voyages.mdb”) SQL = “Select init from Managers WHERE contact=” & manager Set WorkRS1 = WorkBase.OpenRecordset(SQL)
-
-
Delete sql confirm
how to cancel default and make own confirm message showing during when execute delete sql query?
ive got such code
Code:SQL1 = "DELETE FROM Clients WHERE contact=" & [contact] SQL2 = "DELETE FROM Contacts WHERE id=" & [contact] DoCmd.RunSQL SQL1 DoCmd.RunSQL SQL2
-
-
oh
it's a error on posing.
in my real code there are
Servicefield.Ro wSource = sql_str
this code reloads all services select fieldsLeave a comment:
-
-
-
make two dependent select fields
i've got two table
ServicesGroups ( id, name ) and
Services ( id, group_id, name )
tables linked on ServicesGroups. id=Services.gro up_id
at first select field i list ServicesGroups table,
so when user select group i need to reload Services select field, and show only services wich linked to selected group ( Where Services.group_ id=ServicesGrou ps.id )
i realize it so
Code:sql_str
-
you are wrong
there is a date() function to convert timestamp to every date format
http://www.php.net/date...Leave a comment:
-
20070209162211 is
2007-02-09 16:22:11
it's more simple to convert. split this string by symbols using substr() and its allLeave a comment:
-
date( "d/m/Y", $unix_timestamp );
but 20070209162211 it isn't unix timestamp.
unix timestamp is a number of seconds from 1970 yearLeave a comment:
No activity results to display
Show More
Leave a comment: