Search results

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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
  6. 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