Recent content by Cullihall

Now I just have to figure out the password for the locked VBA

That it awesome! It worked! Thank you so much everyone, especially AccessMSSQL. :D

This database has a splash screen that I just noticed that if I double click it, it asks for a password. I guess there is no way I can get this into edit mode without that password.

It's an .accdb file. I've never seen a file like this locked down before. I cannot access anything in it. Cannot even use the X to close Access, have to use the exit button that the user has on the form. No keyboard shortcuts work.

Someone else created this. When I open it it does not prompt for a password but if I try and create a new database and import objects from the database in question, then it won't import some object because of password protection. Probably the VBA.

Hey folks. I have a database with extension .accdb. When I open it, everything is locked. I can't access VB Editor, Navigation Pane, Ribbon, nothing. It just opens a form and the only thing that can be edited are the text boxes on the form. I can't use Shift when opening it, that does...

Thank you pbaldy!

Hey guys. I normally filter text fields in queries using combo boxes on forms to show all records. So I set the default combo box value to "*" and use query criteria Like FORMS!MyForm!MyCombo How can I achieve this for numeric fields in a query? I want to have an option in my combo box...

Awesome Poppa Smurf! I really appreciate the fact that you put the time and effort into this for me. Your code accomplishes in seconds what was taking me about 5 minutes. Thank you very much. This site is the best!!!

Thank for your replies guys. Sorry for not posting SQL of the query. I didn't because I am not sure if the issue is in other queries. I have 4 transactions tables (t_TransactionsMon1, t_TransactionsMon2, ...3, 4) for each day so I can keep a 4 week rolling transaction history. If today is...

Hey guys. If someone can find the time would they please have a look at the database I have attached here? What it does is calculate average cases shipped for each day of the week from 4 tables for each day which contain an average or 15,000 records each. There are queries that also has to...

Excellent. Thank you again ChrisO!!!

I apologize, I am not explaining clearly. Let me try again. I have a formula (stockoutRatio * stkoutAdj * 100000 * hrsInFctn)stored as text in a table. At the beginning of my code I declare variables with the same names that's in the formula. I use the DLOOKUP function to popluate these...

Hi there. How would I go about adding the value to the stockoutRatio variable that's in the calculation, from a variable with the exact name in which was populated with a value earlier in the code? For example, in the sample from ChrisO the variable is being filled with a lookup function...

Thank you very much ChrisO. That is exactly what I'm looking for. You are the best!