Search results

Hi all, I have created 2 queries to filter information from a table. This table consists of all date. reporting month, customers ID(local and foreign), spending amount (local and foreign currency). The first query consists of date, reporting month, customer ID, customer name and amount spent...

Thanks you very much... This is exactly what i needed...:)

Hi, i have two sets of datas... the first(column) set of data is generated by some other programs... The second data is information related to the ID... Is it possible to write some codes so that the information of the second data can be displayed with the first set of data, i.e if it is a 8 in...

Hi, I have an input form for user to enter Y for Yes and No for No. I also have an output to a report. When i print out the report, i want the report to display Yes, instead of Y, and to display No, instead of N. Does anyone have any idea of going about to solve this???

Hi, If i want to group certain items togther in Mail Merge, how do i do it??? For access 97, i can use sorting and grouping, but how i do it in Mail Merge? anyone can advise me on this? :confused:

Hi, U either do a left, right or center alignment... But when u have a paragraph of words, it seems undesirable jus only to do a left, right or center alignment. Are there any ways that i can restrict the numbers of words/letters that i can display in a line?

Hi, Since there is no justification command inside Access, i would like to ask are there any ways where we can modify or add in some code, so that the paragraph of Text look more or less justify. :confused:

hi, Thanks a million...

Hi, Which part of format of the section should i look out for? And what code do i add in? I am relatively new to Access. :confused:

Hi, I was wondering if anyone knows how to make the lines invisble when there is no input to the control source. I have draw a line below a field inside my report, and when there is no value or null value for that particular field, i want the line to become invisble also... anyone knows how to...

thanks doc-man, i will try it... yes, i am very new to access... very grateful for your input :)

joining of access to words Hi, i understand that publishing a report through access, the paragraphs could not be fully justified... Are there any ways where i can get about this problem... i need to generate reports using the existing datas inside the access database... is is possible for me...

Hi, Are we able to justify the alignment of the text in the newer versions of Access??? Does anyone have any solutions of justifying texts in Access???

Hi, Is this a form of marco command??? Where do i insert the code into??? Select Case [FType] Case 1 'Ftype = 1 stDocName = "rpt_1" strFilter = "Name = Forms!frm_europe_1!Name" DoCmd.OpenReport...

Hi, I am doing a group option with 3 options in it. When an user ticks one of the option and click print buttons, a report will be displayed. When the user ticks option A, and click print button, I want the report heading to change to heading A. When the user ticks the second option, and click...

Access Passwords Hi, In that case, i am only able to set one password for tat database. I need a muti-level user password for tat particular database only... IF A opens that database wit his login ID n password, he cld only access that amount of information. IF B opens that database wit his...

Hi, Are there anyway that we could set Multi-user password to the database file instead of Access Program itself? I would like to create only a muti-user password for that particular database. Thanks for any help... :confused:

opz, ok roger that... because i thought we cld that in access... thanks for your reply...

Hi, I have created a text box for user to enter some descriptions of a particular product. On Enter, i want to have bullets... For example, when the user press enter one time, one bullet will appear, and he/she can continue typing, press enter another time, another bullet appear.Could anyone...

Hi, How do i automate the adding of units behind the numerical datas? Only when user enter the numerical datas, then upon print report, the report will show the numerical datas with unit, when there is no numerical datas, the units wont appear? :confused: