Recent content by mickeync

Hi all, I need to link tables from SQL Server to MS Access says .... MYDATA.mdb and allow 30-40 users VIEW TABLE ONLY, but able to create their own queries. However how do they prevent others from updating or changing their queries ??? I have read some help online about creating "NEW...

Thanks a million !!! It worked !!! I mean "pivot table" really nice .... Have a good day to all !!!

Hi all, I need help to figure out how many sales for each sales person based on the Date Sales: For example: ---------------------------------------- Salesperson Company Name Date Sales --------------------------------------- Smith ABC 1/1/2003 Smith XYI 4/5/2003...

Hi all, I am running a problem while importing the spreadsheet which contain the date field from Excell 2000 to Access. I want the date field look just like in excel mm/dd/yyyy. However after importing, the date automatically change to mm/dd/yy. I must have 4 digit year as user requested. I...

Hi Andy, Yeah I found where is all the references under the VB editor and look through all the references. However I have no idea which .DLL I need to make the "PREFIX CHARACTER" grouping available on my Access 2000 database !!! Any idea ?? Thanks again, M.

Hi there, I got it !!! Thanks so much ... You're good !!! M.

Hi, Thanks for the quick response. Where is the "VB editor" located ??? M.

Hi all, After I converted my database from Access97 to Access2000. When I am trying to run the report, I got an error message saying "Undefined function"LEFT" in expression". I found out there was a grouping error on the report when grouping by the customer name with...

Hi Neil, Thanks for all your help. You're the best instructor !!!

Hi Neil, You're genious !!! It worked !!! I need one more favor please ... Now I was able to open CUSTOMER PROFILE from Switchboard as you instructed. However On CUSTOMER PROFILE macro I used BEFORE_UPDATE event to check the minimum required such as name, contact person, city, state before...

Hi Neil, Thanks for your response. I've tried your code. However I wasn't quite sure what you mean by "create an invisible label with a letter in it .." You meant on switchboard tag property create a name like "A" ???? And where do I specify to open "CUSTOMER...

Thanks all, I am gonna try your code when I get to work on Monday Mickey

Hi all, I don't know how to handle this situation. Any suggestions really appreciated. I have one form name "CUSTOMER PROFILE", but being called from two differents places: 1) When user click "CUSTOMER PROFILE" from switchboard: It has minimum required fields such as...

Thank you for your quick response. However I am currently working on "Customer Status" form. The problem is which event I should use to make the Customer Status pause while I am checking for the "Customer Profile" if there is any NULL field.... Here is my code: If...

I am new to VB coding and not quite sure how to make this work. I have two forms, Customer Status and Customer Profile. When changing customer status to complete on Customer Status form, behind the scene it needs to go to Customer Profile form and check to see if any empty field such as...