Recent content by MBresnan

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...

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

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...

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...

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...

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

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

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...

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...

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...

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...

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...

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?

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.

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...