Search results

I found the solution. Basically I have used Word in the past with a Tablet PC. I have been able to use the inking function to draw pictures or annotate. But this does not work with a PC. So I needed to come up with a new way to draw freehand. I needed to open a word document and save it to a...

I'm looking for code to open MS OneNote and then save it to a specific directory/file. Is this possible? Thank you.

I would like help with VB Code to open a word document that already exist, and then save as a .pdf, and then close. I want to email various word documents but have to convert to .pdf first. I don't necessarily have to see the document at any time during the conversion. I just need to identify...

I'm using Acc 2010. I'm not sure where to problem solve my issue. In previous versions of Acc I used the following code to place the cursor at then end of text in a textbox. for example: Dim L as integer fng is the form Note is the textbox L = Len(fng.Note) fng.Note.SetFocus...

Hi Bob, Redid my code to your and it works great with Acc2007 full version, but does not work with runtime. I get: 429: ActiveX Can't Create Object. I'm not sure if i'm missing a reference or not. I tried MS DAO 3.6 Object Library as suggested by someone but it conflicts with what I already...

Thanks Drake, just saw your post. Yes, I have the declare, and it's pretty close to yours. I'm wondering if there is something different with Win7 that causes this problem.

Thanks for your reply, Bob. Can you see anything wrong with my code? I'm curious. I'm going to use your code. Thanks very much.

I'm wondering if someone can give me insight to a problem that I have. I have 3 db called AOMSChart.accdb, AOMSSurgery.accdb and AOMSLetters.accdb. I've run the following code from AOMSChart.accdb on Win XP and Win Vista systems without problems in both full Access 2007 and Runtime versions...

vbaInet and Bob, thanks for the suggestions. I'll check my code and apply what you have indicated. It may take a day or two to find out if this will work. Thanks again.

Yes, the subform is read only.

The subform is in datasheet view. Selecting a record in the subform opens another form that is unbound. Only info is loaded. Then when this form closes, it compares the data with the table in the subform and makes the necessary changes before closing the unbound form. But if that worker goes...

I have a form/subform. I want to unfocus or unselect a record on the subform. Even though I can use a .setfocus to another field on the main form using the timerevent, A record in the subform still stays selected. This causes an occasional write conflict if the same record is selected by a...

Bob, Thanks so much, it worked great. As an amature, I have shyed away from all of the 'dao.recordset' sytax because I don't quite understand it very much. Can you direct me to where I can learn more about it? Thanks again. You always make it look so easy.

I have a mainform and a subform. I want to run code when there are no records in the subform. How can I initiate this code? I've tried: If Not IsNull(Me(Form!Subform.Form!ID)) Then msgbox "Do Something" Else msgbox "Do Something Else" end If Somehow I cant get my code to acknowledge when...

Okay I got it. I open AccDB2 with ShellExecute(). In my case I control the caption of AccDB2 so its already known. I then find the Window Handle, hWnd, of AccDB2 thru the caption of AccDB2 using 'FindWindow'. Then using the hWnd, I close AccDB2 using 'SendMessage'. Please note you have to use...

I am able to get the window handle, hWnd, of AccDB2. I used the following code: Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As String) As Long dim hWndAccDB2 as string hWndAccDB2 = FindWindow(vbNullString...

Another thought. I'm able to open a word application and then close it with GetObject(Word.appplication) and wordapp.quit. Is this something that we can use?

I'm not a programmer, but I do think about things alot. Here's just a thought. You know the way you can close an application by right click -> Close on the bottom toolbar. Is this something that we can use? I'm not sure what what is involved with this code but perhaps something similar to that?

Bob, I'm able to open AccDB2 using Shell() or Launch(). Is there then a way to close AccDB2 once it is open?

Thanks, But didnt we use CreateObject("Access.Application") as you said. So are you saying that this should work? Or what else can I do?