Search results

Thanks, I used the first code because it was provided in a course on Access VBA. But since it throws an error I can't go any further with it. Since I'm not familiar with the code that I will need to connect to and query into one of the tables in the file - I wouldn't know code I will need to...

Hi, the table is in the file I currently have open in Access.

Hi All, I have Access 2016 and am attempting to make a connection to and query a table. I tried this and got a compile error: DIM rst as ADODB.Recordset But this is working: Dim rst As Object Set rst = CreateObject("ADODB.Connection") Any suggestions on what the script would look like from...

Thanks DBguy! I got it. And Uncle Gizmo - love your web-site! :-]

Hi All, I have a subform within a form - which I've added a calculated control (text box) It is simply the formula avg([UnitPrice]). I've named this control "UpAverage" But the subform is in datasheet view and displays the average prices in every row. So I've made this control invisible. Then...

Thanks all! I wanted to make sure there was a way to convert it from a MAKE query to a NON-MAKE query. And yes, by opening it in design mode and then toggling off the MAKE button - and then re-saving it - it converts it to a NON-MAKE query

Hi All, When one saves a MAKE query - it is saved in the navigation pate with an exclamation point. I know that one cay open this in design mode and run it in datasheet view to change it back to a NON-MAKE query. And then re-save it. But it is still saved as a MAKE-query in the navigation...

Awesome! Thank you - it made for a cross join by default - or Cartesian Product. Thanks! Funny - I've been using Access consistently for about a year now and I'm just getting around to noticing that!:confused:

Hi All I have these three ultra simple tables. When I add Table_A to the query editor with this query SELECT TABLE_A.[TABLE_A DATA VALUE] FROM TABLE_A; It returns 6 records - which I would expect. However, when I add TABLE_B into the editor SELECT TABLE_A.[TABLE_A DATA VALUE] FROM TABLE_A...

Thanks June7 - I'll take a look at that!

Hi Tera and thank you. I am familiar with creating a new table from the template of the current one and then loading that table and adding the autonumber - which would reset them. I've done that before - but only after the dataset has matured enough to ensure I wouldn't have to do it more than once.

Thanks very much! I can live with gaps and such in the IDs But I am curious about what you mentioned about generating a custom unique identifier as a common topic. What is the most common way of implementing that? Thanks

Thanks I think the both of you are kind of responding to the same thing. Does it really matter if an auto number is missing sequence or there are missing numbers. I guess it is true that to an end user in most cases an auto id may not even be visible so it won't matter to them. I guess the...

Hi All, I'm building a new database and one of the tables I originally created with the ID field as an autonumber. However, it became obvious as I continued to refine the DB and add data to it - that the autonumbers are now out of sequence and there are some missing numbers. So I changed the...

Interesting! And thanks. Well that is what I did try alright - but with Access continuing to crash. I'll keep tinkering around with it to see if I can't get it to work. Thanks for that!

Beautiful! It worked nicely! Thanks very much!!

Hey Gasman, What kind of form did you use it in? I have a suspicion the ApplyFIlter can only be used in a datasheet form.

That's very kind! Thank you theDBguy!

I'm familiar with a few different languages and have used VBA in excel for a number of years. But I've never done anything with macros in Access before, and I would really like to have some hands-on experience. That's why I was hoping to find a book on it. But even the Access 2016 Bible...

Thanks, I wouldn't want to go to that trouble. I'm just playing to get myself familiar with macros. If however you do think of any resource on macros in Access 2016 I would love to look at it. I have a small kindle book on it but that has one or two macros at the most in it. And so it will...