Search results for query: *

I have an Access 2007 database query and I want to create a temporary table in a SQL 2008 database. I know I need to connect to the server and database, I know I need my recordset from the query, and I need to use an Insert Into statement. I can find bits and pieces of code but nothing...

I ran checklinks on Financials then Sales, Purchasing and finally Inventory. Now when users try opening the Inventory Items List, they get the following error: [Microsot][SQL Native Client][SQL Server]Cannot isert the value NULL into column 'BASEUOFM', table 'tempdb.dbo.##0062828", column does...

I have a user who was updated from Office2000 to Office 2003. She has an Excel file with a pivot table who's source data is in another file. She has always been able to update the data in the pivot table by using the wizard and reselecting the source data to include new rows. Now when she...

I have an Access2000 front end to a SQL 2008 database (Dynamics GP) that has worked since we moved to the new server a few months ago, but has been finicky with DSN's. Today a user is getting this error and after trying to fix it, I now get the error on my workstation. ODBC-call failed...

As soon as I add the Total line, group by's, Sums, expressions, etc it tells me it is too complex. I've done this a thousand times before and there is nothing special this time, and the strange thing is it worked last month. Has anyone experienced this? I also have a union query that is not...

I found this thread to be what I am trying to do also: http://www.tek-tips.com/viewthread.cfm?qid=1546811 But I don't see where to put this code it says to use: If tabctl0.VALUE = 5 Then '6th tab I have an Information tab and I have a Cost tab. The cost tab has a subform where user enters...

I have a sales order form. If it is a new order, then some fields are combo boxes and others are text boxes. If it is an existing order, it is the reverse, and displays an order already in the database. What is the recommended method for handling this? Is it better to have a separate form...

I have two queries that had parameters from a form. I then created a Union query. When I run the Union Query, it works fine. When I try to create a Saved Export I get the Too Few Paramenters - Expected 4 error. I took the parameters out of the two queries, and put them in the Union query, but I...

A while ago I packaged an Access 2000 database (mdb) with my Access 2007 so that users without 2007 could use it. I installed it on a workstation. He ran one of the functions I set up to import data from Excel. On his workstation, I can see this data But when I open the original database, it...

I have SQL2000 installed on my workstation. It is not the server. Can I install SQL2008 also just to create a new database to work with and test or will this cause major problems? The 2008 install will not be connected to a SQL server (for now). Or maybe it has to be? In which case I am SOL.

I have a table where records get imported and I have a few more fields that need to be calculated. Some fields are dependant on the resulting calculation of other fields. I started with Stored Procs but the procedure would run against the whole table. So as someone suggested, I created triggers...

I have spent way too much time on this and really need help asap. I have a table with dDate, AvgPrice and FXRate. I have another field "Factor" that is calculated based on the Weight value in th FactorTable table. I'm not sure how to call this query to run for a single record first of all...

I have all my backend data in SQL 2000 (soon to be upgrading to 08). Data gets imported and a bunch of stored procedures run to update additional fields in the data table. I have another table and an Access front-end form for the use to enter some information. I have another SP in SQL to...

I am new to this and it's something I have to learn on the job. I have a table that gets data imported into it, but some of the fields need to be calculated. We have a Python script that will import the raw data and I thought it would be better to have all the calcultions for the remaining...

I have a continuous subform (Sub2) where a user enters records that are adjustments to records in another subform (Sub1). After the user enters a record in Sub2, I want to run a query that will compare the new record to the original record, and update a value in Sub2 table. THe query works but...

In Access 2007: DoCmd.SearchForRecord , "", acFirst, "[Customer] = " & "'" & Screen.ActiveControl & "'" Is this not supposed to select the record on my form? I had it working, and didn't change a thing. User opens form and selects a Customer. It fills in Customer name, currency and a few...

Hello. I am trying my first sales integration. I've done many GL transactions, Inventory, and payables that work fine. It says it's successfule and there are no errors, but the Items do not get into the sales transaction. I can manually enter the SOP Details and there are no errors or...

Hi. I'd like a brief intro to obtaining data via ODBC from a Pervasive database. The production software we purchased is on Pervasive. The reports are difficult to get, and time is a serious concern right now to learn the reporting tools of this system. I'm familiar with SQL Server and Access...

I have a really simple query: MonthEnd DataType PercentDiff There are two lines on my graph - one for each DataType. I created a query and ran a PivotChart view and formatted it all pretty but it prints really ugly. I then noticed I can insert a Chart into a report, so I tried it this way...

I have a form "Form2", when I open it and enter the criteria, click the Preview button, the report opens. I get the correct data. Now, I put a button on a Main form to open Form2. I enter my criteria, click the Preview button, and the report has no data. Yet when I check the report filters...