473,324 Members | 2,166 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,324 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 14330
isladogs
455 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: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
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...
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)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.