Search results

Hi. How do I format a numeric or currency field on a form, in the following fashion : 5,55,55,555.00 Presently I get the display as 55,555,555.00 So basically, before the decimal - from right; it will be 3 digits,2 digits,2 digits,1 or 2 digit(s). I'm frustrated with no solution on Google...

Hi Doc_man, Thanks a lot for taking time to answer my questions so well ! Really appreciate your effort. I think I'll go for the split DB option which should serve well.

Hi All. I have an Access 2007 mdb appl file on my desktop with several forms, queries and reports in them. It works fine on my PC. I have two issues with it. 1) When I copy that file to some users PC across the network, it opens and I'm able to use them locally just as it was on my pc - only...

Thanks CJ. The actual table name is different from what I mentioned in the example. I'm careful not to use reserved words. Thanks anyway :-)

Hello Everyone ! I have 2 tables, namely 'now' with 150 records and 'req' with 380 records. now : ==== ncode - text nqty - integer nstat - text req : ==== rcode - text rqty - integer xqty - integer ( newly added column with no values as of now) rstat - text Now, how do I update the...

Hi All. I need to replace some values in a field called codes. The field has a few hundred records with codes as follows ES202EM202 ES13457EM13457 ES119EM119 ES20EM20 .... Basically, it was imported from excel, so the column has ES and EM codes with same suffix no. but varying widths. (text...

Thank you both so much ! I'll try it out soon @ my work place.

Hi all, How can I populate all my queries in a combo box on a form ? What I mean is, I need to list all the queries in my navigation pane - into a combo box on a form and then run those queries when user selects a particular query. Is there a way to do this easily or with minimum VBA code ...

I did try converting it to an accde file. I get a 'could not make accde file' error. why ?

Hi. I find the Navigation pane settings confusing at times in Access 2007. I've developed a small application and wish to deploy it with the user able to see only the forms and reports in it. I don't want the user to see the queries or the code in them ! I've tried a few things with the...

Hi All. I have a materials table with MatID (alphanumeric text), MatDesc (text) and MatQty (number) - approx 1200 recs. And I received another table from a branch office with same structure but nearly 1750 recs. Now, I need to compare both using a query. But the result has to be as follows...

Yes, Dave ! MC101 here SHOULD sort immediately below MC10. I want the number portions to sort numerically, within the alpha prefix?

Hi All. I need to sort a column in a table that is of text type, but has alphanumeric values like MC10, MC111, MC215 etc. In the table, when I use the sort from Access ribbon, I get MC10 MC1112 MC1759 MC101 MC2315 MC3000 etc etc... Actually, the MC101 must come between MC10 and MC1112 ...

Thank you all very much for the inputs. However, the union query solved my issue and the peculiar setup I'm working in !

Thanks CJ. But when I substitute a fieldname (me.amount) in place of 12345175987 in your example; it does not work properly. I get the 31,250,000 instead of 3,12,50,000. Why ?

Sure. It is a numeric field (Double) in my table that stores amounts in Indian Rupees. When I enter the number in a data entry form, or retrieve it in a query - it should display as 1,25,75,000.00 and not as it displays currently in Western format of 12,575,000. To be precise, the amount in...

Hi All. How do I format a numeric or currency field in my table, so that it stores and displays the number in Indian (INDIA) number system ? 12575000 should be displayed as 1,25,75,000.00 (without decimal also fine) and not as 12,575,000 ! I've tried the regional settings option but it does...

Hi. Thank you very much for taking time to create an example for me. That's so nice of you. BTW, the union query worked well too. In fact, I used it in a similar situation a few years ago. Thanks again ! I've downloaded your example and will check it soon. And to answer your query, the reason...

Perfect ! " If the records that you are "appending" already exist in your table then you probably don't want to append records, but rather update them. You can (or I can) create queries that will append the one that don't exist and update the ones that do " So, can you please show me how to...

As an example, consider this scenario. Both tables have same structure of about 22 fields each. My 'old bills' table has a few hundred records of the previous years. The other user has 'new bills' table that is updated for the current year only. When I run the reports; I need to have all the...