Search results

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...

I have a form that shows all records in a query, one field is called ProductType, In the header I have an unbound combo box that gets records from the product type table and filters the detail section of the form (all records) to the selection in the combo box. All is working fine but once i...

The move went as well as expected. We're all settled in finally. It's already too small though - our salesmen are real go getters. Wearing me out :) The app is working great, thanks again for all your help!

Hi Pat, Thanks for chiming in! I hope you're doing well. What I was trying to accomplish is a mute point. I fixed my data with an update query, I was attempting to be able for a user's mistake to be corrected with code. Instead I ended up writing the code to keep them from making the mistake...

I corrected some bad data and now there is no issue. I do t need the code. Still don’t k ow why it would not update the checkbox though. That’ll keep me up all night I am sure.

If QtyAvail =0 then the check box should be checked. If not it should be unchecked. This is for a completion form, so if there are none available to be completed, then the checkbox is checked “Marked as Complete.”