Search results for query: *

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

Hello all, Thanks to Heidi's code... I copied your coding and modified to work on my problem. It worked great !!! However when I click on 2nd combo box (On Chris's issue that would be IssueClass2) I got an error message "can't find macro ..." I tried Lost Focus event but it didn't...

Hi Jim, Thanks for your response !!! I am just a new kid on the block. Your coding is way above my head... and I am trying to understand. It might take me a while to figure out, thank you in advance.

Hi, On my 1st form call "Customer profile". The user will pick the customer they want. When they click on OPEN FORM which appear on the CUSTOMER PROFILE, they want to see some of the info that show on the CUSTOMER PROFILE to pre-fill on my 2nd form such as Name, address, Phone, ... in...

That's funny, Jim !!! Thanks for all your help :-)

I can't !!! I mean I don't know how to send it to you... it's a big database and lots of sub-form tied to it !!! My thought was must be the custom toolbar that control the entire application. There must be some macro that running against my form. I am still digging on how to turn of the custom...