MS access Program / module
Hello everybody, my self is Imtiyaz, i made a small database programm for challan in MS Access, but i am facing one problem in it… if u have seen any challan, it has few boxes like, crore, lacks, thousands, hundred, ten…..and when you put a figure like 20536, at that time in that boxis TWENTY [...]
Answer Question
| September 16, 2008 4:47 PM
Database programming, Microsoft Access
Hello everybody, my self is Imtiyaz, i made a small database programm for challan in MS Access, but i am facing one problem in it… if u have seen any challan, it has few boxes like, crore, lacks, thousands, hundred, ten…..and when you put a figure like 20536, at that time in that boxis TWENTY [...]
Answer Question
| September 16, 2008 4:47 PM
Database programming, Microsoft Access
Time limit for use of Access application
Dear Sir, I have created a access application. Now i want that user should be able to use it for 15 days only. After that the application should say that your trial period is expired and get closed. Eagerly waiting for your reply. Thanks, Sandip
Answer Question
| September 12, 2008 6:35 AM
Microsoft Access, Software development, Trial period software
Dear Sir, I have created a access application. Now i want that user should be able to use it for 15 days only. After that the application should say that your trial period is expired and get closed. Eagerly waiting for your reply. Thanks, Sandip
Answer Question
| September 12, 2008 6:35 AM
Microsoft Access, Software development, Trial period software
importing an EXCEL tab
while importing an EXCEL tab with the import wizard, ACCESS 2003 changes a text field with only numbers that exceeds the long integer format to scientific notation. Is there a possibility the numbers do appear?
Answer Question
| September 25, 2008 12:09 PM
Microsoft Access, Microsoft Excel
while importing an EXCEL tab with the import wizard, ACCESS 2003 changes a text field with only numbers that exceeds the long integer format to scientific notation. Is there a possibility the numbers do appear?
Answer Question
| September 25, 2008 12:09 PM
Microsoft Access, Microsoft Excel
Read Only Table
I create a table in sql server 2k5, the script is look like this: CREATE TABLE [dbo].[tb1PmtD]( [PmtDLU] [int] NOT NULL, [PmtDInvLU] [int] NOT NULL, [PmtDAmount] [money] NOT NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[tb1PmtD] WITH NOCHECK ADD CONSTRAINT [tb1Pmttb1PmtD] FOREIGN KEY([PmtDLU]) REFERENCES [dbo].[tb1Pmt] ([PmtID]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[tb1PmtD] CHECK CONSTRAINT [...]
Answer Question
| September 10, 2008 9:08 PM
File permissions, Microsoft Access, SQL scripts, SQL Server 2005
I create a table in sql server 2k5, the script is look like this: CREATE TABLE [dbo].[tb1PmtD]( [PmtDLU] [int] NOT NULL, [PmtDInvLU] [int] NOT NULL, [PmtDAmount] [money] NOT NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[tb1PmtD] WITH NOCHECK ADD CONSTRAINT [tb1Pmttb1PmtD] FOREIGN KEY([PmtDLU]) REFERENCES [dbo].[tb1Pmt] ([PmtID]) ON UPDATE CASCADE GO ALTER TABLE [dbo].[tb1PmtD] CHECK CONSTRAINT [...]
Answer Question
| September 10, 2008 9:08 PM
File permissions, Microsoft Access, SQL scripts, SQL Server 2005
Need Help Importing Data
Hello, I have a relational database that was created by a former employee. The database has old data and I need to update it with current information. I have the most recent data in an Excel spreadsheet. Questions: 1. How can I get the new data into the database and maintain the relationships and populate [...]
Answer Question
| September 9, 2008 6:05 PM
Access 2007, Microsoft Access
Hello, I have a relational database that was created by a former employee. The database has old data and I need to update it with current information. I have the most recent data in an Excel spreadsheet. Questions: 1. How can I get the new data into the database and maintain the relationships and populate [...]
Answer Question
| September 9, 2008 6:05 PM
Access 2007, Microsoft Access
Access 2007 Report displaying the content of three different fields in one box?
I am creating a report in MS Access 2007. I want to create one box that displays the content of three different fields. i.e. Salutation First Name and Last Name. I used to do this in Access 2003 this way =[Salutation] & ” ” & [First Name] & ” ” & [Last Name] but in [...]
Answer Question
| September 10, 2008 6:55 PM
Access 2007, Access reports, Microsoft Access, Office
I am creating a report in MS Access 2007. I want to create one box that displays the content of three different fields. i.e. Salutation First Name and Last Name. I used to do this in Access 2003 this way =[Salutation] & ” ” & [First Name] & ” ” & [Last Name] but in [...]
Answer Question
| September 10, 2008 6:55 PM
Access 2007, Access reports, Microsoft Access, Office
Strange behavior in Access 2003 user interface
I create a form in access 2k3 data project connected to sql server 2k5. I put two check boxes on my form. On runtime, when i click on one of check box, it also fires on the other check box…set check box value from false to true. But it works normally when i use keyboard [...]
Answer Question
| October 17, 2008 11:27 AM
Access 2003, Access forms, Microsoft Access, SQL Server 2005
I create a form in access 2k3 data project connected to sql server 2k5. I put two check boxes on my form. On runtime, when i click on one of check box, it also fires on the other check box…set check box value from false to true. But it works normally when i use keyboard [...]
Answer Question
| October 17, 2008 11:27 AM
Access 2003, Access forms, Microsoft Access, SQL Server 2005
Pivot Table Error Field Message
I have a pivot table in my spreadsheet that is linked to an access database. When clicking on the refresh data button at the top toolbar to refresh the data in my spreadsheet from the new data hitting the access database, I receive an error message stating “The Pivot Table field name is not valid. [...]
Answer Question
| June 21, 2011 3:17 PM
Access Database, Microsoft Access, Pivot tables
I have a pivot table in my spreadsheet that is linked to an access database. When clicking on the refresh data button at the top toolbar to refresh the data in my spreadsheet from the new data hitting the access database, I receive an error message stating “The Pivot Table field name is not valid. [...]
Answer Question
| June 21, 2011 3:17 PM
Access Database, Microsoft Access, Pivot tables
Access 2007 Complex Calculations
In Access 2007 I need to enter raw test data into tables, perform complex calculations including linear trends, then store the calculated results. These are the only numbers I really care about. The raw test data could be deleted for all I care, I just need the calculated results. I will need to run queries [...]
Answer Question
| September 5, 2008 7:35 PM
Complex Database Calculations, Database, Database design, Linear trends, Microsoft Access
In Access 2007 I need to enter raw test data into tables, perform complex calculations including linear trends, then store the calculated results. These are the only numbers I really care about. The raw test data could be deleted for all I care, I just need the calculated results. I will need to run queries [...]
Answer Question
| September 5, 2008 7:35 PM
Complex Database Calculations, Database, Database design, Linear trends, Microsoft Access
Adding prefix to records
Hi, I have a simple database for some products that has some SKU numbers… ie SKU 1001-01076-0000 1001-01120 1001-01120-2100 1001-01120-2400 1001-01121 1001-01121-2100 What I want to do is add the prefix “GF-” in front of those SKUs. This is a database that will continually get sent to me, so adding the “GF-” manually in the [...]
Answer Question
| September 5, 2008 12:03 AM
Database programming, Microsoft Access, UPDATE statement
Hi, I have a simple database for some products that has some SKU numbers… ie SKU 1001-01076-0000 1001-01120 1001-01120-2100 1001-01120-2400 1001-01121 1001-01121-2100 What I want to do is add the prefix “GF-” in front of those SKUs. This is a database that will continually get sent to me, so adding the “GF-” manually in the [...]
Answer Question
| September 5, 2008 12:03 AM
Database programming, Microsoft Access, UPDATE statement
Access form won’t clear after each entry is added
I have an access form with an add button. The button adds the record to the table, but the form won’t clear that entry out. How do I clear the entry?
Answer Question
| September 26, 2008 9:30 PM
Access forms, Microsoft Access
I have an access form with an add button. The button adds the record to the table, but the form won’t clear that entry out. How do I clear the entry?
Answer Question
| September 26, 2008 9:30 PM
Access forms, Microsoft Access
converting files Lotus to Microsoft
Our church office has used Lotus Approach 97 for the mailing list. We have about 600 names. Now we are converting to MS office 2007 and using Access. My question is, can I convert the Approch files to Access – my secretary really does not want to retype all of the address unless necessary. Thanks [...]
Answer Question
| September 5, 2008 8:39 PM
Data Coversion, Lotus Approach, Microsoft Access
Our church office has used Lotus Approach 97 for the mailing list. We have about 600 names. Now we are converting to MS office 2007 and using Access. My question is, can I convert the Approch files to Access – my secretary really does not want to retype all of the address unless necessary. Thanks [...]
Answer Question
| September 5, 2008 8:39 PM
Data Coversion, Lotus Approach, Microsoft Access
Export from Access to Excel shifts decimal position randomly
I am exporting from MS Access ’03 to MS Excel ’03. I retrieve several columns formatted as Fixed width with 2 decimal places in a query and then export those results to Excel. Occasionally, some of the columns, but not all values in that column, will display with the decimal point shifted one position to [...]
Answer Question
| September 2, 2008 8:52 PM
Access 2003, Access query, Access to Excel, Excel 2003, Export, Microsoft Access, Microsoft Excel
I am exporting from MS Access ’03 to MS Excel ’03. I retrieve several columns formatted as Fixed width with 2 decimal places in a query and then export those results to Excel. Occasionally, some of the columns, but not all values in that column, will display with the decimal point shifted one position to [...]
Answer Question
| September 2, 2008 8:52 PM
Access 2003, Access query, Access to Excel, Excel 2003, Export, Microsoft Access, Microsoft Excel
Compile Error
I am trying to prevent duplicate job orders from being entered for the same employer. The employer is in the main form and the job order is in the subform. I have this code attached to the “beforeupdate” event of the control on the subform but I get a compile error: wrong number or arguments [...]
Answer Question
| August 30, 2008 7:55 PM
Compile error, Database programming, Microsoft Access
I am trying to prevent duplicate job orders from being entered for the same employer. The employer is in the main form and the job order is in the subform. I have this code attached to the “beforeupdate” event of the control on the subform but I get a compile error: wrong number or arguments [...]
Answer Question
| August 30, 2008 7:55 PM
Compile error, Database programming, Microsoft Access
Union Query
I ‘ve a problem with porting my ms access database to sql server. In my inventory database, i have 4 tables: (1)Purchase, (2)Sales, (3)Quantity Adjustment, (4)Amount Adjustment. I want to calculate the stock position from those 4 tables. In access database, i do with this kind of queries : a. parameterized query to filter each [...]
Answer Question
| September 1, 2008 6:27 PM
Access Database, Microsoft Access, SQL Server database, SQL Server stored procedures
I ‘ve a problem with porting my ms access database to sql server. In my inventory database, i have 4 tables: (1)Purchase, (2)Sales, (3)Quantity Adjustment, (4)Amount Adjustment. I want to calculate the stock position from those 4 tables. In access database, i do with this kind of queries : a. parameterized query to filter each [...]
Answer Question
| September 1, 2008 6:27 PM
Access Database, Microsoft Access, SQL Server database, SQL Server stored procedures
Access database management
Hi guys I am managing a database and need to know if there is away of moving ‘completed’ records into another database but keep them linked. Senario is: We have records of pieces of work coming into the office and which take about amonth to complete the cycle. My query is instead of having this [...]
Answer Question
| August 21, 2008 8:30 AM
Database, Database programming, Microsoft Access
Hi guys I am managing a database and need to know if there is away of moving ‘completed’ records into another database but keep them linked. Senario is: We have records of pieces of work coming into the office and which take about amonth to complete the cycle. My query is instead of having this [...]
Answer Question
| August 21, 2008 8:30 AM
Database, Database programming, Microsoft Access
processing biometric data
can biometric data be incorporated into desktop or stand-alone applications like ms excel and ms access?
Answer Question
| August 21, 2008 5:40 PM
Biometrics, Microsoft Access, Microsoft Excel
can biometric data be incorporated into desktop or stand-alone applications like ms excel and ms access?
Answer Question
| August 21, 2008 5:40 PM
Biometrics, Microsoft Access, Microsoft Excel
Switch/Case statment in access
how i can use Switch/Case Satatment in Mic. Access 2003, am working on database as follow: Field Name: Directions in this field i need to write codes like: TAm Field Name: Translation here i need to read TAm as T=Take, Am= Morning. the problem i have more than 200 codes, which they have to be [...]
Answer Question
| August 25, 2008 11:10 AM
Access 2003, CASE statement, Database programming, Microsoft Access
how i can use Switch/Case Satatment in Mic. Access 2003, am working on database as follow: Field Name: Directions in this field i need to write codes like: TAm Field Name: Translation here i need to read TAm as T=Take, Am= Morning. the problem i have more than 200 codes, which they have to be [...]
Answer Question
| August 25, 2008 11:10 AM
Access 2003, CASE statement, Database programming, Microsoft Access
How to show list view in Microsoft Access report
i sample out some of the data from database. i shows my sampling in a listview in visual basic 6.0. now i want to show the sample to microsoft access. how’s the coding?
Answer Question
| August 18, 2008 9:42 AM
listview, Microsoft Access, VB, Visual Basic 6
i sample out some of the data from database. i shows my sampling in a listview in visual basic 6.0. now i want to show the sample to microsoft access. how’s the coding?
Answer Question
| August 18, 2008 9:42 AM
listview, Microsoft Access, VB, Visual Basic 6
How do I retrieve the most recent date from an access database
I am building a report in Access 2003 and am trying to pull data based on the most recent service call for a customer. There is typically several service call dates for each customer, but the only record I am concerned with is the most recent date.
Answer Question
| August 18, 2008 5:29 PM
Access 2003, Access Database, Microsoft Access
I am building a report in Access 2003 and am trying to pull data based on the most recent service call for a customer. There is typically several service call dates for each customer, but the only record I am concerned with is the most recent date.
Answer Question
| August 18, 2008 5:29 PM
Access 2003, Access Database, Microsoft Access
