Search results

  1. S

    access 2012 frontend not showing correct data from linked ODBC sql 2012 tables

    Good morning. Was not sure where to post this. I have an issue that just began occurring. views, tables and queries have been working fine and now are not. Here are FAQs: 1. created sql server 2012 table and linked to access 2007-2010 db - call it dbo.224Ongoing 2. created sql server 2012...
  2. S

    error 3022 in vba export access qry to Excel file

    I am totally at a loss. I have a query in Access that I want to export the multiple filtered versions based on "LeadID's in another table and exported to separate worksheets (per LeadID) using transfer spreadsheet vba. I am asking it to find the PeopleID (autonumber NOT indexed) from the...
  3. S

    code in Case Select to open union query based report

    I have searched everywhere for help on this. I hope you're my saviors again. I have a switchboard form that has a combo control with lists of reports to be chosen. In the VBA of control, I have a case select. (pasted below). I currently have the code below opening a report (built on a union...
  4. S

    syntax on update query-WHERE statement

    I give up. Two questions (I'm using Access 2007). One, would you please give me the correct syntax for the below UPDATE code. I am getting a "missing operator" on the WHERE statement. Criteria fields are both text. ("UPDATE [policy changes] SET [Policy Changes].[Legislation ID]=" & Me.SourceID _...
  5. S

    Updating multiple tables after updating form control

    hello. I have tried and tried to get this figured out, looked everywhere, so going to break this down. The big picture is I have a 4 tables (not full names but close) Policies, Projects, Bulletins/Announcements, Job Aids. The DB is designed that you may create a record that is the Master...
  6. S

    Adding "attachments" field to table is "corrupting" it?

    I am revamping a DB in 2007 that was created in 2007. I have updated 4 tables, but with 2 of them, when I add the attachements field to the table, it seems to corrupt the table. Why do I think this? Because when I add the field, and then open the form attached to the table, none of the...
  7. S

    DoCmd.OpenForm won't work, Procedure declaration does not match description

    I am beside myself with this. Originally I coded the Docmd.Open code with a string to open to a specific record. Worked beautifully. Today (did not shut anything down) the form will not even run the simple DoCmd.OpenForm "formname" code without getting the below message. I have plugged in...
Back
Top Bottom