Search results

  1. A

    Scan muli-page document in Access database

    I was wondering what type of scanners are being used. Im looking to setup 3 users with some kind of desktop scanner on their desk. Does anyone have any recommendations?
  2. A

    Object variable or with variable not set in ADP

    New to ADP I use this module in access 2003 and 2007 in mdb format. When i try and use it in ADP i get "Object variable or with variable not set" Can someone point me in the right direction Thanks ________________________________________________ Function test() 'This function looks at...
  3. A

    Remove Text from a field based on a table

    looking to have the suffix removed from the street name based on what data is in the suffix table. Tony
  4. A

    Create Multiple records based on a table

    Thanks again Paul I will Implement your remarks from yoru last post. What is the code to open a record set for append only Tony
  5. A

    Create Multiple records based on a table

    Thanks Paul for the quick response This is my first module ever. It works and does the job with no errors. Im looking to get it critiqued. Does anyone see any holes in the program or is there a better way? Thanks Option Compare Database Function DontKnowWhatImDoing() Dim rstInput As...
  6. A

    Remove Text from a field based on a table

    I have 2 tables. Table 1 is called StreetSuffix. Only one field Exist in it. (Street,Ave,Road,Terrace,Place) Table 2 has the street name (Boston Post Road, Walnut Street) Is there a way i can compare the street name in table 2 with all the street suffix in table 1 and remove the suffix...
  7. A

    Create Multiple records based on a table

    I have a given table with (StartNumber, EndNumber and StreetName) Example of a single record in a table StartNumber = 1 EndNumber = 50 StreetName = Main Street Looking to get an end result of 50 records from that one example above. 1 Main Street 2 Main Street . . . 50 Main Street...
  8. A

    Pause VB for excel to finish

    Heres my situation. I am trying to import an excel file into access. I get invalid file format with docmd.TransferSpreadsheet. When I open the excel file and copy and past the data to a new excel file, I can import the new excel file with no problems with transferspreadsheet. I have no...
  9. A

    Create Dynamic Query from a form

    Thanks That article helps
  10. A

    Create Dynamic Query from a form

    Im looking to have user customized query based on a form Want to have a drop down with the field name then create a query like.... SELECT Table.id, StudentMasterFile.[forms]![form1]![Unbound]FROM Table; That does not work....but can someone guide me in the right direction Thanks
  11. A

    Crosstab Queries with criteria

    Thanks Chris That was very helpful
  12. A

    Crosstab Queries with criteria

    New to this site. very impressing I am trying to create a crosstab query, but can get it right. Table1 = input Table _____________________________________________________________ name StartDate date Present A 1201 1201 P B...
Back
Top Bottom