Search results

Hi Champs I request a code to be written in access where on pressing a button it asks the user to select an excel file . It then copies a specific sheet from that file and pastes it to another excel workbook specific sheet. Data can be text or charts or pics, basically whatever is in the...

Hi Champs I have a simple problem. And i tried access quer unmatched wizard but some reason its not giving the result as expected, hence am asking. I have 2 tables in query to show unused worktypes per user. Table1 User refno worktype UserA 1 worktype1 UserB...

Hi Am trying to import an Excel sheet to access table and i find the comments section being truncated. Am using the DoCmd.TransferSpreadsheet method. I have checked the comments field of my table is memo/long text without the @ but still it truncates to 255 characters like a regular text...

Need help with applying an Excel formula in my access tool. Excel formula is =If(a1<>a2,1,b+1) Basically what it does is it checks the current value with previous value and returns a 1 if duplicate and if not duplicate it adds the value by 1. If any change in the sequence is found, the...

Need help with applying an Excel formula in my access tool. Excel formula is =Mod(If(a1<>a2,1,b1+1),20) Basically what it does is it checks the current value with previous value and returns a 1 if duplicate and starts a counter till 20 if all duplicates. Repeats with duplicate values. If any...