Search results

"if the user selects "Salary" from the combobox, then the form is filtered by the Field "Salary" for whatever value is currently in the field "Salary." Yes Bob, your above statement is correct - I hope I have explained it correctly. The combobox holds all the fields. Once a user selects a...

Hi Bob - I understand - it seems I underestimated the task. Well, if you have some time to kill later on - I would appreciate any sample - perhaps I can follow your example once you start it. Thank you for jumping in Bob!

Can anyone else advice please?

I am sorry vbaInet - but I am struggling to find where in the code it shows how to reference an actual field name through a value in a combobox?

Well - I actually prefer doing it the normal way; so yes! I have the database open, and I am looking at his code, I am just not sure which part I need to learn from so I can use it?

Hi again vbaInet! I populated the form using VBA just so I can learn how it is done. I am sorry, but I couldn't figure out where the link below addressed my particular issue? I am still learning so some of the statements didn't make sense to me. Can you post the particular example you...

Hello, I have a comboBox in a form. The combobox is populates in the code below; Private Sub cboFields_Enter() Dim oRS As DAO.Recordset, i As Integer Set oRS = Me.RecordsetClone cboFields.RowSource = "" For i = 1 To oRS.Fields.Count - 1 cboFields.AddItem oRS.Fields(i).Name Next i...

Thank You vbaInet!!

vbaInet - I have a question. I am still learning so please forgive my manifest ignorance. Is a database necessarily NOT normalized if there is only one table? In other words, can a database be normalized and have only one table? Thank you!

I have 14 fields including one AutoNumber as Primary Key . .

Hi vbaInet - sorry for the delay in response. I have only one table in the entire Database. The existing report references that one table. Thank you!

Hello all, I would be grateful if anyone can guide me on this. I have one table I also have a report based on that table. What I would like to do now is have a from with a multiselect list box that contains all the fields in my table. Then A user would choose multiple selections from...

Thank you so much Bob - I will follow your steps and see how that works! Ghudson - I am still learning so this is a stupid question - where does the code you posted go? I mean - what event makes it run? Thank you!

Hi Bob - it seems to work now. I didn't know HAD that I had to name the macro AUTOEXEC and no other name. Bob - what do you recommend in preventing the user from displaying the navigation pane? I don't want the user to be able to view anything other then the form. Thank you for already...

Ghudson - I found these instructions on the web for 2007 Northwind. 1. Open Access 2. On the Getting Started screen there are some categories listed in the left task pane 3. Click the one called Sample 4. You should see the Northwind 2007 template now in the middle of the screen...

Hi Bob - thank you for your help. I think I am almost there but not quite. I followed the example of Northwind as you suggested. When I open the database, however, no form opens. This is the first macro I've created so I am not sure what I am doing wrong. In the NorthWind Macro, I...

Hi all, I would like to find a simple way to help my users enable their macros. I currently have a database that displays a form as soon as the database is opened. The issue is the form will not work unless Macros are enabled. I would like to have a form with instructions on how to...

RIGHT! That worked perfect! I should have referenced the recordset clone! You are awesome Bob!! The recordsetclone was the one that was moving forward, not the actual form - that's why it kept adding the same number, right? Thank you Bob!

Hi, I can't figure out what I am doing wrong here. The ICounter part works, but the MySum part sums the same exact number, not the aggregate of the records for that field. I would be grateful for any help. Dim MyRecordset As DAO.Recordset Set MyRecordset = Me.RecordsetClone Dim i As...

Bob - as usual you have resolved my issue with expert ease :D Going forward I will no longer use spaces in Field Names. Thank you Sir!!