Recent content by rokuk

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!!

. For future knowledge, and in case anyone was curious, this is what I did. Things that did not work: - Repair and Compact - Decompile - porting the DB objects into a blank DB - exporting the table and reimporting into a new table in the same DB What did work: - have a working copy of an...

. Hi there! I just read this as a suggestion elsewhere too, and I think it is definitely worth a try. I will attempt to reimport everything into another blank DB and see how things fare... thanks for the suggestion = )

hi! I can't, unfortunately... That's the first thing I thought of too. But I "should" be the only one making any changes to it other than a few others who use the forms to run automated queries and sometime muck about in the data table itself, but not with the DB itself, only the table data...

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...

Well, here's the thing. I am the primary DBA, but there are two other people who modify things also from time to time. Our main user base has requested this timestamp to pop up whenever they open to DB, so I am just trying to do it from there. The main user base only accesses the DB through...

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...

. Thank you kindly for your analysis! Let me ask some questions... maybe this will help. --------------------- On your first point (regarding departmentID)... this is what I was thinking. Consider the case if I add the following two assets: > an asset having multiple departments (lets just...

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...

. Huh. Imagine that. Well maybe I will have to go back and give it a second try sometime. In related news, I think I may have found a way. It's not a key shortcut, but it looks like you can add a custom button to the top 'database' group of icons for Queries. I hadn't played around with this...

Yes, I am using the 2003 - unfortunately. Wow, I can't believe there is no keyboard shortcut. That seems... slightly ridiculous. Oh well, shared misery is better than lone misery =p Thanks anyways all... :)

that's sarcastic, right? ; ) I've found the design panel to be cumbersome and confusing. I'd much rather just write the queries. Am I maybe missing something here? :cool:

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...

huh. well, I have what I want working now. I still don't understand the previous issues, but after playing with it, it is doing what I need well enough. I changed the qd.SQL line to: qd.SQL = "Select field1, field2, field3 FROM myTable WHERE qpp = '" & qpp & "'" And the...