473,387 Members | 1,579 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,387 software developers and data experts.

A multi value select field auto populates a date field when data is selected

Hello: I have a form in Access2010
[field 1]- Missing Information- multi value select field
field 2]- Date Missing Email Sent - calendar date field.
End users request to have [field 2] populate a future date if [field 1] has been populated.
Date field will remail blank if nothing is populated in field 1
I would desire to use a easy code in the after update event.I believe that I butchered it
Expand|Select|Wrap|Line Numbers
  1. [Missing_Information] IsNotNull and DateAdd("d", 1, Me.Date_Missing_Email_Sent_to_CPNM)
I receive a Compile Error; Invalid use of property
Aug 24 '17 #1
5 1842
NeoPa
32,556 Expert Mod 16PB
Please include the full procedure. A single line of code is rarely enough of the story to work with. Certainly not in this case.
Aug 25 '17 #2
sorry don't understand what your asking, the full procedure is listed. I tried to use one line of code.
If [Missing info] field is null in then [date field] is not auto populated. If end user populates the missing info field then the date field auto populates .
Aug 25 '17 #3
NeoPa
32,556 Expert Mod 16PB
Perhaps if I give an example of a procedure that has only a single line of executable code :
Expand|Select|Wrap|Line Numbers
  1. Private Sub Form_Open(Cancel As Integer)
  2.     strWhere = Nz(Me.OpenArgs, "")
  3. End Sub
You'll notice that the header and footer lines are included which then means we don't have to ask such questions as :
  1. What's the name of the Control the event's for?
  2. Which event are you utilising for this code?
It also makes clear that there's only one line of executable code, of course.
Aug 25 '17 #4
Hi I am not a coder that is why I am asking for assistance. I explained previously what I am trying to accomplish with the two fields, If you don't want to assist then don't. If you want to nit pic please move on. I just joined this site for assistance and direction. THanks
Aug 25 '17 #5
NeoPa
32,556 Expert Mod 16PB
I appreciate you're not a coder. That's why I've explained what I need, in order to be able to help you, in such a clear manner.

Your earlier explanation was woefully inadequate. Hence I was helping by explaining how to get the question into such a state that I, and others possibly, could begin to help you.

Obviously, it's your choice how you respond to those that try to help you, but you should understand that some responses can make you generally unpopular very quickly. Not a good place to be if you rely on others to offer you their help.
Aug 25 '17 #6

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

Similar topics

3
by: BlackFireNova | last post by:
This concerns an Access 2002 (XP) database. There are two fields, "Notes" (Memo Field) and "Notes Update" on a form (among others) which I am concerned with here. Problem: I need to be able...
3
by: William Wisnieski | last post by:
Hello Again, I'm really stuck on this one.....so I'm going to try a different approach to this problem. I have a query by form that returns a record set in a datasheet. The user double...
1
by: Ken | last post by:
I wrote a function to use in queries that takes a date and adds or subtracts a certain length time and then returns the new value. There are times when my function needs to return Null values. ...
10
by: satishrajana | last post by:
Hi, My SQL returns a NULL in a datefield if there is no date in that field. If there is a NULL in this column, I want to replace it with spaces in my SELECT statement when I am selecting these...
1
by: kunal0101 | last post by:
Hi, I am a new user to access and am building a database to capture the rotation dates for employees. There is a table called "Rotation schedule" which contains "name", "Duration (in weeks) and...
5
by: terbolee | last post by:
I have a text field and a dd/mm/yyyy field. My third field needs to be automatically filled in with the first 3 chars of and mmdd of the field. Here's an example: "CASTOR" in & 15/01/2007...
2
by: Tian | last post by:
I have an age field in my db table and it should be auto-generated based on the date of birth field.Also it should be automatically updated with time. There is another field Premium whose amt should...
4
by: prisesh26 | last post by:
hello friends i ve a prob with sql query generation. iam doing a project in C# .net. using datagrid iam displaying the entries.for that iam using this query "select posts from tblPost where...
0
by: neogazz | last post by:
I am designing a webpage at the moment where a user must enter their date of birth, but I am not sure if it is best practice to provide <select> field for day, month and year, or is it better to...
9
by: yappy77 | last post by:
I want my "requalify date" to auto populate to the beginning of the month in the following year when my "liability date" gets entered/changed. Example: Liablity date = 11/15/2010; 7/31/2011 ...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

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.