i've installed SQL Express 2005 in windows 2003 server; purpose was to store the email
accounts in one database so that email servers can link to a common account database. Mail
server Mdaemon which has got option to store accounts in database. Mdaemon has got
necessary scripts to create table etc..
I installed in one machine (windows2k3 with SP1)Mdaemon and SQL and with a system DSN could...
kaib
Last Activity: Feb 29 '08, 12:41 PM
Joined: Nov 30 '06
Location:
-
system DSN connection
-
i tried to telnet on to 1433 but fails; when i connect from other machine i get an error which says like NT-AUTHORITY ANONYMOUS USER LOGIN and fails; can SQL express be used to connect to other machine; help -
no firewall; i'ven't tried telnet to i'll;...Leave a comment:
-
system DSN connection
i've installed SQL Express 2005 in windows 2003 server; purpose was to store the email accounts for the mail server running on this; i want to connect from another windows 2003 server while creating system DSN on the machine; but sql doesn't allow me to connect.
both machines are workgroup machines; i've installed sql with NT authentication and enabled thru surface area management remote connection (TCP) ; what could be the reason... -
thanks but one of my combo in the main form and the other one in subform; in this scenario how can this work; i get confusedLeave a comment:
-
combo box filtering -access2007
i've got 2 tables tblCompany and tblHrtasks and on the form:
when i choose the company name, the subform gives the details of employee attached to that company; but there is a combo box in the subform for choosing the employee and i want a filter on the combo (on the subform) so that it displays only employees those are attached to the company (based on the selection before from the master form)
following is the code... -
thanks for ur comments; it's working now; but i gave up the DAO method
ur help is not misused; rather respected & valued
thanks again...Leave a comment:
-
i keep trying but nothing work out...Leave a comment:
-
in fact i want a validataion before rs.update if for one employee duplicate workdates are entered; i remmed my code under Form_BeforeUpda te so there are no errors; but i lost my validation
could u assisit me validating these dates....!
thanks...Leave a comment:
-
i tried but it doesn't work; i understand something; the error "you cannot reference a property or method for a control unless the control has the focus"
i remmed all the validation codes and still this error showing up! is it anywhere the ME is losing its focus! id don't understand...it doesn't come as highlighted instead with a heading micrsoft access;
i'm stuckLeave a comment:
-
is it because the values are cleared! the validation doesn't work; i'm lost
help appreciated
thanksLeave a comment:
-
yes work_date is a table field; so how can i get rid of this error
help appreciated
thanksLeave a comment:
-
scenario is like this:
i put some unbound controls in header of a continous form; after user enters the data when he [press 'add new' unbound cntrols are cleared and down records are added; but two controls one is combo which look the em[ployee names into
em[p.master file; another is a calendar ocx; the rest are normal text boxes;
below the code given under 'add new'; how can i clear the value of combo and calendar;(both...Leave a comment:
-
unbound and null
i've used for data entry some unbound text boxes
they are of number, date/time
user will enter data into these fields; when click 'Add New' button,
rs will update and these unbound controls to be cleared by assinging 'null' value to it; but when i click 'add new' button i get an error like this:
"you tried to assign the Null value to a variable that is not a Variant data type"... -
infact it's an installed printer problem; i could sort it out; by default printer was a 'generic printer'; i changed it so now report appears normal;
i've grouped data into employee code and i took the property of that section set the 'force new page' to 'after section' but no use
thanks...Leave a comment:
-
i tried but no thing happens; now in the reports letters are moved one space right; it's very strange; i'ven't done any changes; so when i see the printview all messed up; any clue about this!?
helpLeave a comment:
-
report printing in access
i've got some employee details to be printed (OT, Pay etc..; )in report i want to print details for only one employee (one employee code) on one page and if its different code it should skip to another page;
is it possible!
help appreciated -
ok i got it by changing the 'running sum' property' to 'over group' and it gives the cumulative figure...Leave a comment:
-
ok i got it by changing the 'running sum' property' to 'over group' and it gives the cumulative figure
in report i want to print details for only one employee (one employee code) on one page and if its different code it should print on another page
is it possible!
help appreciated...Leave a comment:
-
ok but how can get a running total of each emloyee code on the reportLeave a comment:
No activity results to display
Leave a comment: