Recent content by accessrookie2

I will check, but I do not think that is the case. I can still do things such as close the box or drag the title bar (even though clicking on it does not change it to the normal dark blue windows xp color - it stays the inactive light blue). I believe if there was a hidden box I wouldn't be...

Hello, I'm running access 2003. When I set forms to open from my main form in dialog view it works as it should - it doesn't allow the user to go anywhere until they close out of that box. However, after they close out of it, sometimes when they switch windows including from the form to the...

Thank you - exactly what I needed!

Hello, I have a combo box that I want to list all the values of a column of a table in. Some values in the column are the same, lets just say there are multiple "Company" values. My combo box then list many different instances of "Company". How can I narrow it down so it only list "company"...

Hello, I need to check it a workbook is protected before it opens. Right now I basically have this: Set xlApp = CreateObject("Excel.Application") Set xlWb = xlApp.Workbooks.Open(WbPath) Wbpath is the path to the excel file. As soon as it hits the second line of code it opens the file and...

Thanks for the try but sadly still nothing. Focus is no where to be found, I can hit the tab key but it won't do anything. I'm thinking the users might have to do an extra click. Hopefully they won't miss the text box since it'll be on such a small screen.

Alright I need to set the focus to a textbox right after importing some data from an excel spreadsheet. It seems that after finishing the import, focus in no where on my form, furthermore even though the rest of the code runs it doesn't set the focus to the textbox. Is there a way to get the...

It says run-time error '2001': You canceled the previous operation I'm not sure what else to try, if it helps the values are: zColumnNumber = "F3" zNumber = "35" topBottomColumnNumber = "F5" zLetter = "T" EDIT: This code seems to work: DLookup([partColumnNumber], "ExcelTable"...

I'm getting confused with all the quotation makes and apostrophes. I have the second half of the criteria set up exactly the same as the first one. Do I have to combine them into the same string to make them work? Would you be able to help me do that from my code above?

Someone helped me yesturday put together this code that works: DLookup([partColumnNumber], "ExcelTable", [zColumnNumber] & " = '" & zNumber & "'") all the variables are strings if that matters. I need to add another condition in the criteria. I want it to return the result where the...

Thank you! I tried many possibilities but never added an "&" to the left side of the equation. It works now, thanks again (Also for the tip on the Nz)!

This is driving me crazy, this works the way I want it too: Nz(DCount([zColumnNumber], "ExcelTable", "F3 = '" & zNumber & "'"), 0) I want it to count the times that records under column F3 are equal to zNumber which despite the name is actually a string. Now here is my issue. Sometimes the...

Alright, thank you very much for your time, I will try to educate the users as best as possible to avoid this issue.

I believe we're trying to get away from storing objects in an sql database. I don't want to store them directly in access because that would cause the database to become huge overtime. I didn't find anything that helped me about the windows images group rights. If anyone has done something...

Thank you for the quick reply, I will look into the extra group priviledges. As for the bottom part of your post, I want the file to be deleted immediately if they do it through access, the problem is that if someone decides to look through old files to free up space on the server or something...