	AllExperts > Experts
	Search

About Manish Batola
(Top Expert on this page)

Expertise
ALL MICROSOFT ACCESS DESIGN AND Development QUESTIONS which occur in a Access Projects Lifecycle. Can offer constructive help on Designing Advanced MS-ACCESS Applications such CRM/FRM(Follow-up),Chemicals Indenting,Import/Export,MRP - Manufacturing Resource Planning, ERP - Enterprise Resource Planning, Automotive Management Systems, Business Intelligence for Oil & Gas Drilling Operations, CRM,KPI- Key Performance Indicators,HealthCare, Hospitality, Constructions, Loyalty Clubs, Call Centers, Travel & Tourism, Educational Institutions and many more being added every year.

Experience
24 yrs in the Software industry with 18yrs completely dedicated on more than 200 Various Access Projects from different Industry Sector[s]. I'm using Access ever since it was born.

Organizations
Worked in various multinationals catering from Aerospace, Oil & Gas etc.

Education/Credentials
-MSAP (Master in Software & Applications Programming) -BPRE (Business Process Re-engineering Engineer) -SQAE (Software Quality Assurance Engineer) -STIE (Software Testing & Inspection Engineer) -Project Engineeer (Software Development)

Past/Present Clients
Catered to various clients in the following industries • Oil & Natural Gas (BPM/CRM/Access Development) • Sales / Marketing (CRM) • Automotive (Automobile Dealers) • Indenters (Import/Export) • HealthCare / Hospitals • Hotels 3* & 5* • Restaurants • Construction Co’s (Project Billing) • Clubs (Concept Selling) • Shoe-Chains • Solicitors/Lawyers • Call Centers • Aerospace (Preventive Maintenance) • Travel & Tourism • Computer Vendors • Manufacturing • Music Shops • Education • Data Warehousing

You are here: Experts > Computing/Technology > Business Software > Using MS Access

Questions Answered By Expert Manish Batola
In Category Using MS Access

Subject	Date Asked

Filter a form	10/19/2008
Q: I want to thank you in advance for taking the time to help. I am on a new business adventure and in ... A: I assume that your newly created form is based either on a table or a query. -Open your form in ...
Can multiple users use same .mdb file?	10/19/2008
Q: i just want to know if a single .mdb file can be used by multiple users for 'data entry' purpose ... A: A Single .mdb file can support mostly 20 users when loaded from a single location, I would advice ...
Access aut sequence	10/18/2008
Q: Below is a link that i search for. trying to achieve the exact results he is trying to get. I want ... A: I'm a bit confused regarding your request, I tried searching for the link which you provided me but ...
Stock	10/18/2008
Q: How do Ms Access create/calculate automatically a stock report of the items mention by user in the ... A: I guess if you have Access installed on your PC, you should load the demo Access programs that come ...
Preventing report from displaying if no records are return	10/17/2008
Q: I am trying to prevent a report from displaying if no records are returned. I have a report setup ... A: - Open your report in design mode - Right Click and go to Events Properties - You should add your No ...
Stock	10/17/2008
Q: How do Ms Access create/calculate automatically a stock report of the items mention by user in the ... A: Your question can be answered in 100 different methods. MS-Access Inventory projects usually perform ...
Filter a form	10/17/2008
Q: I want to thank you in advance for taking the time to help. I am on a new business adventure and in ... A: It's OK to create a separate form to Add new Categorie[s], I feel you can apply filter in the ...
Table Links to Excel data refresh patterns	10/16/2008
Q: I have an excel table linked to external data from a web page. Then I linked this excel sheet to an ... A: Does the excel worksheet refresh just before the access linked table is opened? - Yes will it ...
compare and combine multiple records	10/16/2008
Q: I'm new in my job using ms access 2007. I have a transaction table which looks something like: ... A: What I could assume from your first request was that you wanted to know, "Who were the previous ...
compare and combine multiple records	10/16/2008
Q: I'm new in my job using ms access 2007. I have a transaction table which looks something like: ... A: Do the following : ================ -Create a query based on this table (Choose all fields) -Apply ...
MS Access dataBase	10/15/2008
Q: please help me out with these questions :( How Does MS Access Database Save The Data After ... A: Your questions seems pretty vacant, usually a user will enter data in a table either directly or by ...
Workgroup created, protected the forms,queries, and report, but I am unable to protect the tables	10/15/2008
Q: I have created a workgroup, I protected the forms,queries, and report, but I am unable to protect ... A: I'm assuming you have split your MDB into front-end and back-end. Let your back-end have only the ...
Access 2007 - reports	10/15/2008
Q: have a report I have used before but now cannot see theproperties when I click on a fiel. ... A: Since this is Access 2007, tell me if your clicking on the field while your viewing the report or is ...
Date picker in MS Access 2007	10/14/2008
Q: How can we pick time with date using date picker control? A: -You need to specify your date field as a Data Type (DATE/TIME) in your table structure. -On your ...
DBmaker	10/14/2008
Q: i want to ask if u have any knowledge about DBMaker and is it a compatitor for other db programs ... A: The company being established since 1992 has done well with some Cobol based customers. COBOL ...
Auto Populate MS Access Intersection Table	10/13/2008
Q: I have a many-to-many relationship between two entities and hence in Access it means I have an ... A: Basically I can feel that your schema construction is wrong, because if you create the links using ...
my question	10/13/2008
Q: i dont save the data, after inserting data in the MS Access table,when i close the table there is no ... A: Usually when one enters data in a New Table and exits, MSAccess will ask whether you want to save ...
Access Stock Control Question	10/12/2008
Q: I have designed a stock control system using action queries and macros (I have VERY limited VB ... A: I feel you must stop writing the Bible immediately. Look at your question --> "I need it to alert if ...
my question	10/12/2008
Q: i dont save the data, after inserting data in the MS Access table,when i close the table there is no ... A: I'm totally confused with your statement. You need to provide me more information. You say you ...
Multi value from a list box	10/10/2008
Q: I have a table called Type with several records. I want to create a form with this table as a ... A: Drop me an email on aqantassoftware@rediffmail.com, I need to send you code along with a screen shot ...
Macro sending out an email in Access	10/10/2008
Q: I was wondering if you could help me with a problem that I'm having in Access. I'm using a data ... A: I see you have an internal workflow application project running. Please do not use the Data Access ...
ms access date sortin in report	10/10/2008
Q: i have formated full date field of a table in to months by using the format function in query to ... A: Infact if you could have directly used this date field on your report by using the simple report ...
Prompt...	10/9/2008
Q: I am creating a database to hold information for all my employees. There is one field in particular ... A: NO Nigel, don't create an additional field. Instead I would suggest you to create a query with a ...
Mass Email Shot & Creation of an individual log for each email sent.	10/9/2008
Q: I have some code which when run sends an email to all records in the current form that have an email ... A: I feel since the code belongs to someone else you should stick to his table structure. Or else ...
Mass Email Shot & Creation of an individual log for each email sent.	10/8/2008
Q: I have some code which when run sends an email to all records in the current form that have an email ... A: I feel its a bad practise maintaining a LOG in a NOTEPAD, because a notepad is a plain ASCII TEXT ...
problem with DELETE Query in MS ACCESS	10/8/2008
Q: I might be asking you a basic question though iam sorry but i never worked with Ms Access.. I am ... A: Please check if the datatype is Boolean for this condition check "[IsActive]=0" and also if the ...
Access 2007	10/7/2008
Q: Cntd... Thanks for yor quick response. The application form must have the fields like Reason, ID#, ... A: I will design this program for you in MS-Access 2003 starting tommorrow since I'm extremely busy ...
Access 2007	10/7/2008
Q: Cntd... Thanks for yor quick response. The application form must have the fields like Reason, ID#, ... A: You seem to have deleted the previous dialog we had on this request. It's difficult for me to track ...
asking for query	10/6/2008
Q: sir, what is the query for Occurrence in ms-access. ANSWER: Hi Deo Kant, I need more information ... A: I'm surprised that you have numbers stored in a Text Field. This should have been a Numeric field ...
MRP Inventory Turns	10/6/2008
Q: I'm using access to calculate inventory turns and want to make my report public using a form. The ... A: I feel you need to construct a Parameterized Query. In the field where you specify fixed value of ...
Forms issue	10/5/2008
Q: I have a form(expenses) with a field called 'total expense'.There is another form(Approval) which ... A: You need to use the Dlookup() function. You can use the DLookup function to display the value of a ...
msacceess - vb.net	10/5/2008
Q: see my backend is ms access,front end vb.net windows form.and i am inserting record to my database ... A: I appreciate you contacting me on this, but to bring to your notice this part of the expert zone is ...
Query From a Table	10/3/2008
Q: I have a table which I have a form operating as a search page. I want to have a column that is ... A: As a software engineer I would look at it this way: It's like having a Supplier list and when you ...
audit trail assistance	10/3/2008
Q: . i realised yesterday after a day of endless debugging with no success that the allen browne ... A: You should stop writing the Bible immediately. All you need to do is write a simple Append Query. ...
asking for query	10/3/2008
Q: sir, what is the query for Occurrence in ms-access. ANSWER: Hi Deo Kant, I need more information ... A: First of all you will need to construct a Grouped Query using the MAX function on the field who's ...
Access 2007	10/2/2008
Q: I want to create a database for the employee sick leave approvals in an organization with around 50 ... A: Surely I will help you, let me know the different fields you choose to have in your Leave Approval ...
access 2007 expressions	10/2/2008
Q: I have access 2007. I have set up a table, a query on the table and am trying to write a report. In ... A: If your database isnt confidential, is there a possibility you can send it to me via email on ...
Access 2007-Sharepoint	10/1/2008
Q: I am having an Access Database built. There will be 8 office staff employees that will have Access ... A: I'm afraid in your case you may have to either publish your Access 2007 forms on SharePoint to be ...
Update Query	10/1/2008
Q: This is a SQL View of an update query that i created. Could you please help me convert this query to ... A: What you need to do is have both the queries entered one after the other. Example: ...
Refreshing data in Select query	9/30/2008
Q: I have 2 queries in my database. The query names are qry_webclass and qry_Webclass_TI. Both the ... A: I actually do not have any idea what fields each query has selected for you to display. I feel you ...
Update Query	9/30/2008
Q: This is a SQL View of an update query that i created. Could you please help me convert this query to ... A: I'm confused when you say you want to convert this query, the SQL looks fine to me. Tell me what ...
Access 2007-Sharepoint	9/30/2008
Q: I am having an Access Database built. There will be 8 office staff employees that will have Access ... A: The first thing we need to address is, How REMOTE are my users going to be ? - Will they be in the ...
Querying for count of days	9/29/2008
Q: I have a report I am working on which is in the form of a letter, I need to generate letters that ... A: Try the following: =DateDiff("d",Now()+30,[DueDate])-60 For example assuming it takes ten days to ...
Date add	9/29/2008
Q: I have a form created in a ms access 2000 database. There are 3 fields, Probation Period Start ... A: You need to use the DateAdd() Function to perform your calculations. Syntax DateAdd(interval, ...
Runtime error: 438	9/28/2008
Q: My question is : I have form (with a subform) with a bound-control (on the main form) -memo field. ... A: I'm a bit confused when u mentioned that your Main form and subform are bound with a Memo field. Pls ...
Not to sort the table	9/26/2008
Q: Entered text in a table. Two C, Two West, Third, Fourth, Fifth, Sixth, Seventh, Kitchen, ... A: I cannot visualize what your table properties are but this can be done in a slightly different ...
Duplicate Dependency question	9/25/2008
Q: Microsoft Access 2003. Medium-Level Access user. I have a database with ID#'s, names connected to ... A: Since you haven't provided your identity I don't know how to address you. Anyway do the following ...
How to compact MS Access 2003 via VBA (Not at the end)	9/24/2008
Q: I have a MS Access database utility in which I’m linking some tables via ODBC and creating two ... A: I'm afraid Access will not allow you to compact a running database. We can do activities such as ...
Ms Access 2007 - Subforms	9/24/2008
Q: I have a form "frmOrders" and a subform "sfmOrderdetails" The subform is displayed in datasheetview. ... A: You cannot assign a form color to forms in datasheet view, but I'm surprised why you cannot see ...
Preventing copy of database	9/24/2008
Q: I created a user group, and I am trying to set it up where no one can import the files into another ... A: You need to flag your users with a read-only permission and also disable the check box to modify the ...
Access 2007	9/23/2008
Q: In access 2000 I was able to do a dialogue pop up to ask me for begin and end dates for any report I ... A: I don't think anything has changed at that level. The only thing which irritates is the new Menu ...
check box	9/23/2008
Q: I have an Access database that uses the code shown below. When a date is entered and either the 3 ... A: "a date is entered and either the 3 month, 6 month or 12 month box is checked the calculation is ...
MS Access : Make copy of Desigmaster	9/22/2008
Q: How do i create a new copy of a Design Master in Access 2007? I want to make an exact copy of ... A: You can choose any of these methods =================================== Method 1 (Any Access Ver) ...
Filtering MS records displayed in a Listbox using a Combobox	9/22/2008
Q: I'm pretty good with VBA but not so much with the SQL statements and I'm having a problem. I have a ... A: Your problem lies with a Cascaded object refresh issue. You need to perform a REQUERY action in ...
Help - sort names into 5 columns on a report	9/20/2008
Q: I am trying to put the names of individuals into sections on report and have this output in 5 ... A: ("Is there a way to select only certain members of a section to print within the report?") - The ...
msaccess2003	9/19/2008
Q: If choosing the student no through combo box their detail should be displayed or through report.How ... A: Your combo box containing the student no list should also have a unique identification code. Based ...
Filtering MS records displayed in a Listbox using a Combobox	9/19/2008
Q: I'm pretty good with VBA but not so much with the SQL statements and I'm having a problem. I have a ... A: Your problem lies in the Bound Column area. You need to check which field your combo box is bound to ...
Expression	9/18/2008
Q: Example, i have a field "Sent Date", then i want set default of my field "Expected Return Date" as 6 ... A: Your syntax should be the following: [Expected Return Date] =DateAdd("d",6,[SentDate]) Pls Note: ...
opening an excel spreadsheet in ms access	9/17/2008
Q: i am working with a query in ms access. my task is to copy and paste a few records from the query to ... A: Do the following: - Run your query to view the query results - You will see an Office Links icon on ...
How to Control data entry in forms	9/16/2008
Q: I'm creating a club membership database in MS Access 2003. The members' spouse's and children's name ... A: Your syntax: if [NumberOfChildren] =1 then [Child1Name].fieldname.visible = true ...
find date by using define coloum name in single table	9/16/2008
Q: can we find the date diff in Ms access by using the define coloum entry in a single table.using Ms ... A: Date Add Syntax --------------- DateAdd(interval, number, date) interval Required String ...
find date by using define coloum name in single table	9/15/2008
Q: can we find the date diff in Ms access by using the define coloum entry in a single table.using Ms ... A: Yes we can find the date diff in MS-Access but on a query,form and report level, let me know the ...
combining multiple access tables	9/15/2008
Q: I have a (I think) very simple* in Access, I have about 20 tables with similar layout. * I want to ... A: You need to combine them together using a UNION query, you cannot join multiple tables into one. You ...
How to Control data entry in forms	9/15/2008
Q: I'm creating a club membership database in MS Access 2003. The members' spouse's and children's name ... A: It's a game of Hide & Seek. You need to decide how many children your customer can have if your in ...
Last Date in Access 2000	9/14/2008
Q: ,, For Access 2000, I would like to know the last date in "Date" field. How do i know that?? ... A: The DMAX will calculate and show you the highest value in the query field. But what about the sort ...
Access 2007	9/11/2008
Q: I want to create a database for the employee sick leave approvals in a library with around 50 to 60 ... A: If your organization is a mid-sized one having an internal server hosting a Windows 2003/2008 Server ...
Combo boxes	9/11/2008
Q: i have two forms the first one "frmClientSearch" has a combo box and a search button , when the user ... A: "when i search i only get the results of the first ID " - Results are filtered and based on the ...
Drag and Drop PDF file from Outlook into MS Access	9/11/2008
Q: I saw you had a similar questions hence I thought I would ask you for a solution or guidance to my ... A: I cannot promise you about the Drag n Drop feature of a PDF or any file, but YES if you can send me ...
Access 2007	9/10/2008
Q: I'm new to access 2007 and to databases in general. As a start, I created several trial databases ... A: Deleting your database[s] ========================= -You cannot delete a database from within ...
query for CM & YTD	9/10/2008
Q: Manish, Thank you in advance for taking my question. I am using Access 2003 to build a query ... A: Create a union query (union query: A query that uses the UNION operator to combine the results of ...
DateAdd	9/10/2008
Q: ) I never attempted to actually make the DateAdd work in my previous database as I have been ... A: I guess u have been looking for the Object reference in the wrong place. Tell me something: - Is ...
DateAdd	9/9/2008
Q: It wont let me ask a follow up question, im sorry I know I just keep having problems with this, ive ... A: No problem, your a lady and I respect the fact that your trying so hard to get it working, I will be ...
DateAdd	9/9/2008
Q: Im stuck on a DateAdd expression. I am creating a database on mushroom growing and I want the ... A: The expression is wrong, because you cannot refer to a table when your validating some value which ...
Combine Access 500 files to 1 file	9/7/2008
Q: Please help me to solve this problem. I have 500 access files which have each only 1 table and same ... A: I feel you must divide the import process into 2 half. You should consider the following : - Open ...
Combine Access 500 files to 1 file	9/7/2008
Q: Please help me to solve this problem. I have 500 access files which have each only 1 table and same ... A: The name "Files" has a big scope, a .mdb is a file and within it is a collection of tables, ...
A small database	9/7/2008
Q: Would you please tell me how to design a database as bellow? 1- save personal information of ... A: I would love to help on this issue, but this is as good as developing an entire application from ...
Using MS Access	9/6/2008
Q: I now have MS Access 2003. Is there a way to make an .EXE file from an Access application that I ... A: This has been a dream of every MS-Access Proff in the market today, but the sad thing is that we ...
criteria	9/5/2008
Q: I want to find a table entry with two criteria and edit a field at the same entry. For this I use ... A: The datatype for the underlying field [HemProNo] should be numeric if its a non-aphunumeric value, ...
insert data into table	9/5/2008
Q: i have created a table named student with two fields NAME AND ROLLNO. then i created a form with two ... A: Your code should be as below: Private Sub cmdSave_Click() On Error GoTo Err_cmdSave_Click ...
Return record greater then 30 days, but less then 60	9/5/2008
Q: I have a date field which is manually entered. I am taking this field and adding 3 months to it. ... A: You can use the DateDiff function to determine how many specified time intervals exist between two ...
DateAdd	9/4/2008
Q: Im stuck on a DateAdd expression. I am creating a database on mushroom growing and I want the ... A: The On GotFocus event is in your form where the [ExpectedPickDt] field exists. - Right Click on the ...
Required Property	9/4/2008
Q: "I have created a database to enter the marks of students I have set the default value to 0 and ... A: I assume you have set the default value property at the form interface level. Pls set the default ...
DateAdd	9/4/2008
Q: Im stuck on a DateAdd expression. I am creating a database on mushroom growing and I want the ... A: Date Add Syntax is as below: DateAdd(interval, number, date) The interval argument has these ...
How to run simple select statement using vba	9/3/2008
Q: I want to run simple "Select * from Tablename" statement using vba not by using design query ... A: Do the following on the OnClick of your command button. Create a subroutine() Dim strSQL as string ...
importing form	9/3/2008
Q: I have another question I am hoping you can help with. I have a database that is converted to an mde ... A: I guess you won't be able to perform that operation, because when any .mdb is converted to a .mde ...
Vista and graphs	9/3/2008
Q: I updated to Vista 64 bit and imported my access03 db. Unfortunately, my charts and graphs come up ... A: I'm confused when you say its working in XP and not Vista, would like to know which version of ...
Access Query	9/2/2008
Q: I need to create a query that will display the reults of two fields from two different tables that ... A: In order to view results of two fields from two different tables, you need to have one common field ...
Access in network	9/1/2008
Q: I've already developed a VB.net application with ms access as backend locally i.e. not in a network. ... A: If you have VB(any Version) as your front-end to Access, it won't degrade your performance. Infact ...
Vista and graphs	9/1/2008
Q: I updated to Vista 64 bit and imported my access03 db. Unfortunately, my charts and graphs come up ... A: One usually gets a blank graph screen when either there's no data, or if the printer to which the ...
password protect queries	8/31/2008
Q: ver 03 Hi Manish: Thanks in advance for any help. Your time and expertise are much appreciated. I ... A: That's a piece of Cake, do the following: - Open your database in design mode - Select Tools - ...
password protect queries	8/31/2008
Q: ver 03 Hi Manish: Thanks in advance for any help. Your time and expertise are much appreciated. I ... A: ************** I want to password protect the queries of a db where the user can open forms and edit ...
iff statement	8/29/2008
Q: I have fabric table which contain four 4 fabric name that are alcatraz, alexis, canvas, stretch ... A: You should do the following: - ...
VB Script Issue	8/29/2008
Q: I am trying to switch to another database using the script below. The problem is that unless the ... A: ************* sFilter = "Microsoft Access (.mdb)" & Chr(0) & ".mdb" & Chr(0) & _ "All ...
Access in network	8/29/2008
Q: I've already developed a VB.net application with ms access as backend locally i.e. not in a network. ... A: Don't ever make a mistake of putting one single .mdb file on the server and having the user's load ...
Access 2007	8/28/2008
Q: I am trying to make my database (access 2007) password protected and can you please help me how do i ... A: The encryption tool in Office Access 2007 combines and improves on two older tools — encoding and ...
MS Access	8/27/2008
Q: I have a problem opening the database. When i try to open, it gives me an error saying "The 'Close' ... A: I need more info to get to the bottom of this situation. -Please open the database in design mode ...
Reports	8/27/2008
Q: I have a difficullty in pulling out a report.The summary column is missing which used to be working ... A: Were you sure that your summary column did display in the first place ? If it did, then it may not ...
Phone format for DAP	8/27/2008
Q: I have an input mask for a Phone field as !\(999") "000\-0000;0; format. Works fine in a form, but ... A: When you specify DAP, do u mean Data Access Project ? If it is then your back-end is SQL-Server. ...
Changing the report caption	8/26/2008
Q: I have a table and I'm making a report with this table, but I want to put a field name in the report ... A: I guess this will not be possible if you have multiple values in your report. The report will not ...
Using query in access	8/26/2008
Q: I face a difficulty in using query in access. In my case, for example, there are two queries A and ... A: I see your problem is with the JOIN TYPES between both the Queries A and B. Make sure your JOIN ...
subforms	8/26/2008
Q: how do i make this formula work in a subform where [XXXXX ID] is in a subform and [temp XXXX ID] is ... A: Will appreciate if you can elaborate your question more clearly. I would like to know the form, the ...
Microsoft Access 2007	8/25/2008
Q: I am new at Microsoft Access 2007. I have around 121,000 invoices that I would like to setup an ... A: In order to create an Ageing report for 5 different slabs you need to create 5 different queries ...
Use case diagrams	8/25/2008
Q: we are doing a project where we are asked to draw the use case diagram. are we supposed to include ... A: Your question seems incomplete, I would like to know which area are you really trying to address ...
Alerts	8/24/2008
Q: i have created a small databases of two tables, one with personal details and the other with ... A: Yes I remember you, its been a while....lol Ok here we go: Question 1:A way of me editing the ...
sql query help	8/23/2008
Q: Sir, I am doing a project of Multi-Level marketing website using ASP and MS-Access. There is a ... A: Check out this example: *********************** SELECT City, CompanyName, ContactName, "Customers" ...
sql query help	8/23/2008
Q: Sir, I am doing a project of Multi-Level marketing website using ASP and MS-Access. There is a ... A: Try constructing a UNION Qeury, this will bring together data from Ref_id and Mem_Id together in a ...
Multi-Purpose Database	8/22/2008
Q: I am attempting to design a database for my job with multiple users who use the same information but ... A: This monster will bring great accolades to your career if implemented properly. Cause it has to me. ...
Access Backend Security	8/22/2008
Q: I was in need of securing the backend data. Currently, the front end security is developed through ... A: Check this out **************************************** Dim ws As WorkSpace Dim db As Database ...
drag and drop xls, word, and pdf files into list box.	8/22/2008
Q: I would like to give my users the possibility to drag and drop files into a list box on my ... A: I have a .mdb file reqarding Access Drag n Drop in my office computer. I hope its still there, I ...
security	8/22/2008
Q: The requirement is we have a form and it has some options to select,each would lead to another ... A: Do the following: - Hide the subform on your form by making its propert visible = false - Create a ...
Access Backend Security	8/21/2008
Q: I was in need of securing the backend data. Currently, the front end security is developed through ... A: Do the following: - Disable the shift key combination to get into your backend .mdb - Hide all ...
drag and drop xls, word, and pdf files into list box.	8/21/2008
Q: I would like to give my users the possibility to drag and drop files into a list box on my ... A: Are these user's of your's real technical people, or else to cover up you can camouflage the entire ...
e-mail to access	8/21/2008
Q: Does this process exist in Outlook 2003? Importing Mail Messages from a Folder To import mail ... A: Your process sounds quite logical by keeping in mind the Outlook Model, but I don't take this road ...
drag and drop xls, word, and pdf files into list box.	8/20/2008
Q: I would like to give my users the possibility to drag and drop files into a list box on my ... A: Just to remind you this function is purely a Visual Basic function and this part of the site ...
Adding Multiple records in ACCESS	8/20/2008
Q: I have form(employee table) and a subform (employee discussions table) in a one to many ... A: One way of doing this is by creating a Command Button on your form which can duplicate your previous ...
Update Query	8/19/2008
Q: Manish, Thanks for being with All Experts. My question is: I have two tables : Table A, Table B ... A: Hey No MR.--> Just Manish. I'm a very casual person. I assume that your Total query is based on ...
Using a non-Access front-end in a MS Access db	8/18/2008
Q: I have a MS Access(2003) db of Customers. I want to make it available to multi-users, which I found ... A: You can use the most common method which is a Spreadsheet. But remember this will be an indirect ...
query based on multiple tables	8/18/2008
Q: I want a summary report that gathers fields values from 10 tables, the links between those being an ... A: Do the following: - As you said u have created this little queries, then all you need to do in ...
Access forms-2007	8/18/2008
Q: I have two combo boxes namely "liability" and "limits" in my form.I have to display the values that ... A: As you mentioned the values which u need to put in a LABEL (I assume that this is a field in your ...
Access forms-2007	8/18/2008
Q: I have two combo boxes namely "liability" and "limits" in my form.I have to display the values that ... A: " have two combo boxes namely "liability" and "limits" in my form.I have to display the values that ...
Report based on query form	8/16/2008
Q: Sir, I have a combo box based on Inst table in the query form. How to generate a report based on the ... A: I assume you have a combo box on your form, which derives its information from a query called ...
Using functions in a form	8/15/2008
Q: I have 20 questions that I am rating in the form but can't figure out how use average function in ... A: Modi, You need to have a Master/Detail form to calculate your Average for the questions which you ...
bound forms	8/14/2008
Q: Good Morning Manish, I have a bound form with a combo box using as a list to add to a form. I would ... A: As per your question " would like a way the user can not type anything in in this box and only ...
bound forms	8/14/2008
Q: Good Morning Manish, I have a bound form with a combo box using as a list to add to a form. I would ... A: Do the following: - Right Click on the combo box - Go to Properties - Go to Data - Select property ...
MS-Access and Business Cards	8/13/2008
Q: Manish, it MS-Access a good way to handle tracking business cards from salesmen. I have alot of ... A: Welcome Yes MS-Access is a good way to handle Tracking Business Cards from Salesmen. Infact there ...
MS Access 2003	8/13/2008
Q: I have table called s_sessions and fields session_stime and session_etime both fields datatype is ... A: You need to apply a parameter with the between function or ">= or <=" equations. e.g.: ...
Microsoft Access Forms	8/12/2008
Q: How do I change the control source connected to a field in a form to another table or form's field. ... A: Is your 2nd form a subform on your first form, if yes then you can set a direct path or else you ...
A report showing first, second and third choices:	8/12/2008
Q: I need to build a report to show student choices for work experience at our school. employers ... A: I'm focusing on your question as below : "My question is this, is it possible to produce a report ...
adding to a lookup tables	8/11/2008
Q: I have designed a database with a form that enables you to look up information from different ... A: There are different types of forms to look up and view information. Which type of form are you ...
send the view of an Access pivot table to e-mail	8/8/2008
Q: Is it possible to send the view of an Access pivot table (form, pivot-view) out to e-mail recipients ... A: Yes its possible, You can use a macro to preview the pivot table and then export it to a .PDF or a ...
Rounding minutes	8/7/2008
Q: How do I round a calculation of hours and minutes to the nearest 25 minutes (i.e. quarter of an ... A: Your looking at time calculations like numeric calculations which shouldn't be the case. The field ...
Access 2003, querying information from a field created in a query	8/6/2008
Q: Access 2003, querying information from a field created in a query I recently submitted a question ... A: Note: The format of the return value for DateAdd is determined by Control Panel settings, not by ...
Access 2003 - query a date from a field creating in a query	8/6/2008
Q: I have created a report, and in this report I create a query and added a field which do a date ... A: I feel you should add the 6 months in advance in your query field and have only the result displayed ...
subtracting adjacent rows	8/5/2008
Q: I have a query which contains readings from a water meter like so: Time Stamp Meter ... A: In order for your listbox to display the subtracted reading values it needs to be based on a query. ...
Creating New records froma single form	8/5/2008
Q: I'm using a very simple form in Frontpage to write to a database (Access 2007). I want colleagues to ... A: The only way I see this is by using a subform in your main form. But still u may have to break some ...
Rounding minutes	8/5/2008
Q: How do I round a calculation of hours and minutes to the nearest 25 minutes (i.e. quarter of an ... A: Round function returns a number rounded to a specified number of decimal places. Syntax ...
Access IF or code	8/5/2008
Q: I have a database built on Access 2.0 code (I know it's old, but it works :)). I have two fields, ... A: I look at your question from "I want to pull only results that have the same name in both fields" ...
Using forms to input fields of a query	8/4/2008
Q: Hai, I am using MS Access 2002 and i am using it as both front/back end. I want to add a list box ... A: Hey,...lol. InvoiceNo is the field I choosed to use in my query depending on my situation. You will ...
Auto populate	8/4/2008
Q: I am trying to auto populate one field from another field. For example, if I put TX in the state ... A: Let me assume that you have 2 Combo boxes, Combo1 and Combo2. We need to automatically populate the ...
Auto fill data in form	8/4/2008
Q: Good afternoon, I currently update an access database in 2003 that contain data used in other ... A: You need to have a requery code which requery's data in another combo on the On AfterUpdate Event. ...
Import an excel sheet using a form	8/4/2008
Q: I need to create a form where you should be able to import an existing excel sheet into an existing ... A: If you want to import an existing excel sheet into a database table using a form, you need to decide ...
ACCESS 2003 question	8/3/2008
Q: i am working on a database which includes personal profiles of staff members . being an engineering ... A: Now()function is mostly used to calculate date on time factors. What I normally use in my follow-up ...
Using forms to input fields of a query	8/3/2008
Q: Hai, I am using MS Access 2002 and i am using it as both front/back end. I want to add a list box ... A: Copy paste the below VBA code to a notepad to get full view. Go through it carefully and relate your ...
Using forms to input fields of a query	8/1/2008
Q: Hai, I am using MS Access 2002 and i am using it as both front/back end. I want to add a list box ... A: In your scenario you need to have a MultiSelect List box. This will solve your problems. A ...
Graphs in Access and Excel	8/1/2008
Q: Access 2002 I am doing up a list of people who have stayed at a resort and wish to make a graph/ ... A: Graphs have properties of values which are formed on an X and a Y axis. You need to visualize which ...
Converting feature in Access 2007	7/31/2008
Q: I had Access 2000 and just bought Access 2007. I imported data from an ASCII file. One of the fields ... A: You probably may need to create a new field in your table. You need to write an update query to ...
ACCESS 2003 question	7/31/2008
Q: i am working on a database which includes personal profiles of staff members . being an engineering ... A: Date alarms can be set when u have some kind of expiry date assigned to each of your training ...
Shared Dbase Error - MS Access 2003	7/31/2008
Q: I'm getting a shared error on my database. The database was designed for multiple users and we are ... A: When u say that the database was designed for multiple user, do u mean you are hosting one single ...
Using multiple queries in a report	7/31/2008
Q: I have created 3 queries that separate the orders of each sales associate in our company into 3 ... A: Sure I do have aloooooooot of suggestions for you. But you need to do me one more exercise. I need ...
How to connect to a protected Access database	7/31/2008
Q: I am doing an Access Application that has to connect to a Server database that is protected. The ... A: You can use startup options to control how a Microsoft Access file looks and behaves when it opens. ...
Access building	7/30/2008
Q: i am currently creating a parametric model using MS Access. i have the majority of my calculations ... A: Your question is related to some MRP application. Well it is possible to add an Option group to ...
Conversion to Text	7/30/2008
Q: Sir, I have made report. When I take print out, that is in the pdf format. With the help of this I ... A: I wonder why you wouldn't like to print the .PDF directly to the Dot Matrix printer. Is it a very ...
Disabling Design view	7/30/2008
Q: I've read that i can disable the design view by converting the database to ACCDE format. however ... A: Try to split your .accdb into a front-end and backend database. Then compact each .accdb at a time ...
reg:access report	7/29/2008
Q: In access 2003 pivot table view,how will choose different format report layout?The format report ... A: When you say report layout, do you mean the different styles of report for example..3D Bar, 3D ...
Significant Digits in Access	7/29/2008
Q: In Access 2003 I need to be able to display the correct number of significant digits displayed in a ... A: Storing numeric value has its drawbacks in calculations. In your case where u have multiple decimal ...
Locking columns	7/29/2008
Q: Is there a way to lock columns in a subform? I do not want the user to be able to tab any further ... A: Sorry for misunderstanding the question, I would like to know if your subform is displayed in a ...
Report format	7/29/2008
Q: Sir, I have a front end issue on Microsoft Access 2003. What I have done is created my table with ... A: What u would require is a Crosstab report, or rather a pivot table report would be very neat for you ...
How to insert ,update and delete quries r used by button click event	7/28/2008
Q: i hv exported one excel file in database whose table name is sheet1 so directly text boxes are ... A: As you said that your Excel spreadsheet is now a table, which u mean has been imported in Access(Not ...
Multiple Entry	7/28/2008
Q: I am making a simple project for warehouse. I am to take stock in, which I receive from different ... A: Cool now your a little clear. Make two forms, Master and Detailed. In Master form have these ...
Fill out a for from textbox	7/26/2008
Q: I wanted to fill a specific record in one of the fields on a subform from a textbox found on the ... A: Any field on your sub-form can be filled based on a input in a field in your main form. PROVIDED ...
Multiple If statements	7/25/2008
Q: I'm having trouble writing a multiple IIf statement in a query. Here are the conditions that I'm ... A: If your gonna have an "OR" statement in your IIF() statements, then I would advice you to split this ...
Access 2007 - Forms - Form View - Vertical Scroll Bar	7/25/2008
Q: I like to think of myself as pretty tech savvy, but when it came to Access '07 things began to ... A: So even you saw the nightmare which others did !!! This advice may sound astounding....Please use ...
Macro to open form with two where arguments	7/25/2008
Q: Using a macro on double-click in the list box to open another form with the Project Number and ... A: I want to know if youre trying to get the Project No and Project Extension field value from the ...
Parameter in Query	7/23/2008
Q: I have designed a query with multiple parameters to meet custom reporting for users. I have one ... A: I apologize for the delay. Yes/No field datatype stores their values in a form of boolean data ...
Multiple Answer Options	7/22/2008
Q: I am using Access 2003, writing a small database for a medical research project and I wanted to know ... A: I apologize for the late response, due to some unavoidable family issues. Use a multi-select list ...
Alerts	7/22/2008
Q: i have created a small databases of two tables, one with personal details and the other with ... A: No problem, youre not alone. In your queries date field criteria put the following parameter: ...
Alerts	7/21/2008
Q: i have created a small databases of two tables, one with personal details and the other with ... A: How I wish I could save my Access database as an .exe, it would be bliss. I think your mistaken it ...
Form/calculated fields	7/21/2008
Q: I created a form for data entry purposes. There are a few calculated fields. I was hoping that the ... A: I will need you to expand on the word "Populate" in your next mail. As I assume you have fields on ...
email sections of reports with MS Acces	7/21/2008
Q: I am working with a MS Access database and I need to send individual reports to many people. I want ... A: First you need to decide the sections of your report, you can have them all grouped together or on ...
Access 2003 SQL	7/18/2008
Q: I have a form with a drop-down box with several items. About five of the items, when selected will ... A: You need to reset the [Item] variable to null to let the system know that there isn't any value to ...
Option Group + Command Button	7/18/2008
Q: I have used the wizard to create the option group. It contains four reports. I want two command ... A: In order to select the type of report whether on Screen or on Printer, you need to open a form on ...
Btrieve into Yardi (MS SQL)	7/17/2008
Q: I didn't see a section for Btrieve here in the database area so I'm trying it here. I understand if ... A: Sure you can export your data from Btrieve to SQL-Server 7.0. If you have installed SQL-7.0 there ...
using access ,vb	7/17/2008
Q: I am doing the form design in access. I have connect the database and wrote the code for add new , ... A: Your form will be readonly if you do not have it bound to any underlying table or query. So make ...
Form AutoSum	7/16/2008
Q: I have a very big form with a section at the bottom that would work out much better for me if it did ... A: I'm happy its working, regarding the global sum issue this happens when you use the DSUM() function. ...
saving calculated data	7/15/2008
Q: I understand that saving calculated data is against best practices. But this is the only way I know ... A: Basically to store calculated data from a form to its underlying table, you need to create a field ...
Access Frontend/SQl Server Backend	7/15/2008
Q: I have an access database that has about 10 users. This database is strictly used as a front for SQL ... A: Happy to know your using Access as front-end to Sequel. - The limitations of 255 users for a Split ...
Querying on more than one field name	7/14/2008
Q: Manish! Advance thanks to you! I have created a table by name 'price_details_master' having three ... A: Hey there, Don't thank me, thank the one above. Anyway do the following 1-In either of your combo ...
VBA Code For Relationship	7/14/2008
Q: I am importing data from system generated text files into two table and one table is created ... A: I feel when you import data into your first table from your system generated text file, you need to ...
MS Access Date difference query	7/13/2008
Q: I want to count months between If construction completion date is null then count no of months ... A: I feel you may need to write an IIF() function nested with your expressions. Try this example. ...
Calculation in MS Access forms	7/13/2008
Q: Sir, Suppose I created two tables in MS Access One is the master table with the following ... A: This is possible. What u need to do is the following: 1.Create a field on your subform footer ...
Access 2007	7/12/2008
Q: I have a form that has some combo boxes and also some check boxes. What I need is when the user ... A: Pls do the following: 1-First disable all your combo boxes which u want to enable on the Checkbox ...
Access Query Using Dates	7/11/2008
Q: I have a db that tracks tenants in a building. Each tenant has to be surveyed for their electrical ... A: -You will need to have all these fields in your query, -You need to set a date filter in your date ...
asp update	7/11/2008
Q: I can't get the update statement to work, can u please help thanks. <% sSQL = "SELECT * FROM Detail ... A: The objectives to this question aren't clear enough for me to understand what u would like to ...
ring alarm bell on data entry error	7/10/2008
Q: How does one ring the computer's alarm bell or have the computer make some sound when a data input ... A: Sound alerts are integrated with the Windows Sound Theme. e.g. when u get an error message an error ...
Validation Problem	7/10/2008
Q: In Ms-Access From , I made one query and use text box in creteria field. text box has value which ... A: Make sure u check for a valid input at the text box level itself by either using a default value or ...
DMax then increment	7/9/2008
Q: Manish, Thank you for volunteering your time to answer questions. I am using Access 2003 (v.11) ... A: I cannot identify the line where you are closing the if()-Endif() loop. Anyway just b4 u close this ...
link form to report	7/9/2008
Q: i have designed a form.added a button which on click enter parameter, the report is opened which is ... A: What you can do is change the recordsource of your reports underlying query to a new query with the ...
Locking columns	7/9/2008
Q: Is there a way to lock columns in a subform? I do not want the user to be able to tab any further ... A: Ofcourse there is a method of doing that. Select all the fields in your subform which u don't want ...
if-then-else syntax error	7/9/2008
Q: I keep receiving a syntax error for the following code: Option Compare Database If [Program] = ... A: I need a broader perspective on this issue as to why you are trying to evalute something which does ...

All Questions in This Category