473,322 Members | 1,614 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Check for a value on a form across a network

283 100+
Hello everyone,

What im trying to do is have a form that will check for a value in a TxtBox across a network.

I have a form that when creating a new record it automatically creates a new record number, but the database is running on many computers at the same time and if they all go to create a new record they will all start with the same number, is there anyway to have the database look at all the open forms to check and see if a form already has the starting value and if so then go to the next number (which would be an increment of 1)

For example if computer A, B, C all have the form open.
If A says record 1 then B will change to 2 and C will then change to 3.

Im not even sure if this is possible. I have been doing a bunch of research on this but cant seem to find any solution. Only thing i can find is after you save which does not really help me, because im am trying to avoid the possiblitity if two people are creating the same record and save at the exact same time it wont let them both create the same record. Which currently my program does. Of course if they wait like 1 sec apart it will catch it in the Table but i would like to catch it before that.

Thanks in advance for any info or help on this :D
Apr 30 '11 #1
3 1592
TheSmileyCoder
2,322 Expert Mod 2GB
Thats what the autonumber is there for. It will draw a number wheb you start creating a record. Any user who starts a new record will get the next unique number.
Apr 30 '11 #2
slenish
283 100+
Yeah unfortnatly that does not work for me. Because i have certain Critera to go along with creating the record number. For example it looks at a name and a date to verify that you are creating the right record to go along with the date and name...

I am currently using the DMax function to call the next record number which works, just trying to get it to check across all the forms.

Thanks for the quick response
Apr 30 '11 #3
TheSmileyCoder
2,322 Expert Mod 2GB
Please show the code you currently use and where (which event) you use it at.
Apr 30 '11 #4

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

Similar topics

0
by: Shyguy | last post by:
I have two forms that both open the same (3rd) form. The third form does the same thing, but a little differently depending on which form it is opened from. Is there a way I can check which form...
0
by: Kevin Waltman | last post by:
I am writing a client/server application that is using Remoting across TCP/IP. It does not use IIS or ASP in anyway. What I am looking to do is take the users WindowsIndentity from the remote...
4
by: Gene | last post by:
As my purpose is to load one form at a time, so I want to unload another form before loading the form. But how to check which form is being load, so I can unload it first.
3
by: Parag Gaikwad | last post by:
Hi, I need to delete files across the network using web client (IE 6.x) in Win 2003 - IIS 6.0 environment. Can someone please suggest an approach I can use to acheive this. Will using FSO do...
8
by: News Microsoft | last post by:
Hi there. I would like to know how can I test if a Form exists. This is the situation: I have a single Form in my application. My objective is, when I minimize the form, it will disapear and a...
5
by: wassimdaccache | last post by:
Hello everybody I'm using access 2003 Sometimes I use to open more than form in my project what I need is to check another form if still opened For example I have : form name X,Y,Z
1
by: prakashwadhwani | last post by:
I have an app containing 9 forms which have approximately 2 to 3 combo boxes and 7 to 8 text boxes + a few labels (in each form). On the same PC the forms open very fast. However when I load the...
2
by: Amit Thorat | last post by:
Is there a possibility to scan MS Access 2000 databases and their VBA code automatically? We need to scan several MS Access databases in network drive to check if they use network shares to create or...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.