473,598 Members | 2,844 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

vba code in acess 2007

i write simple vba code its working properly but when i close and again open the programe that code not working.please help me quickly
Nov 11 '10 #1
1 1068
orangeCat
83 New Member
Show us some code.
Nov 11 '10 #2

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

Similar topics

2
1497
by: sonasiva | last post by:
hai Iam creating my own website using ASP and MS ACESS ,iam new to ASP and SQL Please help me to write a query to finish my project. i have datas as follows in my database sno name companyname shares percentage date 1 aaa kroft 5000 5 1/1/2007 2 aaa kroft 10000 10 1/9/2007 if i click "name" link the deatils should...
0
1878
by: umlv | last post by:
Hi, I understand that the runtime will be free with access 2007. I wonder about the following scenario: A user will have the full version of access 2003 installed (or an earlier version). A developer will offer an acess 2007 application, and suggest to the user to download and install the runtime for access 2007. If the user were to do so, will that interfere with her access 2003
1
2106
by: Milan Mehta | last post by:
Dear All, I am new to Access and trying my hand on Access 2007. When I try to create a from using Form Wizard and then selects all fields, all text box remain of same width. If I alter width of any one of them, it changes width of all the text box, even if all of them are not selected. Can anyone guide ? TIA Milan.
4
5728
by: SpaceMarine | last post by:
hello, i am having a problem creating a .ACCDE file from an Access 2007 .ACCDB file. its somewhat large application, about 80 megs. it was originally an Access 2000 app that somebody else wrote for our user base, which ran it as a .MDE. i have now converted it Access 2007 .accdb, and am to use the "Make ACCDE" function off the Database Tools ribbon bar.
1
1684
by: dan.allen.dc | last post by:
I am looking for a quick sanity check, to make sure I my view of a problem is reasonable. Our organization just upgraded from Access 2003 to Access 2007. One of our MS Access databases is not working the way it used to. It is my understanding that this is a typical upgrade problem with Access 2007. The database in question has a number of complex forms that talk to one another. There is a lot of VBA code in the background making it
3
2261
by: Bobby | last post by:
Hi Can anybody tell me why the VBA code below works fine in Access 2003 but doesn't work in Access 2007? I do not get any error message, even if I put a deliberate error into the code. Also, if I put a debug break point in the code, nothing happens. If I add the line msgbox "ok" it displays the message box, so I know that it is reading the code. This is a frightening problem, because if this doesn't display errors, then what other bits of...
1
1445
by: rawilken | last post by:
Does anyone know of a Calendar developed for Access that mimics the functions of the traditional Outlook calendar?
2
1546
by: jmborron | last post by:
I have a report in Access 2007 that is populated by a parameter query. My boss wants this report ran for all 250 optoins once a month, saved as a pdf and emailed to the contacts located in a table in access. I have tried using docmd.sendobject but it will not work with my companies Groupwise email. Does anyone have any suggestions on how I can either write a code with loop that will exicute the report for each option and save as pdf (I...
4
3173
by: mroberts50 | last post by:
On my form I have an option box for Band Option and a field box for Band Amount. When I click the Band Option box I want it to fill in the Band Amount field for 500. But it will not work and I cannot figure out why. Here is the code I am using, my option is True/False. Private Sub Band_Option_AfterUpdate() If (Me!Band_Option) = Then Me!Band_Price = "500" Else If (Me!Band_Option) = Then Me!Band_Price = "0"
0
1277
by: Tahir Mehmood | last post by:
Hi, Thanks in advance. I am facing problem regading adding and deleting records from acess 2007 database to excel 2007 sheet.Sheet exists on system and saved at specific path.Plz help me i am in trouble. Regards, tahir
0
8284
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, 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...
1
8046
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8262
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
5847
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 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...
0
5437
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 then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
3894
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...
1
2410
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
1
1500
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1245
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.