Search results

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...

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...

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...

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...

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...