You are here:

Using MS Access/Questions Answered by Expert Manish Batola

SubjectDate Asked
equestion in access 20071/4/2012
  Q: i want to know how to make this operation in access 2007 (startdate + durationday) = end date for ...
  A: AssSalamwalaykum Shaymaa, You need to use the DateAdd() function to get the result you have in your ...
update query10/3/2011
  Q: I am trying to convert this line to a update query: SELECT Purchasing.PurchaseNo, ...
  A: It has to do with the YYYYMMDD date format of your data. You might try YYYY-MM-DD or MM/DD/YYYY ...
Basketball database help2/12/2011
  Q: I've included a screen capture of the relationships in my database at the bottom of this post. What ...
  A: You're attached image on the link provided seems to have been moved or deleted, due to which I ...
Access 2007 error in using text criteria2/6/2011
  Q: DSum("[DPrice]","[tblPInfo]","[DName]=Helen'') The above expression is what I am using in a text ...
  A: Your syntax should be =DSum("[DPrice]","tblPInfo","[DName]='Helen'" Check out this link for help on ...
Split .mdb file2/1/2011
  Q: I have designed a School Management Software. Now I want to do: Whenever a .accdb file become ...
  A: -Whenever a .accdb file become greater than 10GB (in size) ?? First of all no .mdb or .accdb file ...
Monthly Reporting Tool Using Access1/23/2011
  Q: We need help with MS Access. The Need: We would like to develop a tool to track and monitor ...
  A: Sorry for the delay. I'm amuzed why you have a separate table called "tblReport" and "RepMonth" ...
program that can fetch data from webpages1/22/2011
  Q: I am trying to build a program in MS access or excel (2007) that can fetch desired data from ...
  A: This won't be directly possible since the Directory Database will restrict you. What you can do is ...
List Box to update table11/10/2010
  Q: I have a form with a list box of all employees. I also have a text box where the user will enter a ...
  A: This won't be possible with your approach. Infact you need to look at your problem from a slightly ...
'File Integrity Violated'11/8/2010
  Q: Whenever I try to move or copy a file from one place to another an error message comes 'File ...
  A: What kind of file are you trying to copy. Is it the front-end or are you moving an entire back-end ...
MS Access Quarters11/4/2010
  Q: I need your expert help. I am setting up a table where I need to add balances for 12 Quarters. I ...
  A: Creating a table with Generic fields isn't advisable for dynamic content[s] such as yours. Your ...
Access Asset Template Question11/1/2010
  Q: I have few questions regarding the template provided by access 2007 called Assets. In the form ...
  A: o When I type in text and hit enter. The list datasheet will refresh. How did they do that? - Well ...
sequential numbering8/1/2010
  Q: I am developing a database for my school with ms access but i don't know how to automatically assign ...
  A: You need elaborate more on your request. "how to automatically assign the positions of every class ...
Missing SetValue Macro Action4/1/2010
  Q: Sir I am using MS Access 2007. In Macro action I want to use SetValue action which is not present ...
  A: Sorry for the delayed reply. Infact MSAccess 2007 doesn't support setvalue anymore because of the ...
MS Access12/1/2009
  Q: I have installed a software. in installation the setup created a MS Access ldb file from which the ...
  A: As soon as MS-Acccess.MDB file is loaded along with it an .LDB file with the same name gets opened. ...
HELP ON ACCESS6/30/2009
  Q: Am Femi Adeoye,I needs your help on this question.I have 4 entities e.g ENTITY A,ENTITY B,ENTITY C ...
  A: -You can create a form each having a table as the forms backend (Entity A, Entity B, Entity C, ...
Display best result according to parameter input in query4/9/2009
  Q: Version: Access 2003 Topic: Query Design Hi, I am trying to make a query that prompts the user ...
  A: The query will display results but will they really be best all depends on the data in your ...
combo box in ms access 20034/8/2009
  Q: manish. thank you for taking the time to look at this question. i am having issues with combo boxes ...
  A: Infact I'm not to clear which values you change and where. I assume that once data in the combo box ...
Line in Report4/7/2009
  Q: I have a report, i have to draw horiz. and verti. line AFTER DETAILS SECTION, upto end where i put ...
  A: You need to create a Group on any of your fields with a Header and a Footer. You need to then place ...
MS Access 2000 tab control multipage form4/5/2009
  Q: This must be a stupid question as I have not been able to find a reference to it in several weeks of ...
  A: Your question just ain't stupid, its logical cause I faced the same situation in 1999. Anyway what ...
Access Make Table Update4/3/2009
  Q: I am using MS 2003. This part of the database will be in the Backend once I split it out. I ...
  A: You may need to use an update query concept which is used similarly in a Mobile Phone with an ...
Recipe database4/2/2009
  Q: I am doing recipe database. My problem is I have Recipe table consists of RecipeID, Recipe Name, ...
  A: U can deal with 7 subforms at a time in Access, all the relationships need to be re-specified when ...
Recipe database4/1/2009
  Q: I am doing recipe database. My problem is I have Recipe table consists of RecipeID, Recipe Name, ...
  A: I must comment that your from a beautiful country (Australia). Regarding your database, you must ...
MS Access 2003 Creating a form with input of ranges of data3/30/2009
  Q: I'm working in MS Access 2003. I have a query that was created from two tables and from a ...
  A: - You need to create a Single form having 2 subforms which will help you enter 2 sets of data. - ...
Frezing a field3/1/2009
  Q: What is the mesn by freezing a field in M S ACESS
  A: You can look at it from different views, -Freezing a field can also mean Locking it for modifying ...
combobox2/25/2009
  Q: my combobox is queried base on the year you input on a particular textbox. the problem is nothing ...
  A: sorry to mention but the entire process of fetching automated info is wrong and your question seems ...
Access Combo Box Wizard2/24/2009
  Q: I hope you can help me. I am using Access 2007 Enterprise edition. The problem is with Combo Box ...
  A: You need to base your form on a table instead of a query, cause Access assumes that you already are ...
Tracking of document lifetime2/23/2009
  Q: Manish. I've a question, my manager requested me to develop a small database where i can keep ...
  A: Your kind of application is known as a Workflow application. These features can be found in ...
Automated emails from access 20072/22/2009
  Q: l have created a database but l will need to know how to automatically send emails by concatenating ...
  A: I need to know what are the contents of your email, I assume its a report. -To send a report you can ...
survey count2/20/2009
  Q: i created two tables(tblClient and tblResult). tblClient is for a particular respondent and ...
  A: -You need to create separate tables to record your answer[s]for each category such as A1,A2 and A3 ...
Blank lines between addresses2/18/2009
  Q: I have a database with addresses. I send letters using the address information. My problem is some ...
  A: I'm assuming your report is based on a query which has the following fields as below: Name Title ...
saving a record before adding a new record2/17/2009
  Q: I have a print button, which is attached to a macro that opens a report, that report is based upon a ...
  A: Add this piece of code before your print command line : DoCmd.DoMenuItem acFormBar, acRecordsMenu, ...
datepart2/16/2009
  Q: I am trying to figure out the Week number that a patient has been in our facility. For example, if ...
  A: In a Medical Project it becomes very essential to identify your Working Calendar Schedule. Identify ...
Refreshing main form according to subform datasheet selection2/13/2009
  Q: I need to update a form based on the selection made in the datasheet. I have done it with a list ...
  A: "I need to update a form based on the selection made in the datasheet" As I see your datasheet in ...
Changing FontBold property on MouseMove2/9/2009
  Q: My question is how do i set the FontBold property of a command btn to True only when the ...
  A: Mouse Mouse Event can be programmed in several different methods for different objects. Pls refer ...
reg:data structure2/5/2009
  Q: what is the data structure used for memory reference in ms-acess
  A: Over the years, different versions of MS-Access have different methods of memory references to store ...
problem with insert into command in vba2/4/2009
  Q: I have a problem with insert into statement. I want to insert the user input details from an access ...
  A: I want to insert the user input details from an access form to external database which in access - ...
Line in Report upto Report Footer2/3/2009
  Q: . expert I have a report with page setup of A4 size, but sometime records are very few say 4 line ...
  A: BUT HOW TO GET VERTICAL LINES TILL THE END OF PAGE, WHEN FEW RECORDS ? - You need to insert your ...
limit text im memo field2/2/2009
  Q: I want to limit the amount of text that can be entered into a memo field to 2000 characters. Is ...
  A: I'm afraid you won't be able to do this in a memo field provided with MS-Access, but there ways of ...
Logon and Password Code1/29/2009
  Q: I've had some great help from you with my database in the past and now I'm hoping you can help me ...
  A: I help 100's of people everyday so I don't really remember who is who. Anyway thanks for trusting ...
Increase size of status bar1/28/2009
  Q: I have 20 questions in a form and everytime you select a question there is some help information I ...
  A: Similar problem was faced by one of the Computer Institutes in Asia, for their mini entrance ...
Queries not working properly1/27/2009
  Q: I have a database and various tables within. I have queries that will take data from one table, go ...
  A: It's very clear that the problem lies in your append query. For some reason it needs to be grouped ...
insert query1/26/2009
  Q: i created a button woth no help of a wizard. it worked out well until the save part, it doesn't save ...
  A: Why do you wish to use an SQL Insert into statement to store your values the other way around, when ...
removing record information from a non current source1/23/2009
  Q: hey, basically i have an emergency appointments table and a doctor can see each patients record per ...
  A: Your question seems pretty absurd to me or rather incomplete. For example.: i have an emergency ...
continuous dependent combo box1/21/2009
  Q: I have a problem on the Synchronized Combo Boxes on the continuous form. The problem is the unit ...
  A: I feel your problem is with the Dlookup function if your using one there, if no check for help on ...
how to link database to a webpage1/20/2009
  Q: I am new beginner to database design and i would like to know how to open a webpage from a form in ...
  A: There's no requirement for writing a script or code to perform such a task. What you need to do is ...
Loss of Data in Access1/19/2009
  Q: We have been using an access data base since 2000. From 200 up until Sept 2005 others entered data ...
  A: Probably you have restored a mix backup which contains forms and reports from two different sources. ...
Access Form data into Access Table1/17/2009
  Q: Hai I am having a form with 10 fields. In this ten 5 are already linked with table values. In one ...
  A: -Give some understandable names to your 10 fields on your form to remember the save sequence.e.g.: ...
queries in microsoft access 20031/16/2009
  Q: I need to run a query in access 2003 that will find a word in a group of words in a specific field ...
  A: As you mentioned earlier you needed to search for a word in a group of words, well you wont be able ...
Averages, VB6 and Access Database1/13/2009
  Q: I am working on Time-Frequency Convter tool. I need some help sorting out this challenge. I have ...
  A: It looks like you've invested alot of hardwork writing that kinda code to make things happen.I ...
Averages, VB6 and Access Database1/12/2009
  Q: I am working on Time-Frequency Convter tool. I need some help sorting out this challenge. I have ...
  A: Your first step should be a Data Cleanup process. Identify all the junk data which came from your ...
Creating entries for multiple records12/18/2008
  Q: Your previous answers on here have helped me develop my database, so I'm hoping you'll be able to ...
  A: Yes it is possible to create a new record in the GrpContacts table for each ClientID, you may need ...
Diary for Microsoft Access12/17/2008
  Q: Can you link an Access database to a diary? I want to be able to enter an appointment in the ...
  A: When you mean Diary, do you mean the appointment object in Microsoft Outlook. If it is then YES you ...
Access menu12/4/2008
  Q: In the former MS Access version 2003 i could easily create my own menu's (shortcuts) on the taskbar. ...
  A: I clearly understand your problem and the big goofup which Microsoft has made by disabling the menu ...
error message12/3/2008
  Q: A warning message appears when I click the 'Next' command button (Button to display next records)in ...
  A: This message usually popsup if some unbound field values are bound improperly to its backend table ...
Adding a record number to a List Box12/1/2008
  Q: I use Sccess 2003 to produce single user standalone desktop apps. I have what I think is a stupidly ...
  A: I usually have the autonumber primary key field from the table listed in chronological order which ...
i dont know where i can find the currency in microsoft access?11/29/2008
  Q: I dont know where i can find the currency in microsoft access in the database? please answer me
  A: All currency settings in Access are based on the default regional settings which you select in the ...
Parsing multiple criteria to an IN operator clause in a query11/28/2008
  Q: I have a query containing the expression: WHERE tblRMSLoad.PhaseDesc In([SeasonCode]) I need to be ...
  A: Extremely sorry for the late reply, I would suggest you to use the 'OR' / 'AND' operator within ...
Multiple users, 1 access file11/27/2008
  Q: Could anyone help me with the following: 1. could sevral useres use one access file on a server ...
  A: Don't worry about your English I don't see any problems with it. I appreciate you contacting me. ...
MS Access 2003 Define a variable11/25/2008
  Q: I have created a database for our preschool students for this year's enrolled students, as well as ...
  A: Extremely sorry for the late reply. Is there any way I can define to the database what the current ...
Text Query Criteria based on the Date11/24/2008
  Q: I have a list of location names. During the summer months, one of the locations isn't used. I want ...
  A: You need to separate the criteria on 2 expressions for 2 different fields to achieve this. - First ...
Ms Access11/20/2008
  Q: I have few questions about ms access which I need your expert advice. 1)I created my own user login ...
  A: 1)I created my own user login ( not the built in one). I store all the account information in 1 ...
Combining, grouping and calculting total11/19/2008
  Q: I have a database that i am trying to extract information. The database contains, Month, Department ...
  A: M, I would need more information to analyze your scenario carefully, as of now what I understand is ...
Filter a form10/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 sequence10/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 ...
Stock10/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 return10/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 ...
Stock10/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 form10/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 patterns10/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 records10/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 records10/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 dataBase10/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 tables10/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 - reports10/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 200710/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 ...
DBmaker10/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 Table10/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 question10/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 Question10/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 question10/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 box10/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 Access10/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 report10/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 ACCESS10/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 200710/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 200710/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 query10/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 Turns10/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 issue10/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.net10/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 Table10/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 assistance10/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 query10/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 200710/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 expressions10/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-Sharepoint10/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 Query10/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 query9/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 Query9/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-Sharepoint9/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 days9/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 add9/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: 4389/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 table9/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 question9/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 - Subforms9/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 database9/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 20079/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 box9/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 Desigmaster9/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 Combobox9/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 report9/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 ...
msaccess20039/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 Combobox9/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 ...
Expression9/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 access9/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 forms9/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 table9/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 table9/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 tables9/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 forms9/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 20009/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 20079/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 boxes9/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 Access9/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 20079/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 & YTD9/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 ...
DateAdd9/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 ...
DateAdd9/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 ...
DateAdd9/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 file9/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 file9/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 database9/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 Access9/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 ...
criteria9/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 table9/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 609/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 ...
DateAdd9/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 Property9/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 ...
DateAdd9/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 vba9/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 form9/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 graphs9/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 Query9/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 network9/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 graphs9/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 queries8/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 queries8/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 statement8/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 Issue8/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 network8/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 20078/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 Access8/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 ...
Reports8/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 DAP8/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 caption8/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 access8/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 ...
subforms8/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 20078/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 diagrams8/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 ...
Alerts8/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 help8/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 help8/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 Database8/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 Security8/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 ...
security8/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 Security8/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 access8/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 ACCESS8/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 Query8/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 db8/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 tables8/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-20078/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-20078/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 form8/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 form8/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 forms8/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 forms8/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 Cards8/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 20038/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 Forms8/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 tables8/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-mail8/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 minutes8/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 query8/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 query8/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 rows8/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 form8/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 minutes8/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 code8/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 query8/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 populate8/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 form8/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 form8/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 question8/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 query8/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 query8/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 Excel8/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 20077/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 question7/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 20037/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 report7/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 database7/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 building7/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 Text7/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 view7/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 report7/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 Access7/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 columns7/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 format7/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 event7/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 Entry7/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 textbox7/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 statements7/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 Bar7/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 arguments7/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 Query7/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 Options7/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 ...
Alerts7/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: ...
Alerts7/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 fields7/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 Acces7/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 SQL7/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 Button7/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 ,vb7/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 AutoSum7/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 data7/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 Backend7/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 name7/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 Relationship7/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 query7/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 forms7/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 20077/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 Dates7/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 update7/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 error7/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 Problem7/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 increment7/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 report7/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 columns7/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 error7/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

Using MS Access

All Answers


Answers by Expert:


Ask Experts

Volunteer


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),HSE-Health,Safety & Environmental Applications,School Management Systems,Hotel Software, Hospital Software,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, Industrial Strength Invoicing and many more being added every year.

Experience

26+ yrs in the Software industry with 19yrs completely dedicated on more than 300 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) • Logistics & 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 • Health,Safety & Environmental Applications • Mud Engineering • School Management Software

©2012 About.com, a part of The New York Times Company. All rights reserved.