Search results

I did that, I deleted the control & added a new but no go. The max value it is taking is 37 list items from the list of 55. I added a table and created a query but it would be great if I could do that using value list option. Also what is the difference between Value List and Field List ???

No I don't see a scroll bar and I am using Row Source Type as "Value List" and Manually typing all the 55 values in the list. I am not using a Table/Query but in case of no go, I might have to use that only. Is there a way to get all 55 list items using value list.

Hi All, I am creating a form where I have a combo box that should hold 55 items in the dropdown but it is only able to hold 36. not sure why Process #1 XXXXXXXXXXXXX Process #2 YYYYYYYYYYYYYY Process #3 ZZZZZZZZZZZZZZZ Process #4 WWWWWWWW - - - - - - Process #55 hksdghosdgoh but it is only...

The below query worked. transform count(format([Tbl - Supplier-Item].[SI Added],"yyyy")) SELECT format([Tbl - Supplier-Item].[SI Added],"yyyy") as YearAdded FROM [Tbl - WRIN] INNER JOIN [Tbl - Supplier-Item] ON ([Tbl - WRIN].[Item Suffix] = [Tbl - Supplier-Item].[Item Suffix]) AND ([Tbl -...

@isladogs No I don't have 2 separate tables called tblSupplierItem & Tbl - Supplier-Item. tblSupplierItem is an alias name for Tbl - Supplier-Item & other table is [Tbl - WRIN]. @June7 Yes, I am using both "query designer" and SQL mode to create CROSSTAB query. Without the concatenation, I am...

Here is another task that I am working on I am trying to create a new field using 3 numeric fields and use the same in Transform statement. Below Query gives me the SI Count year wise SELECT tblSupplierItem.YearAdded, count(tblSupplierItem.SI) AS SI_COUNT FROM (SELECT DISTINCT [Tbl -...

I got it, I am able to get it without Transform statement. :) SELECT tblSupplierItem.YearAdded, count(tblSupplierItem.SI) AS SI_COUNT FROM (SELECT DISTINCT [Tbl - Supplier-Item].[Item Prefix] & "-" & [Tbl - Supplier-Item].[Item Suffix] & "-" & [Tbl - Supplier-Item].[WSI #] AS SI, Format([SI...

I agree but I have only 2 column and I don't need Pivot. Looking to get it without Pivot.

Hi I am trying to concatenate 3 numeric fields in a table Item Prefix, Item Suffix and WSI (Item Created), so that I could get the year wise count of concatenated values but I am getting "Syntax error in transform statement". Could you please help, below is the access query I wrote. TRANSFORM...

Replaced " double quotes with ' single quotes but no go. Same error. Once you click "ok" on error message. It highlights below text of query with black background. SELECT DISTINCT TPR_BOM_HEADERS_CONFIG.*, TPR_ITEM_ATTRIBUTES_CONFIG.ITEM_NUMB

Below query is working perfectly with double quotes. Words within double quotes are text criteria to pull specific records. Not able to get the reason. Could you elaborate. SELECT DISTINCT TPR_BOM_COMPONENTS.*, TPR_ITEM_ATTRIBUTES_CONFIG.ITEM_NUMBER AS BMI_Number...

But there are other queries which are working with double quotes. Could you elaborate.

Hi All, I am trying to move a table to another database by modify the below query SELECT DISTINCT TPR_BOM_HEADERS_CONFIG.*, TPR_ITEM_ATTRIBUTES_CONFIG.ITEM_NUMBER AS BMI_Number, TPR_ITEM_ATTRIBUTES_CONFIG.LONG_DESCRIPTION AS BMILongDesc, TPR_ITEM_ATTRIBUTES_CONFIG.ITEM_DESC AS BMIShortDesc...

I actually created a user form with 5 input controls first 2 Combo box then 2 text box and last combo box. The first 2 and last combo box are mandatory fields where user had to mandatory select the value only then query will be executed and record gets added. Code works properly for first time...

There is lot of manual search to determine proper prefix under lakhs of product group. I choose to stream line and prepared a DB on my own. Now instead of manual searching, I am aligning sub group under group & so on. So if you see the below code I am at Combo box 23 that does not give related...

I am a analyst who work for a small supply chain management company. I work on access DB and I am just trying to develop a form to reduce my own work load using automation and save some time. I am fully loaded and have no time for breaks, So I could automate some of my daily chores then I will...

Hi All, I am working on large set of Cascading combos on form. I initially got Data type mismatch error and I corrected the query as the last combo has data type number & not text but now and I am again getting prompt to enter the value for variable instead of retrieving it from above Combo...

Thanks a ton, Its working. Appreciate your quick response. Thanks again and again.

Hi All, Thanks for the login. Feeling nice to be part of Access Experts. I am just trying to fetch values in a combobox based on selection done by user in another combobox. I am trying to pass the value using a query but getting run time error 7874. Below is the code that I have written...