Recent content by pckong

Thank you very much for the reply JHB. It works as intended. I have an additional problem. The above code ignore Space Bar input. Are there any ways to accept the space bar input as in the search field, I might need to type in a phrase.

Hi all, Here is my problem. I made an On Change Procedure on a textbox, so everytime I input a character, it will trigger the Me.Requery. However, after that the event, the mouse cursor moved to the beginning of other field. I want it to stay at the end of the textbox so I can enter a full...

Re: Form Load Error described as "Syntax Error (Missing Operator) in query expression Thanks for the reply. But it still does not work. I guess it is somewhat related to error handling when I did the coding.

Form Load Error described as "Syntax Error (Missing Operator) in query expression" Hi guys, I made some changed in query integrated in a form. The form will load up with automatic query run on open. The problem is my change has some syntax error. After a few unsuccessful run, the error code...

I have found the answer! Basically, you can go to Design View for the Chart, click on Property and select Row Source, it will direct you to a Query Builder, and then you can build your Query. After finished building your Query, go to Datasheet View of the Query you have just built, and you can...

But wait a second, I am doing another chart, and it does not have the table data to copy from. It is automatic generated, where do I copy the data from to the Chart Data Grid? For example, Chart I generated based on Raw Source "SELECT [Field1], COUNT (*) As [COUNT] FROM [TABLE1] GROUP BY...

Thanks for the reply. Yeah, I checked it. It works ;)

Hello I have created a chart report, but for some reasons, it only shows Sample data (East, West, North, 1st Qtr, 2nd Qtr, 3th Qtr, 4th Qtr etc). It is in Design View. If I do Print Preview, it looks fine. Can anyone help me to have the Chart properly displayed in Design View? Thanks Pete

Thank you Bob and Paul for the repply. The above code works and it solves my problems! Cheers

Hello all I want to return the number of record with the SQL search in MS Access. I am using the following code, the expected result will be a value. But somehow, it does not give any result. StrSQL = "SELECT COUNT(*) FROM table1 WHERE [Condition]='A' " How do I return the count value with...

Nevermind all, Just found the answer. Following the following steps, and edit the report property and then edit the property. Open the report in Design view. Double-click the report selector to open the property sheet. Set the PageHeader or PageFooter property to one of the following...

Hi all, I need some help, and it is probably very simple. I have created a report using Access 2003, the report has: Page Header Group Header Report Detail Page Footer The Page Header and Page Footer shows up from second page onward, but Page Header/Footer not showing in the first page. I have...

Hi David Thank you for the reply. I got the cross-table data look up working, by using DLookup function as you have mentioned. It is frustrated that the expression builder supposed to do the right thing, but it dones't work. Thanks again. PJ

Hello, I am relatively new to MS access. My question is about expression builder and it is problably pretty simple, but I won't figure out how. I added a Text Box and use Control Source to choose a data source from another table. And I used Expression Builder. The field in Expression Builder...