hello,
i have a problem , i am a new user at access , i am using access 2000
, when i am making macro with msgbox the access stucks, i have check
the same file with the macro on other computer and is is working great
,what can i do? 1 1749
You probably don't want to hear this, but have you thought about
using code instead of macros?
If not, what does your macro condition look like? I recently saw
a Microsoft example where they put this in the CONDITION column
of a macro:
MsgBox("Do you want to fax invoices to 555-1212 using MSFax?",4)=6
Give that a try.
--
Danny J. Lesandrini dl*********@hot mail.com http://amazecreations.com
"alon" <ya****@012.net .il> wrote in message
news:ec******** *************** ***@posting.goo gle.com... hello, i have a problem , i am a new user at access , i am using access 2000 , when i am making macro with msgbox the access stucks, i have check the same file with the macro on other computer and is is working great ,what can i do? This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Rafael Campana |
last post by:
Hi,
I posted the messsage below last week, but no replies,
I've reproduced the problem with a VB macro, just create
one and paste the following code. Let me know of any
workarounds you can think of.
thanks,
-R a f i
' add reference to Microsoft.VisualStudio.VCProjectEngine
|
by: alon |
last post by:
i am using access 2000 .when i use macro and in the macro use msgbox
the access stuck , the other software in the computer works great ,
and the same database with the same macro at other computer works
great.
what can i do?
|
by: Bruce Lawrence |
last post by:
I'm running Access 97 and my modules are looping if someone puts an
invalid value in.
The setup:
3 macros - get_clock_num, verify_clocknum, append_to_history
3 functions. each in their own module - get_clocks(), verify_clocks(),
append()
Each macro runs a function from in its corresponding module.
Here is my code.
|
by: redryderridesagain |
last post by:
My macro is writing to a table(T) and reading a query (Q) based on that
table (VBA/Visual Basic 6.3). I cannot write T and read Q in the same
execution of the macro, however, if I skip the writing part I can read
Q just fine.
How does closing the macro reset the state of the system?
The SQL for Q is--
SELECT Relatesto.contains, Relatesto.iscontained
FROM Relatesto GROUP BY Relatesto.contains, Relatesto.iscontained;
|
by: ApexData |
last post by:
Hello
1- What is the AutoExec Macro? Is it the same thing as AutoKeys Macro?
2- I'm looking to Control Keys equally on startup for my entire app. I
understand that
the AutoKeys Macro is the place to go but it seems that some keys
cannot be
controlled there according to MS Help.
I created a Function in my form module to control my keys, but I
| |
by: Bill |
last post by:
This database has no forms. I am viewing an Access table in datasheet
view. I'd like to execute a macro to execute a function (using
"runcode"). In the function, I'll reading data from the record the
cursor was on in the datasheet at the time I executed the macro.
So, the questions are: 1) In the macro, how to I get my hands on the
record key or record data of the record the cursor was on in the
datasheet at the time I executed the...
|
by: Net |
last post by:
Hi Please help. I have a database which requires a message to come up
when certain part numbers are added to it. I have solved part of this
by using a conditional macro eg = 54125 and using a msg
box. This works fine until a part no. which contains a letter is used
eg B6541. Access changes the criteria in the condition box to Part
No]= and won't let me take the parameter boxes out. If I leave
them in I get an error message "type...
|
by: jhicke03 |
last post by:
Hi,
This problem has been bugging me for a while. In my form's before update field i have the following code:
Private Sub Form_BeforeUpdate(Cancel As Integer)
If Me.Nominator_name = "" Or IsNull(Me.Nominator_name) Then
MsgBox "Please fill in your name", vbCritical + vbOKOnly + vbDefaultButton2, "MISSING DATA"
Me.Nominator_name.SetFocus
DoCmd.CancelEvent
Exit Sub
|
by: helraizer1 |
last post by:
Hi folks,
I have a system for an auctioneer and have on the form I have the fields: lot (the item), reserve price () and minimum successful bid so far (). There is then a text box for the user to input their bid (). I have set up a macro for this:
mcr_addBid:
Condition Action
isNull() MsgBox
isNull() Stop Macro
isNull() MsgBox
isNull() StopMacro
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |