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

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

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

movin on! I wanted to update this thread for the sake of completion. I was not aware you need to end a SQL string in VBA with a semi-colon ";" - I had been NOT doing this in the SQL query editor in Access for the longest time, and apparently it puts it in for you if you forget. Well, I was not...

still no go That's a good suggestion, and I had tried it previously but I just tried it again and it's still doing the same thing. With the warnings on, it tells me it's going to import 0 (zero) rows, but when I run the same exact query from the SQL view of the query wizard it tells me it's...

hmm I'm not sure about that. I've just discovered that it works just fine when I run it from the query wizard in SQL view... but it doesn't work when being used with currentdb.execute. I have no clue why... and it's pretty damn frustrating because I'm trying to automate this so I don't HAVE to...

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