Hi everyone,
I am new in ASP
I want to create a string with current date+ "1/2/3" year(s )
if mm/dd/yyyy is current date
i want to add a "variable" in yyyy , variable is a combo box values.. (1,2,3)
And then i want a string like "mmddyyyy"
Thanks
sam12
Last Activity: Nov 6 '08, 02:22 PM
Joined: Apr 23 '08
Location:
-
FTP in SSIS package failed
Hi Everyone
I made a SSIS project in " SQL SERVER business intelligent development Stuidio"which has only a FTP task . When i run this project it doesn't give any error and FTP successfully but when i make a job in SQL SERVER and select this package as step , then it gives an error package failed. -
First of all Thanks for replying
Actually this is old database
I don't know who made it and i am having problems with this now
What i am doing is , creating another field DATE in the table
And its datatype is datetime
I want to copy the old data from BIN to DATE field
I was trying to run this script
...Code:Dim RS As New adodb.Recordset RS.ActiveConnection = CurrentProject.Connection
-
Date format conversion
Hi
I am having a problem to convert the date format
This is my date feild in an existing database
6/26/02 11
05/02/2002
6/05/02 3:
6/12/02 11
05/02/2002
05/02/2002
6/06/02 10
6/06/02 10
6/06/02 10
6/06/02 10
6/06/02 10
6/06/02 10
05/02/2002
I... -
Backingup running Sql Database
Hi everybody
is there any way that we can backup sql database from server while it is running on some machines? -
Thanks stewart
Done!
i did it by recordset method with do while loop
Thanks again for replyingLeave a comment:
-
select into statement to transfer data into table frm sql query
I have one variable strsql declared as string
this is just like strsql= "select* from blabla....."&"b llalal"
I have another table tbl_temp which has all the fileds selected in strsql query
I want to move all the data into tbl_temp from strsql query
I am trying to do:--
DoCmd.RunSQL ("insert* into tbl_temp from strsql")
it gives rutime error 2757
There was... -
Thaks a lot Problem solvedLeave a comment:
-
I am sorry the question was unclear
Customer wants an automated way(With Single click) to send an email without any interference of user to particular person(dependin g on the report,Report tells the EmailID) with attached pdf report from ms access with Using MS outlook express at the backgroud. Thanks in advanceLeave a comment:
-
Send Email through MS ACCESS via outlook express
Hi
I wana send Email with attached pdf files from my ms access 2000 ,os win 2000 via outlook express without confirmation .
I googled a lot
Tried so many codes but that didn't work
Thank in advance -
Hi yaara
I was having the same problem with datepicker
I finally gave up and used a new form "calendar" to do this
Here is the link to see how it works
http://rapidshare.com/files/143939578/calendar.rar.html
It has two modules
one is for calendar and other is to change the cursor type when u go on the calendar icon
If u wana use this, Import these 2 modules and one form calendar...Leave a comment:
-
Change combobox to textbox in vba
Hi I was trying to use this code to change a combo box to a text box :
Me.cboEntry.val ue = ""
Me.cboEntry.Set Focus
DoCmd.RunComman d acCmdChangeToTe xtBox
But when i run the application it gives error
Runtime error '2046'
The commant or action "ChangetoTextbo x" is not available now
Can anybody help me to do this
"I know i can use alternative... -
Thanks all of you, you all are right
But some customers are so stupid
I was using lock/unlock button with color and caption chages.
they said they need edit button instead of lock/unlock button and now they want "A waring message should pop-up when you click on locked form"
I tried my best to resolve it but still working on it.
I used formname.allowe dits method to lock forms
I want to capture...Leave a comment:
-
MS Access 2003 - Code to inform the user to click the edit button
I have an application where all the fields on the form are locked preventing editing of the information(Thr ough a function lockUnklockfrm) until an edit button on the form is clicked or NEW RECORD EVENT occurs which then unlocks all the fields for editing. However, most users come in and move to a field and forget that all fields are locked and that they try to edit the data. Is there any event code that can be placed on a field when the user... -
Thanks wassim for ur reply
this code helped me to do sorting
Me.OrderBy = "Control_Na me" 'or = "tablename.fiel dname"
Me.OrderByOn = TrueLeave a comment:
-
Run time sorting on tabular form by cliciking labels
HI there
i have this kind of employee list form in my database
select flag first name lastname dob
x xxxxx xxxxxx xxxxxxxx
x xxxxx xxxxxx xxxxxxxx
x xxxxx xxxxxx xxxxxxxx
x xxxxx xxxxxx xxxxxxxx
i wnat to do sorting...
No activity results to display
Leave a comment: