Search results

  1. N

    run-time error 424 object required

    Dim orsCompany, oConn Set orsCompany = CreateObject("ADODB.Recordset") Set oConn = CurrentProject.Connection ' within current project therefore no need to open connection Dim branch As String, zipcode As Long, tempdistance As Double orsCompany.Open "select * from [ZipCodesUSUnique];", oConn, 3...
  2. N

    how do you check to see if field exists?

    I know this must be very easy I just can't find it. Isdefined, isNull I thought might work but didn't. Does anyone have any idea how I can check to see if this table exists before I alter the table? Thanks so much! Sam If (orsCompany("Pricing")) Then orsPricingField.Open...
  3. N

    Alter table by adding columns as the first three fields

    Interesting problem with my database Currently I alter a table by adding three fields to it but now I need these three fields to be added as the first three columns instead of at the end. How can I do this dynamically? Is there a field property in Alter that allows me to change the order? I...
  4. N

    Change Data type and name

    I allow the user to import a file where they select the name of the table and location of the excel file. I need to add a few more lines of code that check to see that there is a zip code field and that its data type is a number field Here is the basic idea, but I am so new to vb script that...
  5. N

    How to I check to see if a field exists in a table using VB?

    How to I check to see if a field exists in a table using VB? I want to run DoCmd.RunSQL ("ALTER TABLE " & test2 & " DROP COLUMN Branch Distance;") but the field may not exists in all cases.
  6. N

    Query database for the names of all tables

    I am trying to make a combo box that will list all the table names in my db. I have no idea what I need to do. Thanks!!! I really need your help!!!
  7. N

    How do I update a Calendar with dates?

    I have a db which holds event dates, and I need a way to be able to tell if any dates overlap? Any ideas?? Thank! - SAM
  8. N

    Help with reports

    Thanks in advance for everyone's help. I create two reports in access report 1 with detailed information (company name, info, status, details etc) report 2 is an outline form of report 1 with company name, status, and a link that I want to directly into the report 1 I publish both forms...
  9. N

    Exporting reports to word -- need help with dynamic hyperlinks

    Thanks in advance for everyone's help. I create two reports in access report 1 with detailed information (company name, info, status, details etc) report 2 is an outline form of report 1 with company name, status, and a link that I want to directly into the report 1 I publish both forms...
Back
Top Bottom