473,287 Members | 1,555 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,287 software developers and data experts.

Comparing user input date in a form with a date which is stored in another form (and therefore its database)

Hey there,
I am dealing with two forms in access. One of them has a "Date Code" field which asks the user to enter a date. I want it to be such that if the date entered by the user is greater than a "Fix Date" date which appears in another form, I would like to throw a notification saying that the DateCode must precede the Fix Date. I am trying to use the validation rule of the expression builder but it is throwing some error. I am not sure if i should be comparing the DateCode with the FixDate from the second form, or from the corresponding table of that second form. So far I am using the expression: [DATECODE]<= Forms![FindingsMaintenanceF]![FixDate]
As can be seen, the input datecode value is being compared with the fixdate value in another form named "FindingMaintenanceF". I also tried to compare the same datecode value with the FixDate in the table where the values of that form are stored but that didn't work either.

I was hoping if someone could point out the correct syntax to compare these values. Thank you so much for reading till here and for your time. Cheers.
Sep 28 '22 #1
1 14325
isladogs
454 Expert Mod 256MB
Hi
Welcome to the forum.
For info, posts for new users are moderated to prevent spam. That's why your two identical posts didn't appear.
I've approved this post and deleted the duplicate thread.

I'm sure someone will respond to your question soon
Sep 29 '22 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Matt | last post by:
Can form.submit() submit another form? In the following example, in page1.asp, it is fine to submit the current form: form1.submit(), and and I could see the value "Joe" in page2.asp. However, if I...
1
by: Bob Sanderson | last post by:
I have two forms, frmSearch and frmMain. I want to be able to enter a job number in a text box on frmSearch and when I enter it, open frmMain and go to the record for the job number I've entered....
8
by: Mike Caputo | last post by:
In VB.NET, need to be able to access certain properties on my main form from other forms. These are properties that may be changed by the user, so I have to be able to get to them throughout the...
10
by: Saber | last post by:
I did a web search and found someone is looking for what I'm looking for: There are 2 forms...named => formA and formB and each of them have their own button named => btnA and ...
4
Cintury
by: Cintury | last post by:
Hello I need to take a date from one form and use it in a conditional statement on the other. Question: Is there a way to link data in code from 2 different forms? Example: (on agency form) If...
1
by: Tamer Ibrahim | last post by:
Hi, I'm trying to validate user input date using range validator on a text box . This code is throwing this exception "The value 'DateTime.Now;' of the MaximumValue property of 'rvQDate'...
13
by: DDragon | last post by:
ok here is the problem, i have to forms which have values i wish to be added together i can add together the values in one form all right but im having problems with adding the values of the other...
2
tuxalot
by: tuxalot | last post by:
I have a textbox, on with a record source . FrmMain is a tabbed form showing injury data for a given EmployeesID. I have a textbox, on a subform . with as the record source. is entered by a...
1
by: mzovko20 | last post by:
Hello ! I´m having problem with this. I already created index.html document which allows user to input his/her date of birth. It looks like this : <html> <body> <center> <h3>How old are you...
1
by: markzabo | last post by:
Hi, I am currently working on a project that i was asked to do for my boss. What does the project consist of... First of all I need to select some pictures from a disk/drive, they will then...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.