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

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

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

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:

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:

Hi, How do i create an option inside the form, such that when the user ticks this option, it will print the form in this particular report. If user ticks another option, it will print the form in another particular report format... Thanks...

Hi, If i have a new entry from the user, and i want access to create a table on its own, with the table name defined by the user and the elements of the tables already pre-defined by a sample table that i already do out... Is there any way of doing it? Thanks for any helpful souls around...

Hi, I have created a report to show average value from my table. My table have around 10 records. Thats means i only want one report on the averge value of the 10 records. But in the report print preview, i have 10 reports all showing averge values. How do i remove the remaining 9 reports...

Hi, Is there any way that i could extract data from a single cell inside the table to the forms, and vice-versa?

hi, Are there any ways where i could increase the no of entry within a switch board to be more than 8. I have 40 templates for my database, and i hope to have everything displayed on the switch board... :confused:

Hi pple, From what i know, Microsoft Access could convert Reports into word document or html fomat. I am wondering if it could also convert the reports into *.pdf format. If do, pls advise thanks. I want my access database to be able to output report in pdf format... Thanks.

Hi, i inserted a few *.gif file into my report, upon exporting into html, all the *.gif cannot be displayed... could anyone advise me on how to resolve this issue... thanks...

Hi, if i have to input a entry that have more than 255 words, but my table could only handle 255 words, so how do i go about it... pls advise, thanks...

How to i send a single record to report from form command? when i use the report wizard, it will display all the records in report form. but i jus need that particular record in report form only... pls advise, thanks....