Excel and Access integration and auto-population
Overall, I want to create a database that tracks defects for several sites and ouputs the information in a pivot table. Each site (7 in total) documents their internal defect data and sends it to me weekly. I then merge all of this data (have been doing so manually) into one spreadsheet to perform my analysis [...]
Answer Question
| December 7, 2010 2:52 PM
Acces, Access 2000, Access Database, excel, Excel 2010, Excel macros, Macros
Overall, I want to create a database that tracks defects for several sites and ouputs the information in a pivot table. Each site (7 in total) documents their internal defect data and sends it to me weekly. I then merge all of this data (have been doing so manually) into one spreadsheet to perform my analysis [...]
Answer Question
| December 7, 2010 2:52 PM
Acces, Access 2000, Access Database, excel, Excel 2010, Excel macros, Macros
Sending Email in Excel using Macro
Hi, I want to create a button in excel wherein once you click that button a message will pop-up and ask “Are you sure you want to send notification to your supervisor?” Yes/No. If yes is selected a New Outlook Message will appear where recipient’s email address is already given and the subject is already available [...]
Answer Question
| November 22, 2010 6:34 AM
Access 2000, excel, Excel macros, Outlook, VBA Access 2000
Hi, I want to create a button in excel wherein once you click that button a message will pop-up and ask “Are you sure you want to send notification to your supervisor?” Yes/No. If yes is selected a New Outlook Message will appear where recipient’s email address is already given and the subject is already available [...]
Answer Question
| November 22, 2010 6:34 AM
Access 2000, excel, Excel macros, Outlook, VBA Access 2000
Access 2000 Database Entry Question
When creating a table is there a way to set the first entry as a drop down menu and the associated entry as a currency entry on the same line? We are trying for an employee database that has several extra jobs that we would like in a drop down menu and then be able [...]
Answer Question
| November 3, 2010 6:47 PM
Access 2000, Access Database, Access database permissions, Database query
When creating a table is there a way to set the first entry as a drop down menu and the associated entry as a currency entry on the same line? We are trying for an employee database that has several extra jobs that we would like in a drop down menu and then be able [...]
Answer Question
| November 3, 2010 6:47 PM
Access 2000, Access Database, Access database permissions, Database query
crystal reports and access 2002 issue
can Crystal Reports 9 access data originally created with MS Access 2000 (successfully), be used in MS Access 2002. Getting error code 0xc28, no read permission. MS Access application had been recently updated. Read permissions on access data file are correct, and have not been changed since using earlier version of MS Access.
Answer Question
| September 15, 2010 5:22 PM
Access 2000, Access 2002, Access errors, Crystal Reports, Crystal Reports 9
can Crystal Reports 9 access data originally created with MS Access 2000 (successfully), be used in MS Access 2002. Getting error code 0xc28, no read permission. MS Access application had been recently updated. Read permissions on access data file are correct, and have not been changed since using earlier version of MS Access.
Answer Question
| September 15, 2010 5:22 PM
Access 2000, Access 2002, Access errors, Crystal Reports, Crystal Reports 9
Find and replace text in text file using MS Access VBA
Hi I need to modify some tags of an XML file that I receive. How can I search the file for specific text and replace it? Here is the code I have right now. It runs without errors but does not replace the text. Function ReplaceTextInFile() Dim sSearchText As String Dim sReplaceText As String Dim [...]
Answer Question
| May 8, 2013 11:46 PM
Access 2000, Access VBA, VBA editor, Visual Basic for Applications, XML File Creation
Hi I need to modify some tags of an XML file that I receive. How can I search the file for specific text and replace it? Here is the code I have right now. It runs without errors but does not replace the text. Function ReplaceTextInFile() Dim sSearchText As String Dim sReplaceText As String Dim [...]
Answer Question
| May 8, 2013 11:46 PM
Access 2000, Access VBA, VBA editor, Visual Basic for Applications, XML File Creation
Report Page Header tied to Field in a Make Table in Access 2000
In Microsoft Access: How do I write the control in (properties) of an unbounded box created in a report header to display the a month I query (Criteria -Enter: Month) which then converts to a Make Table? When I run the query and am asked, “Enter: Month” and I type in “May”, I want May to show up in my report page [...]
Answer Question
| June 24, 2010 1:54 PM
Access 2000, Access query, Access Tables
In Microsoft Access: How do I write the control in (properties) of an unbounded box created in a report header to display the a month I query (Criteria -Enter: Month) which then converts to a Make Table? When I run the query and am asked, “Enter: Month” and I type in “May”, I want May to show up in my report page [...]
Answer Question
| June 24, 2010 1:54 PM
Access 2000, Access query, Access Tables
SQL
is it possible to have a where sql statement that is open ended. I have notice that there are time that parameter box pops up with some the Access pass-through queries that I have. Is it possible with SQL to be able to have a box pop up that would ask for a specific input to [...]
Answer Question
| February 27, 2010 4:40 PM
Access 2000, Access Datasheet, Microsoft Access 2000, SQL, Windows Server 2000
is it possible to have a where sql statement that is open ended. I have notice that there are time that parameter box pops up with some the Access pass-through queries that I have. Is it possible with SQL to be able to have a box pop up that would ask for a specific input to [...]
Answer Question
| February 27, 2010 4:40 PM
Access 2000, Access Datasheet, Microsoft Access 2000, SQL, Windows Server 2000
Closing Open Databases
I’ve been doing access for years, but only really developing one mdb at a time. My new job has me working on this product called UA, which does some pretty slick stuff that I haven’t seen before.. Always fun to learn. Anyway, this product has multiple mde’s that all are “called” from a main System [...]
Answer Question
| October 7, 2009 5:28 PM
Access 2000, Access Database, Exchange System Manager
I’ve been doing access for years, but only really developing one mdb at a time. My new job has me working on this product called UA, which does some pretty slick stuff that I haven’t seen before.. Always fun to learn. Anyway, this product has multiple mde’s that all are “called” from a main System [...]
Answer Question
| October 7, 2009 5:28 PM
Access 2000, Access Database, Exchange System Manager
How do I set decimal places with VB Access
I am using Access 2000 database for calibration control of measuring instruments. i.e. micrometers, calipers etc. The precision of the instruments varies and the decimal data fields in the table are set to Auto to minimize the stored values without changing the accuracy. I want to change the number of decimal places displayed in the [...]
Answer Question
| September 21, 2009 11:55 AM
Access 2000, Microsoft Access, VB, Visual Basic
I am using Access 2000 database for calibration control of measuring instruments. i.e. micrometers, calipers etc. The precision of the instruments varies and the decimal data fields in the table are set to Auto to minimize the stored values without changing the accuracy. I want to change the number of decimal places displayed in the [...]
Answer Question
| September 21, 2009 11:55 AM
Access 2000, Microsoft Access, VB, Visual Basic
Date problem with Delphi 7
I am trying to select records where the date is smaller that a specific date by using Delphi 7. The data is stored in a MS access 2000 database. dtsdate.DataSet := qrydate ; qrydate.Active := false ; qrydate.SQL.Text := ‘ select * from datum where datum < 1994/02/05′ ; qrydate.Active := true; in she shown [...]
Answer Question
| August 31, 2009 8:48 PM
Access 2000, Access Database, Delphi 7, Microsoft Access, SQL
I am trying to select records where the date is smaller that a specific date by using Delphi 7. The data is stored in a MS access 2000 database. dtsdate.DataSet := qrydate ; qrydate.Active := false ; qrydate.SQL.Text := ‘ select * from datum where datum < 1994/02/05′ ; qrydate.Active := true; in she shown [...]
Answer Question
| August 31, 2009 8:48 PM
Access 2000, Access Database, Delphi 7, Microsoft Access, SQL
adding hyperlink
I have created columns in the query for links to pdf files. Each one belongs to an employee. My question is how do I create the link to showup on the form for each employee? The links belong to certain employees while others have no link. I am currently running Access 2000.
Answer Question
| April 23, 2009 5:25 PM
Access 2000, Microsoft Access
I have created columns in the query for links to pdf files. Each one belongs to an employee. My question is how do I create the link to showup on the form for each employee? The links belong to certain employees while others have no link. I am currently running Access 2000.
Answer Question
| April 23, 2009 5:25 PM
Access 2000, Microsoft Access
creating reports with forms/subforms
I have created a report that is linked to the form. When I click the preview command button it asks for Emp. ID I enter in the ID Number and click ok. The print preview screen shows up with nothing on it. How can I get the data to show up on the report? and [...]
Answer Question
| April 19, 2009 5:51 PM
Access 2000, Access forms, Microsoft Access, Microsoft Access forms, Microsoft Access subforms
I have created a report that is linked to the form. When I click the preview command button it asks for Emp. ID I enter in the ID Number and click ok. The print preview screen shows up with nothing on it. How can I get the data to show up on the report? and [...]
Answer Question
| April 19, 2009 5:51 PM
Access 2000, Access forms, Microsoft Access, Microsoft Access forms, Microsoft Access subforms
Allow Additions Property on Subform In Form View in Access 2000
I have a main form and a subform in access 2000. I have set both the properties to NOT Allow Edits, Or Deletions, but Yes to allow additions. However, when I open the form in form view the property for allow additions changes back to no. I am able to go back and change the [...]
Answer Question
| March 9, 2009 12:57 PM
Access 2000, Access forms, Microsoft Access
I have a main form and a subform in access 2000. I have set both the properties to NOT Allow Edits, Or Deletions, but Yes to allow additions. However, when I open the form in form view the property for allow additions changes back to no. I am able to go back and change the [...]
Answer Question
| March 9, 2009 12:57 PM
Access 2000, Access forms, Microsoft Access
Locking Forms in Access 2000
I am using access 2000. I have created a form based on a table filled with tons of information. This is a multi user form. At the end of all of the records a blank form is presented so that the multi users can enter their appropriate information. However, some of the user are going [...]
Answer Question
| March 5, 2009 2:24 PM
Access 2000, Access forms, Microsoft Acccess
I am using access 2000. I have created a form based on a table filled with tons of information. This is a multi user form. At the end of all of the records a blank form is presented so that the multi users can enter their appropriate information. However, some of the user are going [...]
Answer Question
| March 5, 2009 2:24 PM
Access 2000, Access forms, Microsoft Acccess
Formatting a subform for printing in access 2000
I am trying to print a form in access 2000. The form consists of a subform. The problem is when I print, the name of the subform is printed at the bottom of the fields on the subform. The name of the subform appears whenever there is a blank field at the end of the [...]
Answer Question
| March 9, 2009 8:54 PM
Access 2000, Access Database, Access forms, Microsoft Access, Printing Subforms
I am trying to print a form in access 2000. The form consists of a subform. The problem is when I print, the name of the subform is printed at the bottom of the fields on the subform. The name of the subform appears whenever there is a blank field at the end of the [...]
Answer Question
| March 9, 2009 8:54 PM
Access 2000, Access Database, Access forms, Microsoft Access, Printing Subforms
Switch between two options in Microsoft Access 2000 text field
I am an access programmer, not much used to with the VB codes. I am using the wizards instead. I have a new project where in I want the secondary level users to check the data fed by the primary users. The findings of the primary user will be available in the new screen for [...]
Answer Question
| February 25, 2009 9:52 AM
Access 2000, Database programming, Microsoft Access 2000, Text field
I am an access programmer, not much used to with the VB codes. I am using the wizards instead. I have a new project where in I want the secondary level users to check the data fed by the primary users. The findings of the primary user will be available in the new screen for [...]
Answer Question
| February 25, 2009 9:52 AM
Access 2000, Database programming, Microsoft Access 2000, Text field
How do i have access fill in a field in the form in opening with data from the parent form
My first question please feel free to point out to me if i need to do any of this differently I am looking to create a button that opens an existing form with a new record and inserts into a field in the new record data from the parent form. We have a system where [...]
Answer Question
| February 11, 2009 7:00 PM
Access 2000, Microsoft Access, PostgreSQL, Windows Server 2003, Windows XP
My first question please feel free to point out to me if i need to do any of this differently I am looking to create a button that opens an existing form with a new record and inserts into a field in the new record data from the parent form. We have a system where [...]
Answer Question
| February 11, 2009 7:00 PM
Access 2000, Microsoft Access, PostgreSQL, Windows Server 2003, Windows XP
mixed 2000 db and 2007 mixed datepicker results
I had an old access database (2000) and ported it to access 2007 all well and good then created a new date field in my form, now i get the datepicker option for the new field but none of the old date fields. any ideas how to get access 2007 to give date picker to [...]
Answer Question
| December 13, 2008 1:14 PM
Access 2000, Access 2007, Access Database, Access Date Picker, Microsoft Access
I had an old access database (2000) and ported it to access 2007 all well and good then created a new date field in my form, now i get the datepicker option for the new field but none of the old date fields. any ideas how to get access 2007 to give date picker to [...]
Answer Question
| December 13, 2008 1:14 PM
Access 2000, Access 2007, Access Database, Access Date Picker, Microsoft Access
Amending a Product Price without altering existing orders in Microsoft Access
Platform; Windows XP Microsoft Office – Access 2000 Adapting the example database that was supplied with Access – Northwind Sample Database. I adapted the above sample database back in 2003 to my own database but have now hit a snag and i am unable to rememberor or find the solution. Currently, If a product price [...]
Answer Question
| December 1, 2008 6:27 PM
Access 2000, Database programming, Microsoft Access, Microsoft Access 2000, Northwind sample database, VAT, Windows XP
Platform; Windows XP Microsoft Office – Access 2000 Adapting the example database that was supplied with Access – Northwind Sample Database. I adapted the above sample database back in 2003 to my own database but have now hit a snag and i am unable to rememberor or find the solution. Currently, If a product price [...]
Answer Question
| December 1, 2008 6:27 PM
Access 2000, Database programming, Microsoft Access, Microsoft Access 2000, Northwind sample database, VAT, Windows XP
permission to open database
ACCESS 2000 which we used to write two databases. We added a new user, and correctly added the group. Then the next morning and every day since we can not gain access to the database. There are 3 user computers. 1 user reads the reinstalled ACCESS database fine, the other two can’t gain access to [...]
Answer Question
| October 20, 2008 7:42 PM
Access 2000, Access Database, Access database permissions, Microsoft Access
ACCESS 2000 which we used to write two databases. We added a new user, and correctly added the group. Then the next morning and every day since we can not gain access to the database. There are 3 user computers. 1 user reads the reinstalled ACCESS database fine, the other two can’t gain access to [...]
Answer Question
| October 20, 2008 7:42 PM
Access 2000, Access Database, Access database permissions, Microsoft Access
