Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. MBresnan

    INSERT INTO VBA statement not working for Memo or Hyperlink fields

    sorry those are text fields. my test data is all numeric for those but normally it's a combination of alpha and numeric (hb12 or something similar) argh, I should have entered into my test fields more clearly. Those null fields are the memo fields i'm missing (and the URL at the end) I could...
  2. MBresnan

    INSERT INTO VBA statement not working for Memo or Hyperlink fields

    I also tried to delimit the [HearingDate] field with '#'s and it errored out.
  3. MBresnan

    INSERT INTO VBA statement not working for Memo or Hyperlink fields

    yes, there should be a URL field at the end (the 16th field), but it's not bringing anything in and (I believe) triggering the error. As far as your highlighting questions, all the commas seem to be framed with the apostrophes (', ' for example), not the fields themselves. is that incorrect? I...
  4. MBresnan

    INSERT INTO VBA statement not working for Memo or Hyperlink fields

    Made the above change and things seemed to compile correctly! however, when I ran the code from the form, I got an error. Run-time error '3075' Syntax error(missing operator) in query expression: (lists out each field and stops at the URL) so it looks like the memo fields are coming over now...
  5. MBresnan

    INSERT INTO VBA statement not working for Memo or Hyperlink fields

    The break seems to be happening in the beginning of the code now (but the sqlString = part of the code is red) Here's a little more including the prompt that comes up when you kick off the code. Private Sub cmdAddAndQuit_Click() Dim intMsgAnswer As Integer intMsgAnswer = MsgBox("Update the...
  6. MBresnan

    INSERT INTO VBA statement not working for Memo or Hyperlink fields

    Dim sqlString As String sqlString = "INSERT INTO tblBillInput ([BillNum], [Sorter], [Sponsor], [FileCode], [Title], " & _ "[Synopsis], [Type], [Priors], [PriorPosition], [Notes], [CFBillNum], [Week], [Committee], " & _ "[HearingDate], [Status], [BillURL]) " & _ "...
  7. MBresnan

    INSERT INTO VBA statement not working for Memo or Hyperlink fields

    so I need the &"','"& between each VALUE field? I'm even less knowledgeable about VBA than I thought...
  8. MBresnan

    INSERT INTO VBA statement not working for Memo or Hyperlink fields

    I'm trying to run some VBA code to update some Access tables from a form, everything seems to be working except for the Memo, and Hyperlink fields i'm trying to update. the code just skips those fields, and then the user has to go back in and update via another form pointed towards the table i...
  9. MBresnan

    Server issue, or application?

    The server was fine, but as it turns out we had to reboot the SQL DB, and that seemed to speed things up. during the work to fix the issue, it seemed we were going more along the route of it being an application error (rebuilding the datamart, etc) which I wasn't sure would help with anything...
  10. MBresnan

    Server issue, or application?

    We are currently experiencing some major issues with all applications related to GP. GP itself takes about 10 minutes to fully start up (stuck while it's loading the home page with the various menus), and once it does, runs very slow. However, some people are able to get into the system just...
  11. MBresnan

    Process Server issues with Binary Reports

    Has anyone used Binary's multi-entity plugin, and created a process server that ran reports successfully? we're getting an issue where if we run the default unmodified GP reports, everything runs fine through the process server. If we try to run the (default or modified)Multi Entity versions, we...
  12. MBresnan

    User unable to integrate credit memos but can enter them manually

    we have blocked our receivables clerks from being able to apply credit memos/cash receipts (don't ask why, not my call). For some reason in removing that the receivables clerk is still able to enter a CM manually through the window, but she gets a "you are not authorized" error when she tries to...
  13. MBresnan

    Microsoft Dynamics GP 2010 reprint past due invoces

    There is a historical invoice report, you'll have to format it similarly to your current invoice report to make it printable though. You can look up unpaid invoices via smartlist, and send out the historical invoice? Is that what you are looking for?
  14. MBresnan

    Missing FATRX batch?

    no this particular situation had a batch listed, but I came across other issues by the same person where it was blank. I assumed blank meant deleted, but it makes more sense that it just hasn't been run.
  15. MBresnan

    Applying receivables credit memos during integration

    every quarter we end up writing off quite a few (this quarter was 700)receivables invoices through credit memos. i upload them through an integration, but someone else has to go in and apply them all manually. i don't see an option to apply anything in the receivables transaction destination...
  16. MBresnan

    Missing FATRX batch?

    that's what i was thinking, does the missing batch in the "financial detail inquiry" mean that posting hasn't been run at all for that transaction? or that it has been run and deleted? the more i think about it, the more i think that means it wasn't run at all... (obviously, there has not been...
  17. MBresnan

    Missing FATRX batch?

    One of my users ran depreciation, and ran the GL Posting process for Fixed assets. The assets are depreciated, and when i run the reconcile to GL report (and the financial detail inquiry) i'm seeing an FATRX batch associated with the depreciation transaction. However, it didn't post to the...
  18. MBresnan

    A question I can't noodle out...

    this... doesn't make much sense. the class ID basically assigns the defaults to any subledger transaction involving the vendor that it's attached to. however, those defaults can be overridden, so the class ID doesn't necessarily determine where in the GL that transaction hit. I'm not sure what...
  19. MBresnan

    Exporting transaction level detail in FRx

    Just a follow up to close this down, the reason they aren't exporting is because of a compatibility issue between GP10 and Excel 2010. works fine with Excel 2007.
  20. MBresnan

    USER ID on a Great Plains general journal entry

    Victoria (love your blog btw), Not to derail, but what determines who is "Last User"? Our parent company wants us to show the user who created, and user who approves(posted) a particular journal entry in a report. I would think, as long as the manager is posting via the batch, and not getting...

Part and Inventory Search

Back
Top