Search results for query: *

Hi all, I'm trying to write a macro in Excel that will all instances of a word and replace it with an image. Any ideas? Is this possible? Ideally I'd like the image to be anchored to the cell that the word was in. Thanks, Mitch

I'm trying to write a query using LIKE. I know how to do this when I'm comparing a field to a string, but how do I do this when comparing a field to another field? So where we do this: WHERE table1.field1 LIKE "*joe*" How do I do this: WHERE table1.field1 LIKE table2.field2 Any ideas...

Hi all, I had a form which consisted of a single page (one 'tab') and now I've added multiple pages. I now get an error for the following code: intCurrentLevel = Me![Current Level] This line of code assigns the value of 'Current Level' to the variable intCurrentLevel. I think the problem is...

I have a linked table that is sourced from another access DB on a different network drive. Under the table properties it is linked using the drive letter that I have mapped. When other users try to access the table, it errors out because they have the network drive mapped using a different...

Hello, I'm trying to write a module that opens up a template in Powerpoint and inserts data into it (data pulled from an Access table). I've done similar things with MS Word using Form Fields and/or Mail Merges, but was wondering how I would do this with a Powerpoint document instead. I know...

I need to create an Outlook form that includes a drop down combobox of options. When the user picks one option, it populates the body of the email with specific text. When user picks a different option, the body is populated with different text, and so on. Has anyone tried this before? Any...

All: I have this code in Access, which starts a timer, and after 15 seconds, the loop ends and the rest of the code is processed. Problem, the program locks up while this is looping... Any suggestions? ........ Dim PauseTime, Start PauseTime = 15 ' Set duration. Start = Timer ' Set...

Hello, Anyone know how I can create a msgbox in Access that does not require a user response? I have some code that runs, and as a part of it it pops up a message to the user. Problem is that the code haults until the user responds. I do not want it to halt. Is there any other kind of MsgBox...

Hello, Does anyone know if it is possible to send someone an Access query and/or report? Basically I have an Access DB with a query/report in it. I want someone to be able to run it without them actually opening the database itself. So what I am wondering is if it is possible to send them...

Does anyone know how to make an asterisk literal in a MS Access query??? We've tried encapsulating it in quotation marks, etc, but it hasn't worked. Any help is appreciated! MitchJP

Hello, The OnClose event procedure applies to forms and reports in Access. Is there a similar event procedure that applies to the database itself? I want to prevent the user from closing the entire database (by clicking the 'X' button in upper right corner, or choosing File>Exit or File>Close)...

Hi all, I have a edit form which inlcudes an option group (say, 1-5 options). Let us assume a user has looked at a particular record and selected option "1" (or the first radio button), then saved the record. When they choose an option, a value is stored (say, when they chose the 1st radio...

OK, I need to delete some records when a form is closed. When the form is closed, I have a module run, which will inlude the code to delete the records. The records to be deleted depend on what the user entered into a certain field on the form (say the form field is called "Number")...

Hi all, What MS Access Control (or whatever) determines where a field is located on a form? I want to be able to move fields around on a form based upon a users response to a question. I tried 'Top' and 'Left', but those didn't seem to work. No matter what value I assigned them they always...

Hello, I have an Access form (developed with Access 2000) and I need to make certain fields Required based upon what choices the user makes in another field. So, they choose via a series of radio buttons, and depending on which option they choose, certain fields need to be made required. How is...