Is there any easy was to transponse the results of a query on a report?
I have a query which gives results like:
Mo. Plan Actual
Jan 11 10
Feb 20 19
Mar 2...
My client may encounter the currrent scenario in the not too distant future
A database is used which aggregates monthly data from a reporting process into a table. The database is about 1....
Hi,
I have an Access database defined with several tables in it. In some of the tables I have fields defined as OLE object. These fields consist of embedded audio files.
How do I go ab...
Hello.
I am working with many datasets in an Access form. Each dataset has its own chart with linear trendline. I need to do some further statistical calculations in VBA that involve knowi...
What are the drawbacks of doing this.
1 issue is how to manage file associations but this can be handled by adding a shell extension for MDB files to open the file with access 97 if the file...
Hello
I have a form which has a Tab Control named tabDetail. Some of the pages have subforms, others do not. As I move from one page of the tab control to another, I want to perform ...
Hi Experts,
I have a replicated Access (2003) d/b and I'm confused about the locking:
Under "Tools", "Options", "Advanced" the following options are set:
"default open mode" is shared,...
Hi Experts,
Is it possible to determine for which MS Acces version an mde was compiled using vbscript?
thanks,
Michiel
Hi Experts,
What is the VBA script to write into a text file line by line?
I want to query a table in MS Access and write the records line by line into a text file and save the text file...
Is there a way to add a header or footer in a pivot table. Currently when I print the data I have no way of showing when it was printed, when the data was extracted, etc
Thanks...
Experts-
I have to design a process that imports data stored in files(.csv,.xls,.txt) in an access DB , runs a specific query on each of the sheets and then exports the data back to differe...
Using VBA, how can I get the path of the backend of a split db?
I had been doing this to find the current path of my db before the split:
Function GetPath()
Dim db As Database
...
Hi
I have a form in datasheet view, when i highlight a column in the grid the sort buttons on the tool bar and the right click popup menu are greyed out. Why would this be, I have other forms...
For all who'd be interested MS will be making the Runtime and Dev Extensions freely available for Access 2007.
See http://msdn2.microsoft.com/en-us/office/bb229700.aspx if you're sat in disbe...
I know, the title is bizzarre. Here is the problem:
I have a table named STUDENTS with fields
ID (int) <-- PRIMARY KEY
NAME (text)
BIRTHDATE (date)
ADDRESS (text)
CITY (text)
...
Hello Everyone,
This is a little complicated, so I hope I am explaining it correctly. I have a access report that displays all the open orders for the company. Now mgmt. wants to see the ...
I am building a report of Part No vs Stock Level in MS Access.
Part numbers are of varying length (16 to 20 characters) in the format XXXXXX-YYYYYY-ZZ where the first and last portions (XXX...
I have a number of tables in a SQL database and I am linking them into MSAccess. These tables are to be viewed by internal users as raw data for counts and simple queries, however I do not wan...
Hi
This allows me to export a report to rtf format.
DoCmd.OutputTo acOutputReport, "rptCustomerInvoice", acFormatRTF, "C:\test.rtf"
I'd like to have a different name each time for the...
I have a Form that has a button. When clicked, the button opens a ListBox Form with another button. The ListBox Form button is to seize two variables in the list box and since I have declare...
I have a database that is no longer functioning, it has been in use for several years working fine. Somehow the references to object libraries have broken. Only this particular MDB will not...
I was recently replacing a PC that housed a Microsoft Access database. The profiles and data was successfully transferred however I ran into an issue with the main access database they use
...
Access 2003
I would like to change this query to bring back
SELECT tblData.fldDId, tblData.fldWwg, tblData.fldMfgname, tblData.fldMfrnum, tblData.fldDescription, tblCoreSkuInformation.WW...
Access 2003
I want to compare text(alpha words) in table(tblData-fldDescription) to another table(tblSku-DESC) and score the finds
in a field called "fldScore"
tblData: field I need to use ...
A user clicks one of three command buttons on a form to export a report in .snp format to a server directory. The following code is used behind the command button for the first version of th...
