Search results

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...

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...

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...

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.

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...

I have a Database that has a main menu and 5 other forms. The problem I am encountering is that in Access when I let it set for a few min.(no set amount of time) it bounces back to the Main menu. The current menu does not go away and you do not lose any information entered it is just a pain. if...

I have two tables that I need to put together for reporting. The problem is that when I run a UNION query it tells me that I have exceeded the number of fields. Each table has about 160 fields. One table is the current information and the other is a purged history. Is there another way I can...

Is there a way to print a list of all the queries that are part of a DataBase?

On my form I am submitting a query and when it runs I get messages from the completion. I put the SetWarnings False and True in to end the messages. Now when it runs I get a different message that says: "You Canceled the previous operation" and wants me to reply 'OK' Can someone tell me...

I have a tbl that I do a search on and when I get the results I place the record selector beside the record I want to look at and then press the View Detail cmd button. It takes me to the form I want but does not show the record I am looking for. The form is built from a query. Here is the code...

I have a routine that does a search and return all the records from a table that meet the request. This could be 0 to any number. It brings it back in a continious display on a form. Is it possible to be able to place my mouse next to the line I want and click it and then be able to read the...

When I press the cmd button and execute the following: Dim stDocName As String Dim stLinkCriteria As String Dim intNum As String DoCmd.RunCommand acCmdSaveRecord DoCmd.OpenQuery "InsertNewSBDProspects", acViewNormal, acAdd stDocName = "frmSBDProspects" intNum =...

This I am sure has been covered but either I have not found it or don't understand what I found. I have a combo box with the Sales Rep name in it. when the sales rep is selected I need to fill a txt box with the correct Office Name. the sales rep name is built from a table that has three fields...

I have a tbl that has 2 fields on it Ctl nbr(autonum) and Ctl Name(txt) when the user enters a new Ctl Name the tbl creates a new Ctl Nbr. then the user press a cmd button to go to the next form. I have to open a blank form except for the Ctl nbr and the Ctl Name which is from the first form...