Search results

But what would a switchboard give you that the form isn't? Isn't a switchboard basically a form that displays user options?

You'll have to jump through a few hoops to get this to work the way you want it to. I think it's possible, but why not just place "111222" in like a label next to the combo box and place the suffices in the combo box? See the attached picture. By using multiple columns, the combo box can still...

Isn't that just like a switchboard form? :)

What exactly did you expect?

Have you tried just changing the name of the table to the name of the query?

How many possible booleans could you be storing? This isn't that uncommon. Visual Basic uses this same technique when storing multiple user options in functions like the Excel inputbox method.

Don't know that much about ftp, but what about mget? It might not be all that useful without some way to narrow down the filenames, but it could be useful.

Well that's strange. The Replace() function worked for me in Access 2000 exactly the way I expected it to. I created a calculated column like this: Changed:Replace([MyField],"Smith","Jones") It replaced all instances of "Smith" to "Jones" in MyField.

Why not split your table into two separate tables? Shipping addresses and billing addresses?

The .SelText method returns to you the text that was selected. It doesn't set the value of the text box. To do that, something like: Me!subformName.Form!ControlName= "Inactive" Read Mile's FAQ: Syntax for Main and Subforms

I can't say for sure since I did not send the query output to a report, but I don't see why not.

Have you tried a totals query? Look under "Calculate a sum, average, count, or other total on groups of records in a query" in the Access online help.

Some of the solutions I'm thinking of require coding the SQL statement, then setting the controlsources of the report controls. But why be some complex about it? Why not use the Access report wizard?

There are a few methods, try this thread: Age bracket query

Then it's best to have code in the On Exit event of each field that requires input. Check for a valid entry before letting the user proceed. I would point the On Exit code of each field to an error checking routine that checks all the fields in turn. If it passes the error check, then I would...

LOL! That's more likely the case here!

A simple way is to exit the sub if an error condition is found: Private Sub cmdCheck_Click() If IsNull (Me.RevDate) or Me.RevDate = "" Then MsgBox "You must enter a review date", vbOKOnly, "Required Data" Me.RevDate.SetFocus Exit Sub End If If IsNull (Me.ProvCd) or Me.ProvCd = ""...

That could be it. What version of Access are you running?

Forms("Main Form")

You can store the order of topics in a table and use it in a query to generate your form dynamically. It's not that different in concept from when you have a many-to-many relationship in your data. You have many topics, you also have many different courses to survey. Set up a course table with 3...