Search results

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!

Hi guys. Does anyone know if it's possible (if so, how) to store a calculation in a table and run that calculation in VB? I have about 20 different calculations that I would like to store in a table rather than hard code them so they could be edited by a general user who knows no VB. For...

Hi. I'd like to let everyone know that I managed to find a work around for this issue. I'm not quite sure why this was necessary for it to work but here it is. I changed the opening of the clipboard to be inside the 'With Pic' block. I then added a msgbox that will ask the user to click...

Thanks tranchemontaigne. The code that will follow is the only code in the whole database. Here's what I have found out. If the clipboard is empty when the code runs, it actually does add the screen shot to the clipboard but it fails on the line: stdole.SavePicture IPic, strFileName '...

I'm attempting to save a screen shot of a form as a bitmap. My code works correctly sometimes but somethimes it doesn't. Here's the code: Option Compare Database Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long) Private Declare Sub keybd_event Lib "user32" (ByVal bVk As Byte...

:D That's awesome Brianwarnock. Everything as I requested. Thank you again! Very much appreciated.