473,549 Members | 2,781 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

To get an automatic number when the button refresh press

1 New Member
Im preparing in an excel sheet a purchase order form and im just new with the VBA and right now im just learning how make it in excel.
Im currently stocked with the problem that I do not know how I can have a continuous number – to have a +1 prior to the last Order number. I have at cellK10 the cell for the order number, when the refresh button is press and the fixed number I saved at cell P10.
Will it also be possible that when I will press again the refresh number it will give me the correct synchronize number since I need to save every form separately.
Hope you can help me with this issue.
Thank you!
Dec 6 '12 #1
2 1305
TheSmileyCoder
2,322 Recognized Expert Moderator Top Contributor
Based on the information provided, and the requirements listed, it sounds to me like you would be better of making an access database, and either print as pdf, or export to excel.

Access has autonumber capability for one, and you can store all orders in a single system. Storing seperate orders in seperate excel files sounds like a headache waiting to explode.
Dec 6 '12 #2
NeoPa
32,564 Recognized Expert Moderator MVP
I'm with Smiley on this one. Definitely an Access type of project, and I'd advise you to explore further in that direction.

However, you didn't ask about that so I'll see what I can suggest that might help. Very little at this stage as what you have is not very clear, and knowing what you may require is pretty well impossible without an understanding of where you're starting from. Why don't you explain exactly what you're working with and all the relevant columns and we can see what we can suggest for you.
Dec 6 '12 #3

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

Similar topics

5
2863
by: fatih kayaalp | last post by:
Hi, i have imported an access database into sqlserver 2000. In access, i have some table fields which were using automatic number as datatype. But i see that there is not a datatype in sqlserver like automatic no. I have to enter id numbers to my tables for each records automatically. Would anybody help me about solving this problem? Any...
1
3190
by: Ed Sutton | last post by:
<Newbie> How can I get arguments, and build a query URL, before a button is pressed? I have a text box to enter a serial number. When the search button is pressed, I wish append the serial number text to the URL and navigate to the search results page. I tried the button click event, but this does not work until the second click. What...
3
2796
by: huhey | last post by:
Hi I am trying to make a html page where I have 3 swf files which I would to be shown randomly when you refresh the page. However I can't get the code to work. I have tried to delete the javascript part and then the movies are being shown - but not in the right way. And when the javascript is there no movies are shown. I would really...
1
17766
by: thewickedman | last post by:
Hi, I try to open new OpenOffice document (writer), But I am getting the exception FRM 40735:WHEN-BUTTON-PRESSED Trigger Raised unhandled Exception ORA - 305500 Please help me to resolve this exception. my code is as follows in when-button-pressed trigger:
9
4134
by: Navaneet | last post by:
Hi, Can anyone tell me how to prevent some particular POST DATA when refresh button (F5) clicked on server side(vb.net). Thanks Kumar N
1
1571
by: pallavi25 | last post by:
how to click the submit button after press the enter key?? plz.. can u help me...
5
7442
by: milk242 | last post by:
Hi everyone I'm trying to change what shows up in the contentpane depending on what button you press. Say you press a button labeled "Customer", it would add textfields to the content pane. I thought I could just add the action int eh actionPerformed method but doesn't seem to work. Thanks for your help! public class ButtonDemo...
9
25870
by: ghjk | last post by:
change the background image when Button Click ====================================== I' developing site with php and postgres. It has menus list in the left side. and all are images(jpg) EX:Add User, Edit User, Remove user(all arebuttons) I have another set of images with different color. Those will display only after the mouse click. How can...
1
2272
by: Karan Singh Goyal | last post by:
I have an access table which have fields like Customer Id, First Name, Last Name etc. i know how to generate auto number but when i delete last record it generates next number instead of previous one and place auto number before save record. I want to know how can Assign Number when user click on save record and also message box display like "You...
0
906
by: anis amor | last post by:
Hello everyone, I am currently wrapping some C functions into Php functions using SWIG. But actually, I don't know what does happen when I refresh the page. It appears that my wrapped functions are called in another process after the refresh. What I would like to have is : When I refresh the page and I call my wrapped function again,...
0
7520
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, 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...
0
7450
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...
0
7720
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. ...
0
7809
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...
0
6043
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
5088
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...
0
3500
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...
0
3481
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1941
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 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.