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

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

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

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

Hi, I have a drop down box name "Company Name". The Company Name is only a field from a table. I need to make this drop down box eligibility to add NEW COMPANY NAME automatically when the user can't find the matching COMPANY NAME from the drop down box. I am using Access 97. I really...

On my form, every time I click on NEW RECORD or navigate from one record to next record I have an error message pop-up saying "The macro doesn't exit, or the macro is new but hasnn't been saved. Note that when you enter the macrogroupname.macroname syntax in an argument, you must specify...

Hi, I have the 1st drop down box called DIVISION which have 4 selection "GENERAL BANKING" "GOVERNMENT BANKING" "BROKERAGE" "WEALTH MGT". The 2nd drop down box called SUBDIVISION. On my form I want to select GENERAL BANKING from DIVISION, and in the 2nd...

Hi all, I am working on the form that allow user to choose one of the selection from the 1st drop down box. When they pick one, the 2nd drop down box should appears to let them choose one from the 2nd box. For example, the 1st drop down box called DIVISION which have 4 selection "GENERAL...