Search results

Hi all, I am trying to give a few people a complex Visio diagram (many layers that get turned on and off due to user action). The problem is whenever I print it, it prints ALL layers, whether they are visible or not at the time. How can I have Visio print ONLY the visible layers? I want to set...

Hi there! I have a question using VBA in Visio 07 regarding hiding layers (having an issue with it). Is this a good place to ask, or should I be using another forum? My searching on Visio threads has come up pretty empty (unless I was doing it wrong?) so I wasn't sure... Thanks!!

Hi there. I have some forms set up to do searches on my Access 2003 DB table. The forms used to work fine, but now when I type in the parameters it finds no assets. Even if I go into the table and copy/paste a parameter directly into the search form, it has stopped finding the assets. If I...

Hi there. I currently have a switchboard automatically opening with some data and options whenever I open my Access 2003 DB. I would like to add a value on it that displays the last date that file has been modified (automatically, not by someone needing to go in and edit the timestamp...

I'm trying to re-design a database I "inherited" (gasp-shock-surprise, eh? :D). The current design has just one table with about 20 fields in it... I'm no database-design-fu black belt, but that sounds all kinds of wrong. I'm hoping to get some comments on my attempt at re-design. This...

Is there a keyboard shortcut to open a new query in SQL view? I find myself encouraging carpal tunnel by: > going to "queries" > "new query" > "design view" > closing the "show table" dialog box > right clicking the new query > finally selecting "SQL view". There has GOT to be an easier...

Issue Exporting to Excel w Recordsets Hi there. I am struggling with a bit of code and was hoping someone might be able to prod me in the right direction. Someone else set up an export function in VBA that later broke due to later modifications to the Access DB and I am trying to fix it...

Hey, I'm having trouble for some reason with this query. It's telling me it can't find the object "Deletions" which is a valid table. Directly above this I do another operation with the same table referenced the same exact way. Is this a syntax thing? 'this works Dim qryImportRecords As...

Hi there! I am new to VBA and trying to query an Excel spreadsheet to enter all the data into a temporary Access table. I am taking one step at a time though, and after reading this microsoft article on how to query a spreadsheet from Access...

Hi there! I am having a fair amount of trouble figuring this out, and I was hoping someone might know what I was doing wrong. Someone set up a switchboard (I think using the Switchboard wizard) in this Access DB. I've since taken on the project of automating a database process and I want to use...