Recent content by slharman1

OK So i just found out that access is creating the ACCDE file even though it is reporting it didn't during the saveas process. That's a strange one to me.

Holy Crap!, I have a lot to learn about TAA any pointers you can give? (just got it installed)

Do you know if i have TAA, I thought all I have is TVA

Thanks Pat - TAA is my Total Visual Agent for backing up - correct?

And this: There is no accurate method to estimate the number of TableIDs the Access database engine uses during the process of compiling a database as an MDE. However, each VBA module and each form uses one TableID, as a result, if the database has 500 forms, and each form's HasModule property...

Yes it will compile but when I try to make the ACCDE file I get "Microsoft Access was unable to create the accde file" This is what shows up in the onscreen help file: This error is usually associated with compiling a large database into an MDE file. Because of the method used to compile the...

I have a front end DB that is 13,040 KB in size. I can no longer make an ACCDE compiled version to distribution. I have emptied and bunch of irrelevant tables (linked) but have a ton of queries not being used that I would like to be able to delete but I need to know if there is a way to...

Use LIKE in place of the = sign correct?

Thanks, Ill give it a try. I only have less than 3000 records

Thank you Pat, what if I need to use a portion of the field to see similar items in the data - such as: typing ST in the search box would show all models numbers with ST in them like this user types ST and the form is limited to: ST 304 ST 305 ST 306 and so on. Thanks

Pat, I hope this question finds you and yours doing well. I have a similar question on a bit of code you created for us, it is in Module 1 and it is Public Sub FilterByControl. I would like to modify this to filter based on multiple txt boxes at the top of my form but I can't wrap my head around...

If you’ll look, you’ll see that I responded to your post. Thank you.

Easy enough but...I am using the FilterByControl method in VBA to filter the records on the form and when I select the "All" selection I get the error that no items match "All" on my form. How do I use a if then in VBA to remove the filter?

This is what i have. The primary key from the table the combo is looking up is the first column and 0 length. When I say the combo is clear after selection is made I mean it is blank but applies the filter.

I think I've figured out why it is clearing, I am using it to filter the form so I believe it clears the combo box after the filter is applied and re-paints the screen with the filtered records - does that make sense? The combo box was made using the wizard. and gets it's value from a table, is...