Search results

Hello! I've used unbound combos on several of my forms and am wondering how to get them to display their multiple column values (either default or selected) fully. When a user clicks on the drop down arrow of a combo, all columns (aside from the hidden one) are displayed apart from the main...

hi there! I have a subform imbedded in a main form. The main form has a one to many relationship with the details in the subform. The subform's properties are set to Single Form rather than Continuous Form. The main form is a Booking Form and the subform is a booking status form with the...

Thanks Bob, I've been reading up on subforms and have begun building my mega form with all its subforms. So far so good though still a long way to go. I have set the Allow Additions, Allow Edits, and Allow Deletions properties to false as you suggest but for my main form and to occur only once...

Hi there! I'm attempting an ambitious form or maybe its quite straightforward, perhaps someone can advise me please: I am trying to create a powerful form that will have access to data from 8 tables. They are all interrelated via foreign keys and one to many relationships. 3 of these tables I...

Thanks both Bob and Roy - my coding problem is now solved! The type mismatch did stem from using bang (!) when referring to a property. Not only does: DoCmd.ApplyFilter , "[Office ID] = " & ONumID work, but so does: DoCmd.ApplyFilter , "[Office ID] = " & Combo48.Column(0) Hurrah!

I've the following piece of code that works fine in one form but throws up a runtime error message '13' that says 'Type Mismatch' in another form. The code is: Private Sub Combo48_AfterUpdate() Dim ONumID As Integer ONumID = Combo48!Column(0) DoCmd.ApplyFilter , "[Office ID] = ONumID" End Sub...

Thanks Brian - it now works fine. Thanks ajetrumpet - I've noted your comments in my VBA useful tips file!

Hi there - I seem to have a data type mismatch or something - the following simple If...End If statement is not working: ... 'Check House Name/ Number and Postcode are populated: If Me.House_Name__Number.Value = Null Or Me.Postcode.Value = Null Then MsgBox "Both House Name/ Number and...

I've refined my While.. Wend and DoCmd.GotoRecord idea and it works albeit clumsily: Its a real sledgehammer solution to the problem, but it does mean I can move on to my next VBA job, however at some point I will definitely want to improve on this. The following code retrieves the correct...

Well it worked for a short while then I added a new record and then it stopped working... aargh! The single form idea did work (and without your Docmd.ApplyFilter code) but only briefly. I have since tried using your code but there's a problem with the following line: DoCmd.ApplyFilter ...

Hi there Coyote, One form is a simpler solution with the combo at the top - I have tried this and it now works. I can now move onto my next Access task. Just one more question: my combo has 4 columns (one hidden) and is based on a query that sorts the data within the columns. Once a user has...

I've been going round in circles for a while with this one and I'm sure there's an easy solution - I just can't see it!! Anyway, I have two forms both based on the same table: Property which has a primary key "Property ID". Form1 asks the user to select a property using the a combo button. The...