Search results

Actually , in my description I omitted to mention that there is a Key column for which the numbers are auto generated by access and that column would be column 0.

Do yo mean that when using VBA I can shove anything, any type in that ComboBox and it will accept the value whatsoever without any consideration to the Control Source value type ? What about the linked Source, will it still get modified according to an invalid assignment still ?

Not quite, the Limit To List is Yes. My interrogation is rather based on the fact that whether I force VBA to assign a Long number or a text String to the combCategory ComboBox it will accept both and for it's proper corresponding field. If it is the column1 that is linked to the data table then...

I've been building this Access Database with Tables and Forms and I am now getting ready to turn it into a somewhat finish product. I want the Main Form to open in a User Only format. Meaning I don't want the user to access all the building tools and Access Menus. This is probably one of those...

Now I really feel ashamed:eek:

What I have done so far is quite easy. Anytime a user changes the Category ComboBox value I use VBA with a simple SQL query to update the SubCategory ComboBox recordset. My problem is not that it doesn't work, In fact, it works pretty well! What I want to do is when the user changes to...

I have two ListBox. LB1 is a Category selector, LB2 is a SubCategory selector. If the User changes the Category choice from LB1 a whole new set of Sub Categories must be updated to LB2 recordset. I also want the focus to go immediately to LB2. I can do all that with VBA, no problem.:) When a...

What is your YouTube channel? I'm interested

I have a ComboBox on an Access Form that is populated with a recordset comprising two columns. Column1 called lngCatIndex, a Long number and column2 called txtCategory, a corresponding text field. That ComboBox named combCategory is modified by a VBA command as such: combCategory = MyVariable...

I wish I had gotten those two links before. I would have saved me so much aggravation. This truly is an illumination. Now I have to understand the whole concept and implement a Query instead of working directly with my table, and probably get rid of those lookup in my table. I have a lot of...

When I create a Form using the Access2007 wizard and choose the Multiple-objects feature I end up with a form with a top section and a Detail Section in which there are multiple records from the linked table tabAmplifier. One of those tabAmplifier.fields is a ComboBox from the table itself. The...

When a User consult a post or a thread it would be of great help if he could return to his own User Statistic page and be able to choose amongst a list of all the posts that he viewed in date order. I presently am trying to find a post I looked at 5 days ago and cannot find it. With such a tool...

Thanks Ranman, No, there are no properties for that object because it does not appear in the Property window DropDown selector. The object I am referring to (if it is an object ?) is the search field on the very bottom of the Form. It is not an object that I have put there myself, it is...

When you create a brand new form with the Access Wizard, data from the linked table magically appear. That newly created form have a Search Field on the bottom. It is very useful and efficient. I need to run a VBA code when the user access that search field. I have been looking substantially on...

Just wanted to say hello to all and tell you a little bit about me. I am a half century young ;) In regards to MS Access I would say I am a beginner with a practice. I have been using MS Excel for as long as it existed and substantially using Excel VBA as well. I have used Access in the past but...