Search results

Thanks Bob, that worked!

I am trying to run the code below in the On Timer Even but I keep getting the Else Without If Error Message. I have 2 If statments and 2 End If statement, I can't figure out what I am doing wrong.. Any help is greatly appreciated..... Private Sub Form_Timer() [FrmDashBoard].Requery...

I have two different Subforms (Graphs) that are based on the same table. Basically I am using them as Dashboards that update every 25 seconds. As long as the focus stay on the 1 rst Dashboard there are no problems but once I click on the Tab that has the second subform I get RunTime Error 2118...

I have and Access Query that Groups and returns the Accession Number for each Division. I need a query that will fill in the Missing Accession Numbers. See attached Image of what I am talking about, any help is greatly appreciated....

Thanks, I used your code and took out the Me.[txtCodingEntryVerifyBatch] <> "Not Found" after Else and it worked! Thanks Again.... If Me.[txtCodingEntryVerifyBatch] = "Not Found" Then MsgBox "Invalid Batch, Please ReEnter Valid Batch Number" Me.[txtCodingBatch].SetFocus Else...

I have a text box with a DLookup that will return "Not Found" or a Number > 0 when it loses focus. Below is the code I am using I keep getting the compile error Else without If, any help is greatly appreciated..... Private Sub txtCodingBatch_LostFocus() Dim vTempCodingEntryBatchVerify As...

Mr. B that is exactly what I am looking for, you are a life saver, thank you Sir!

I have an Access database that is on a shared drive that multiple users maybe logged into. I need an event that will auto close access at 9:00 pm each night. From what I understand I need to have a hidden form that will constantly check the time against 9:00 pm and when it reaches 9:00 pm then...

I have an Access(2003) Data Project that is connected to a Sql Server 2008 Express. I am trying to import a text file into one of the tables using the Import Wizard but I get an error message saying it doesn't recognize the table I am trying to import into... I have a primary key set on the...

Thanks everyone for your help, I really appreciate it.....

I have a data entry form and I want to set the value of the 'Request Date' field to equal the Current Date Date() after the Form is Cleared for New Entry. Below is the code I am using however it enters 1/6/1900 as the 'Request Date' value.... Private Sub Command21_Click() Dim Rs As...

I have a word Document that I want to Loop Thru and every where the String "data-author=" exists I want to grab the name after it and copy it to ms excel. So in the example strings below I only want to grab the string inside the quotes and copy paste in excel.... data-author="MrOWNEDLOL"...

Thank you very much!

I am testing a Data Entry Form I created to make sure it throws a message box when all required fields aren't populated. So I left all fields blank and when I click submit it throws a runtime error '2465' Microsoft Access can't find the field '|' referred to in your expression. Below is the...

I have an access table that holds parameters that I want to pass to a query.... Example: TableParameters Grp# / trackingStartDate / Payor 4 | 5/1/2010 | 1105 5 | 6/1/2010 | 335 7 | 4/30/2010 | 1 I would like to use the data in the TableParamters as the criteria for my query against the...

Mr. Larson, As always thank you very much.....it worked perfectly!

I have a table named Tbl_Temp_PP_Edit_Name and a list box named List_Edit_Name I would like to take the items selected in the list box and add it to the table. Below is the code I have tried but it failed saying Sub or Function not defined. Can someone help? Private Sub...

I have an Access Db Module on another computer that contains a Sub Routine I would like to execute from Excel. How can I execute the routine and have it open and run on the host computer from an Excel workbook on my computer? I tried the code below but ran into two problems (1.) It opens the...

Bob, thank you very much!! It worked perfectly......

I have a Form with Text boxes that contain report names. I have a button on the form that executes the below code.... for some reason I can't get the text box background color to change before and after the code is executed. Can someone help me understand what I am doing wrong? Basically I want...