Recent content by retro

Brilliant! I knew I was missing something simple. Many thanks! :)

I want to be able to do something to several labels, e.g. make them invisible, using a FOR loop. They are all named similarly, with ascending numbers on the end, e.g. lblName20 Say I want to make lblName20 to lblName40 invisible. I need something along the lines of: Dim labelname...

Wow, that certainly works! Thanks! I'll take a look at the code and get an understanding of how it works. It seems to work pretty well, actually. There's a bit of a delay when it loads the full 40-pin chip then decides it only needs e.g. a 14-pin chip, but I can live with that :) For my...

There are no relationships at present as I'm trying to get my head around accomplishing the form update and there's only one main table and two lookup tables: tblPinouts PinoutsID [PK] PinoutName PinCount Pin01 Pin02 etc. tlkpPinCounts PinCountID [PK] PinCount tlkpSignals SignalsID Signal...

I'm making a database of (electronics) chips in Access 2010. These have varying amounts of pins - 6, 8, 14, 16, 18, 20, 24, 28, 32 or 40. On a datasheet, they are drawn as per the following image: http://www.beavisaudio.com/library/555/555_556_Pinout.jpg As you can see, the pin numbers run...

Despite having tackled it a different way, I'm still having problems with this! I have rewritten my Word template letter from scratch. When linking to the db, I used the DDE connection option (as some of my queries weren't showing up). I'm trying to open the Word document from a form in...

I have a Mail Merge letter in Word that gets its information from an Access database. If I open the Word document manually, I get a message box which says: When I select yes, the document opens up on the last record, and I can browse through the records using the navigation controls on the...

Thanks for the quick response, namliam! I'm having problems here as a colleague has pinched my mouse and I had to replace it with a Wacom tablet (not the best thing for Access!), but on the brief glance I managed to have before windows started shooting all over the place due to an...

I have a form, frmMailShot, which has an option group, grpMailShotType and two command buttons - cmdLaunchWord and cmdLaunchReport. The option group is used to select whether the mail shot will be the initial mail shot (value = 1) or a follow-up (value = 2). The command buttons select whether...

Thanks ByteMyzer! I had actually worked this one out myself, but was watching The Apprentice final here in the UK so didn't post before you'd replied. This is how I acheived it: I discovered that SHGetFolderPath is the way to do this in Windows. A bit of searching produced the following for...

Quite. However, Windows knows where to find it. Is there not an environment variable which refers to the location of My Documents? Something like %WinDir% or %ProgramFiles%. %UserProfile% isn't much use, as My Documents isn't necessarily in there (although it is by default). This must be...

I am using the Common Dialog API (http://support.microsoft.com/kb/888695) in Access 2003 to select a file. The following part of the code dictates the initial directory opened: Dim OpenFile As OPENFILENAME OpenFile.lpstrInitialDir = "C:\" Obviously, that opens in C:\, which I don't want. I...

Sorry! That's me being a combination of thick, half awake and trying to do several things at once! What I meant was that I have a LOOKUP WIZARD on the table, which gets its data from the query. Is that what you mean by table level lookups? I also have a form based on tblGames. Of course...

Ahh, whoops! That should say tblGames Now that I've corrected that, when I try clicking the drop-down on the combo box (on the table), it asks for a value. Am I able to assign the query to a combo box directly on the table, as I am trying to do? The value should be stored as GameSubGenre...

Hope I'm not too late for you, here. Firstly, you need to think about exactly what you want the PC for NOW, and what you'll want it to do in future... not only what you'll want it to run, but upgradability. If you want upgradability, then go for a board with PCI-express, DDR2 (use 667MHz btw)...