You are here:
- Home
- Computing/Technology
- Business Software
- Using MS Access
Using MS Access/Questions Answered by Expert Ahmed Sayed Aziz
| Subject | Date Asked |
| event not firing on the text box in the form | 8/2/2010 |
| Q: on my form I have a date of manufacture text box and expiry date text box as soon as the user enters ... A: try to use LostFocus event instead AfterUpdate. To check if Update event is being fired or not write ... | |
| Access 2003: Autofill/Auto Populate fields | 3/16/2010 |
| Q: How do I autofill 1 field to auto populate in another field? ANSWER: i couldn't understand your ... A: right click Insur coverage Type combo and then scroll to Row source click (...) ellipses. it will ... | |
| compact and repair database | 3/16/2010 |
| Q: access creates a new database "db1". then i have to rename it to the original one and delete the ... A: I think you have error in vb coding. In visual basic editor click Debug--->Compile database if vb ... | |
| Counter function in Access database | 3/3/2010 |
| Q: I have an Access database of reference-only library books. I want to track the usage of the books ... A: you would need tables like : tblBooks ======== BkId primary key BkCat BkTitle PubId foreign ... | |
| Carrying one number from one record to next record | 2/28/2010 |
| Q: I am working on a cash book with fields like opening balance, closing balance, cheque amount, ... A: I have uploaded a sample file at rapid share. ... | |
| Date Range search on Calculated Date | 2/25/2010 |
| Q: I'm working on an MS Access database, where in a query I have genereted an other column with to be ... A: Place Stop after DoCmd.OpenReport strReport, lngView, , strWhere Stop run the report and when code ... | |
| ms access 2003 FAQ | 2/24/2010 |
| Q: Sir, I want to convert an already entered data into a new empty field. Example: Data entered in a ... A: you need to create a form. place several textboxes you want to edit data. bound the form to the ... | |
| How to limit number of records | 2/24/2010 |
| Q: I have a query which is running off 2 tables. There is a column which contains either a "Yes" or ... A: you can add both the tables in query design and under criteria for CalculateCommission Column Put ... | |
| How to limit number of records | 2/24/2010 |
| Q: I have a query which is running off 2 tables. There is a column which contains either a "Yes" or ... A: I am unable to understand your question. there is no number of records in access. if you put Yes ... | |
| Display Username on Form | 2/23/2010 |
| Q: I have created an ms access database and used the user level security to give access to the users of ... A: use public variable in any module and store value to this variable after succcessful user login. ... | |
| Stop AutoExec | 2/18/2010 |
| Q: I have a AutoExec Macro that I have running but i dont want it AutoExec if the criteria of the ... A: A good AutoExec macro can launch one or many different procedures or objects. In my view, the ... | |
| Setting Focus After Requerying Form | 2/18/2010 |
| Q: I have an unbound form with two subforms. Both subforms are continous forms tied to queries. The ... A: Hereunder is your modified code, you will note I have added bookmark to return back to the same ... | |
| working but little problem | 2/18/2010 |
| Q: I have apply ur sended query. it filter the subform according to the given dates. but sir i want to ... A: I am unable to understand your question. Please come up with some example. It is not my coding that ... | |
| Access 2003 issuse, please help. | 2/17/2010 |
| Q: I use a template from Microsoft Access 2003 to create an Order Entry for my own. Please look at the ... A: I already told you to RIGHT CLICK PRODUCT COMBO AND AT LAST OPTION YOU WILL SEE PROPERTIES CLICK ... | |
| Create monthy query | 2/17/2010 |
| Q: I have created the database of two table, (1) CustomerInfo, (2) CustomerBills. (1)Customerifo ... A: send me your db at aziz_abroad at yahoo dot com **************Added on 17/02/2010********** Open ... | |
| Access tabels | 2/15/2010 |
| Q: How to prevent from anyone importing my tables from my project into their projects? Foe example, ... A: Divide your mdb file into Front End and Back End. All tables will be in BackEnd and ... | |
| Three Column values in one whith condition | 2/12/2010 |
| Q: I am working with database using ms access 2000-2003 format, I am having table with column named ... A: use recordset as follows Dim rst as DAO.recordset Set rst= ... | |
| Access Tables | 2/11/2010 |
| Q: I'm fairly new to access but can get it to do most of what I need. I'm having trouble with one ... A: place a command button on the where you have combobox. then select report number , press enter and ... | |
| query re exclusion criteria | 2/8/2010 |
| Q: i want to do something that i thought would be pretty simple, but can't work out how, that is i want ... A: I asked you to pate YOUR query here so that I can maodify it to get the desired result. however with ... | |
| Question | 2/4/2010 |
| Q: Suppose I have a data of mobile number and in that record I have to change "9794424931" to ... A: use the following code if you want to run from command button on a form : Private Sub ... | |
| AUTO NUMBER | 2/2/2010 |
| Q: During Making a Table with Autonumbering. When I delete a record from take it dos't come back. Means ... A: you can not do it directly in table but you can do it from code and if the datatype is number and ... | |
| AUTO NUMBER | 2/1/2010 |
| Q: During Making a Table with Autonumbering. When I delete a record from take it dos't come back. Means ... A: In the table it will occupy the place of table record 8 but its value would be 9 and not 8.record ... | |
| Excluding weekends in a query | 1/30/2010 |
| Q: I'm new to Access and want to find a way to show only the weekdays on a query using the long date ... A: send me your db in zip format to aziz_abroad at yahoo dot com ********Code added on 31st January, ... | |
| Excluding weekends in a query | 1/29/2010 |
| Q: I'm new to Access and want to find a way to show only the weekdays on a query using the long date ... A: try with the following sql (you need to change table name and field names to suit your table and ... | |
| COMBO BOX | 1/29/2010 |
| Q: I have 3 columns headed - product code, product price, product name. how can I store the product ... A: make a form right click on form and select properties in property you will Record source fro the ... | |
| Access 2007 - Sequential Numbering | 1/18/2010 |
| Q: I am very new to the Access scene, can you help me with this one please. I have a very simple ... A: use the following code (you must change the control name as required) ... | |
| how to add a new field in ms access | 1/11/2010 |
| Q: sir, I want to add a new field in ms access 2003 form. the field i want to add is not showing in ... A: I expect you are using different table. check the record source of the form and then check the table ... | |
| Access dates | 1/5/2010 |
| Q: I want to let the user select a date for a list I have created from valid dates in the database and ... A: at the moment i do not have the file i sent you in this computer so i am unable to comment. send me ... | |
| How to print results from a form (but not all the pages in the report) | 1/5/2010 |
| Q: I'm trying to create a database with all contacts in it. the dbase has a table for contacts (which ... A: 1) make a report and place whatever info you want in report. Use the same recordsource as you have ... | |
| Access dates | 12/31/2009 |
| Q: I want to let the user select a date for a list I have created from valid dates in the database and ... A: can you send me the db at aziz_abroad@yahoo.com ************Additional Comments***************** I ... | |
| VBA | 12/31/2009 |
| Q: Hi, I am looking at using MS Access database, how can I create a Switch Board Manager? On Forms when ... A: You should ask 1 question and not multiple questions bundled in 1 question. I answer your first ... | |
| Access dates | 12/30/2009 |
| Q: I want to let the user select a date for a list I have created from valid dates in the database and ... A: You didn't tell what date format you are using to store date in table. date should be stored as ... | |
| design/query | 12/29/2009 |
| Q: Access 2003 I have been trying to set up a report that will tell me what software (ie Adobe Reader, ... A: you didn't write how you have stored data in table. i guess you have entered data as follows : ... | |
| Finding Record id from line of Report | 12/20/2009 |
| Q: I have a report that shows fields from a record on each line. I have a button with code to display a ... A: even if you use command button on report, you will not get any benefit since it doen't have click ... | |
| Access Query Help | 12/17/2009 |
| Q: In this query screen shot, I have duplicate rows for HOUSE 1, 3, 5,7,9,11 and 13 because they have ... A: can you send me your zipped databse at aziz_abroad at yahoo dot com **********Solution*********** ... | |
| Control in a form | 12/15/2009 |
| Q: I am using Access 2002 I am trying to make a form for a barcoded entry. The first field is for the ... A: The above code is ok for retreving first 6 digit to match You should use recordset with table which ... | |
| Autonumber formatting | 12/14/2009 |
| Q: I am attempting to use the autonumber as a key field. I need the field to only display 5 numbers, ... A: Is Field Size for autonumber ReplicationId ? If so you can not limit it to 5 If Field Size for ... | |
| Excel's like Access | 12/12/2009 |
| Q: I wish to replace excel with access but the following question holding me back from doing it. If all ... A: 1) Insert comment Like can be done in user interface (form and not directly entering data into ... | |
| Excel to Access Import with Transformation | 12/10/2009 |
| Q: Im absolutely new to VB and Access and Im trying to achieve an automation for below scenario: I ... A: Try with the following code : Private Sub cmdImport_Click() Dim rs As DAO.Recordset, rs1 As ... | |
| FIND statement | 12/9/2009 |
| Q: I have entered the following in MS Access to obtain the first oart of a postcode. It's the same ... A: there is no A and B columns in ms access.columns in access are denoted by field name. can you send ... | |
| Calculating prior fields | 12/9/2009 |
| Q: My department has 4 laser printers that are ran by two shifts. Before each shift starts, the meter ... A: If you have data in your table like : Date Printer Shift StartMeter EndMeter 01/12/2009 ... | |
| MS ACCESS 2007: Picture image shows up with its file name under the image: One of fields are to show images. When I browse and point to the image (bmp file), the filed shows its image and its file name under the image. I just want to see the image only. | 12/6/2009 |
| Q: MS ACCESS 2007: Picture image shows up with its file name under the image: One of fields are to ... A: What do you mean by browsing. In Access there is no browsing. I think you mean you have field in ... | |
| Access Question (report related) ? | 11/30/2009 |
| Q: I am having a very difficult time figuring out the answer for this question. I will be very thankful ... A: The command button code add records in new table and then opens report Private Sub cmd1_Click() ... | |
| Date Conversion | 11/28/2009 |
| Q: I have a formula in access VB set up to convert text to MS Date. The date on our system appears as ... A: you didn't write how you are exporting to excel. Try to change the code as follwos: Private Sub ... | |
| Access Macro (naming of files) | 11/24/2009 |
| Q: Hey, thx for taking Access questions! I'm trying to automate a database process that outputs a ... A: make a form place a commandbutton say cmdExport in its click event paste the following code : ... | |
| Date Conversion | 11/23/2009 |
| Q: I have a formula in access VB set up to convert text to MS Date. The date on our system appears as ... A: I am unable to understand what calculation u mean ? your function returns vdate = 1091123 as ... | |
| access & word | 11/22/2009 |
| Q: I am using access 2007 & office 2007 I have a record per employee saved in access table and the ... A: Have you enable macro ? follow these steps : 1) Click Office Icon on left corner. on right bottom ... | |
| usage of ms-access in industrial engineering | 11/21/2009 |
| Q: I'm afshin.I'm a student of industrial engineering in Uni.Please help me to know that what are the ... A: Distribution ============ BACKHAUL. Use of a common carrier or vehicle from a private fleet for a ... | |
| usage of ms-access in industrial engineering | 11/20/2009 |
| Q: I'm afshin.I'm a student of industrial engineering in Uni.Please help me to know that what are the ... A: Industrial engineers determine the most effective ways to use the basic factors of ... | |
| recovering information | 11/19/2009 |
| Q: Someone accidentally deleted information from a table and we have the information from last year. ... A: yes this is possible. you can append records from external database to the current database. but ... | |
| access & word | 11/17/2009 |
| Q: I am using access 2007 & office 2007 I have a record per employee saved in access table and the ... A: Instead of inserting word doc you can simply make a reference through hyperlink and on click event ... | |
| Please help me | 11/16/2009 |
| Q: I have to design a simple super market data base where in i had two tables,one is Store_goods where ... A: is it homework or work asiignment. If it is work assignment then you should condsider for POS ... | |
| Filter for reporting | 11/15/2009 |
| Q: I'm glad that finally I have found someone who can really help me. I asked you one question ... A: The database has been uploaded to http://rapidshare.com/files/308170530/Database.zip.html In ... | |
| Monthly Report | 11/13/2009 |
| Q: I have a youth database which holds all of the youth information for a facility. I need to add a ... A: Make another table with following fields: tblSummary Data Type ========== ... | |
| Calculating time in days/hours/minutes, based on time completed | 11/11/2009 |
| Q: Calculating amount of time used in hours and minutes, based on time completed. I need to calculated ... A: I have uploaded a file. It appears you didn't download that file. 1. I assume you created fields in ... | |
| Calculating time in days/hours/minutes, based on time completed | 11/11/2009 |
| Q: Calculating amount of time used in hours and minutes, based on time completed. I need to calculated ... A: How are you storing the date and time field together in table. if you are entering manually and it ... | |
| Inventory tracking database | 11/4/2009 |
| Q: I am very curious to make an inventory tracking database.I have created tables such as Product ... A: mail your db aziz_abroad at yahoo dot com *******Follow Up with the Questioner******** I am ... | |
| function for my query | 11/3/2009 |
| Q: I am sending you an image of my present query. You will notice that I have rows for ZONE "5+7" and ... A: Use Recordset then like : Dim rs as DAO.Recordset,rsPrevVal1,rsPrevVal2,rsPrevVal3 Set rs= ... | |
| Inventory tracking database | 11/3/2009 |
| Q: I am very curious to make an inventory tracking database.I have created tables such as Product ... A: In my opinion Stock Table should be removed and add 2 fields in Product table like OpeningQty (every ... | |
| function for my query | 11/2/2009 |
| Q: I am sending you an image of my present query. You will notice that I have rows for ZONE "5+7" and ... A: Run 2 update queries as follows : To change date 1 day earlier: ============================= ... | |
| Query before reporting | 11/2/2009 |
| Q: I have more than 3000 data in a table in access. I have created a report format with which i can get ... A: I have uploaded a sample database at : http://rapidshare.com/files/301260984/Mahfuz.zip.html In ... | |
| How to run an array function in a query | 10/31/2009 |
| Q: I am sorry you did not understand my question. When we call a function in a query design view to ... A: Unless you tell me the exact requirement, I can not comment further. For custom function you can ... | |
| employee form | 10/31/2009 |
| Q: I am develping a form for adding employees I set the controls for firstname, middlename, ... A: First remove data validation Is Not Null from all the fields then in save command button click event ... | |
| Microsoft Access window size (twips) | 10/30/2009 |
| Q: I'm looking for a simple way to determine the height and width of the Access window in twips, but ... A: 1. Start Microsoft Access, and then open any database file or a project file. 2. Create a new ... | |
| How to run an array function in a query | 10/29/2009 |
| Q: I am sorry you did not understand my question. When we call a function in a query design view to ... A: do you mean functions like DLookup / DSum or something else. it would be better if you could ... | |
| Nested SELECT query | 10/27/2009 |
| Q: I have a table that records computer parts. A part can be a component of some other parts. Each part ... A: Use the follwoing Query Syntax ============================== SELECT Parts.PartNo, ... | |
| Nested SELECT query | 10/27/2009 |
| Q: I have a table that records computer parts. A part can be a component of some other parts. Each part ... A: do you have sub part in other tables for example : Table1 PartId (PrimaryKey) PartName ... | |
| count checkboxes in access 2007 | 10/26/2009 |
| Q: I have 32 check boxes per client how do i count the yes and no's ANSWER: Use the following code : ... A: I have uploaded a sample file at : http://rapidshare.com/files/298472086/Elvis.zip.html In this ... | |
| Populating data in field based on other field. | 10/26/2009 |
| Q: I have created 2 tables. TB 1 contains 2 columns "Clause" and "description". TB2 again contains ... A: In lost focus event of Form combo box (Table1 Clause) use the following code: If Clause is numeric ... | |
| Add new product | 10/25/2009 |
| Q: I actually tried all the ways to make it work but unfortuniately no way I used this code Private ... A: Replace the code line ===================== If Not IsNull(DLookup("[ProductName]", "tbl_Product", ... | |
| count checkboxes in access 2007 | 10/25/2009 |
| Q: I have 32 check boxes per client how do i count the yes and no's A: Use the following code : Dim chkYesCount As Integer, chkNoCount As Integer, ctl As Control ... | |
| add new category | 10/24/2009 |
| Q: I have a form for adding the categories the form contains 2 fields one for the categoryname indexed ... A: I am unable to understand your Question : As far as I derive , do you mean you have ... | |
| Combo Box | 10/23/2009 |
| Q: I have a Combo Box in a form that is based on a table with two columns. One column is the full name ... A: I don't know how you would like to abbreviate the country name.programatically it can be done by ... | |
| How to create openrecordset | 10/22/2009 |
| Q: i want to creat openrecordset. Can you please show me the steps to create on? A: Make a table and name it Copy_table. add following fields to the Copy_table Field Name ... | |
| List Box on Form | 10/22/2009 |
| Q: I have a form whose data comes from tblmodel. I have a list box which gets its info from ... A: Try with the follwoing : Paste the follwoing Query syntax into Property Sheet(Row Source) of ... | |
| Import Table from Password Protected DB | 10/21/2009 |
| Q: I have protected my Access 2000 database with password and want to allow user to import certain ... A: 1. you need to Link Table to SourceDb. In my example below I have placed DestinationDb.mdb and ... | |
| How to set a default value in a table? | 10/21/2009 |
| Q: I would to know how to set a default value in a table . I am preparimg a training database with ... A: In table you have some restrictions for default value. Like you can not use table fields in formula. ... | |
| Number format for phone numbers | 10/20/2009 |
| Q: I currently have a 2007 database that stores both land line phone and mobile phone numbers. Both are ... A: if you format phone number as number it wouldn't have leading zero. basically most of the softwares ... | |
| MS Access | 10/20/2009 |
| Q: i have some data about employees of a company i need a results of this persons monthly date wise and ... A: there are some monthly programme What programs While asking question provide complete details to ... | |
| DATEDIFF in ms access | 10/19/2009 |
| Q: I am creating a table in MS access for railway data base in which journeydate and reservationdate ... A: Editing directly in table is not recommended. You should create a data entry form and there using ... | |
| MS Access Save Button Code? | 10/19/2009 |
| Q: Please i need help in MS Access MS Access Command Button (Save) codes to save one unbound front end ... A: you can download a sample file from link below : ... | |
| return characters in a text string | 10/19/2009 |
| Q: I need to "extract" the character string between the 2 # symbols in a column, where the field length ... A: Try with this : Mid(Me.Text0, (InStr(1, Me.Text0, "#") + 1), (InStr((InStr(1, Me.Text0, "#") + 1) + ... | |
| Add new product | 10/19/2009 |
| Q: I have a form for adding new products, and when I insert a new product which already exist in the ... A: Why you want to add same product again. Suppose you have ProductId Product Description ... | |
| adding form | 10/18/2009 |
| Q: I have a Form for orders the main form to add the customer information and subform for adding the ... A: Stop the Scrolling Madness! =========================== Step 1 ------ Use the link found in ... | |
| Access Problem | 10/18/2009 |
| Q: I am trying to create a form in Access 2007 as follows: The form has 3 columns titled Sta1, Sta1, ... A: I assume you have Tesxtboxes Sta1/Sta2 and DiffNo. Place a command button on the form and name it ... | |
| sql query | 10/18/2009 |
| Q: I have a table named "tblantennadatanodups" that has fields "tagid", "date"," time" and "number of ... A: Make a query and name it Query3 (I have used this name in my query syntax). In SQL view (Right click ... | |
| Auto-increment Field | 10/15/2009 |
| Q: I apologize for this really simple question - I'm fairly new to Access, and I have looked for a ... A: I assume you have bound form (i.e. bound to a table). In my example below the Form textboxt txtQid ... | |
| How to make an MS Access Unbound Combo Box A Multiple Value List on an Unbound Form? | 10/14/2009 |
| Q: I need your help on MS Access 2007. I have a big problem with my MS Access Unbound Form. How can I ... A: Your combo Row Source Type (In Combo Property Sheet) should be Value List. In Row Source (just above ... | |
| Linked tables | 10/13/2009 |
| Q: I have a access form which uses a linked table that links to a SQL DB. The table contains the ... A: I assume you have CityId invisible on the form. you can use the following code to run update query: ... | |
| Copying Fields | 10/13/2009 |
| Q: I have a database with 1000 enters, with the following fields - CatNo, Name1, Name2, Sex1, Sex2, ... A: make a second table and name it Copy_Table with the following fields: Cat/Name/Sex/DOB/Car There ... | |
| Copying Fields | 10/12/2009 |
| Q: I have a database with 1000 enters, with the following fields - CatNo, Name1, Name2, Sex1, Sex2, ... A: If you want to change your existing table structure i.e. Cat/Name/Sex/DOB/Car and store the values ... | |
| MS Access 2007 date/time calculation | 10/12/2009 |
| Q: I need to perform TAT's for my company. I have the following columns: Ins Date (for inserted dates) ... A: This is query syntax so you need to use the syntax in Query grid. if you send me the compressed ... | |
| MS Access 2007 date/time calculation | 10/12/2009 |
| Q: I need to perform TAT's for my company. I have the following columns: Ins Date (for inserted dates) ... A: Try with the following : SELECT Table1.fldId, Table1.InsDate, Table1.ResDate, Table1.RevDate, ... | |
| Microsoft Access Survey Form for Online Use | 10/7/2009 |
| Q: I have created a Microsoft Access 2007 database with a form for students to respond a few survey ... A: you can deploy your application Using package Solution wizard.This way user wouldn't need to ... | |
| How to pass field name from form to query | 10/6/2009 |
| Q: Sir, How do I send the some field names from form to query With Regards Dhandapani Bangalore ... A: 1. for string use "'" at the begining and at the end for example Lname(tablefield) ... | |
| MS Access multiple selection from a form | 10/5/2009 |
| Q: How do I pass multiple values to a query from a form. I need to pass a selection of a single zip ... A: Use like operator instead : ---------------------------- strSql = "SELECT tblZipCodes.Zip_Codes FROM ... | |
| Microsoft Access Survey Form for Online Use | 10/2/2009 |
| Q: I have created a Microsoft Access 2007 database with a form for students to respond a few survey ... A: you can freely download Access 2007 runtime from Microsoft site. Brief Description ... | |
| Form DOB calc not showing in back end Table | 10/2/2009 |
| Q: Apologies if this question already got sent: I have an input form with an AGE field. The age is ... A: take another textbox(say txtAge).Bound it to the age field in linked table and set its visible ... | |
| Photo capture | 10/1/2009 |
| Q: I am using ACCESS 2007 i am designing an employee form with OLE field which i am welling to restore ... A: In your employee table create a field (say Attachments) and from data type drop down combo select ... | |
| Running Sum in Query | 9/30/2009 |
| Q: I am trying to create a running sum in a query based on a table "Data" and a query "Count_New" ... A: You can not use running sum in query but you can display running sum in Report. if you want to add ... | |
| linked access db and sql server backend | 9/29/2009 |
| Q: I have a linked access database, the back end is sql server(2005), I was trying to insert rows ... A: detach database from sql server attach database again in sql server remove the links from access and ... | |
| linked access db and sql server backend | 9/28/2009 |
| Q: I have a linked access database, the back end is sql server(2005), I was trying to insert rows ... A: I think there is one-to-many relationship problem. you are trying to update many side without first ... | |
| Current Month and Cumulative Month total in MS Access Reports or Query | 9/27/2009 |
| Q: Sir, I have a database like this : Employee Number and Net salary for the months Net_01 = January, ... A: Why Net_01 to Net_12 ? Only Month field be sufficient and it would be easier to query if you store 1 ... | |
| Entering new data in a form which contains more than one foreign key | 9/27/2009 |
| Q: I'm trying a small database program using MS Access 2003. I have a number of tables ( 5 in number ) ... A: yes access need foreign key to link aprent table with child table. However you can supress this ... | |
| Labels | 9/25/2009 |
| Q: I have created an order entry form that will print out an invoice and a label for each box on the ... A: Are you manually putting product id ? and how the data is being stored in table something like : ... | |
| Recover Database | 9/16/2009 |
| Q: We are using a seperate s/w to process information and store it in access database in local machine. ... A: There are so many software who claims to recover deleted files(manually if programatically then ... | |
| A request for Access 2007 | 9/16/2009 |
| Q: Sir I am MCA Graduate and I need made an Application of my company where I am doing job as a Oracle ... A: Here is the link to download Access Developer Extension : ... | |
| search in a query by two criterias | 9/16/2009 |
| Q: I would like to make aform depends on aquery to search in my tables by two criteria the first : a ... A: I assume by Time you mean Date range "SELECT fldOrderId, fldOrderDate, fldCustomerid, fldOrderValue ... | |
| Database Management | 9/15/2009 |
| Q: I was in the middle of defining a relationship betwee two tables in my database access program and I ... A: I think you have left Contract table opened while creating relationship.Press Alt+ctrl+del key ... | |
| MS Access 2003 Shrink form to a pop up window and create path to go from a report back to switchboard | 9/14/2009 |
| Q: I am a beginner user in MS Access 2003. I have a page that has several buttons that when you press ... A: Try the following steps : ========================= Step 1 Paste the following code in ... | |
| combobox in ms access | 9/14/2009 |
| Q: why the first column in my combo is blank Me!mag_kombo.RowSource = "SELECT org.imemag, org.mag FROM ... A: In property sheet of the combo box scroll to Column Widths.you will see first column as 0cm;6.35cm ... | |
| ms access 2003 creating a form where you enter a date range | 9/9/2009 |
| Q: I need to create a form that I can reference in a query where the form pops up when running the ... A: I think no need for pop-up form just a form as starter with two textboxes and one command button ... | |
| insert query | 9/9/2009 |
| Q: how to insert the value obtained from a textfield into the database table. A: Try this DoCmd.RunSQL "Insert Into urtblname ([tblFieldname]) Values(Me.TextboxName);" if you have ... | |
| Multi Select Records | 9/8/2009 |
| Q: I am a university student, on work experience creating a database for a company. The purpose of the ... A: I would suggest your table structure as follows : tblCompany tblCorrespondence ... | |
| About the | 9/5/2009 |
| Q: I want to ask you about the record serial number in the bottom of the from that give each record his ... A: create a field in your table and name it fldSerial in load event of your first form use the ... | |
| About the | 9/5/2009 |
| Q: I want to ask you about the record serial number in the bottom of the from that give each record his ... A: do not store it in table bcoz if you delete record then it will still have the same serial number ... | |
| Call counter form | 9/2/2009 |
| Q: Ok, I'm trying to create a form that is way over my head, and I need to know if its possible. I'm ... A: yes it can be done. Prepare yourself with the form first like: Place all command buttons on the ... | |
| Access - SQL | 9/1/2009 |
| Q: I am try to set up a SQL backend for my database. I consider myself a moderate to expert access ... A: You can upsize the database to sql using upsize wizard from access 2007. following are the questions ... | |
| Ms Access 2007 | 9/1/2009 |
| Q: I need to create a form with 3 colums and i have a table with phone details like (Number, Name, Bill ... A: Steps to follow to display 10 records at button click ... | |
| delete query | 8/31/2009 |
| Q: I am trying to use a delete query to delete a record. The only thing is that it did not work for ... A: It appears to be correct. I have tested it with following.check what additional information you have ... | |
| Design issue | 8/28/2009 |
| Q: I have a design question. My database has sql backend and access front end. I have multiple users ... A: I would suggest to map the folder at each user's computer and link your database to that folder ... | |
| How Do I Disable Append/delete/maketable Prompts? | 8/28/2009 |
| Q: I have created a software using MS Access 2007 Now i want to create package I have downloaded and ... A: you didn't mention whether given answer DoCmd.SetWarnings False before running action query ... | |
| Iff | 8/27/2009 |
| Q: I have a Access database in which every company has a different type of products(A,B,C,D : They are ... A: what is your row structure in table 1) CompanyId / Compnay Name / ProductTypeA / ProductTypeB / ... | |
| Check Box | 8/26/2009 |
| Q: I want to collect information from volunteers availablity. I want enter inforamtion that what days ... A: I assume you have 14 check boxes for each day 1 for morning and another for evening. if they are ... | |
| MSAccess Calc | 8/25/2009 |
| Q: Need to calculate distance between two fields in different records. All I can think of is using ... A: Now it is clear So I assume atleast you have following fields PoleId =Pole1 / Ploe2 .... and so on ... | |
| Updating Single Record in Continuious form | 8/25/2009 |
| Q: Sayedaziz, I have a Access 2000 database that I "inherited" when I came on board with my company. I ... A: you have not written how are you updating fields with True/False values and once this field is ... | |
| Re:MS Access Database set-up | 8/24/2009 |
| Q: Sayedaziz, I am creating an Access Database Project for a Non-Profit Organization. It is an ... A: I think Response and answer are fixed. they donot vary say for example Assistance with food only 1 ... | |
| Submit HTML form in access database | 8/21/2009 |
| Q: .I am new to both HTML and MS Access. I have created a form in HTML (no check box, no radio ... A: if you are using Front Page to create your html form then you can use Data Interface wizard. follow ... | |
| MSAccess Pakaging | 8/21/2009 |
| Q: I have created a software using MS Access 2007 Now i want to create package I have downloaded and ... A: When you install the Access 2007 Developer Extensions on your computer, a new section, called ... | |
Using MS Access
Answers by Expert:
Ahmed Sayed Aziz
Top Expert on this page
Expertise
database designing,event driven programming,capturing/updating data programmitically using ms access 2000 and ms access 2002
Experience
multiple yrs. as a vb programmer
Organizations
Print Media
Publications
Math Skill Test VB6 Game Source Code published at Planet-Source
---------------------------------------------------------------
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=72322&lngWId=1
Holy Quran Source Code published at Planet-Source
-------------------------------------------------
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?lngWId=1&txtCodeId=72343&txtForceRefresh=82020091635140766
Right to Left Treeview & Listview Source Code published at Planet-Source
------------------------------------------------------------------------
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=72376&lngWId=1
Education/Credentials
B.Com, AICWA (Associate member of Cost & Works Accountants Of India)
©2012 About.com, a part of The New York Times Company. All rights reserved.