Hi all,
I'm getting an error "The setting for this property is too big" for my combo box when trying to load 2 columns (fields) of about 2,000 records using a stored proc (SQL SERVER 2000) to access 2003 as my front end. If i only load the customer number.. one field it does it.. but as soon as i try adding the customer name next to each number I get this error, is there a limitation to the combo box that I'm not aware of?
Hi,
I'm actually concepting a new site about travelling, in this web site people will be able to post the stories about there travelling (in french its called 'carnet de voyage') So lets say i will let limite texte to around 2 pages and will let upload 15 picture (but have a mini picture and a big picture, so in fact its 30) and i will limite weight for big at 100ko, but pictures is not uploaded in database.. only the link to the uploading file..
The language i want to use is asp and want to use an access database.
My question is considering that if my web site would become 'popular' and let say i have 200 hundred members who have post there stories. it would do about 3000 entries on pictures, and let say that 100 peoples looking at stories at the same time, is this gonna slow down my database or even crash it?
ps: im canadian (french) so sry if my english is a little bad, i have do my best to explain clearly.
I wonder if anyone can help me. I have a table in my database which currently uses 9 fields to make up the primary key. I wanted to add a further 2 fields to this to make 11, however Access will only accept 10. Does anyone know any way around this please?
View 7 Replies View RelatedA newbie to Access
I created a table to store data of my clients.
One of the fields in the table was set aside for the A/c Nos (Primary Key) for my clients.
An example of the A/c no looks like this : 57051-01
After setting the A/c no as the primary key, I cant key in the "01"
The field only allows me to key in 57051.
Is there any way to overcome this? Pls enlighten me!
Hello,
I have a database that has 63 fields. I want to do a query that will give me one aggregate number for all 63 fields. When I try to run it through the Access Query GUI, it only allows me to select 43 of the 63 fields then the buffer is full. So I tried through the SQL GUI and it's better but still will not get the entire 63 fields. So last I tried through the MODULES and wrote a quick VBA and it tells me the string exceeds the 1024 character limit. ARRRRG!! What I'm trying to do is this:
SELECT qryGrpByUL.CellName, ((([qryGrpByUL]![UL0]+([qryGrpByUL]![UL1])*1)+([qryGrpByUL]![UL2]*2)+([qryGrpByUL]![UL3]*3)+([qryGrpByUL]![UL4]*4)+([qryGrpByUL]![UL5]*5)+([qryGrpByUL]![UL6]*6)+([qryGrpByUL]![UL7]*7)+([qryGrpByUL]![UL8]*8)+([qryGrpByUL]![UL9]*9)+([qryGrpByUL]![UL10]*10)+([qryGrpByUL]![UL11]*11)+([qryGrpByUL]![UL12]*12)+([qryGrpByUL]![UL13]*13)+([qryGrpByUL]![UL14]*14)+([qryGrpByUL]![UL15]*15)+([qryGrpByUL]![UL16]*16)+([qryGrpByUL]![UL17]*17)+([qryGrpByUL]![UL18]*18)+([qryGrpByUL]![UL19]*19)+([qryGrpByUL]![UL20]*20)+([qryGrpByUL]![UL21]*21)+([qryGrpByUL]![UL22]*22)+([qryGrpByUL]![UL23]*23)+([qryGrpByUL]![UL24]*24)+([qryGrpByUL]![UL25]*25)+([qryGrpByUL]![UL26]*26)+([qryGrpByUL]![UL27]*27)+([qryGrpByUL]![UL28]*28)+([qryGrpByUL]![UL29]*28)+([qryGrpByUL]![UL30]*30)+([qryGrpByUL]![UL31]*31)+([qryGrpByUL]![UL32]*32)+([qryGrpByUL]![UL33]*33)+([qryGrpByUL]![UL34]*34)+([qryGrpByUL]![UL35]*35)+([qryGrpByUL]![UL36]*36)+([qryGrpByUL]![UL37]*37)+([qryGrpByUL]![UL38]*38)+([qryGrpByUL]![UL39]*39)+([qryGrpByUL]![UL40]*40)+([qryGrpByUL]![UL41]*41)+([qryGrpByUL]![UL42]*42)+([qryGrpByUL]![UL43]*43)+([qryGrpByUL]![UL44]*44)+([qryGrpByUL]![UL45]*45)+([qryGrpByUL]![UL46]*46)+([qryGrpByUL]![UL47]*47)+([qryGrpByUL]![UL48]*48)+([qryGrpByUL]![UL49]*49)+([qryGrpByUL]![UL50]*50)+([qryGrpByUL]![UL51]*51)+([qryGrpByUL]![UL52]*52)+([qryGrpByUL]![UL53]*53)+([qryGrpByUL]![UL54]*54)+([qryGrpByUL]![UL55]*55)+([qryGrpByUL]![UL56]*56)+([qryGrpByUL]![UL57]*57)+([qryGrpByUL]![UL58]*58)+([qryGrpByUL]![UL59]*59)+([qryGrpByUL]![UL60]*60)+([qryGrpByUL]![UL61]*61)+([qryGrpByUL]![UL62]*62)+([qryGrpByUL]![UL63]*63)/63)-110) AS TotalOfUL
FROM qryGrpByUL;
The output is the mean of all the fields and should give me an output that looks like this
CellName TotalOfUL
Site1 -85
Is there another route I can take? The database is not a security issue. If you would like it, I'll be happy to pass it along. I am also very flexible. I can modify almost anything for a suitable outcome.
Thanks for your time,
I am creating an access database and I want to know the following limitations;
1. Maximum number of users who can log into the database at a time
2. Maximum size of the database. Here I understand that it is 2GB, but I am confused as to whether it is for .MDB file or for each table in the database.
Can anywone help me in this regard? :confused:
I have a website writen in ASP and connected to Microsoft Access.. Why several people is telling me they couldn't find my website, it's not working. But they didn't tell me what is the error are they getting..
I get about 50 hits daily. Could Access handle this type of job?
Today a guy who has done some Access programming told me that an Access table has a limit on the number of records.
Whereas I was thinking the only limit is the 2 gig size.
Which one of us is correct here?
(Access 2003).
I haven't been able to find if there is a maximum length of text within a textbox.
I have a form on a club database, and one of the textboxes has the details of their photographic experience. I have one person who is a very experienced worker and I need to add more details in the textbox. Currently there are 29 characters, including spaces in the box, but it won't allow me to add any more. I have set the width of the box on the form to a wider setting, but this makes no difference. What can I do?
Hello all
I was wondering if there is limitation to the number of IIf statements that can be nested in a calculated field.
Basically I need to assign a particular ‘label code’ to a record that will be derived from data with in several fields within the query. The data from the table (that the query is derived from) will be completely deleted and recreated on occasions, meaning I can not write data back to the table as it would be lost when the re-creation happens.
There is a possibility of many derivations for the ‘label code’ (maybe up to 100) so the nested IIf code will be substantial.
If there is a better way to do what I want I am all ears however I am not a VB programmer so would rather stick to doing within the query design grid, or SQL at a stretch.
Anyway the main focus to the question is there a limitation to the number of nested IIF statements.
Example preliminary test code:
Thanks in advance for any help provided regards.
Daryl
I have a form that supervisors use to input employee accountability for each day. Once supervisor completes the input, a command button is selected and records are appended to an archive table and then deleted from the "live" table. End of the month, reports pull from the archive table to tally absences.
The problem: when a supervisor submits the daily status report but resubmits the report do to an input error I now have two records for the one reported date.
How do I pull the end of month report without including an earlier record for a duplicate date? Is it possible to have access overwrite any records previously submitted for that day?
How many records does MS Access 2003 hold, i.e. is there a limitation & what is it?The toolbox greys out after being selected on the Menu options even though Tools/Startup/allow built-in toolbars is selected - how to activate the toolbox in 2003 version?
View 1 Replies View RelatedWe have a database with one main data entry which stores records in a seperate table. There are several thousand records keyed in using this form. Therefore, alongside the entry we have a search form which allow the user to search for a specific record and display it in the main if he/she needs to edit one.
We have received a request from users for a functionality which allows users to browse all records, using the main form layout, that they have keyed in. I guess what I am asking is: Is there a way to limit the records visible in a form using field on that same form as a limitation (ie. the users name - which is a required key-in)?
I was wondering how to do a crosstab query and have to column headings
I need the Organization Number and the Org name..so something like this
4005 4010
Office of HQ Office of Accounting
Is this possible?
I have several comboboxes (6) on my form.How to populate these comboboxes with values depending on selected value in previous combobox.
Example.Lets say that you select value "Audi" in combobox 1, then available values in combobox 2 should be "A4","A6","TT" etc. and if you selected "BMW" in combobox 1, then available values in combobox 2 should be "3-series", "5-series" etc...
I have a form that currently uses a "catch all" table for listing available equipment to choose from for an equipment field. I call it tblEquipment. What I want to do is to make it so when I type a name in (1 of 35) in one field of the current record, the record source for the equipment field immediately looks at a different table that has equipment available only for that name. To do this I plan on making 35 different tables with limited data originally found in tblEquipment. I would call these tblEquipment1, tblEquipment2, etc. I do not use a sub form, nor do I want to.
So my questions are:
1) can this be done
2)If it can be done, how can I do it?
Hi everyone,
I have two combo boxes on the same form bound to a table. I want the contents of the next combo box to change based on the previous combo selection e.g
cboContinent cboCountry
Africa Zambia
Africa Congo
Africa South africa
Europe England
Europe Holland
If I choose Africa in cboContinent, I want to see only Zambia, South Africa and Congo under cboCountry and if I choose Europe I want to see only England and Holland
Thanks
Humphrey
I have a Suppliers database which contains a form that will allow me to place orders with Suppliers.The Main form has a combo box that allows me to select the supplier. The combo box is called SupplierID with the following:
Row source: SELECT Suppliers.SupplierID, Suppliers.CompanyName FROM Suppliers ORDER BY Suppliers.CompanyName;
The subform is called Stock Subform witha combo box called ProductID with the following:
Row source: SELECT DISTINCT Products.ProductID, Products.ProductName, Suppliers.CompanyName, Products.Discontinued FROM Suppliers INNER JOIN Products ON Suppliers.SupplierID=Products.SupplierID WHERE (((Products.Discontinued)=0)) ORDER BY Products.ProductName;
Event Procedure - AfterUpdate: Private Sub ProductID_AfterUpdate()
On Error GoTo Err_ProductID_AfterUpdate
Dim strFilter As String
' Evaluate filter before it's passed to DLookup function.
strFilter = "ProductID = " & Me!ProductID
[code]..
The Link fields are done on the Purchase Order ID (PONoID).What I want to achieve is to select the supplier from the combo box (SupplierID) on the main form and then the combo box (ProductID) on the subform to filter to only show products directly supplied by the Supplier selected on the Main Form.
I'm looking for a way to have a text box auto fill based on the selection of a combo box on the same form. I cannot use the method i find all over the internet of using multiple columns in the combo box and basing the text box on that because the combo box already has multiple columns being used to determine its own possibilities and other combo box possibilities.
I would really just like the text box to work like this, but im still kinda inexperienced in VBA...
If combo box is "F004-001", then text box is "237"
If combo box is "F004-003", then text box is "280"
I know how to add in an "after update" thing, but i do not know how to do If/then statements.
I'm have quite a difficult time getting a form in Access 2010 to perform the way I would like it to. I have multiple tables that I've created, and a query that contains the data from the various tables. I then ran the form wizard to select the data from the query that I wanted to populate in my form and I've added 2 combo boxes.
What I want to do:
1. I want users to be able to select a category in combo box #1 (example: "Bag")
2. I want users to be able to select a detail in combo box #2 based on the category they selected in combo box #1 (example: Combo box #1, "bag" would populate the following selections for combo box #2: "sandwich" and "tool")
3. I want users to then receive a list of suppliers that provide the product they have selected, either "Bag: Sandwich" or "Bag: Tool"
I have combo box #1 populating a list of categories already. However, I am not able to get combo box #2 to provide choices based on the selection chosen for combo box #1.
Let's assume we have 3 tables:
Order_Category (Order_Category_ID, Order_Type_Name) with 2 records:
1, Minor
2, Major
Order_Type (Order_Category_ID, Order_Type) with 4 records:
1, Book
1, Pencil
2, Car
2, House
Orders (Order_Category_ID, Order_Type, value) with 2 records:
1, NULL, NULL
1, NULL, NULL
2, NULL, NULL
I want to create a Multiple Items form presenting Orders table with two Combo Boxes:
1. A combo box to select Order_Category_ID.
2. A combo box to select Order_Type. When 1 (Minor) is chosen in the first combo box it should show Book and Pencil, when 2 (Major) is chosen it should show Car and House.
Examples in the Internet show how to do it on a 'single row' forms using the RowSource property. I tried to use a query like:
SELECT Order_Type
FROM Order_Type
INNER JOIN Orders ON Order_Type.Order_Category_ID = Orders.Order_Category_ID
WHERE Order_Category_ID = [comboBoxOrderCategoryID]
But it sets same values for all records in the Multiple Items form and it should return different values in each rows based on value in the first combo box (Order_Category_ID).
Here's the deal:
I'm an extreme newbie, I do not know access very well, nor do I know VBA, I do know PHP.
I have a for in access that has 2 user input fields, one for prodid one for shipid. I have a combo box that upon entering data into the previous 2 fields, it does a query against an MsSQL database looking for a record that has both. In any case there will only be 2 outcomes, either 1 record, or null. I would like to have that same combo box automatically use the result as it's value so that users don't have to check the box, because they won't, and so that the rest of my VBA will be able to function properly.
Can anyone assist?
Thanks.
Thanks in advance for your help.
I would like to set up rules/constraints such that the value selected in combo box A determines the available values in combo box B. For example, "Combo box A" is bound to the [PartnerType] field and "Combo box B" is bound to the [PartnerRole] field. Let's say that the two choices in Combo Box A are "LLC", "LP", and "Corporation". There are 5 possible choices in Combo Box B: "X", "Y", "Z", "Q", and "U". If a user selects "LP" in Combo Box A, I would like Combo Box B to only show choices "X" and "Y". And if a user selects "LLC", only choices "Y", "Z", "Q", and "U".
Similarly, I would like to set this up so that Combo Box B is not initially visible--it becomes visible when a user selects "LLC" or "LP". If a user selected "Corporation", Combo Box B would remain hidden.
I have seen a few articles here and there on using a combo box to filter records in a sub-form and to filter records in another combo box, but I am not getting anywhere. I hope someone can belp
Exercise 1
For this exercise, I have the following tables:
tblClients containing client names
tblProjects containing some project details
I want to set up a simple form, so that the user can select a client name from a combo box on the main form which filters the project detail records in the Projects sub-form.
Once the user enters project details, I want this info as well as the selected ClientID to be fed back to tblProjects.
Exercise 2
I have the following tables:
tblProjects as above
tblWorkstream containiig names of workstreams and some other details.
Every project has one or more workstreams
I have a form where users will enter hours worked on each workstream. They will first select Project from a combo box on the main form. This should then filter records to be displayed in the Workstream Combo box, before they can then enter hours.
Please let me know if you need me to explain any part of this better.
Thanks in advance.
ps. I am a novice, so I'm hoping to do the above using default MS stuff, not with complex programming!!!
Thanks
I'm an Access newbie and I'm having trouble restricting a combo box on a subform based on the selection of the combo box on the form.The combo box (Combo1) on the main form (FrmOrganisation) gives a list of companies, I want the combo box (Combo2) in the subform (SbFrmEmployees) to list people only from that company. I then have a subform within that subform that displays information about the employee.
View 3 Replies View Relatedi have a table with three column Named
1-State
2-City
3-Customer
on a form i m placing 3 combo box for each column how can i filter combo 2 from table after select value from combo 1