| Subject | Date Asked |
|
| 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 ...
|