Search results for query: *

Hi Is there a way to delete Unposted SOP invoices that have been printed? We are trying to delete some documents, but GP says it can not be deleted as it has been printed. You have to void it. Any help would be appreciated. Take it Easy Man with one chopstick go hungry

Hi All We have had a third party billing platform implemented that incorporates into the GP tables. Users access and maintain the contrat data by logging into GP and opening the relevant third party form. We are trying to implement an audit trail of the contract data, by using a SQL trigger...

Howzit We have started to make some of our inventory items to inactive (we do not have the full functionality of the inventory module - we just use the cards), but they are still showing up in the SOP Transaction Entry, lookup window. We would like for these inactive inventory items to not...

Hi All We use the Proactis Purchase Order system in conjuction with Great Plains. I have been tasked with exporting a couple more fields out of Proactis, on receipting of the order. I understand that the view view_cus_ExportCommitmentTransaction deals with the export, but as far as I can see...

Hi All You are able to post to the most recent Historical Year, after you have done a year end close. How are you able to identify these transactions - is there a special Source Document I should be using. Any help is appreciated... Take it Easy Man with one chopstick go hungry

I have recently built an application and put it on the server (split between front end and back end), with all the access objects opening pretty quickly. I have taken a copy of this application and put it on my laptop (as there were some new requirements), and relinked the back end to the one...

For SOX compliance, our Financial Controller needs to review the users access by menus by company. The system generated reports are pretty unhelpful (not to mention long winded), so I am looking to generate something in sql to give us a flat file to review. Could someone please advise what...

Hi all Iam stuck on how to reference a bookmark in word from access, where the book mark is on a text box within the word document. The code below is what i have to date, but it errors with a message Type MisMatch. Any ideas on how I can resolve this? I have included the code below, and...

I have a module that exports data from access to excel, adds a new sheet (for suuary data) and formats all sheets in excel. I have managed to add the company logo onto the summary sheet, in cell A1, but the picture itself is too small to see (without manually resizing it). I have tried many...

I have a form "frmStmtExport", with the Record Source being a query. This continuous form lists the unique Sales Execs who are due commission payments based on teh current month sales. I have a command button that transfers the sales execs commission data to excel, using the...

I have a database that imports Revenue transactions into a database for rreview. The revenue is contained in a csv file (dataimport.csv). The import process works fine. What I would like to do is create a Progress Bar telling the user how far into the process the import is. I know how to get...

Hi I am trying to rename an existing colmn in one of my tables dynamically, but come up with the following error message. I am not sure how to get around this. I want to change the column called Month1 to Test ALTER Column tblSummary ALTER COLUMN month1 to TEST; Any help would be...

Our company has the following email address set up in the Global Address Book - "LastName,FirstName". When you select multiple email recipients, they are separated by semi-colons (;). We use MS Outlook through an exchange server. A database I have created for the issues surrounding a finance...

I have a database that is 29mb in size. THe biggest table contains only 288 records and 20 fields, so is not excessive. There are no embedded pictures or files of any sort. I compact the db after close but the size does not get any smaller. I need to find out the size of each database object...

I am trying to export a database query to a csv file. This has been successful for the most part, but I have come across a couple of problems. 1. The first problem is that the resulting file does not have any headers, only the data fields. The output only contains 6 fields and should be named...

I am trying to update a field in a table called tblActuallabour, based on the EmloyeeId and the WorkDate. If I omit WorkDate criteria, the SQL will run but will update every record for the selected employee. This I do not want to happen. If I include the criteria about the workdate, nothing...

I am having difficulty in opening a recordset that restricts the data to a particular QID, which is on a form frmQuotes, but I get the follwoing error message. "Run-time Error '3061' Too few parameters. Expected 1." I think it may be falling down when it tries to filter the recordset, based...

Good morning An after update procedure of my Quotes form looks up the chargeout rate of the Employee based on their Employeeid, but returns an incorrect value - where the EmployeeID has more than one rate. The employee will have more than one rate as the rate will be effective from a point in...

I have a form called frmReceiptReview, that has a command button cmdPaidInv - see code below. I would like this code to open the form "frmInvoiceByCustomer", and show only the invoices that have had cash applied. The cash applied is in the subform "child26" in the text box "ReceiptValue"...

I have a quote form (frmQuoteHdr), where the user can create an invoice when the quote is accepted. When the quote is accepted, the cmdMakeInvoice button becomes visible. The On Click code executes (as below), except the final part, making the CustomerID the focus. I get the message "MS...