Access

VBA Looping In Access

I have a report in Access which pulls from one table in an Access databse.  In the table there is one record for each "Region" and when I run my Access report it then creates one big pdf file containing a one page report for each region.  How can I write a peice of VBA code that will loop the...

Optimizing Query that uses linked tables and bound form w/joins

I have a bound form whose record source is an Access query.  That Access query involves 3 linked SQL Server tables (one inner join, one left join).  The form takes a while to open. I have run a SQL Profiler and it appears that access is sending two select fields from table without where clauses,...

linking report to form by macro

I have a report that various info including name is pulled off of a form. i want to be able to click on the name in the report and have it bring up that particular record in the form. i can click on the name and it brings up the first record, but i want it to go to the specific record that matches...

Edit data in an Access Form

I have done this before, but cant get it to work in my new database. I have created a form that is based off a query in my database. I want my users to be able to type data into one of the fields on my form and the table driving the query will update with what they type. Every form I've created...

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 header with the report header but I...

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?

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...

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 to do this from within...

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...

Microsoft Access and Oracle

Can tables created in Access or Excel be imported into Oracle?

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?

,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

Convert OO Base to MSA

Is there a way to convert an existing Open Office Base database to MS Access?

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.....

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...

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?

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...

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...

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...

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....