Search results for query: *

Here's the down and dirty. My db creates up to 4 batch files, runs all created files, creates messages and kills batch files. My problem is identifying when the batch files are done running. Before creating the messages, I need to know when all batch files are done. Doing a shellandwait function...

It's been a while since I've had to post a question. Was doing good for a while. Here's the situation. From Access, I'm creating an email to send. The email has 3 hyperlinks. I can hyperlink them using .HTMLBody but since the string as a space in it, I can't get the hyperlink to navigate to...

This is something I haven't tried before. Have a dbs that I need to extract data and input into a specific slide on a ppt presentation. Slide has custom background we're required to use but the data has an embedded excel spreadsheet. What's been done in the past was to update dbs, update excel...

It's been a while since I've posted here but you all have been awesome in your help. Here's my new project. Form is opened with a select sql statement as recordsource which selects fields from 3 tables. I want to add a field to the form to show who made the last change (have code already for...

It's been a while since I've posted here. Hoping to get some great help as I've always gotten here. I have 4 tables with delete queries and a few mismatch queries. Table 2 has a list of offices and table 3 has a list of the HR offices and contact information. Each office is assigned under a...

I'm getting pretty decent with my VBA writing but this one has me stumped. I'm importing a txt file into access. It's the basic "read one file and write another to import". When the records populated from the txt file are imported into access, those records have a specific suspense date that...

I'm not too versed in Excel VBA. I have a xls where I need to insert a column (E) and input formula "=right(D2,4)" and then copy that for all the rows that contain data. I do this each week and the number of rows changes. Below is what I have and been manually going in and changing the last...

Using Windows XP and Office 07. The below code is in a word macro to extract data from an excel spreadsheet. The value "MyPAS" is first a selection within a word document used as the search value to find in excel. What I can't figure out is how to program it to input a default value if the...

Using Office XP and Access 07. Access db runs script to open a word doc based off access table paths and for each doc, runs a macro and saves. Now I need the saved word doc renamed. In the filename, I need to search the filename for a 4 digit alpha-numeric code. I need to take that code and...

I have a word macro that separate different documents attached in one attachment. There are several different documents this works for. I use a word macro to split the docs and save individually. Part of the name saving function is to search the document for the last 4 of the agency code. I have...

I have a word macro that separate different documents attached in one attachment. There are several different documents this works for. I use a word macro to split the docs and save individually. Part of the name saving function is to search the document for the agency name by it's code. I have...

I got a code from another dbs that sort of does what I need. I can't get it to work though. Here it is: *************START CODE******************** Option Compare Database 'windows-defined type Private Type SYSTEM_INFO dwOemID As Long End Type Private Declare Sub GetSystemInfo...

Since I was kindly referred to go somewhere else and ask this question: I have a listbox linked to a table showing different ranges of numbers from 0-9999. What I want to do it have the user click on one option, then ok and open a form based off the number range filter. Form's RS is an...

I have a listbox linked to a table showing different ranges of numbers from 0-9999. What I want to do it have the user click on one option, then ok and open a form based off the number range filter. Form's RS is an updatable query. I've searched a bunch of forums and know this can't be that...

I have a word macro used for multiple word documents. These documents are saved as a .bkp from another system. Can't change that. Instead of having to open each individual document, I want to script something (familiar with access mostly) to open the first found document, run macro, close it and...

Again, I've searched but am limited on time to find the answer. Here is my code. Private Sub Command12_Click() On Error GoTo Error_Handler Dim stUnitName As String Dim stReportName As String stUnitName = Me.Admin_Unit.Value If Not [Admin Unit] = "ALL UNITS" Then If [Report Name] = "Date...

I've done some searching for this answer and only found similar ones but nothing that would seem to really help me. I have 2 tables [TblReport] & [TblAccounts]. The accounts table includes a field called agency and the report table has a similar field called case status. Case status has the...

I've done some searching for this answer and only found similar ones but nothing that would seem to really help me. I have 2 tables [TblReport] & [TblAccounts]. The accounts table includes a field called agency and the report table has a similar field called case status. Case status has the...

I know I'll kick myself for asking but I just can't figure this out. Not finding the answer searching other threads. I have a date field from a table reflected on a form. The field on the form cannot be editted. I need the background color of the box to change to red if within 30 days, yellow...

For those providing help, THANKS! Best forum I've found so far. Here's my next question: I have a form (ITF) whose recordsource is a query combining two tables. I need to add a checkbox to the form to flag returned notifications. I can add the checkbox but not use it. It either checks and is...