Search results for query: *

It's possible to open a Word doc, go: File->Send To->Mail Recipient and send the doc as an email. Can I automate this from Access using VBA? Pls also see related thread: thread705-1289920

Is this possible in code and if so how do you do it? I can get the text no problem; pictures are a different kettle of fish.

Hi, as per the subject I'm trying to copy text from a Word doco and paste into an email. Can anyone point me in the right direction? TIA.

I've trawled through all the posts on this subject in these forums without really finding the right answer. My situation is that I have a Form with a tab control, that has a subform on it (dont ask), that has a tab control on it, that has a subform on it. The problem is that when I go to a new...

A simple question I'm sure - I've created some ref integrity between 5 tables in total but on all of the links the checkboxes that allow me to set "Cascade Delete" etc are disabled. How do I enable them?

Hi, I have a bound form which contains a number of bound controls inc txtDate and txtTime. I'm trying to suppress the user moving to the next record if they only populate either txtDate or txtTime and not both of them. The closest I've got is to test the Dirty event on the Form BeforeUpdate...

Does anyone know what the max number of Access 97 seesions you can have open on 1 machine at any one time? Is it only limited by the spec of the hardware? Cheers.

Hi when I run a query containing several linked tables, little squares appear in the memo field in one of the tables instead of text. This only seems to effect the memo fields. Moreover if I remove one of tables in the query they disappear but there doesnt seem to be any obvious conflict...

Hi a number of tables within my A97 app are updated by a VB app. I have a number of forms bound to these tables, the idea being that once the tables are populated the form opens displaying the info. However what I'm finding fairly regularly is that the form will open displaying the data from...

Hi I'm working with A97 and am finding that an update query that I'm trying to run is very tempremental in that sometimes it works, other times it doesn't! The query is a very basic one invloving no WHERE clause and is along the lines: UPDATE tblTest SET fldField1 = 'Hello World' I run this...

Hi I've got a report bound to a table and a textbox bound to one of the fields in the report header. There is data in the field. If I run the report the data is displayed in the header as expected. However if I put some test code eg. MsgBox Me.DateRegistered in the Report_Header Format...

Hi, I have a subreport on a main report. On this subreport I have a running sum textbox called txtSum in the Detail section. In the report footer I have another textbox txtOverallTotal whose control source is set to txtSum in the Detail section. The textbox in the footer displays the correct...

Hi guys, I'm trying to add a new field to a table in a local Access database. Is this possible and if so what's the syntax? Thanks in advance.

Hi, I'm using A97 and getting the above error message on the following line: Set tdf = "tblTableName" & CStr(x) Access highlights the ampersand symbol. X has been declared as an integer and runs from 1 to 10 in a loop. tdf has been declared as a TableDef. Anyone shed any light on it...

Hi can anyone give me the lowdown on including this reference within Access applications. Basically my app crashes and generally misbehaves when this ref is unchecked and is very compliant when is checked. I'm interested in what it ACTUALLY does? Can anyone elaborate or at least point me to...