Search results

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=55729

Actually, just reading your example, which is a little different from what I inferred from the start (That should teach me to read the whole thread!) What you're after is Cascading Comboboxes. There's are thousands of examples of these on the forum, if you do a search.

Well, it won't show a message to the user, but it will restrict their choice to the options in the combobox. If you want to do a message, then these lines: Private Sub YourComboBox_NotInList((NewData As String, Response As Integer) MsgBox "The selection is wrong.", vbExclamation +...

As above, then.

Is this combo in a table field or on a form? If a form, then you can set the combobox's LimitToList property to Yes and, in the OnNotInList event, the following: Response = acDataErrContinue

First things first: are you replicating these spreadsheets like for like in an Access table, or have you taken the necessary steps to design/normalise your data into a set of tables in Access?

Or even: DoCmd.OpenQuery "QueryName"

Perhaps evaluate the user input in your control's BeforeUpdate property. i.e. Private Sub YourTextBox_BeforeUpdate(Cancel As Integer) If Me.YourTextBox > Me.TheQuantity Then MsgBox "That's too much stock for the quantity", vbExclamation + vbOkOnly, "Too Much Stock" Cancel...

If you're getting the Too Few Parameters error then it's likely you're going to have to look into the QueryDef object and its Parameters collection, as it sounds like the queries you are trying to open need their parameters defined.

Answering my own questions now. Basically, here's my new AppForm class. Option Compare Database Option Explicit Private WithEvents frm As Access.Form Public Sub SetAttributes(ByRef param_frm As Form) Set frm = param_frm With frm ' some general form attributes...

Okay, I'm sick of designing forms whereby I have to go through their individual settings and set things like PopUp to True or RecordSelectors to False. Therefore I want to create a form class that, in the Form_Open event will do all that form me for every form. So, I've got a class called...

Of course it would have hard a defence force. Just not one backed up by nuclear weapons.

It's precisely because we have our own parliament and they work in our interests that we get free presciptions, tuition, etc. The claim of Scotland being subsidised is untrue as Scotland generates far more cash than it is allowed to spend. All tax receipts go back to Westiminster. Our...

It's what's needed. Indeed. Otherwise we'll be demanding a referendum again and the sentiment will be even stronger. Depends. Not seen any evidence of the fag packet it's been written on. If Devo-Max had been on the ballot, that would have been the way to go, to be honest.

The option they've pulled out their ass in the last week is certainly not Devo-Max, which is how some are reporting it. Devo-Max is everything devolved, with the exception of defence and foreign affairs. I must say, the atmosphere in Glasgow is special. There's a real buzz about the city...

The UK only bailed out a portion of RBS. The UK portion of bailing out RBS and HBOS was £65b. However, bailouts don't come from where the business is registered, but from where they have economic activity. That's why the US Federal Reserve bailed out RBS and HBOS to the tune of £400b. The...

That's also true. Worth the risk, in my opinion. What would be guaranteed is a government making decisions for its people with its own money; not the pocket money its granted. I don't think that has any bearing on the subject of Scottish independence.

The only problem there is that there is no DevoMax option on the referendum card and there's not going to be DevoMax after the referendum, since the vague promise of 'more powers' does not constitute DevoMax. Plus, no further referendum to the rest of of the UK on whether they wouldn want to...

Bit messy, as just cobbled it together, but this may help. Personally, I think it would be better if the forename and surname were stored in separate fields.

As I said, an UPDATE query. Change value to Felix Hernandez. Set criteria as the field in question = HERNANDEZ JR, FELIX / BRADY, ANDEL