when i change a form so that instead of single form its multiple forms it seems to only want display 30 instead of the 62 that exist. is there a quick fix this?
if not is there a way to make it display the next 30?
as now it says "record 30 of 62" when it gets to the bottom of the form... ;/
any help is much appreaciated ta. <3
I have qrys that show current info and also repeated info. A request has been brought to me to now count how many times the repeated data has been repeated.
The data is updated daily, so the repeated record would need to increase in the number of it's occurances by 1 each day.
Any guidance on how to accomplish this is GREATLY appreciated! :)
I've created a database from an 8 page questionnaire with questions all linked to the subject ID (in other words, each 8-page questionnaire is about 1 subject). I think have the data normalized fairly well. However, now I'm running into problems regarding length of the form. Because the original questionnaire is 8 pages, the 22 inch form limit is not nearly enough. I had used tabs that run across the form horizontally, but the users doing the data input had too much trouble clicking the tabs and scrolling across. They said it was too much of a hassle and slowed them down, so they want me to change it so the questions flow vertically. But I don't know how to get around this 22 inch vertical limit. I would greatly appreciate some help. Thanks in advance.
View 2 Replies View RelatedHello All,
In my table, I have some records that are duplicated (aside from the primary key).
How can I select only one record from each set of duplicated entries? (There may be more than 2 of each of the duplicated records, but I only need to pull one of them...doesn't matter which one.)
i.e...Like a 'Find Duplicates' query, but only returning the top 1 primary key from each duplicated set.
Thanks,
Sarge.
I am trying to build a query which will find the costs from a set of tables where the client has costs.
The client has a cost on booking a fee, he has a hotel room cost and a room facility cost.
My query brings up what I want but each result is repeated 3 times.
I don't know why, can someone correct me please.
SELECT DISTINCT Addresses.ID, Holiday_Bookings.Initial_Cost, Room_Facilities.Cost, Rooms.BasicCostPerNight
FROM ((Room_Facilities INNER JOIN ((Hotels INNER JOIN Rooms ON Hotels.HotelID = Rooms.HotelID) INNER JOIN Stops ON Hotels.HotelID = Stops.HotelID) ON Room_Facilities.FacilityID = Rooms.FacilityID) INNER JOIN (Routes INNER JOIN WalkTypes ON Routes.RouteID = WalkTypes.RouteID) ON Stops.StopID = Routes.Arrive_In) INNER JOIN (Holiday_Bookings INNER JOIN (Groups INNER JOIN (Clients INNER JOIN Addresses ON Clients.ID = Addresses.ID) ON Groups.ID = Clients.GroupID) ON Holiday_Bookings.ID = Clients.ClientID) ON WalkTypes.Walk_TypeID = Groups.GroupID;
Attaching a sample mdb file. I have TABLE1, TABLE2 and QUERY1, QUERY2 in my mdb file.
I want Query1 Value 4 once in Query2. It should not be repeated again with [SBNO] values 5 time.
Value 4 in Query 2 shows with only 1st record and remaing 5 records shows 0 value instead of 4.
How is it possible.? Can anyone help me.
I am really new to using access and I have a massive table 16000 or more entries. What I need to do is take this example data :
VPIAddress
001:99_97_AO
001:99_96_AO
001:99_0_AI
001:986_51_CI
001:986_50_CI
001:985_51_CI
001:985_50_CI
001:984_50_CI
001:983_51_CI
001:983_50_CI
(This is just a tiny fragment of the total data)
The 001: to the first '_' is the important bit this is defining a "Router" what I need to do is total up how many '001:*_' there are, not including duplicate numbers.
Firstly if I understood this (http://www.access-programmers.co.uk/forums/showthread.php?t=92001) post correctly I need to have all the VPIAddress the same. If this is correct is there a way to get access to delete the data after the first '_' ? (I would of posted in this tread but i didnt think that would be right, if im wrong mods move the post :) )
Secondly will the info in that post help me to reduce the data into this :
VPIAddress
001:99_
001:986_
001:985_
001:984_
001:983_
So that I can then see how many Physical "routers" there are
If any one can help me and tell me that my idea will work then tell me how to do it id be extremely happy!
Even if any one says that wont work and gives me the correct way to do it and does a virtual "Clip around the Head" and call me a Daft Bugga I would still be happy because I wouldn't have to trawl through the entire 16000+ entries deleting and modifying.
I'm trying to set up a query where it returns me only the items that are repeated.
ie...I have a table that has clients that are one time clients and other that are repeated. Each client has a client number. I would like to get only the clients whose client number appears more than once. Is that possible?
I have a pair of combo boxes which are n a frm and work fine.
The code is:
Private Sub cboSubjectSelector_AfterUpdate()
Me!cboOneBookSelector.Requery
Me!cboOneBookSelector.SetFocus
End Sub
Private Sub Form_Current()
Me!cboOneBookSelector.Requery
End Sub
I want the combo boxes to be repeated five more times so that the same options are given within the same form. Every time inset a copy of the same combo box get the folowing error message:
'Microsft Access can't find the macro 'requery''
I am ot sure what I need to do nrder t remove the error message. I did not create a macro called 'requery' tis part of the code above.
I have alos tried to recopy the code above and then retnamed the cbo in the form adn then modified then copied and modified the code to see if that helps - it doesn't. Any ideas - please help.
I have a form that simply lists the items:
DEPARTMENT_NBR and DEPARTMENT_NAME
In the table: DEPARTMENT_TBL
When I edit the field DEPARTMENT_NBR and it is in error (must be between 01 and 99) I want to put out a message in a MSGBOX and SetFocus back on the DEPARTMENT_NBR.
I coded the MSGBOX with vbokonly and then DEPARTMENT_NBR.SetFocus, but after the message displays and enter is hit for the ok the cursor jumps to the DEPARTMENT_NAME on the current line. Is there a way to get the SetFocus to work properly on repeating items like this? I can never seem to get them to perform the same as they do on non-repeating items.
Thanks for your help.
HERE'S THE EXACT CODE:
If IsNumeric(DEPARTMENT_NBR) = False Then
If DEPARTMENT_NBR <> "00" Then
MsgBox "DEPARTMENT NUMBER must between 01 and 99.", vbOKOnly
DEPARTMENT_NBR.SetFocus
GoTo DEPARTMENT_NBR_EXIT
End If
End If
Also, is there a way to look at a specific item in a list like that? IE. I want to reference the 3rd row's DEPARTMENT_NBR. Thanks.
I have an activity report which has multiple entries for the same date by club members. I have managed to build the database:
2 Tables
2 Queries
2 Forms
1 Report
Which list attendance's and activities by Member and Date and Prints each one starting on a fresh page..What I wish to do is count each Club Members total days attendance. I have tried using the Totals button but I don't know enough about expressions to get it to count multiple dates as 1.
Everywhere I have looked can tell me how to count between dates, around dates, workdays in a year etc. etc. etc. but none give me multiple dates the same counted as 1.
I am running repeated calculation queries of different data, but its is not working to well. I have one query listing the total number of hats made from wool. I then have a second query of that lists the total number of hats made from wool and are black. I have third query that calculates the percentage. I have many different hats of many different colors, and i am doing the same three queries over and over. However, the calculated field for percentages does not update. E.G. I have 100 wool hats, 10 wool,black hats, 10%. The next round: i have 100 wool hats, 5 wool green hats, its will still show me 10%, as its is still calculating based on the previous data. how can i go about this most efficiently and why is not updating?
View 1 Replies View RelatedI have a form with Continuous Records as its default view. I would like to number the amount of records displayed on screen to about 5 or 6 at a time instead of having them scrolling right off the bottom of the screen. Is there any easy way to do this?
Thanks
I have a combo box in which I wish to show the Person_ID's of every record in the table TBL_Person, except those which are returned by a separate query. Is this possible at all?
View 1 Replies View RelatedI want to limit the # of records being entered in a form according to a limit value which has to come from a query.
View 11 Replies View RelatedI have a split design form, where user can select on any row and column of the spreadsheet view of the form and edit the data. Now, I want to write a code to limit the data addition(Row addition) to a certain number. But I still want to be able to edit the previous records added to the form.
I used Me.AllowAdditions = False, but when I want to select the previous records, it gives error:"You cannot go to specified record".
I can't get this to work! I have a module for it and I think (?) the correct code.
'Limit Records On Subform.
OnCurrentEvent of Main Form ' Main form is frmTimeCards
LimitRecords Me.frmPayrollEntry.Form, 7 ' Allow at most 7 records
Scenario: Main Form/Subform
Subform is a Continuous form.
Enter Payroll via Subform
Via Combo, select a Employee on Subform
Enter Hours
Finish,Select a New Employee
Using CarryOver for Employee
Problem: Can't add new Record for a new Employee.Because of the Limit Records Code.?
I have a db with around 400 records. It contains user's basic information such as first name, last name, supervisor...
Problem is that one supervisor can be multiple users supervisors so they are showing up a lot each time I use the search tool. Is there a way to disable searches on the supervisor field?
my search form has a combo box with "make"names. i can add new makes via a other form. so the combo box needs te run via a query so that it can list new makes (so that i can also search them). but, since some makes repeat them selves in the table, sometimes up to 15 times (see atachment 1), the combo box will show 15 times the same make. i just need it to show the make 1 time, all of the makes just 1 time. only way i can do that is to type them my self (see atachment 2). but then new makes that are added later wont be shown in the list.
so: i want that the make is only shown once in the list, and that the list is updated with new makes that are added later. how do i do that?
note: a "make" E.G = Philips, Apple, LG, Microsoft, creative etc (just for the lesser skilled english readers like me )
all help is welcome
Right now I have a flat database with too many unnormalized fields. I am trying to figure out how to break down the repeated "QuantityOrdered" 1 through 5. "QuantityReceived" 1 through 5.
"RequestedItems" 1 through 5 and "Price" per unit 1 through 5. I'm not sure if they go into the same tables, if they are each listed 5 times and if in different tables how many instances 1 or 5 to show each as seperate and how to create a relationship between them.
I started off with a blank form and added a command button, three labels and a text box. None of these are bound to anything.
The sole purpose of this form is to show the progress of a VB script I've written that retrieves all the table names and the number of records contained in each. This information is also exported to Excel.
Everything works great apart from the log I'm producing inside the text box. This log is just a replica of what is being exported to Excel. Once the log reaches a length of 1,837 characters, it fails to have anything else added to it. The code below is where I have an error returned.
Code:
Me.LogList1.Text = Me.LogList1.Text & vbCrLf & tdf.Name & "|" & intRecCount
The error I receive is "Run-time error '2176': The setting for this property is too long.". From what I've read elsewhere though, an unbound text box is meant to have a character limit of a good few thousand. Around 60,000 from what I remember.
I did try a few other options such as using a label or a listbox but they weren't great. The label doesn't support a scroll bar and if the text goes past the size of the label it doesn't scroll down by default. A list box worked but I want the user to be able to copy the text after in-case the Excel report doesn't work for whatever reason.
I could possibly setup a table with a single field set to 'memo' and bound the text box to that. I don't know if that works though as I don't want to have to create an extra table. This form is to be used across other databases when required and this solution would add an unnecessary table to the list (which I could code out) and also means the table has to be exported to the other database along with the form.
Why my text box is limited to around 1,837 characters?
In the form frmOrders of my database i have a combobox where i can choose a ClientID and the dropdown list shows me all the clients in upgoing order with their related orders in descent order.But the drop down list doesn't show all available clients. The two hundred heighest clientnumbers aren shown. However if i type one of these clientnumbers in the textbox of the combobox, the client is found.If i go to the property sheet of the combobox and activate the query that serves as the recordsource of the combobox, all clients are shown!!!I control of the records of these clients in the table Orders, doesn't show any difference with all the other records.What can be the reason for these behaviour. Is it a question of a limit of records that can be shown via a combo box?
View 4 Replies View RelatedI am looking for a way to limit the number of rows that are added to the subform of a main form. Is there anyway that the allowable number of rows be defined using a field on the main form.
View 3 Replies View RelatedI am new to Access and I am developing a form. I have already read and found useful resources on internet but there is something I am not able to sort out.I have seen that the limit of fields I can enter in Access is 255 and my survey is far below that number.So no issue at all when I created the fields in Data view.However, the issues started when I created a form.
I created a form by Create>Form.The last few fields, at the very bottom of the form, are squeezed onto each other as if there was not any space available. Is there a limit to the number of fields I can have in a form? There should not be if I am allowed to enter up to 255 fields. How can I go about it? Should I alternatively create 2 forms? I would rather not to though.
Ok, not sure if this is even possible or where to even start..
I've got a form that has all the info for a client, eg..
Client First Name
Client Last Name
Client Hours
Client WE/CS/EE
Client Day And Times
Client Phone
Client Comments
Begin Date & End Date (2 boxs) on there for date input..
and what i'm trying to do is limit that any date entered between begin date and end date, it'll check and make sure there is only ever 20 clients on any 1 day..
i thought Datediff would be the way to go, but then again how do you get it to search each day and make sure theres only 20 clients on there..
We have a database where we are trying to limit the amount of data that users need to input.
We have a form, which contains order information. Where a customer has specific requirements, we add those requirements to a separate document review table MasterSpecification and DetailedSpecification.
When a customer has specific requirements, we can open the frmMasterSpecification and search for the document.
Assuming a review has been done the requirements will be shown on the subform Frmsubcoverage. I would like to be able to select the record source from this form and have the details entered into our order entry form.
Under the specification form there could be many sub coverage records depending on the type of item ordered to that specification.