Search results for query: *

thread705-1272718 I would like to revisit the closed thread, above. It works great, but I would like to adjust it to loop through all PDF files in a specific directory, and merge all files found (perhaps merge to "Source1.pdf" in the example below). Can anyone please help guide me? Original...

I currently have a form that contains a command button, which runs a query (below). Private Sub Command60_Click() Dim qryLithLogLinks As Hyperlink DoCmd.OpenQuery ("qryTrendChartLinks") DoCmd.RunCommand acCmdOpenHyperlink DoCmd.Close acQuery, "qryTrendChartLinks", acSaveNo End Sub The query...

I had the biggest problem trying to set a "Read-Only" group access to my database due to a make-table query that is fired (in a vba script) by the "Autoexec" macro (anything in a macro with this name fires when the database is opened, automatically. The reason I needed this to fire each time...

I need to create a Word macro/vba script to display text to the right of a form field if a particular field value is select from the list of values. Can someone give me an example vba script?

OK, I got this hyperlink field to open with Adobe Acrobat as below, but I would also like it to hide the query's datasheet view of the hyperlink. I do not know how to set a query's visible property in VBA though. Code: Private Sub Command59_Click() Dim qryLithLogLinks As Hyperlink...

I am trying to have Access open PDF's via hyperlinks in a query, but from a command button on a form. It actually opens the correct record in datasheet view, and can then click the hyperlink to open in Acrobat, but get an error "Unable to open Query!qryLithLogLinks![Lith_Logs]. Cannot open the...

I have a Tab Control, "TabCt", which includes two Tabs (aka Pages) containing subforms(irrelevent though), "Tab1" and "Tab2". This is on a main form, "Form1", which includes a text box "txtbox" (names for example only). I would like to have the text box appear only when "Tab1" is...

I have a main form with a combo box, and a subform which is linked to the main form combo box, as a Child link. I have already synchronized the form to the combo box, through a "SetValue" macro. I have an identical field in both forms, based on a lookup table. I would like to limit the choice...