Search results

Figured it out after much trial and error! Dim wDoc as Word.Document Dim wTable As Word.Table Dim wCell As Word.Cell Dim wRow As Word.Row Set wDoc = appWord.Documents.Add(strDocLoc) wDoc.Visible = True Set wTable = wDoc.Tables(1) If wTable.Rows.Count >...

edit: crap i accidentally derped this post...

Yikes, I thought I had posted in the Word forum! My bad! Well, maybe someone might be fluent with Word VBA here, too.Since this is being run from Access VBA someone here might know something too. Adding changing "Selection.InsertRowsBelow 5" to "wDoc.Selection.InsertRowsBelow 5" doesn't do...

My end goal is to populate a pre-existing table in an MS Word document with records from a query. The easiest way I've found (through scouring the internet) is to start with the code below (ran during OnClick() even in Access) to get the table the same size as the recordset: Dim wDoc As...

Is there way a to get this audit trail module to work with a form in Datasheet view? It works fine with a form in Single Form view; I can open the table where the audits are saved and everything looks good. But when implemented on a form in datasheet view, nothing happens. I don't get any...

First thing: My db is on a different network, so I can't provide a sample. I can only provide a screenshot and retyped VBA code. :( In my DB, we task out our different units (squadrons/divisions) to do different things on a daily basis. We don't want to over-task them, so I created a way for...

I know this is an old thread, but I've had success by just adjusting the column widths in Layout View and then saving the form. That seems to work for me.

Touche, my apologies! I will look into this. It's too bad MS didn't think to add something as simple as borders to conditional formatting. :banghead:

I already know that lol. Unfortunately my leadership wants the borders changed for affected records, not the background color.

Yeah the report autorefreshes every 15 seconds and will be displayed up on a few monitors for situational awareness. What's the other technique?

On my report, I want rows with expired dates to stand out by having their borders thicker. Something like: If Me.txtDate < Date() Then Me.txtDate.BorderWidth = 6 End If When I do that, it ends up formatting every txtDate field in the report if one of them passes the If criteria instead...

Hmmm, that sounds like that would require a bit of manual work to maintain. I wonder if the "DateCreate" field from MSysObjects could be use in ID'ing each Form and Report. After all, I won't ever be creating more than 1 form or report in a second, so there's a very miniscule chance of having...

So, would you or anyone else have any thoughts on other ways to accomplish this?

Dang it Microsoft!! Y U NO AUTONUMBER?

Thanks for the reply! In my real database (on a separate network so I had to make the one in OP from scratch) the table's field is actually called "ObjectCaption". So I dont think that's the issue. Good catch though!

In my database, my "switchboard" consists of two listboxes: "Available Forms" and "Available Reports". The Available Forms listbox lists all the forms that can be accessed, and Available Forms listbox lists all the reports that can be accessed. I did this so that I wouldn't have to create...

In our enterprise environment, GPO forces all MS Office apps to disable macros by default until you click the "Enable Content" button in that yellow security message bar as soon as you open Access. When my switchboard loads, I want to force users to click the "Enable Content" button before they...

wouldn't changing the registry item require the user to have admin permissions on their box? this isn't feasible if your IT dept is worth their salt and doesn't let average users have admin rights to their boxes.

Any ideas? I'm stumped. :(

Our office needs a way to track reports that are due to us, so I'm trying to build an Access database to do that. What happens is this... We put out a weekly tasking document (called an AFCTO) every Friday that tasks our outside agencies (units) to do various things. Each task in the AFCTO...