Search results

Hi, I am trying to write a query that can combine multiple rows of data into a single column. What I want is a result set which has JobRef as coulmn 1 and column 2 will be all users assigned to the job e.g. "User 1, User2, User 3" (from User.UserName) The structure of the database is below...

Hi, I have a main form which calls a small form "frmBuildQualAim", but when it calls this form the control on it (combo box) seems to be readonly (you cant select any of the values), the strange thing is that I have replicated the code into a blank form and it works fine, does anyone have any...

Hi, I am trying to return a value from a stored procedure to access. From what I remember you have to use a command object and define the Input and Output Parameters, but I cant remember how. The SQl Stored Procedure takes 6 Parameters (1-5 Input and 6 Output), can someone please tell me how...

Hi, I have writen a SP, but when running it I get the following error. Msg 245, Level 16, State 1, Procedure ExpPeriodsForYear, Line 47 Conversion failed when converting the varchar value '01-Oct-' to data type int. The SP is SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO --...

Hi, I have a SSIS Package which transfers data from one database to another and then does some conversino work on the data. Only problem is that when I run this script I get the following error message. [OLE DB Source [1]] Error: There was an error with output column "StarHashOther" (83) on...

Hi, I sometimes have a simular error and it usually is missing references on the PC. Try opening VBA and opening references option screen and seeing if any thing has missing in there. If it does you will need to copy the libraries and use regsvr32 to register them.

Hi, I have a report with a footer which forces page breaks, but my problem is that I have a report footer with some summary details, which due to this appears on a blank page, I am looking at a way to suppress the force new page on the last page of the report, so the report footer appears after...

Ni, I had it on full, I have changed it to simple, I will see if this makes any difference

Hi, Thanks for the help, I curreently do run the Database Log Bakcup and ddbc on a regular basis, but I am looking for a way to remove the need to do this, (hopefully by creating a job, or changing a setting on the db).

Hi, I have a couple of DB's which have a lot of transactions against them overnight and the log files grow to hugh sizes, and I have to compact these files down several times a week. What is strange though is I have anoth DB, which as even more transactions against it and this db, doesn't have...

Found the problem I was referencing the function as AGLH(); when I should have referenced as dbo.AGLH();

I am trying to access a SQL server function called AGLH(), GetAGLH is only the VBA function, which I want to use to retrieve the result into from SQL Server. If I change this it deffinately wont work.

Hi I wrote the following code Sub GetAGLH() Dim rst As New ADODB.Recordset rst.Open "SELECT AGLH();", CurrentProject.Connection Debug.Print rst.Fields(0) End Sub but all I get back is "AGLH is not a recognized function name" I have checked to make sure that the user logged onto my ADP has...

Hi, I am fairly new to writing Access ADP Projects, and am looking at how I can run SQL Server functions and return the result to Access. Thanks, Gavin,

Hi, I am fairly new to SQL Server and am trying to find out if there is a way to create a function in master db (I want all databases to be able to access the function) that can then be called by any db on server without having to reference the db name e.g. master.db.functionname(parameters)...

to do this in your Query Enter the following into the Criteria field: Forms![Form Name]![Control Name] Then When you run the Query as long as the Form is open it will pick up the entry from your text box.

the Tool that I am after in particular is Code Librarian, which I know came with at least Access 2000. As I am developing with ADP's I need a tool that I can use with this for managing my SourceCode, and tool I currently use appears through the AddIn's Menu, and is not there when using ADP's

the Form you want these data source on do you want to be able to update the data on 1 or all of the tables.

Hi, I have recently install Access 2003, and have just come to use the AddIns (SourceBook Program etc..), which were installed as standard with Access 2000... but in my Access 2003 install they are not there, does anyone know if this is an install issue or if MS have decided to no longer...