Search results for query: *

DoCmd.TransferText acExportDelim, "TOutputSpec", "tOutput", "c:\data\Agresso.txt", False Is there a limit to the length of a string that can be exported to a Fixed length csv file I have set the size to 500 in the specification file but only get a max length of 255

I am using : "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:\Test\DrawingsSA.mdb" /excl to open a Database Exclusive, works fine Is it possible to open it exclusive without using the "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" part

Can a Textbox be rotated 45 degrees

Is it possible to refer to a reports recordsource using a variable eg. DoCmd.OpenReport Variable1 & "Report2", acViewDesign, , , acHidden Reports!Variable1.RecordSource = sqlstr DoCmd.Close acReport, Variable1 & "Report2", acSaveYes

Cannot see a problem with this Code Dim db As Database Dim tdf As TableDef Dim fld As Field Dim n As Integer Set db = CurrentDb DoCmd.SetWarnings False DoCmd.OpenQuery ("qBelowStandard") **** Make Table Query Set tdf = db.TableDefs("tBelowStandard") MsgBox (tdf.Fields.Count) *******...

I have the following Code: On Error GoTo Err_Handler Dim db As Database Dim rst As Recordset Set db = CurrentDb Set rst = db.OpenRecordset("select * from tSample where sftshift='K'") MsgBox (rst!wodref) Exit sub Err_Handler: MsgBox ("Error") A "no current Record" error is deliberatltely...

I have a Pass through query and am getting a syntax error in join operation. sqlstr = "select fds.nonPMJobs.npmJobRef,fds.workorders.wodref " _ & " from fds.nonPMJobs " _ & " INNER JOIN fds.Workorders ON fds.NonPmJobs.npmJobRef = fds.Workorders.npmJobRef" _ & " where...

Code for changing colours in a Pie Chart Please

How can you change series colours based on the series datalebel e.g. datelabel "Priority 1" Series colour Red

Is it possible to activate an OLE object automatically when a Crystal Report Runs?

Is it Possible to suppress the header on the last page of a report. Private Sub Report_Page() If Me.Page = Me.Pages Then Me.PageHeaderSection.Visible = False Else Me.PageHeaderSection.Visible = True End If End Sub This code works but not until you have diplayed the last...

Is it possible to print a page in crystal then pass a path to open word, print the document, close word and continue the report. The path would be variable depending on a defined field. The creation of the path is straightforward it is the opening of Word and passing the path that is the problem

Is it possible to open a database and display just a msgbox only. i.e. no menus, toolsbars, access startup flyer etc. I need to open access from another application, perform a calculation and display the result to the user.

Doe anyone know how to display the advanced properties such as height, width, horizontal resolution, vertical resolutuion and other info stored in the file header of a jpg file

Is it Possible to give a User Update and Insert Permissions to a table without giving READ Permission?

Why does Access Force me to save Querys, forms, etc when I don't want to save them ?

Is there any way of changing the position where a MSGBOX is displayed ?

Is It Possible to edit a previously created import / export specification File

Can a custom toolbar be copied from one database to another?

Is it possible to create a Parameter query using the In operator. The "In" string is in an object on a form