473,386 Members | 1,598 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,386 software developers and data experts.

Getting a Box # of # to work in form

First I'll break down this database. Its about 4000 project numbers, some repeat, some do not. Due to these numbers that repeat I need a box that displays which "box number" I am on within these repeat project numbers. Example there are 3 project number 010054's and the box counter will display box 1 of 3, box 2 of 3, box 3 of 3 as you click through them via the next or previous button. My issue is I can not get this counter to work correctly. I have it working through a different query than the form is linked to, however when I try to add new information, it does not allow me. I am not familiar at all with VB so I was wondering if there was an easier way to do this with VB. Any information regarding this issue would be much appriciated.
Jun 28 '13 #1
2 1010
Rabbit
12,516 Expert Mod 8TB
Why do you have duplicate data? How do you tell one unique record from another if you have no unique identifier? You need to be able to identify a unique record if you want to get that working correctly.

Also, please show us the code you tried. It's hard to tell you what's wrong with it if we can't see it.
Jun 28 '13 #2
We solved the issue, used the code
Expand|Select|Wrap|Line Numbers
  1. =DLookUp("RowCounter", "qryBoxNum", "[ID]=Forms![Archives]![ID]") 
to produce the number we are currently on and
Expand|Select|Wrap|Line Numbers
  1. =DLookUp("CountProject","qryTotalBoxList","[ID]=Forms![Archives]![ID]") 
to produce the amount of repeats.
Jun 28 '13 #3

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

Similar topics

4
by: beveled edges | last post by:
Hi: If you set the id attribute of a form, how do you access the id's value from the script handling the post submission? Cheers, Aeden
0
by: Willoughby Bridge | last post by:
Hi - Having trouble getting a multipart series of forms to move to the next form. The problem line is: <form method="post" enctype="multipart/form-data" action="Data_Form1.php"> If the...
2
by: Bad Little Kyle | last post by:
Yes, I'm back with one more question, but it's probably really simple for you guys! Recently I spent time creating a web-based form for our company so that a customer can input all of his own...
1
by: Sam Wuebben | last post by:
I've been trying to get the values of hidden fields from one of many forms on a page to load into a function. The test page is at: http;//www.mvldesign.com/test/item_pop.html The 'Add to Cart"...
2
by: Marian Aldenhövel | last post by:
Hi, Short question: Is it possible to write a CSS-Style that formats <INPUT TYPE=TEXT>-Elements in Table-Cells in a way that they use all the horizontal space available? Long question: I...
2
by: Mystery Man | last post by:
I have developed a series of user defined controls. These have been placed on a variety of different forms. From within one of these controls, I want to show another dialog directly to the right...
2
by: Adam Right | last post by:
Hi, I want to get the controls of the windows form. I know that form.Controls give me the list of controls but i have a problem. For example, the toolstripmenu control cannot be reached with...
3
by: Dave | last post by:
Hey all, I have a problem and I can't find anything on the net to really address it. We have a program at work that has lots of numbers on the front of the form because it is a control program...
5
by: olaamussah | last post by:
Hi, i just started learning perl which i would use for my uni. project unfortunately. Well, this is a simple user login page i tried to create but i cant get it to work. Can someone please check this...
32
by: Don Lancaster | last post by:
In an existing, tested and working program, I have a form entry that simplifies to... <INPUT name ="fp1s" type="text" value=0.000 size=12 > and a button of... <input type="button" value="...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
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
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,...
0
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...

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.