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

Yes. I am usinc code to add the total amt at the detail section.

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

Yes, I can make a query to include all the desire fields. The problem is for that subreport, I have to put 5 check box there. Here is the sample data return from the query. ID reason 1 2 1 4 1 5 In the subreport, the layout is: checkbox1 description checkbox2...

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

Thanks. It works.

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

I think that is not an issue since the datatype is number.

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

Thanks Phaed. I am new with Microsoft Office, could you pleasse to show me how? Thanks

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.

Sorry PHV, I am not quite understand your query for the part: First(NZ(C.chk, 0)) As Check1 Can you explain how this work? Thanks

Thanks for all the replied. I used GHolden's method and created a query exactly what I expected. When I use the query for the report. I need to group by ID, then name. It working fine if I set those header and footer not showed. But I need to put the fields at the footer section. When I do this...

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