I have an application that links to sql tables using ODBC. The users access all the same tables but one group access them from one server and another set of users access from another server. ...
I have a query that need to be exported on Pivot Table for Analysis proposes.
The required pivot wanted is called "finalpivot.jpg"
I just got an error, "see runtime-jpg"
the code below only...
I current have a Visual Basic Module within MS Access that I output the results of an MS Acceess table to an MS Excel spreadsheet. My problem is my output is now over 65,000 records so I want...
I would like to write a procedure that will link all tables in a SQL I have named all of my tables beginning with "tbl" and all of my views begin with a "v". Is it possible to programaticall...
Well, what is the Modulus operator in MS Access? I need to know this so that I can use this function for a programming thing I have to do. Thanks!
Hi,
I'm writing a report in Access and I need to calculate a field that is based on a value on the current record minus the value on the previous record. Is there an easy way to do that? I...
I have a stored procedure on my SQL 2000 box, the procedure needs two parameters.
The stored procedure is below
CREATE Procedure GetPlanID
( @PlanDate datetime,
@Client...
I'm using MS Access VBA and would like to open a dialog open box, similar to MS Excel's "GetOpenFileName" function for the user to select a specific file. I then would like to capture the com...
I have been looking everywhere for resources that explain how I can create an ActiveX DLL in Visual Studio 2005 that I can use in Access. I have a class in Access currently that I need to con...
hi
i have a simple sql select query that checks if certain text exists in a table
how can i incorporate vba code [or do it in sql if possible] that will add the text to a new record if i...
I need to modify the following code to allow me to specify which records to display in each of several text boxes on my report.
Dim rs As DAO.Recordset
Dim strValues As String
Set rs=Cu...
I'm trying to get the next row in a query.. for example
ID Value GetNextRowValue
1 3 2
1 2 6
1 6 8
2 8 0...
I have an Unbound OLE Object (type is MS Graph) in my Access 2007 program. It is on a report called rptMain and I want to populate or refresh it during the Load Event of rptMain, using the fol...
My old employer built a slick little tool that built an ODBC connect string in Access and then used that string to connect the Access front-end to a SQL Server backend. I know he used some op...
i have created the following code to automatically set up an ODBC connection in my access database. this code works great if i use the trusted connection option but when i try and give it a ge...
I've pasted my SAP GUI script into a Microsoft Access module. the script works if I run the .VBS file from my desktop, but when I try to run from within Access, I get a comile error 'Method o...
My Questions:
1. i have a database with 200 records and a rank field on the form. the user has the option to enter a rank for each record. I want to be able to produce a report that will ge...
I need to create a formula so that a total can be divided by a calendar of only Week Days not Weekends.. This calendar needs to be based on a 4 - 4 - 5 callendar...ie..5 weeks in the months o...
In Access 2000 I used to enter a line
Set Warnings Off
(or something)
How do I do this in Access 2007
Thanks
Paul
I have a list box that is plugged into a table with that only has one field, it is a hyperlink field.
I want to give the user the option of adding a new hyperlink to the listbox. Which m...
OKay.. so I'm using VBA automation from an Access script to generate an outlook e-mail. However, I'd like to embed images in the email... (not as an attachment) (CID?)
Now I thought that i...
I need to find code that will create a reference to another Access DB which contains generic code used throughout several other company applications. All of our user's applications are shared...
I am using Access 2003 and was using this code to cut mp3 files into smaller parts:
Private Sub cmdCut_Click()
Dim bytData() As Byte
bytData = ReadFile(App.Path & "\music.mp3", 1, 300...
Hallo,
I would like to send a XML (subscribe.xml - see below) file to a WSDL using VBA in ACCESS 2007.
An username and password must be used
The WSDL replies with a XML file (see below)
...
I have the following script giving me an error 6 - buffer overflow:
It occurs when the folder size is extreme (in this case example - the folder was 45 GB)
Anyway I can prevent this from hap...
