Search results

  1. A

    Open forms in dialog view causes problems

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

    Row Source repeating values

    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"...
  3. A

    Check if excel workbook is protected before opening it

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

    Setting focus after importing from excel

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

    Need help with DLoopup syntax

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

    Help with the DCount function

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

    Question Using Access as a medium to store files

    Hello I'm currently working on a database where users are allowed to upload documents. The documents get transfered to a server, and the links and all that get stored in a table, here's my issue. In order to write files to the server they have rights, I want the user to be able to delete...
Back
Top Bottom