Recent content by jp2468

SpikePL, Thanks for your input. I am much appreciated.

Galaxiom, Thank you so much for your input, I totally agree wiht you. :) Thanks.

I created different Access Databases from time to time for different departments. Each database is used for different purposes, has different functionalities, different fields, and for different end user/users. Recent discussion from our company (We are small company with only me as a...

Mark, I am so glad you always give me good suggestions. It does make sense to change to OR. However, even I use AND, it works at Access 2007 to catch overlapped times. After upsized to SQL 2005, that function didn't work anymore. Even I added SQL connections, and recordset, it still...

Mark, Thanks for reply. I should make code clearly. The Orginal data entry form at Access 2007 alllow users to key in service with begin time and end time. Every time when a use key in a new record, the VBA code compare it with the records in the main table. if there is a overlapped service...

Mark, You are so smart, just made a little bit change, the error was gone. Thank you very much. Now, go back to my main problem that VBA code didn't work anymore. I copied my code below, would you please look at it, and give me your help? I looked code for a week, still cannot find a way...

Lagbolt, Thanks for reply! The code is as the below: Dim cnn As ADODB.Connection Set cnn = New ADODB.Connection Dim rst As ADODB.Recordset Set rst = New ADODB.Recordset Dim strConnectString As String 　 strConnectString = "Provider=MSDASQL.1;" & _ "Data Source=MyDataSource; Initial...

I have an Access 2007 application which has VBA code to avoid users to key in wrong data in the data entry form. After I upsized the main table to a back end SQL Server 2005, then link the main table at Access 2007 front end, the VBA code at Access 2007 didn’t work any more. All other functions...

Hi, Chris, Thanks so much for your help. I am much appreciated your time and hardwork.

HI, Chris, Thanks so much for working at midnight to answer my question. I am much appreciated. I figured out at the code I posted. I just need to stick on the same forecolor, or background color within different category and conditions. I will look at your code too to learn something from...

Hi, Chris, If there is a way don't need to use code, it will be great. However, I didn't see the Condition Format at Access 2007 report design view offer me to do color change depend on two fields condition change. Thanks.

Thanks, Chris, Would you give me any idea about which function or loop can make all the Category looked, and correct color returned for different category? Thanks again.

Hi, I tried to build a reprot which change one of number fields color depend on another Category field at the report and number field itself. If there is Category A, then number field will change color at certain number range. If there is category B, then the number field will have...

Hi, Jdraw, Thanks for reply my question. Even I separate tables like you suggested, When I search a staff name, who is secondary in the AssignedEquipment table, how can I also get a additional field to show who is Primary staff shared with him/her too? Thanks again.

Hi, I have two tables as the below: Equipment: EquipmentID (Auto Number), Equipment Name, Purchased Date. Shared : Category(primary, Secondary), StaffName, Department, Assigned Date, and EquipmentID(as foreign key) One Equipment may have couple of staffs shared with it as the below I...