Search results

  1. A

    Scan documents into table

    Is there anyway to scan documents and save them in an Access table? As of now we scan them and save them to a folder on the network. Then go into Access form to add them into the tables. Would like to automate this process all from Access but have know idea how to go about this. Any suggestions?
  2. A

    return all records if combo box is null

    OK here it is SELECT LoanOfficers.LoanOfficerID, Entities.EntityID, [fname] & " " & [mname] & " " & [lname] AS Individual, [Company] & [Individual] AS Borrower, LoanOfficers.LoanOfficerName, Entities.ReviewDate FROM LoanOfficers RIGHT JOIN Entities ON LoanOfficers.LoanOfficerID =...
  3. A

    return all records if combo box is null

    I tried your suggestion and still got nothing, any other ideas? thanks
  4. A

    return all records if combo box is null

    I have a form that using a combo box to select specific record, sometimes we need to see all records, i would like if the combo box if left empty to return all records. I typed this expression but it returns no records when combo box is empty...
  5. A

    Link PDF files

    Thanks so much that worked great!
  6. A

    Link PDF files

    What would be the best way to link pdf files in an Access database form? For each record there could be more then one pdf file. I would like to automate the process as much as possible. The pdf file would exist on a network drive and the user would need to go to their record in Access and...
  7. A

    Confirm Data Source

    that what i was afraid of, not a programmer so i guess i will just leave it the way it is for now, thanks
  8. A

    Confirm Data Source

    I am automating a mail merge with Access to Word. Does anyone know how to stop the Confirm Data Source dialog window from coming up and just except the default (orginal) data source? I have users that do not know they should just click the OK button, some are clicking NO and then I lose the...
  9. A

    Mailmerging Word Documment with Access Query

    push the query results to a temp table in access and then you will be able to select the table from the list of datasources
  10. A

    Format issue

    Brian, your code works great, now they just select the range and run the macro using a button on the toolbar. Thanks
  11. A

    problem with linked excel table

    I checked the versions, and they both have 2003 but one has SP2 and the laptop does not have any sp. The one that is not working is the one with 2003 SP2. Why would the SP make the excel link in Access behave that way. More important how can i fix it? I will go to the Knowledge base site and...
  12. A

    Format issue

    Hello MaTT I dont know AutoCad at all, I am sent the file via email in an excel file, the file is then linked to access, but the field is a text in excel and access needs it to be a number field.
  13. A

    problem with linked excel table

    Does anyone know why when i have a link excel spreadsheet in my access database i am not able to edit the data? I have a copy of the database on my laptop and it works fine, i can edit and add data but the office copy which is on the network it will not let me edit the linked spreadsheet in...
  14. A

    Format issue

    thanks Shades I was thinking along the same thing and i created macro but i like your idea about not having a 1 in a cell but in the code instead, i am not good with vba could you tell me how to do this. Here is the code from my macro. I would assume its a simple fix on the line that points to...
  15. A

    Format issue

    Help!!!! I have a shared exel spreadsheet on the network that is set up with Field names and formated the so the number fields have a number format and text is text or general fields. The data is sometimes entered in manually and sometimes the data comes from AutoCad. It seems when coming from...
  16. A

    Calculate Median value

    Here is a table that has a sample of questions with their rating, this is a survey database. I need to find the median for each question. Your function will work if i create a query for each question and then put your function in a report or form. I have 99 questions. would like not to have to...
  17. A

    Calculate Median value

    more help please? Thanks, i got it to work in Northwind but can not see how to apply in my database. I have a survey database. My table's fields are surveyID, questionID, and rating. I have a groupby query that groups my questions by category and then returns the average for the rating of each...
  18. A

    Calculate Median value

    What is the easiest way to calcuate a median value for a group of values?
  19. A

    Clear option box

    Thanks mhartman, that works great! Mstef i will take a look at your sample db too Thanks to all!
  20. A

    Clear option box

    I have a form that has two option groups, when the user selects one from the first group and then decides to select one from the second group i would like the selection from the first box to clear. In other words only 1 option group can have a selection at a time. I tried an IF statement that...
Back
Top Bottom