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

Form append mode?

25
How can you check if a form is in append mode (ie new record)
Expand|Select|Wrap|Line Numbers
  1.   If MyForm = '  Append Mode ? Then
  2.  
  3.       ' my code
  4.  
  5.    End If
Feb 22 '08 #1
6 1641
FishVal
2,653 Expert 2GB
Something like
Expand|Select|Wrap|Line Numbers
  1. If MyForm.DataEntry Then ....
  2.  
Regards.
Fish
Feb 22 '08 #2
Codebug
25
Thanks,

overlooked the obvious
Feb 22 '08 #3
FishVal
2,653 Expert 2GB
Not a problem.
Good luck.
Feb 22 '08 #4
missinglinq
3,532 Expert 2GB
How can you check if a form is in append mode (ie new record)
Fish's code will work if the form is opened using acFormAdd or if the form's AllowAdditions property is set to Yes, but if by "if a form is in append mode" you simply mean that you've moved to a new record,as opposed to an existing record, you need to use something like this:

Expand|Select|Wrap|Line Numbers
  1. If Me.NewRecord Then
  2.   'Place your code here
  3.  End If 
Welcome to TheScripts!

Linq ;0)>
Feb 22 '08 #5
Codebug
25
Yes thanks, NewRecord that worked!
Feb 26 '08 #6
missinglinq
3,532 Expert 2GB
Glad we could help!

Linq ;0)>
Feb 26 '08 #7

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

Similar topics

4
by: Tim Marshall | last post by:
This is an embarrassing question to which I should know the answer, but I am not 100% sure of myself. My applications, whether they are Jet or Oracle usually deal with reporting on existing apps...
1
by: PeteCresswell | last post by:
I've got a query that comes up with a dataset list in < 3 seconds when run just in DataSheet mode...but the same query, when run as intended (Append to an empty table) takes upwards of 30 minutes...
1
by: GlobalDeveloper | last post by:
The following simple code which is supposed to enumerate the form and query variables does work in IE6 and FireFox but NOT in IE5. Could anyone advice me on this one??? I think the issue has to...
4
by: John Boy | last post by:
Hi, Can anyone help. This is really doing my nut in. 3 years ASP exp. and now doing .DOT which is a step in the wrong direction. Basically I am left with the code of a guy who has left. When I...
1
by: Ritesh Raj Sarraf | last post by:
Hi, I've got a problem here. def compress_the_file(zip_file_name, files_to_compress, sSourceDir): """ Condenses all the files into one single file for easy transfer """ try:
3
by: Chris | last post by:
Hi, I'm a bit of a vb.net newbie. I'm building a application in VS2005 that will help manage my business. I've got the form working to a extent. What i want to know is the following: 1. Is...
16
by: Hans Fredrik Nordhaug | last post by:
I'm trying to write to a file in the current directory - no remote files. The subject says it all - I can add that both the directory and the file is wordwritable. This happens on a (quite good)...
2
by: Curious | last post by:
I want to write to an output file, "C:\\temp\\debug.txt": If the file exists, append the new content to the end of the file (instead of overwriting the current content). Therefore, I want to...
1
by: nupuragr82 | last post by:
I have a parent form and on button click I am calling a child page where i have a textbox and a button. On button click of child form I am passing the value of the Textbox to the Textbox in parent...
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: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
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?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
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
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
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.