Recent content by mbair

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