Search results for query: *

Thanks ChaZ

I am having a problem connecting a sub form to the Master Form in ACCESS 2016 on a common field that is also be recommended by the wizard. It keeps asking for a parameter value. please help. Thanks

Hi, I am trying to program a form in ACCESS and need some help with the following 1) The user selects a value from a drop down combo box 2) The value displayed in the combo box shows the description but not the code associated with the description. The combo box name is cmbCode 3) In a text box...

Thank you Borislav. What would I put in the parenthesis in ROW()?

I have two SQL tables with a one to many relationship. I will join on the common field . What I want to do is to pull the common field from one table and find the First, or top value in a filed from the "many table". Any help would be appreciated. Thanks[bigsmile]

Please explain a ranking query?

I am looking for some help on a VBA function that would do the following 1) I Have a table that has one of the fields that has multiple values (Field1). An adjoining field is called ranking and it has null values. Thus for instance the value 411 could be repeated 2, or 3 times in Field1 2) I...

Thanks Skip. That's the exact formula that I am using in EXCEL. However I want to emulate that function in Ms ACCESS. Any suggestions?

I am looking for some help on a VBA function that would do the following 1) I Have a table that has one of the fields that has multiple values (Field1). An adjoining field is called ranking and it has null values. Thus for instance the value 411 could be repeated 2, or 3 times in Field1 2) I...

Thanks

Old and new tables in SQL, right?

Recently my company migrated data tables from an inhouse SQL server to a remote server. As such the links that I had created to an ACCESS database no longer are valid. Does anyone have experience creating links to a remote server? Any help would be appreciated. Thanks