Search results

Hello Here is the shell script i have (vbs) how do i run it in a module make function out of it??? Set WshShell = WScript.CreateObject("WScript.Shell") WScript.Sleep 10 WshShell.AppActivate "Microsoft Office Outlook" WshShell.SendKeys "{TAB}" WshShell.SendKeys "{TAB}" WshShell.SendKeys...

I HAVE A STRING A THAT HAS EMAILS EX: ABS@XYZ.COM,ABC2@XYZ.COM ... I need to convert it to format below ... how can i do this without manually typing stuff out? Dim recip(25) as variant recip(0) = "emailaddress1" recip(1) = "emailaddress2" e.t.c maildoc.sendto = recip

Hi here is the code it returns value of "-1" how can i change this to lets say "*"? 'Examiner ID If OP_ID.Value <> "" Then strWhere = strWhere & "AND (Operator_ID = '" & OP_ID.Value & "') " End If 'strwhere is just dim string ...

ok here is whats in my table Document ID UserName Age I need to have grouped UserName, Total count of DocumentID. Then i need to have age range count between 0 and 5, 10 and 15, 20+ .... basically, Username , Total DocumentID count for User, Range Count (0-5,10-15....) Thanks

I need to convert this into query: The code loops through the recordset and checks to see if the current records NDC is equal to the value of the previous record, If it is set the date to that record to 1 day less than the previous record, if it's not set it to 12/31/9999 The first date it uses...

I have an access database that a VB program links into to a specific table. There are dozens of people linking into this database. Since its separate VB program that links in i cant use auto logo off to do database maintenance. What can i do to create a workaround ? Is there a way in Access to...

Hi guys Here is the code can someone add to this so i am able to attach a document? like excel file "c:\1.xls" ? Function SendLotusEmail() On Error GoTo Ett_Trap Dim notesdb As Object Dim notesdoc As Object Dim notesrtf As Object Dim notessession As Object Dim ToName As...

Hi Guys Here is my issue i have form opens up with : DoCmd.OpenForm "contest", acNormal, , , acFormAdd, acWindowNormal Then i get new records i cant go back and see if there are any previous records. I want to link new form to old form by recordID. Kinda like subform but this time it has...

Hi I have a table audit AUDIT_QUEUE RESC Pre Ex COB RESC-x Pre E-x-x-x COB-x-x-x-x What i want is a query or code so that it reads the field and strips away all "-x" there might be more then 1 instance of -x in there so need to remove all of them. How do i do this? Thanks

Hi Here is the code i have need to condense it and combine it into one statement. Reason being by the time it gets to If Category.Value = "Department" the audit_que value already has -x-x-x ... in there ... how can i prevent audit_que from repeating -x-x-x over and over again? Maybe covert all...

Hi I have this table date, error code, user i need the output to be : User, Error Code, Month/Week1 Count of error code, Month/Week2 Count of error code ..... basically how do i make error code field as count with each week 1-4 for the month? Format([AuditDate],"mm-ww") create week but in...

Hi I have a from with this code under one of the command buttons: Dim pp1 As String If AUDIT_QUEUE Is Null Then pp1= pp1 & " Please Fill in Audit Que" & vbCrLf If [from date] Is Null Then pp1 = pp1 & " Please Fill in From Date" & vbCrLf If [thru date] Is Null Then pp1 pp1 & " Please Fill in...

Hi I am using access 97 need to refence value carsid which is a combo box tied to table... from the main form. Basically to check to see if null then ="123" how do i do this? Thanks!

hi how can i make query that selects the first match of a criteria, or multiple criteria. lets say list of members first record in CA only then first record in OR only .... basically select first record from list of criteria.

Hi guys here is the query, i use access 97. It groups just fine but i need to select to 50 records for each of the "[1].CLM00_ABS_PMG_ID" and top 50 based on "[1].CountOfCLM00_CLAIM_ID1" below is the query. It groups just fine everything is good just need top 50. Now just want top 50 records...