Search results

Hi Is there any reason why there are no Table threads showing with a date greater than May?

Hi everyone I have posted the same question on Utter Access The code I am using as as follows and I am getting the following error. Private Sub cmdAddLines_Click() 10 On Error GoTo cmdAddLines_Click_Err 20 If Me.Dirty Then Me.Dirty = False 30 If DCount("[MainId]"...

Hi Everyone I have a Form which has an Unbound Control named "CurrYr" to display the Current Year 2025 using the following. =Right(Date(),4) I then want to run an Append Query using the Code as follows: INSERT INTO tblCurrentPastYears ( YearClassID, StudentID, GradeID, ClassID ) SELECT...

Hi Are we able to not display all of the current adverts?

Hi Everyone For some reason I cannot get the following to work. I have a Main Form named "frmQuotes" On the Main Form I have Sub1 named "frmQuoteElementsSubform" When I run an On Click Event from Sub1 I need to refresh Sub2 on the Main Form The name of Sub2 is "frmProfileOrdersSubform" I have...

Hi Everyone I am trying to attach a PDF file as an attachment to an EMail but when I run the Code I get the following Error. The Report opens just fine but no EMail is generated. Any help appreciated. Private Sub cmdPreview_Click() 10 If Me.Dirty Then Me.Dirty = False 20 On...

I have 2 Controls whose datatypes are set as Double in the table and display values like 2.1 and 0.35 When I create an OnClick Event and need to Dim these 2 fields how would I correctly Dim these Controls? I currently have :- Dim varSquareMeters As Long Dim varTotalSquareMeters As Long When...

Hi I cannot get a DCount of the number of times the same Date is entered into a Table. My latest attempt is as follows with no Joy, it displays 0 Any help appreciated. =DCount("BatchDate","tblBatchData","BatchDate = " & [Forms]![frmBatchDates]![frmBatchData].[Form]![BatchDate])

Hi Everyone I have crossposted this question https://www.utteraccess.com/topics/2065471/posts/2819007 but not understanding Doug's answer. I have a Continuous Form that displays a list of all students with their current StudentID, ClassID, GradeID and DateFrom as shown in the attached Current...

Hi Everyone I have a Continuous Form with an Unbound Textbox to Filter for specific records. How can I then export just the filtered list to Excel? If I just use the following Code it exports all records. DoCmd.OutputTo acOutputForm, "frmActiveClaims", acFormatXLSX, True Any help appreciated

Hi Everyone I have a Continuous Form where I need to validate just 1 Control named "AchievementLevel" I have tried adding the following Code to the On Click Event for Closing the Form. When I try to run the Code Access Locks up? Is there a better way to achieve this? Any help appreciated...

Hi Everyone What is wrong with the following please:- strSQL = "UPDATE Order SET DateOrdered = Date() WHERE [Shopping Cart] = 0 And [PO]= 0;"

Hi Everyone I need to calculate the number of Days between 2 dates. StartDate and TermDate I know how to use the DateDiff Function =DateDiff("d",[StartDate],[TermDate]) How would I cater for the TermDate being Black and If it is Blank then use the Current Date. Any help appreciated.

Hi I appear to have a mental block on checking for Duplicates for a Members Data Entry Form. The 2 fields are Forenames and Surname. How would I code the AfterUpdate of the Surname Control to display the Duplicate warning? Your help appreciated

I have an On Click Event which saves a PDF file of a Report which is being sent as an Attachment in an Email Message. Is it possible to use the following code provided by Carda Consultants Inc. to browse to a folder to store the PDF? Any help appreciated. 'FSBrowse (File System Browse) allows...

Hi Everyone In the attached when you double click on a Date it opens up the Appointments Form When I add a Location is it possible to have this Location display on the Actual Calendar? Any help appreciated

Hi Everyone Is it possible to have a table named "tblAgentEmailDefaults" with a specific field named "MsgBody" Then in the on Click Event to send the email, be able insert into the Code this specific field by using a DLookup or anything similar? Any help appreciated

Hi Everyone Vlad gave me what I thought was a solution in the following Link, however I now find I am getting the following error. Link The Code I am using is as follows. Any help appreciated. Private Sub cmdPreview_Click() 10 On Error GoTo cmdPreview_Click_Error 20 If...

Hi Everyone Can someone tell me where I an going wrong with the following Code to add an attachment to an email. The Code creates a PDF file in the Folder as required It displays the Report But it does not Display the Email in Outlook ? The code is as follows:- Private Sub cmdPrint_Click()...

Hi Everyone I have a Combobox named "cboDriver" has the following :- Row Source: SELECT DriverT.DriverID, [DriverFName] & " " & [DriverLName] AS Driver, DriverT.TruckNumber, DriverT.TrailerNumber FROM DriverT; with an after And an Update Event as follows:- sSource = "SELECT...