Search results for query: *

Actually, I posted this under the forum "Access other topic" but no one reply this. I guess I must posted in the wrong forum. I have just upsize my Access database (Access 2003) to SQL server 2000. I keep the Access as front end so I do need to change anything.Everything looks fine after the...

I have just upsize my Access database (Access 2003) to SQL server 2000. I keep the Access as front end so I do need to change anything.Everything looks fine after the migration. However, I found out that whatever data updated or input from one machine will not updated to other machine, not even...

Hi, I have a quarterly report with the grouping as below: Agency (Group header) center (group header) department (group header) item(group header) detail section: mon itemName total amount total for the department (department footer) total for the center (center...

Hi, I have using VS 2005 and tried to create a masterpages with header, left column for menu and right col for the content. In the menu column, i would like to have a dropdownlist with value of account names from the database. Under the dropdrowlist, there are couple other menu such as account...

Hi, I have a report that include many fields (around 40) that is not easy to join them and put in the report as desire. So, some of the fields I use subreport and some of the fields I use DLookUp. I understand either way will slow down the performance. My question is should I use subreport or...

I am using CR10. Is there any way I can set default value for start date of parameter date range blank and keep the end date as today date? Thanks

I have a report created with CR 10. The report has just 1 grouping and a subreport at the group footer. Since the content of the subreport is always more than 1 page, it always starts at a new page after the group header. Is there any way I can try to make the subreport start right after the...

I am working on upsizng our Access database to SQL server keeping Access as front end. I have experience some of the errors such as no index for the tables ... Since it is still under processing, I cannot put it on sevice (letting user to update the data) while I am still doing the modification...

Hi, I have a table that I want to add two more fields to collect the update information whenever a record is updated. The two addition fields namely, date_modify with datatype= datetime and modified_by with datatype = number I have added the following code: Private Sub...

I have created form with microsoft Word 2002 SP3 for mail merge with the data from Access. There is a checkbox in the letter. Is it possible for me to program the status of the checkbox based on the field value from the data? Thanks

Hi, Anyone has idea how to create a formula for grouping of years and months? The data will return the date range we do not know. For example, the date range will be from 2002 to 2004 and not every month has data. What I need is create a formula that will group the data by month and year. The...

Hi, Can anyone shows me how to set up the user/group permission for Access 2002? What I want to do is setup a password for every user. Base on their login password, the the user can access only part of the tables/query/report from the database. Thanks.

Hi, I am using Access 2002. For a query, I wrote: Select m.ID, m.Name, Check1 = case when m.ID in (SELECT m1.ID FROM merge m1 Where m1.check_code = '1') Then 1 Else 0 End From merge m; The error message is: Syntax error (missing operator) in query expression 'Check1 = case when m.ID in...

Hi, I am new to Access. When I created a form, it will display record by record. If I made any changes for that record, the data will save as soon as I move on to next record? Is there any way to make the form pop up a message to confirm whether to save the changes or not when I move on the next...

Hi, I am using crystal report 9 with sql server2000. I have noticed when I exported the output to pdf format, the font size is smaller than the original report. Is there any way I can do to make them the same? Thanks.

I have reports cresated with CR9 with US locale. Now my reprots need to run under different locale setting (Spanish) My problem is: For any date type record, if I use the cdate( ) before the data displays, it works perfectly with any locale. For those number and currency datatype, the only...

Can someone tell me how can I write the selection formula so only return records contain Null value on a specific field. Thanks.

Hi, I have created a report with 2 parameters. After I place the crystalreportviewer to the web form, it automatically set the databinding=true. Every time I try to view the report, it prompts me for the paramter value. Can anyone show me the code to pass the parameter values to the report...

With CR 9, which method provide the best performance? - selecting the tables using database expert; that will include many fields that not needed for the report. - add command; write the sql statement and select only the fields needed for the report. Thanks for your comments.

In CR 9, is this possible to display images from my local hard disk? I have all the image files stored in the same folder. Say, c:\images. The file names are a.jpg, b.jpg, c.jpg. ..... In the report, I want to display like this: a.jpg Product Name a Qtr. b.jpg Product Name b Qtr. c.jpg...