Search results for query: *

I have the following DateSerial command in access: DateSerial(Year(DateSerial(Year(Now()),Month(Now()),1)-1)-1,1,1) And DateSerial(Year(Now())-1,Month(Now()),1)-1 I need to convert it to work in a SQL server view.

I have a textbox on a subform. After I run the afterupdate event on the textbox I want to set focus to that same textbox if the textbox is null.

thanks

How can I loop through my panels and find the one that is visible. Then take that panel id and loop through the controls on the panel?

I am using this IIF statement on a field called department. Like IIf(IsNull([Forms]![frmTrainingHoursLess40]![cboDepartment]),"*",[Forms]![frmTrainingHoursLess40]![cboDepartment]) but I also need it to return the records even if the deparment field is null.

I need that does something like this < = Like IIf(IsNull([Forms]![frmTrainingHoursLess40]![TextHours]),"*",[Forms]![frmTrainingHoursLess40]![TextHours])) or this Like IIf(IsNull([Forms]![frmTrainingHoursLess40]![TextHours]),"*",<=[Forms]![frmTrainingHoursLess40]![TextHours]))

If I execute a stored procedure that accesses a table on another database. I get an error that I have no permissions on the other database. Is there a way to run the procedure without the permission?

Can I reverse the order of my records in a datasheet. So the new record is on top instead of at the bottom?

I have 2 columns in an excel spreadsheet. I want to match the first column to a (primary key) column in a SQL table and then update the field in the table with what's in the second column of the excel spreadsheet. Is there a way to do this and what is that way???

I need to call an SQL stored procedure and pass it a value and then have the procedure execute. How do I do this from Access????

I have never done this before and need to know how to do it

I to write a DTS package to import some data from an excel spreadsheet and put that data into a table???

what is the syntax for refering to a value in listbox column on a subform

I have a report that grouped by 2 fields. When I added a third field to group on. It shows the first group header before the detail records, but it also shows the third group header before the detail records and then again where it is supposed to show up. How do I get rid of it showing up before...

thanks

I have several scripts that I run once a week. They drop tables and manipulate data. Write now the scripts are just in notepad and I copy and paste them into query analyzer. Can I just make stored procedures out of these scripts???

This is my code and I need to exactly where to put the user or capture the current user name for the Lotus notes database when it opens. Public Sub OPENNOTES(Location As String, Dateopened As String, Desc As String, ddrpass As String, ticketnum As String) Dim LOTSESSION As...

i HAVE THE CODE TO SEND THE E-MAIL OUT, BUT I WANT TO PUT A CERTAIN USERNAME AND PASSWORD IN. SO, IT OPENS UP THE RIGHT DATABASE.

Need to know how to attach an access report to a lotus notes email?

How to put in a carriage return in the body of a Louts Notes email!