Search results for query: *

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...

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...

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...

I have an access report where i have a grouping that i need to have summed. How do i sum just a group (i have tried using Sum([Line Total]) but this does not just sum the group, but the whole list. Any advice would be appreciated. Andrew

I have tried exporting a report to a database and I have ended up without a visable report, although it does seem to exist (ie I cannot rename another report to that name)!. Does anyone know a workaround to this? Andrew

I have got an Access 2002 db and made one change earlier with A2003 and now when A2002 users try to open, db opens initial db manager, waits for a few seconds and then up comes error message along the lines of: Access has encountered an error and has to close, do you want to create backup and...

hi there, Trying to write a basic vba procedure to loop through a spreadsheet looking for duplicates (by first name and initials). Need to increment the row number, but have defined row as an integer. Does anyone know the best way to do this (is it using chr(20), chr(21)?? Thanks in...

I have a view made up of 6 underlying views that all need to accept the same date parameters from an Access Form. What I was thinking was to have one table that holds date values and is updated each time the form is closed (before running the report). These two values would then make up the...

I have a small network with 3 macs running osx This PC runs a software RIP called Best Colorproof, which drives an Epson Pro 4000 printer. The RIP produces virtual Postscript printers which are available over the network. Presently, the Macs all see each other OK. However, the PC does not...

I have a small network with 3 macs running osx This PC runs a software RIP called Best Colorproof, which drives an Epson Pro 4000 printer. The RIP produces virtual Postscript printers which are available over the network. Presently, the Macs all see each other OK. However, the PC does not...

I am having problems working out how to write a stored procedure to take the parameters for three underlying views that make up another view. It is for a report that has calculated views that are based on date parameters. Can anyone point me in the right direction??? Any help would be...

I have a fair amount of experience programming access (VBA, DAO and SQL), but have recently been given a project working with SQL server and cannot even work out how to put parameters into queries (or views). Does anyone know of any good sites with practical examples? I have found that the...

I have a fair amount of experience programming access (VBA, DAO and SQL), but have recently been given a project working with SQL server and cannot even work out how to put parameters into queries (or views). Does anyone know of any good sites with practical examples? I have found that the...