473,508 Members | 2,112 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

how to remove error in my access

1 New Member
how to remove error in my access

like =SpellNumber([Text51]) it`s showing Error when no data
Nov 11 '17 #1
2 2149
PhilOfWalton
1,430 Recognized Expert Top Contributor
Like is a reserved word and should not be used, so let's call it MyLike instead.

I Presume SpellNumber is a function yo have designed

Try
Expand|Select|Wrap|Line Numbers
  1.     If Nz(Text51) > "" Then
  2.         MyLike = SpellNumber([Text51]
  3.     Else
  4.         MyLike = "No Number"
  5.     End If
  6.  
Phil
Nov 11 '17 #2
NeoPa
32,557 Recognized Expert Moderator MVP
It doesn't matter what language you're writing your question in - that is always far too little information to post when asking a question. Also, never post a question with code you've typed in on the post. Copy & Paste it to avoid stupid errors that are not even what you're struggling with. This wastes everybody's time and is quite inappropriate behaviour when using any forum.
Nov 12 '17 #3

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

Similar topics

10
8682
by: Shawn | last post by:
JIT Debugging failed with the following error: Access is denied. JIT Debugging was initiated by the following account 'PLISKEN\ASPNET' I get this messag in a dialog window when I try to open an...
7
4758
by: Martin Strojek | last post by:
Hi, I have the following problem with developing some web site. I use Visual Studio 2003 to build a website. I tried Windows 2003 Server and switched now back to Windows XP with PWS but the...
2
4964
by: bb | last post by:
when using the web deployment project to merge my aspnet assemblies i get an unusual error 'access to path denied' i double checked path looks ok, and gave everyone full perms on the folder and...
12
3403
by: pake2007 | last post by:
Need To Remove Ms-access Bug#3420 Please Help- Every Time I Press To Move From One Record To Another A Get A Message Box (3420) How Can I Remove This From Popping Up Every Time? THANKS
1
5154
by: daraboy | last post by:
I have a Web home page which allows the IIS users account IUSR_Svr01 to view the page. Each link on the home page allows access to a sub folder, the access to the sub folder is restricted by the...
7
7596
by: sforsasi | last post by:
Hi, I'm trying a simple code to upload a file to the server. When I click to Upload I get the following error message: Error: Access to the path xxx is denied The folder in which I'm trying...
2
2345
by: RAG2007 | last post by:
Hi, I'm running an ADP with SQL Server as back end. On a main form, my subform is coming up blank. When I was running as an mdb with no back end I didn't have this problem. I get an error "Syntax...
2
1767
by: =?Utf-8?B?U2hhbQ==?= | last post by:
I am having the error when i execute my .net application i got this error. "Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) ". Can anyone help me to resolve this error....
2
4181
by: yatinbvn | last post by:
hi how to remove file access permission in j2me? when i test my application in device or simulator ( i use fileconnection api) it start with popup (popup with "Allow application to open "some...
5
1792
by: surendraringwal | last post by:
/* * To change this template, choose Tools | Templates * and open the template in the editor. */ package data; import java.sql.*; class Data {
0
7227
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
7127
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
7391
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...
1
7054
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7501
tracyyun
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...
0
5633
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
5056
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new...
0
4713
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3188
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?

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.