Search results

I'll give it a try... You sort of asked two questions: 1. How to make a variable which equals a particular date plus one month. This is (as you already seem to know): varDate = DateAdd("M",1,[Service Date]) 2. How to make a query which returns all records where [Date1] is older (aka...

You can also set the Forecolor in the Property list. In Design View, double-click on the control in question, then find forecolor on the Format page of the property list. Select it, then click on the "..." box, and you'll be able to select a most wonderful color. Take care to select only good...

I've always done that in a more brute-force way; not as sure as the above, but for some of us boneheads it works: With the form in design view, I middle-mize the design view window, and manually make the form the size I want it to be and place it on the screen where I want it to be, then click...

Greetings, All. I'm trying to create useable runtime versions of a DB I've created, and I've run into a few odd questions. 1). Is there any way to set up auto-correction entries into a runtime version. I'm working in a world with a lot of odd jargon, and autocorrection entries are very...

Here's a quick rundown on arrays: Say you want to have a several values held in variables of the same type which you can call from code. You could give each variable a unique name like: Dim Name1 as integer, Name2 as integer, Name3 as integer, Name4 as integer and then your code would use...

Greetings, all. I'm trying to turn a db into a distributable runtime version, using A97 ODE Tools. It all works fine except for one thing: I cannot see how to set the Access system settings in the runtime version. Specifically, I want to turn off the "Action Queries confirmation" (found in...

Here's another thought... 1. Is there a comma separating the city, state and Zip? If so, you could a) Run a search and replace in Excel, changing all commas to tab characters (^t in the replace field). b)Export the Excel files as a tab-dilineated text file, close Excel, re-open Excel and open...

This shouldn't be too difficult. You've only got to make a statement that'll check the startdate of the job against the cut-off date between academic year and summer. Create a textbox, and put the judgement criteria in the control source statement. Presume that the startdate of the job is in...

I can't quite tell from your posting if there are a lot of different logos for the IT company, or if you're just talking about having one of two logos displaying, depending on the situation. If there are only two (or three) possible logos to display, you could simply place both logos on the...

Are the publisher names in the same table with the book titles? If so, it would be better if the publisher names were in their own table, with the book records only referencing the publisher names from the publisher table. With the publisher table separate and apart, it's easy to have a combo...

Russ I believe the date picker control you're seeking is part of the Access Developer's upgrade. I have the upgrade, and I have the datepicker (which I don't think I had before the upgrade). [Unfortunately, there's no easy way I see to determine if a control is part of the Developer's kit, or...

It's not at all difficult, but it doesn't work quite as you're describing it. You don't pass the textboxes, but you pass the data contained in the textboxes to subroutines. Look up "Passing Arguements" in the Access Help, and there's a rich abundance of info about how to do it. -Curt

Hi, all. Is there a simple way to set the position of a common dialog box? I'm using the activex commondialog object, and it seems to open wherever it wants to. I'd like to be able to tell it where to go! I've looked at the postings about using APIs, but I'd rather not have to write that...

Scottfarcus's solution is very correct and very accurate. What some of us seat-of-the-pants writers do is to un-maximize the design window for the form, manually place and size the form window, and save the form. This sets its' default to the last one saved, but you have to fool around with it...

Another way to edit forms from which you've removed the editing toolbars is to right-click on the form, then select the DESIGN icon.

The question is a bit unclear. What exactly do you want to do?

There's probably a half-dozen books on that in my local bookstores, though I haven't found any particular one I'd suggest. You could look at the code behind the Northwinds database, and several bulleton boards have sample databases with good code to study. And then there's the good old jump...

Thank you very much. The Len(Dir(filename)) test is just what I needed to make sure that the name of the path had been typed in correctly. -curt

Hi, all... I've got a little DB which needs to export and import a couple of tables from Excell97 spreadsheets. I've gotten all that to work just fine using TransferSpreadsheet, except that I can't figure out how to catch errors is someone tries to import a spreadsheet that doesn't exist in...

Hi, All... What is the protocol for returning a field of a particular record number in a query? I would like to pull up the field like this: For X = 1 to DCount(queryname) myString = DLookup([fieldname],queryname, "recordnumber =" X) 'mess around with that data for a bit Next X I just...