Search results

Yes the Shortcut Menu is set to YES. It just works in Design view. I guess it's the way Access is built.:(

When I click on a record on the subform and right click to get the delete record option nothing happens in FORM view but works in DESIGN view. I have checked all the record and form options and they are all correct. Using Access 2010

How to convert decimal time from Date/Time calculation StartTime and EndTime are Date/Time types Dim ElpsdTime, EintMin, EintSec, EintTSec, As Double Dim EintHr As Single Dim intHr, intMin As Integer ElpsdTime = CDbl(![EndTime] - ![StartTime]) intHr = Hour(ElpsdTime) 'Rounded Hours...

Yeah but you need 10-15 replies to do it!!!!!:p

Bob; I deleted my last post but still need assistance.:) Cal Pettengill RENO, NV calbikes38 @ att.net

I'm building it right now. I;m knida in the dark with queries. Thanks Cal

I'm building it as we communicate. I don't use queries a lot so I'm kind of in the dark. Thanks Cal

ASSL1 Application attached

2003 Access

Can I just send you the application zipped?

FORM frmCopyTasks Option Compare Database Option Explicit Private Sub cboYear_AfterUpdate() PYear = Me.cboYear End Sub Private Sub cboWeek_AfterUpdate() PWeek = Me.cboWeek On Error GoTo Err_cboFRMN_Click Dim FoundIt As Boolean FoundIt = False 'DoCmd.Hourglass True strSQL = "SELECT *...

strSQL = "SELECT * FROM qryTasks WHERE [ActYear] = " & PYear & " and [ActWeek] = " & PWeek & "" strSQL2 = "SELECT * FROM qryTasks2" What do I use instead of currentDb for the other database?

I'm trying to copy specific records selected by Year and Week from the original qryTASKS. Year 2011 Week 1 all records copied to week 2 The double quotes are added by access not me. ??

ERROR MESSAGE The field cannot be updated because another user or process has locked the corresponding record or table. (Error 3164) Public Sub CopyTasks() On Error GoTo Err_CopyTasks Set TaskDB = CurrentDb Set TaskDB2 = CurrentDb strSQL = "SELECT * FROM qryTasks WHERE [ActYear] = " & PYear...