Search results for query: *

Hi guys I have been trying to copy a file to a shared mailbox with no luck. At the moment I am just trying to move 1 file to make sure it works but going forward it will be around 100 a week in different folders. I get stuck at the copyfile part and it says: Run-time error...

Hi Guys I am currently having trouble sending keys (using Microsoft Access 2003) to a Application on Citrix, I can get focus on it (using AppActivate) however when ever using a sendkeys statement it does nothing, something to note is that the citrix Application does not appear in the start...

Hi Guys I am currently having trouble sending keys to a Application on Citrix, I can get focus on it (using AppActivate) however when ever using a sendkeys statement it does nothing, something to note is that the citrix Application does not appear in the start bar. Code...

Hi Guys Just found out how to access the Activity Log and noticed the following error come up every minute without fail, any idea what it means? RTB Not Responding

Hi, Im trying to view all info from both tables with links so if one table doesnt have a record the other will still show and visa versa. Im looking at a call centre and the times calls come in grouped by half hour(1nd query) and number of people signed on grouped by half hour (2nd query)...

Im looking to connect to a Aspect Call Centre using an ODBC connection. I can currently connect to our own site as it is configured in the tnsnames.ora file however this file is protected and can not be changed! I have searched high and low and cannot find a solution. From what I can tell i...

I am converting a worksheet to PDF using the solution from thread707-416330 how ever I get a argument not found error on PrToFileName argument of PrintOut, could this be because of i am using Excel 8? Anyone know of solutions other than sendkeys as this will not be possible. Code: Sub...

Hi guys, I am looking to convert a Access report to PDF using either PDFWriter or Distiller, Have searched the forums and all solutions seem to either point at changing the registry which doesnt work for me due to permissions or altering the printer port settings which i also dont have...

Hi Guy's Could anyone shed any light on why this would not work? If I put in a string which i know exsits replacing "Is not null" it works but is not null just wont work... If the PC username = Hartwei then bring back everything which isnt null else bring back my record only...

Is this possible at all?

We are looking for users to fill in a form within Access and with a click of a but it will open a webpage, transfer the data over to the relevant fields and click submit, I have tried searching the forms but no luck, could you please point me in the right direction or so me an example for...

Hi Guy's Trying to change a variable form's record source here is what i have (ive only included what is needed) Dim strSubFormName As String strSubFormName = Forms![frmIndex].txtSearch.Tag rs = "(SELECT * FROM tblMatrixCoreData WHERE tblMatrixCoreData.Accountno = " & strSearchValue & ")"...

could you please point me in the right direction for counting the number of alphanumeric value's in a field?, Had a good search through the forum but no luck so far, it is to see if the value entered in the search box is either a search for the surname or postcode, any other ideas on how this...

I am trying to change the filter of a date drop down when refreshing a pivot table via VBA my current code is as follows... Dim myweekstart As Date myweekstart = Worksheets("data").Range("D1").End(xlDown).Value Range("b3").value = myweekstart B3 is the cell ref of the drop down box in the...

I am trying to create a VLookup which will look for the date then move onto the next coloum and look for an ext number then bring that row back, i have tried putting a Vlookup within a lookup but no luck, this is how the pivot is structured Date EXT Data1 Data2 ETC 01/06 101 10...

Tech Spec.. Aspect 8 (or something) Seagate Info Desktop 7.5 we have a report that runs every 15mins directly to a excel file which M$ access links direct to so our agents can view there stats. Problem is now and a again (well most nights) all reports stops because this 1 report has "No...

I love seagate (In a way) and always have problems but yet feel as tho i have alot of ideas and solutions to give, its a shame no1 looks here anymore

I have had a good look around and could only find net use lpt1: "\\Server\Name" Cmd comes back sucessful but when going to printer folder theres none added

I am looking into showing the total time spent in each idle code on a canvas, i have tried showing dur_idle with a filter of reason_num but goes blank as soon as they come out of idle.

I want to send a net send to multiple people from a query, so it would take each record from a field untill the end, I have never done a loop before and have no idea where to start they query would be called FilterAgent and the field would be called RACF under access97