Search results

Thanks, that helped and it worked as you new it would.

Is it possible to check for a blank date. everytime I try to check if it is null it tells me an object is required. Dim dteDate As Date dteDate = [Forms]![frmSBDAmendments].[Received Date] dteDate = GetBusinessDate(dteDate, 0, icFuture) dteDate = AdjustDate(dteDate...

Thanks, that did it. It now works on all the forms......

One more question on Simple Subform Question....... That worked great! Now the same subform is used on a different form. is there an easy way to tell which form is open. Say, could I use a 'If' statement and if so how. I used the following and it gave me the following results. If...

Thanks, I have learn a lot today. Today was a great day!

I have a Form it is called frmSoldCase. On this form is a subform called frmRevisions. I have a Date field that I need to put some code behind to check the date: Dim dteDate As Date 'MsgBox "Received Date = " & [Received Date] dteDate = [Forms]![frmRevisions].[Received Date]...

I have a field that is a Time using Date/Time and Short Time. if the user enters a time prior to 2pm I use date routine 1 if the user enters a time after 2pm I use date routine 2. Can someone tell how I can compare the time. I have looked in the help and all I can find is examples for date. I...

Thank you that worked and helped

I sorry I left that out of the last thread. Dim SQL As String If (Me.txtSoldCase) = "Sold" Then SQL = "UPDATE tblSoldCase " & _ "SET tblSoldCase.[Case Name] = tblProspect.[Case Name], tblSoldCase.[Admin Letter App/Decl] = tblProspect.[Admin Leffer App/Decl]" &...

Can someone please tell me where I went wrong with the following: SQL = "UPDATE tblSoldCase " & _ "SET tblSoldCase.[Case Name] = tblProspect.[Case Name], tblSoldCase.[Admin Letter App/Decl] = tblProspect.[Admin Leffer App/Decl]" & _ "Where (((tblProspects.[Case Track...

Thanks to all of you. I found my problem. I had a query that was to append a single record but somehow it started appending the entire table which did not take long to grow. This has been fixed and should not happen again. Again thank to all.

Thanks, I will try that

I have a Database that was only 15mb I have not increased the number of records but I have increased some of the code. it now is up to 171mb and when I do a Compact and Repair it does nothing. Is there any other way to get it back to a reasonable size other that delete code.

Yes, I will work on that and post it as soon as possible.

Thank you all, I will

I am afraid that I can't. The company policy does not allow for this information to be distributed. I guess, I will have to live with it until something pops out and I am sure it will sooner or later. Thanks for the help

We are using Access 2003 and operating system Win 2000 Pro

I need to add a +1 to the seq number of a record on a table when I insert the record to the table. The following is the code I am using can someone please tell me where I have gone wrong? If Me.txtCaseType = "SBD" Then DoCmd.OpenForm "frmSBDAmendments", WhereCondition:=strLinkCriteria...

Thank you for your help. I am at a lost......do not understand why.......will continue to look at different things...... Again thanks

No, it just goes back to the Main Menu. Like someone put the mouse and the 'start' row at the bottom and clicked the Main Menu. :confused: