Search results for query: *

HughLerwill, worked like a charm. You are the man!

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

Looks like I figured it out. Here's what I ended up with: **************CODE START********************* STR = "<a href='file:////server/path/folder'>whatusersees</a> **************CODE END*********************** Can't believe it was that simple. Thanks guys.

When I hover the cursor over the hyperlink, it doesn't display the same as when I manually assign the hyperlink. It also doesn't work.

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

I haven't had much time working with it. I know I could open the ppt using vba and was thinking of using on "on dirty" instance for a recordset to open and update the slide. Not sure if that's the best approach but not sure how to with an embedded excel. That's where I start to get lost.

I have a powerpoint presentation that has an embedded excel spreadsheet. I need the data from access to open one specific slide and update the excel spreadsheet on that slide. I tried to recreate the custom background in an access report but the field sizes for the data don't adjust according 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...

It's 2 work days but we have some days that the office is closed and those days are not counting and holidays are also not included so it seems easiest to manually input what date to use.

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

Have you tried to open the note records as a recordset and then set the spellcheck to a loop.

GlennUK...You da man. Works like a charm. Thanks.

I have to login to another system that exports the data via xls. Before I can import the data into access, I have to tweek it to match with the tables. There is not an option in access (that I'm familiar with) that allows me to automatically input a column and trim another column to use the...

That chooses everything in that row. I did forget to mention that this spreadsheet (after editting) is used to append an access table. If the code is used in rows with no data, it causes an error in my dbs. This is why I need the formula to reset the last row by searching for the last row with...

That selects everything from that column down to the last row but also includes all columns right of selected start position.

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

Skip, You are the man. You saved me a lot of heartache. Tried to figure this out on my own for 3 days straight and you did it in no time. For those who can use it, below is the final working code: Function CheckAdminName() On Error GoTo Error_Handler Dim xlApp As Excel.Application Dim...

Didn't work. I think my biggest problem is the err 91 runtime error. The code won't catch the "" value the first time around but the errorhandler for err 91 gives the .find a "" value everytime afterwards. I'm way over my head on this one.