You are here:
- Home
- Computing/Technology
- Business Software
- Using MS Access
Using MS Access/Questions Answered by Expert Manish Batola
| Subject | Date Asked |
| equestion in access 2007 | 1/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 query | 10/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 help | 2/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 criteria | 2/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 file | 2/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 Access | 1/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 webpages | 1/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 table | 11/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 Quarters | 11/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 Question | 11/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 numbering | 8/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 Action | 4/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 Access | 12/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 ACCESS | 6/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 query | 4/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 2003 | 4/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 Report | 4/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 form | 4/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 Update | 4/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 database | 4/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 database | 4/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 data | 3/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 field | 3/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 ... | |
| combobox | 2/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 Wizard | 2/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 lifetime | 2/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 2007 | 2/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 count | 2/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 addresses | 2/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 record | 2/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, ... | |
| datepart | 2/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 selection | 2/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 MouseMove | 2/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 structure | 2/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 vba | 2/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 Footer | 2/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 field | 2/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 Code | 1/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 bar | 1/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 properly | 1/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 query | 1/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 source | 1/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 box | 1/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 webpage | 1/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 Access | 1/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 Table | 1/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 2003 | 1/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 Database | 1/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 Database | 1/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 records | 12/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 Access | 12/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 menu | 12/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 message | 12/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 Box | 12/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 query | 11/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 file | 11/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 variable | 11/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 Date | 11/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 Access | 11/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 total | 11/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 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 ... | |
Using MS Access
Answers by Expert:
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.