hi, trying to use the code below found on another thread, but am having problems. when using the form, get an error message runtime error 438, object doesnt support this propert or method. it reffers to line...Me.Comments = Me.Comments & " " & Me.NotesMemoField & " " & Now...The unbound box, NotesMemoField and box Comments are on the same form on different tabs. any ideas
cheers... - If InputData.Caption = "Input New Notes" Then
-
NotesMemoField.Visible = True
-
NotesMemoField.SetFocus
-
InputData.Caption = "Add Data"
-
Else
-
If Len(NotesMemoField.Value) > 0 Then
-
DoCmd.SetWarnings False
-
NotesMemoField.SetFocus
-
NotesMemoField.SelStart = 1
-
NotesMemoField.SelLength = Len(NotesMemoField.Value)
-
DoCmd.RunCommand acCmdSpelling
-
NotesMemoField.SelLength = 0
-
DoCmd.SetWarnings True
-
Comments.SetFocus
-
Me.Comments = Me.Comments & " " & Me.NotesMemoField & " " & Now
-
End If
-
InputData.Caption = "Input New Notes"
-
Me.NotesMemoField = ""
-
NotesMemoField.Visible = False
-
End If
-
12  3164  
hi, trying to use the code below found on another thread, but am having problems. when using the form, get an error message runtime error 438, object doesnt support this propert or method. it reffers to line...Me.Comments = Me.Comments & " " & Me.NotesMemoField & " " & Now...The unbound box, NotesMemoField and box Comments are on the same form on different tabs. any ideas
cheers...
- If InputData.Caption = "Input New Notes" Then
-
NotesMemoField.Visible = True
-
NotesMemoField.SetFocus
-
InputData.Caption = "Add Data"
-
Else
-
If Len(NotesMemoField.Value) > 0 Then
-
DoCmd.SetWarnings False
-
NotesMemoField.SetFocus
-
NotesMemoField.SelStart = 1
-
NotesMemoField.SelLength = Len(NotesMemoField.Value)
-
DoCmd.RunCommand acCmdSpelling
-
NotesMemoField.SelLength = 0
-
DoCmd.SetWarnings True
-
Comments.SetFocus
-
Me.Comments = Me.Comments & " " & Me.NotesMemoField & " " & Now
-
End If
-
InputData.Caption = "Input New Notes"
-
Me.NotesMemoField = ""
-
NotesMemoField.Visible = False
-
End If
-
Try this on the line before "Comments.SetFocus" and see if that helps:
Forms!YourForm!YourTabControl.Pages("YourTabPage") .SetFocus
Try this on the line before "Comments.SetFocus" and see if that helps:
Forms!YourForm!YourTabControl.Pages("YourTabPage") .SetFocus
Hi, cheers for the help, but i'm still new to this. So if you could expand abit more...
my form is called Issue
the tab containing the unbound is called add notes
the other tab containing the comments box is called comments
and the tab control is called tab control...
so what should this look like. many thanks
Hi, cheers for the help, but i'm still new to this. So if you could expand abit more...
my form is called Issue
the tab containing the unbound is called add notes
the other tab containing the comments box is called comments
and the tab control is called tab control...
so what should this look like. many thanks
Based on the info you provided, the syntax would be as follows:
Forms!Issue![tab control].Pages("add notes").SetFocus
Forms!Issue![tab control].Pages("comments").SetFocus
Based on the info you provided, the syntax would be as follows:
Forms!Issue![tab control].Pages("add notes").SetFocus
Forms!Issue![tab control].Pages("comments").SetFocus
didnt work, get same error reffering to same line
didnt work, get same error reffering to same line
Ok, I take it to mean that the syntax I gave you set focus where it was supposed to be, but the error line is after the set focus code. If you don't know if the syntax I gave you sets focus where it is supposed to, comment out the error line and see if focus is properly set. If it is, then:
Change these lines:
Comments.SetFocus
Me.Comments = Me.Comments & " " & Me.NotesMemoField & " " &
To this: - Forms!Issue![tab control].Pages("comments").SetFocus
-
Forms!Issue!Comments = Forms!Issue!Comments & " " & Forms!Issues!NotesMemoField & " "
Ok, I take it to mean that the syntax I gave you set focus where it was supposed to be, but the error line is after the set focus code. If you don't know if the syntax I gave you sets focus where it is supposed to, comment out the error line and see if focus is properly set. If it is, then:
Change these lines:
Comments.SetFocus
Me.Comments = Me.Comments & " " & Me.NotesMemoField & " " &
To this:
- Forms!Issue![tab control].Pages("comments").SetFocus
-
Forms!Issue!Comments = Forms!Issue!Comments & " " & Forms!Issues!NotesMemoField & " "
get same error for line ...
Forms!Issue!Comments = Forms!Issue!Comments & " " & Forms!Issues!NotesMemoField & " "
any ideas??
get same error for line ...
Forms!Issue!Comments = Forms!Issue!Comments & " " & Forms!Issues!NotesMemoField & " "
any ideas??
There appears to be something wrong with Comments, so double check that it is a textbox control and its name is correct. NotesMemoField appears to be ok based on the code and info you provided.
There appears to be something wrong with Comments, so double check that it is a textbox control and its name is correct. NotesMemoField appears to be ok based on the code and info you provided.
ok, will check everything again. thank you again for your help:-) cheers lee
ok, will check everything again. thank you again for your help:-) cheers lee
I think I may have spotted your problem: In the left hand side you use "Issue" and on the right hand side you use "Issues" ...which is correct
Try changing this:
Forms!Issue!Comments = Forms!Issue!Comments & " " & Forms!Issues!NotesMemoField
to this:
Forms!Issue!Comments = Forms!Issue!Comments & " " & Forms!Issue!NotesMemoField
or this:
Forms!Issues!Comments = Forms!Issues!Comments & " " & Forms!Issues!NotesMemoField
I think I may have spotted your problem: In the left hand side you use "Issue" and on the right hand side you use "Issues" ...which is correct
Try changing this:
Forms!Issue!Comments = Forms!Issue!Comments & " " & Forms!Issues!NotesMemoField
to this:
Forms!Issue!Comments = Forms!Issue!Comments & " " & Forms!Issue!NotesMemoField
or this:
Forms!Issues!Comments = Forms!Issues!Comments & " " & Forms!Issues!NotesMemoField
cheers, i noticed the same problem yesterday, also comments needed to be comment!! cheers for all your help. lee
cheers, i noticed the same problem yesterday, also comments needed to be comment!! cheers for all your help. lee
Just a quickie, im using - Private Sub Command85_Click()
-
DoCmd.OpenReport "Issue Details", acNormal, , _
-
"[ID]=Issues"
-
End Sub
to print from the form, its open a window asking for the ID number, once typed in it prints the record 'Issue details' for that particular issue. is there a way where by i can pass the window where i enter the id, so when you press print it automatically prints just that issue. ID is the only unique item. cheers
Just a quickie, im using
- Private Sub Command85_Click()
-
DoCmd.OpenReport "Issue Details", acNormal, , _
-
"[ID]=Issues"
-
End Sub
to print from the form, its open a window asking for the ID number, once typed in it prints the record 'Issue details' for that particular issue. is there a way where by i can pass the window where i enter the id, so when you press print it automatically prints just that issue. ID is the only unique item. cheers
dont worry, sorted it. cheers
Sign in to post your reply or Sign up for a free account.
Similar topics
by: AIM |
last post by:
Error in msvc in building inheritance.obj to build hello.pyd
Hello,
I am trying to build the boost 1.31.0 sample extension hello.cpp.
I can not compile the file inheritance.cpp because the two...
|
by: Gregory |
last post by:
Hi,
One of the disadvantages of using error handling with error codes
instead of exception handling is that error codes retuned from a
function can be forgotten to check thus leading to...
|
by: deko |
last post by:
I use this convention frequently:
Exit_Here:
Exit Sub
HandleErr:
Select Case Err.Number
Case 3163
Resume Next
Case 3376
Resume Next
|
by: p |
last post by:
WE had a Crystal 8 WebApp using vs 2002 which we upgraded to VS2003. I also
have Crystal 9 pro on my development machine. The web app runs fine on my
dev machine but am having problems deploying....
|
by: Manuel |
last post by:
I'm trying to compile glut 3.7.6 (dowbloaded from official site)using
devc++.
So I've imported the glut32.dsp into devc++, included manually some
headers, and start to compile.
It return a very...
|
by: bazzer |
last post by:
hey,
im trying to access a microsoft access database from an ASP.NET web
application in visual basic 2003.NET. i get the following error when i
try running it:
Server Error in...
|
by: developer |
last post by:
Hi All
I have made a .NET project.
the files included are borland c++ files that i am migrate to VC++ .NET
I am using Microsoft Visual C++ .NET 2003.
the compilation goes through properly,...
|
by: mchuc7719 |
last post by:
Hello,
I have a Vb.Net 2005 ClassLibrary, when I try to compile using MSBee, only
get errors.
Before I to run the command line, I open in notepad the .vbproj and I was
add the next line:
...
|
by: hyperpau |
last post by:
Before anything else, I am not a very technical expert when it comes to VBA coding.
I learned most of what I know by the excellent Access/VBA forum from bytes.com (formerly thescripts.com).
Ergo, I...
|
by: hyperpau |
last post by:
Before anything else, I am not a very technical expert when it comes to VBA coding.
I learned most of what I know by the excellent Access/VBA forum from bytes.com (formerly thescripts.com).
Ergo, I...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
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
|
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...
|
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...
|
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,...
|
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...
|
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,...
|
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: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |
