Search results

I could certainly make it based on a query easily. Can you step me through how that would help, and what the code might look like?

Hello experts, I've been tasked with creating a database to track meetings. I have a table, tblWeeks, that contains each weekday and the date of that weekday for the year 2019. I have a form on which the user enters the start date of the meeting, the day the meeting takes place, how many...

Found the reference and added it but still getting a Run-time 490 error :(

Thanks for this. Is there a reference I must add to my DB to allow this? I am getting a "user defined type not defined" at the FileSystemObject line. Assuming my DB doesn't have the right references.

Because I was not getting any responses and feared that I had posted it in the incorrect forum area.

Experts, I have the following code in two different databases: Application.FollowHyperlink "\\S:\myfoldername", , True In one of my databases, this works totally fine. In another, I get the following error message: Run-time error 490 - Cannot Open The Specified File. I have already verified...

Thank you kindly but that did not solve the problem :(

Experts, I have the following code in two different databases: Application.FollowHyperlink "\\S:\myfoldername", , True In one of my databases, this works totally fine. In another, I get the following error message: Run-time error 490 - Cannot Open The Specified File. I have already...

Found a solution, for any that may come after me :) Dim HasDecimal As Integer HasDecimal = InStr(1, Me.Hours, ".15" Or ".30" Or ".3" Or ".45", vbTextCompare) If HasDecimal <> 0 Then MsgBox "Hours must be entered in 15 minute increments using .25, .5 or .75 values. Please try again."...

I worked up the below code. However, it is not working, even when I enter a value with .30 in the Hours field. Thoughts? Private Sub Hours_BeforeUpdate(Cancel As Integer) If InStr([Hours], ".15" Or ".30" Or ".3" Or ".45", vbTextCompare) Then MsgBox "Hours must be entered in 15 minute...

could we set this if/then statement up to simply check to see if the field contains a decimal value, and if it does, check to see if it's .25 or .50 or .75 and if not pop up the message?

Experts, I have a form employees use to enter leave time. I would like to set a validation rule on the "hours" field of this form to prevent them from entering leave in increments other than decimal (for example, 90 minutes as 1.5 hours). I have some folks who will try to enter 90 minutes as...

how foolish of me! it's always something simple and silly. Thanks, I'm in business now :)

Sure, here you go :)

Hi, I mean that although I have the sorting/grouping set to sort by this field in ascending order, when I view the report, it is not sorted. I cannot attach the DB as it is proprietary, sorry :(

it's a date field

It's in the query, and does show as an option to sort. However, the report does not sort successfully after making this selection :(

Hi experts, I have a report that is based on a query which determines the most recent time a student attended class. It has a "MaxOfClassDate" field which I would like to use to sort my report. I have indicated in the Sorting & Grouping window that I would like to sort my report by this field...

I think i've figured it out :) Below is what I went with, for any curious folks who come after me! Private Sub Report_Load() Dim Frequency As String Frequency = DLookup("Frequency", "tblClassList", "ClassName = '" & Forms!frmSupDash2!cmboClassName & "'") Select Case Frequency Case "Annual"...

I have tried another method - saving the frequency of the class in a variable and using Case statements to guide the recordset for my report. However, I am now getting the below error message when trying to use this SQL statement for my recordset: "You have written a subquery that can return...