Recent content by handlebars

My mistake, pretty damn obvious! Many thanks Andrew

Donutman I have had a good sleep now:) I have a report in which I want do display percentages, so I need the result of the query to be a decimal and display it on the form as a percentage. The first post was a good workaround, but meant that i could not have the % on my report, which the boss...

I have created a little app to fire off an email to update staff details. One issue I have found when trying to implement is that the helpdesk have two accounts each running on Exchange. I have tried playing with the mailitem object, but cannot find the propery to set (the only likely ones...

SQLSister Could you give me an example of code, would it be: CONVERT(decimal,(2,2) (dbo.ResolvedInTargetCount.[Resolved In Target]) * 1.0) / (dbo.CallsResolvedCount.[Calls Resolved Count] * 1.0)) Many thanks Andrew

Thanks for you post James It is an ok work around, but how do i atually get a decimal from two intergers (i cannot belive it is so difficult!!!) Andrew

I am trying to work out what is the best way for staff to update HR with new and updated records from an SQL based Helpdesk system. I have created a basic app for manually searching for new/updated staff and automatically creating an email to relevent department. What I am now thinking is for...

Many thanks to Roy - its all about using the correct terms - database window! All i wanted to do was hide it completely. Cheers for all your relies. Andrew

Hi there Does anyone have a code snippett to hook into an open word application rather than create a new instance - cannot find in google or advanced search on this site! Thanks Andrew

I cant find how within code how to make the access switchboard (that contains objects such as tables and forms, etc) invisable. Can anyone enlighten me? Andrew

We are running SQL server with a web front end product. The system is a helpdesk management system and recently, it has slowed to a crawl when querying the database from either the web or the back end tables. In terms of data, we have around 10,000 end users, 50 analysts and currently...

I am trying to perform an update query on a table from a field in a related table. However, when I go to design this query, it will only allow me to use one table. Is there any other way around this? Im sure its possible like using MS Access, but cannot work out how! Any help would be...

I have used the following code: On Error GoTo Err_Command2_Click Dim stDocName As String stDocName = "OutstandingCalls" If IsNull(Me.Combo0) Then DoCmd.OpenReport stDocName, acPreview Else DoCmd.OpenReport "OutstandingCalls", View:=acViewPreview, _...

Is there any way to get access 2000 (sp1) to see functions, or will i have to rewrite as stored procedures? The adp opens fine, but functions are not even visible. Thanks Andrew

I have a query that I cannot get to work that adds up line totals, then adds additional percentage charge, and subtracts a percentage discount from that total. Should my solution be a query of a query of a query (seems messy) or can anyone suggest an appropriate way of doing this. I have tried...

I have the following line in sql: CAST(CONVERT(int, dbo.ResolvedInTargetCount.[Resolved In Target]) / CONVERT(int, dbo.CallsResolvedCount.[Calls Resolved Count]) AS decimal(3, 3)) AS [% Resoved in Target] but when i go to run it, i get the error message: "arithmetic overflow error converting...