Hide Header In Access Report
Hi, I have a report built in Microsoft Access that has a page header and a header for one of my fields named JobNo. Well, I wanted to know if there is a way to not display the page header with the jobno header? I know there is a way to not show the page [...]
Answer Question
| December 25, 2008 10:12 PM
Access, Access reports, Database
Hi, I have a report built in Microsoft Access that has a page header and a header for one of my fields named JobNo. Well, I wanted to know if there is a way to not display the page header with the jobno header? I know there is a way to not show the page [...]
Answer Question
| December 25, 2008 10:12 PM
Access, Access reports, Database
MS Access & EDI
Is there a way to use MS Access to interface with a database that uses EDI? If so, what do I need to do to do this & where can I get more info on this?
Answer Question
| November 11, 2008 1:32 PM
Access, Database Management Systems, DBMS, EDI, Electronic Data Interchange, Microsoft Access
Is there a way to use MS Access to interface with a database that uses EDI? If so, what do I need to do to do this & where can I get more info on this?
Answer Question
| November 11, 2008 1:32 PM
Access, Database Management Systems, DBMS, EDI, Electronic Data Interchange, Microsoft Access
How to pass value at run time from VB 6 to Access 2000 Query for reporting
I have developed a sall application. Data is in Access 2002, Development is in VB 6. For reporting I have designed Queries, using the queries I have designed the reports. It works fine. While run time I accepts the criteria or value from user, based on that I have to show reports. My question is [...]
Answer Question
| October 6, 2008 10:19 AM
Access, Access 2002, Query, Query tuning, VB, VB 6, Visual Basic 6, Visual Basic developers, Visual Basic for Applications
I have developed a sall application. Data is in Access 2002, Development is in VB 6. For reporting I have designed Queries, using the queries I have designed the reports. It works fine. While run time I accepts the criteria or value from user, based on that I have to show reports. My question is [...]
Answer Question
| October 6, 2008 10:19 AM
Access, Access 2002, Query, Query tuning, VB, VB 6, Visual Basic 6, Visual Basic developers, Visual Basic for Applications
Add module to remote access database
I have 100+ access 2000 .mdb’s that I need to add a specific module to. What I want to do is loop through all mdb files in a specific directory and add a standard module to each one. Any ideas as to how to accomplish this from within access vba would be appreciated. I intend [...]
Answer Question
| August 30, 2008 5:53 PM
Access, Access 2000, MDB, VBA
I have 100+ access 2000 .mdb’s that I need to add a specific module to. What I want to do is loop through all mdb files in a specific directory and add a standard module to each one. Any ideas as to how to accomplish this from within access vba would be appreciated. I intend [...]
Answer Question
| August 30, 2008 5:53 PM
Access, Access 2000, MDB, VBA
Report -Conditional Format with multiple conditions: Access 2007
I am trying to generate a report that will change the font to different color if of a date field but the total number of days will change if another field = ?. So basically if [TYPE] = CHILD then DATE()-30= (red font), and DATE()-31 BETWEEN DATE()- 60= (yellow font) and DATE()-61 BETWEEN DATE()- 90=greenfont) [...]
Answer Question
| June 24, 2008 10:39 AM
Access, Access reports, Conditional formatting, Conditional statements, Database, Database programming, Microsoft Access
I am trying to generate a report that will change the font to different color if of a date field but the total number of days will change if another field = ?. So basically if [TYPE] = CHILD then DATE()-30= (red font), and DATE()-31 BETWEEN DATE()- 60= (yellow font) and DATE()-61 BETWEEN DATE()- 90=greenfont) [...]
Answer Question
| June 24, 2008 10:39 AM
Access, Access reports, Conditional formatting, Conditional statements, Database, Database programming, Microsoft Access
Microsoft Access and Oracle
Can tables created in Access or Excel be imported into Oracle?
Answer Question
| June 24, 2008 8:49 PM
Access, Microsoft Excel, Oracle, Oracle import/export
Can tables created in Access or Excel be imported into Oracle?
Answer Question
| June 24, 2008 8:49 PM
Access, Microsoft Excel, Oracle, Oracle import/export
Public Folders
I have created a public folder to store excel spreadsheets that I need users to be able to access and change. I understand the permissions. My question is can more than 1 user be in the same spread sheet at one time and make individual changes.Will all changes be saved?
Answer Question
| June 22, 2008 7:13 PM
Access, Excel 2003, Microsoft Access, Public folders
I have created a public folder to store excel spreadsheets that I need users to be able to access and change. I understand the permissions. My question is can more than 1 user be in the same spread sheet at one time and make individual changes.Will all changes be saved?
Answer Question
| June 22, 2008 7:13 PM
Access, Excel 2003, Microsoft Access, Public folders
,temporary files, on win02/03 servers in access(.ldb files) and excel are not deleting when applications are closed
can someone provide a possible solution
Answer Question
| June 23, 2008 3:52 PM
.ldb, Access, Microsoft Excel, Windows Server 2003
can someone provide a possible solution
Answer Question
| June 23, 2008 3:52 PM
.ldb, Access, Microsoft Excel, Windows Server 2003
Convert OO Base to MSA
Is there a way to convert an existing Open Office Base database to MS Access?
Answer Question
| June 18, 2008 4:51 PM
Access, Microsoft Access, OO, OpenOffice, VB
Is there a way to convert an existing Open Office Base database to MS Access?
Answer Question
| June 18, 2008 4:51 PM
Access, Microsoft Access, OO, OpenOffice, VB
run vba code as admin
I am currently working on an ms access application for a large insurance company which generates reports for the user after the user inputs/select some data…. Unfortunately the application has already been built – and till now we used to run the application/reports by logging in as admin.. however, we now want that users login [...]
Answer Question
| May 13, 2009 11:56 PM
Access, Microsoft Access, VBA
I am currently working on an ms access application for a large insurance company which generates reports for the user after the user inputs/select some data…. Unfortunately the application has already been built – and till now we used to run the application/reports by logging in as admin.. however, we now want that users login [...]
Answer Question
| May 13, 2009 11:56 PM
Access, Microsoft Access, VBA
Using Access Data Bases on My Web Site
I have a library of information that I maintian on my web site. Because it is getting large, it is difficult for a reader to find what is there. Is there a good example of an MS Access Data Base Application that allows different sorts of the information? For instance: By title, By Publication, By [...]
Answer Question
| March 10, 2008 4:32 PM
Access, Database, Web development
I have a library of information that I maintian on my web site. Because it is getting large, it is difficult for a reader to find what is there. Is there a good example of an MS Access Data Base Application that allows different sorts of the information? For instance: By title, By Publication, By [...]
Answer Question
| March 10, 2008 4:32 PM
Access, Database, Web development
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
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
Months query in Microsoft Access 2000
On the basis of my query i have built a totals query as follows: SELECT Sum(qryMargin.MarginInvoice) AS SumOfMarginInvoice, qryMargin.invoicedate FROM qryMargin GROUP BY qryMargin.invoicedate; I want to break down the sum so obtained into months on the basis of the invoicedateand also to arrange them to be not in alphabetical order but following the order [...]
Answer Question
| February 17, 2008 12:57 PM
Access
On the basis of my query i have built a totals query as follows: SELECT Sum(qryMargin.MarginInvoice) AS SumOfMarginInvoice, qryMargin.invoicedate FROM qryMargin GROUP BY qryMargin.invoicedate; I want to break down the sum so obtained into months on the basis of the invoicedateand also to arrange them to be not in alphabetical order but following the order [...]
Answer Question
| February 17, 2008 12:57 PM
Access
Exporting MS Access data to Oracle
Hi, I am exporting MS Access tables to Oracle using ODBC. I face MS Access ‘Overflow’ error for the tables which has date/time fields and has values in the format MM/DD/YYY. The error happens for only some of the data, for example 10/15/101. Please provide suggestions for how to solve this error. Thanks.
Answer Question
| February 8, 2008 3:33 PM
Access, ODBC, Oracle
Hi, I am exporting MS Access tables to Oracle using ODBC. I face MS Access ‘Overflow’ error for the tables which has date/time fields and has values in the format MM/DD/YYY. The error happens for only some of the data, for example 10/15/101. Please provide suggestions for how to solve this error. Thanks.
Answer Question
| February 8, 2008 3:33 PM
Access, ODBC, Oracle
MS Access Date Time
I have a date time filed in MS Access a database and woudl like to be able seperate in a query but so they keep the format settings. ie the date is a date and the time is still a time
Answer Question
| February 8, 2008 11:10 AM
Access
I have a date time filed in MS Access a database and woudl like to be able seperate in a query but so they keep the format settings. ie the date is a date and the time is still a time
Answer Question
| February 8, 2008 11:10 AM
Access
Microsoft Office & AS/400 Database
I am trying to bring data into Microsoft Access 2007 using ODBC. If a database has multiple members, how do you define/select the correct member in the ODBC definition? I have no problem getting the library list, and can see the files list but unable to select the member.
Answer Question
| February 6, 2008 5:56 PM
Access, i5, ODBC on i5
I am trying to bring data into Microsoft Access 2007 using ODBC. If a database has multiple members, how do you define/select the correct member in the ODBC definition? I have no problem getting the library list, and can see the files list but unable to select the member.
Answer Question
| February 6, 2008 5:56 PM
Access, i5, ODBC on i5
IIF clause
Can you help me build the right IIf field in the query with the following conditions : The field DDU consissts of : DDU :[exworks]*2+0,4+0,01 To the above expression i must also add 0,001 if size = 205, etc according to the following table : 205 0.001 60 0.001 20 0.009 1 1.32 4 0,32 [...]
Answer Question
| February 5, 2008 4:24 PM
Access
Can you help me build the right IIf field in the query with the following conditions : The field DDU consissts of : DDU :[exworks]*2+0,4+0,01 To the above expression i must also add 0,001 if size = 205, etc according to the following table : 205 0.001 60 0.001 20 0.009 1 1.32 4 0,32 [...]
Answer Question
| February 5, 2008 4:24 PM
Access
How to read/write Access 2003 mdb records on server via INTERNET connection
It seems that I’m a rather thick-headed nubee . . . Here’s the scenario – Running SBS 2003 on T105 box. Running Access 2003 on client under XP Pro. mdb has been published to wwroot with FP 2003 with full control permissions set on the folder containing mdb. All works when opening mdb locally. When [...]
Answer Question
| February 6, 2008 10:53 PM
Access, SBS 2003
It seems that I’m a rather thick-headed nubee . . . Here’s the scenario – Running SBS 2003 on T105 box. Running Access 2003 on client under XP Pro. mdb has been published to wwroot with FP 2003 with full control permissions set on the folder containing mdb. All works when opening mdb locally. When [...]
Answer Question
| February 6, 2008 10:53 PM
Access, SBS 2003
