MS Access-Query
I am Using MS Access. I have a table that has price quotes from subcontractors. The fields are: SubID; TradeID; TradeValue (this is the Price Quote). I typically have 3 quotes for each TradeID. How do I query to get a result of the lowest price for each TradeID?
Answer Question
| March 12, 2008 4:54 PM
Access, Database programming, Microsoft Access
I am Using MS Access. I have a table that has price quotes from subcontractors. The fields are: SubID; TradeID; TradeValue (this is the Price Quote). I typically have 3 quotes for each TradeID. How do I query to get a result of the lowest price for each TradeID?
Answer Question
| March 12, 2008 4:54 PM
Access, Database programming, Microsoft Access
Equivolent SQL Server function for Access DoCmd.TransferText
I need to convert an Access app to SQL Server that has a DoCmd.Transfer command in it. Is there a qay to accomplish this in a stored procedure?
Answer Question
| March 5, 2008 4:36 PM
DoCmd.Transfer, Microsoft Access, SQL Server, Stored Procedures
I need to convert an Access app to SQL Server that has a DoCmd.Transfer command in it. Is there a qay to accomplish this in a stored procedure?
Answer Question
| March 5, 2008 4:36 PM
DoCmd.Transfer, Microsoft Access, SQL Server, Stored Procedures
Connect to Microsoft Access database
I want to connect to an access database that is placed on an internet server. i use the following syntex when i want to connect localy. With DB .Provider= “Microsoft.Jet.OLEDB.4.0″ .Properties(“Data Source”).Value= “C:Data.mdb” .Open .CursorLocation = adUseServer End With Can’t i just change the datasource property that points to the database on the internet, and [...]
Answer Question
| February 29, 2008 12:08 PM
Microsoft Access, VB, Web development
I want to connect to an access database that is placed on an internet server. i use the following syntex when i want to connect localy. With DB .Provider= “Microsoft.Jet.OLEDB.4.0″ .Properties(“Data Source”).Value= “C:Data.mdb” .Open .CursorLocation = adUseServer End With Can’t i just change the datasource property that points to the database on the internet, and [...]
Answer Question
| February 29, 2008 12:08 PM
Microsoft Access, VB, Web development
How can i express the percent margin in a query for Microsoft Access?
How can i express the percent margin in a query? I have a field PurchasePrice and a field Salesprice. the field Purchaseprice is the price at which we buy the products and the field salesprice is the field at which we sell the products.I tried to substract the salesprice to the pruchase price and divide [...]
Answer Question
| February 27, 2008 7:16 AM
Access 2000, Microsoft Access
How can i express the percent margin in a query? I have a field PurchasePrice and a field Salesprice. the field Purchaseprice is the price at which we buy the products and the field salesprice is the field at which we sell the products.I tried to substract the salesprice to the pruchase price and divide [...]
Answer Question
| February 27, 2008 7:16 AM
Access 2000, Microsoft Access
I am a student trying to convert a excel spreadsheet to a Access database.
My questions: How do I convert data from an excel spreadsheet to a Access Database. How do I convert a access form to excel – Using the form as a front for data capturing. How do I link multiple users to a access database – making allowance for data to flow simultanously into the database.
Answer Question
| February 21, 2008 7:56 AM
Microsoft Access, Microsoft Excel
My questions: How do I convert data from an excel spreadsheet to a Access Database. How do I convert a access form to excel – Using the form as a front for data capturing. How do I link multiple users to a access database – making allowance for data to flow simultanously into the database.
Answer Question
| February 21, 2008 7:56 AM
Microsoft Access, Microsoft Excel
How supply password in VBA during CompactOnClose for back-end password-protected db?
Access 2000: Goal: to open and close a password-protected public access db (which compacts on close) and hide the “Password Required” prompt on open and on close. Purpose: Provide public access to Main.mde and protect Main.mde from remote connections, i.e, import & link. I have password protected “Main.mde”. Main.mde compacts on close. If I open [...]
Answer Question
| February 20, 2008 9:46 PM
Access, Access 2000, Microsoft Access, VBA
Access 2000: Goal: to open and close a password-protected public access db (which compacts on close) and hide the “Password Required” prompt on open and on close. Purpose: Provide public access to Main.mde and protect Main.mde from remote connections, i.e, import & link. I have password protected “Main.mde”. Main.mde compacts on close. If I open [...]
Answer Question
| February 20, 2008 9:46 PM
Access, Access 2000, Microsoft Access, VBA
Microsoft Access – Find and Replace Issue
In Microsoft Access 2007, the “Search Fields As Formatted” check box checked results in a serious performance hit when a Find is done on a linked Oracle table. Even though the Find is being done on an indexed field, and the Access link to that table is aware that the field is indexed, the Find [...]
Answer Question
| February 28, 2008 6:21 PM
Access, Access 2007, Microsoft Access, Microsoft Office 2007, Oracle
In Microsoft Access 2007, the “Search Fields As Formatted” check box checked results in a serious performance hit when a Find is done on a linked Oracle table. Even though the Find is being done on an indexed field, and the Access link to that table is aware that the field is indexed, the Find [...]
Answer Question
| February 28, 2008 6:21 PM
Access, Access 2007, Microsoft Access, Microsoft Office 2007, Oracle
Access to MySQL – How hard is this going to be?
I’ve just taken on a client who has been building his databases in MS Access for 14 years. He wants to put a significant amount of this data into an online MySQL application. I know it can be done, and I’ve agreed to help him do it. Does anyone have a feel for what it [...]
Answer Question
| February 20, 2008 11:06 PM
Data migration, Microsoft Access, MySQL
I’ve just taken on a client who has been building his databases in MS Access for 14 years. He wants to put a significant amount of this data into an online MySQL application. I know it can be done, and I’ve agreed to help him do it. Does anyone have a feel for what it [...]
Answer Question
| February 20, 2008 11:06 PM
Data migration, Microsoft Access, MySQL
Access Module – calculating work minutes
I have this code that someone else created and I modified to calculate elapsed time between submit time & complete time but exclude hours that aren’t between 6AM & 6PM. The problem I am having is if something is submitted at 6:18PM and not completed until 6:30AM the next day it isn’t providing the correct [...]
Answer Question
| January 31, 2008 8:05 PM
Calculate Workday, Microsoft Access
I have this code that someone else created and I modified to calculate elapsed time between submit time & complete time but exclude hours that aren’t between 6AM & 6PM. The problem I am having is if something is submitted at 6:18PM and not completed until 6:30AM the next day it isn’t providing the correct [...]
Answer Question
| January 31, 2008 8:05 PM
Calculate Workday, Microsoft Access
MS Access Query
I have a table that has item information by store. I am looking to get back the top 25 items in each store. I can’t figure out how to run this. If I use the “Top 25″ tag I only get the top 25 through all stores, not by store. Anyone have any suggestions?
Answer Question
| February 1, 2008 4:03 PM
Microsoft Access, Query
I have a table that has item information by store. I am looking to get back the top 25 items in each store. I can’t figure out how to run this. If I use the “Top 25″ tag I only get the top 25 through all stores, not by store. Anyone have any suggestions?
Answer Question
| February 1, 2008 4:03 PM
Microsoft Access, Query
ms acess trouble
i am having trouble with my vb programs. I have several vb programs that make data reports from access datatables. All of a sudden my datareports will not update until i close my program and reopen it. Any help would be greatly appreciated.
Answer Question
| June 18, 2012 8:39 AM
Microsoft Access, VB
i am having trouble with my vb programs. I have several vb programs that make data reports from access datatables. All of a sudden my datareports will not update until i close my program and reopen it. Any help would be greatly appreciated.
Answer Question
| June 18, 2012 8:39 AM
Microsoft Access, VB
convert a query from access to sql server 2005
Ive recently been given the task of converting an application from an Access database to sql server 2005. One of the queries has this on the ORDER BY Clause ORDER BY not isdate(Obsolete), not isdate(not_relevant), isdate(assessed), isdate(published), isdate(implemented), not locally_adapted, guidanceType DESC, nice_ref DESC this wont work on sql server. Locally_adpated is a bit column [...]
Answer Question
| January 29, 2008 3:47 PM
Microsoft Access, SQL Server 2005
Ive recently been given the task of converting an application from an Access database to sql server 2005. One of the queries has this on the ORDER BY Clause ORDER BY not isdate(Obsolete), not isdate(not_relevant), isdate(assessed), isdate(published), isdate(implemented), not locally_adapted, guidanceType DESC, nice_ref DESC this wont work on sql server. Locally_adpated is a bit column [...]
Answer Question
| January 29, 2008 3:47 PM
Microsoft Access, SQL Server 2005
MS Access – Count of parent table items in a report
I have an MS Access database with a parent table and a child table. Table A (the parent, an Order table) has a PartID field, an OrderDate field, and an CustomerID field. Table B (the child, Parts) has a PartID primary key field and a PartDescription field. A relationship joins the 2 tables on the [...]
Answer Question
| January 18, 2008 8:43 PM
Access, Access multi-table reports, Access reports, Microsoft Access, Multi-table reports
I have an MS Access database with a parent table and a child table. Table A (the parent, an Order table) has a PartID field, an OrderDate field, and an CustomerID field. Table B (the child, Parts) has a PartID primary key field and a PartDescription field. A relationship joins the 2 tables on the [...]
Answer Question
| January 18, 2008 8:43 PM
Access, Access multi-table reports, Access reports, Microsoft Access, Multi-table reports
Access 2007 refrence look up
Ok this question might sound kind of elementary but i just seem to be missing something. I have a drop down box, within that combo box i want to display choices which consist of 3 cap letters then a “-” Then what the letters stand for. when i choose a selection from the combo box [...]
Answer Question
| January 16, 2008 3:05 PM
Access, Microsoft Access, Microsoft Office, Microsoft Office 2007
Ok this question might sound kind of elementary but i just seem to be missing something. I have a drop down box, within that combo box i want to display choices which consist of 3 cap letters then a “-” Then what the letters stand for. when i choose a selection from the combo box [...]
Answer Question
| January 16, 2008 3:05 PM
Access, Microsoft Access, Microsoft Office, Microsoft Office 2007
Access help
I have a 10 digit predetermined ID number. What I want to do is when a new number (the number referred to above) is added to the database, information based on this number will appear. The producer is based on the first three digits, the owner is based on the first three and the last [...]
Answer Question
| January 7, 2008 2:21 PM
Microsoft Access
I have a 10 digit predetermined ID number. What I want to do is when a new number (the number referred to above) is added to the database, information based on this number will appear. The producer is based on the first three digits, the owner is based on the first three and the last [...]
Answer Question
| January 7, 2008 2:21 PM
Microsoft Access
access supoort beyond 2007
will Microsoft package and support Access beyond office 2007
Answer Question
| December 19, 2007 4:15 PM
Microsoft Access, Microsoft Office
will Microsoft package and support Access beyond office 2007
Answer Question
| December 19, 2007 4:15 PM
Microsoft Access, Microsoft Office
SQL query – Unique item with latest date of entry
Hey guys, I have been working on the query running against MS access database. The table has multiple columns and two of them (which are vital to this query) are Date and ItemN ( suggesting Item number). There are multiples which show multiple entries for single itemN, for example. item 1 has three date entries [...]
Answer Question
| April 18, 2013 6:44 PM
Aggregate function, Distinct, MAX, Microsoft Access, Query, SQL, Subquery
Hey guys, I have been working on the query running against MS access database. The table has multiple columns and two of them (which are vital to this query) are Date and ItemN ( suggesting Item number). There are multiples which show multiple entries for single itemN, for example. item 1 has three date entries [...]
Answer Question
| April 18, 2013 6:44 PM
Aggregate function, Distinct, MAX, Microsoft Access, Query, SQL, Subquery
Where is my data
Hi Friends, I am able to enter the data through web form and able to get a query web page with the data being entered, but can’t find the data in the relevant table in Microsoft Access Database. Where is the data hiding and why it is hiding? I am trying to develop a dynamic [...]
Answer Question
| December 10, 2007 12:05 AM
Dreamweaver, IIS, Microsoft Access
Hi Friends, I am able to enter the data through web form and able to get a query web page with the data being entered, but can’t find the data in the relevant table in Microsoft Access Database. Where is the data hiding and why it is hiding? I am trying to develop a dynamic [...]
Answer Question
| December 10, 2007 12:05 AM
Dreamweaver, IIS, Microsoft Access
Is there a way to Call a Lotus Notes agent from Access code and pass Variables?
I’m on a Windows XP Pro System using M.S. Access 2003 and Lotus Notes 6.5. I provide adhoc and ancillary reports to our user community. We now have to send a hotspot to the users to inform them where their Excel files can be found. I created an agent that will send an email to [...]
Answer Question
| January 31, 2008 3:13 PM
Lotus hotspot, Lotus Notes, Microsoft Access, Variables, Windows XP
I’m on a Windows XP Pro System using M.S. Access 2003 and Lotus Notes 6.5. I provide adhoc and ancillary reports to our user community. We now have to send a hotspot to the users to inform them where their Excel files can be found. I created an agent that will send an email to [...]
Answer Question
| January 31, 2008 3:13 PM
Lotus hotspot, Lotus Notes, Microsoft Access, Variables, Windows XP
Vista and Office 2007
We have a customer upgrading their PCs with Vista and Office 2007. The host is an 820 at V5R3. iSeries access fix pack is SI28055. Does anyone have this mix and do you have issues to report? Thank you.
Answer Question
| June 4, 2012 7:25 PM
AS/400, Microsoft Access, Microsoft Excel, Microsoft Office 2007
We have a customer upgrading their PCs with Vista and Office 2007. The host is an 820 at V5R3. iSeries access fix pack is SI28055. Does anyone have this mix and do you have issues to report? Thank you.
Answer Question
| June 4, 2012 7:25 PM
AS/400, Microsoft Access, Microsoft Excel, Microsoft Office 2007
