Search results for query: *

I am trying to figure out how to create a query (or view) that will create several columns for this one column of data. The data type for this column is text (I did not set this up & I cannot change it). The column [records_XML_String] from table [WebApps].[dbo].[cm_app_xmlform_records] is...

I am trying to move data from one server to another, but have hit a bump on how to replicate a view I use on the old server. Due to the traffic on my old server, I had to create an independent server to hold a few tables in which 2 seperate programs use almost independantly. My only problem is...

I have a table in my database (which is a text file import from raw edi data) that I need to somehow group. I would like to first loop through the table and assign a group name to the records. Here is the example of what the table data might look like: Field1 Field2 Field3 Field4 PTD SS N1 ST...

I have a Form with a subform in it. As I enter data into the main form, new blank records get added to the subform. How do I prevent this from happening? I only want records to be added when I click into the subform. The subform has totals in it that relate back to the main form. Would making...

I am trying to number my rows that appear in my queary. The query actually goups and sums data, so the count function will not work. I have the following code in my module: Global IncrementVariable As Integer Function IncrementValues(QTY) As Integer IncrementVariable = IncrementVariable + 1...

I have the following code that keeps giving me syntax error (missing operator) in query expression "[CBNumber]= 79CB". I am running Access 2007. Private Sub Command34_Click() On Error GoTo Err_Command34_Click Dim strDocName As String Dim strWhere As String strDocName =...

I am having a few problems setting up users in Forecaster. I have the forecaster database set up in SQL. I was able to add a new user in SQL and then into Forecaster with some assignments. When I log into Forecaster as the new user, there are no departments or accounts assigned. I go to open...

Does anyone know of some EDI software that will support serialized box labels, lot numbers and ups tracking numbers in connection with Great Plains?

I have a subreport that will only print the data that fits on one page. I know that there is probably a really easy solution, but I just cannot figure it out. For example, I have a main report with a group header, details and a group footer. The subreport is withing the group footer of the main...

Is there a way to create a macro or something to be able to run a particular FRX report with the push of a button? If so, how?

I have a field in a subform that updates every time you click in it. However, I would like every record in the subform to update when I perform an action in my main form. I have no experience with loops in Access so I am totally lost. Any help would be appreciated. Main Form: [Chargeback] Sub...

I have a field in a subform that updates every time you click in it. However, I would like every record in the subform to update when I perform an action in my main form. I have no experience with loops in Access so I am totally lost. Any help would be appreciated. Main Form: [Chargeback] Sub...

I have two tables- chargeback(header info) and chargebackdetail(detail line items). I am using a form (links to chargeback tbl) and a subform (links to chargebackdetails tbl) to enter in the info. We can use the form in two ways... 1 to enter in all the infor manually and 2 enter in header info...

I am fairly new to access and I am trying to create a database for our company and this website has provided me with awesome solutions to many of my problems... but I can't quite solve this one from previous posts. OK, I have a command button on my form which opens a chosen excel file and...

i am trying to create a cash receipts integration through integration manager for GP V7.0. When I have only one invoice to apply a check to, it works fine. However, when I try to integrate more than one invoice to apply to for one check, It says the receipts already exists. Also, I don't know...

The problem we are having in Receivable Management is that we are having to do a lot of extra work when entering a check received from our vendor. Almost all of our vendors send us consolidated checks containing both invoices and credits they are paying and deducting for. The problem is, many...

We accidently imported checks this month into the wrong company. We import the checks into the Bank transaction Entry screen (financial-bank transaction entry). What I did was delete all these imported checks from the CM20100 and CM20200 table in SQL Query Analyzer. After I did this I ran...

I am trying to delete some lines in a table, however I have to delete lines that would meet to criteria. Here's what I am doing: select * from GL11110 where YEAR1 ='2004'and PERIODID ='12' When I get this, I get the 3 lines that need to be deleted, so I say delete from GL11110 where YEAR1...

I know this may seem very simple, but I can not get this to work. I have a button in excel that is linked to a macro. I want to be able to click on a random cell in column J and then click the button to run a macro in order to insert value into that cell. My problem is that I cannot figure out...

I have a report which groups rebates by state. In the group, there are two detail sections. DetailsA includes an NDC amount and DetailsB includes a Notes Amount. I need to add the sum of these two amounts together in order to get a total rebate per state: {@Rebate}=Sum ({Adjustment Query.Notes...