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 derfloh 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: *

  • Users: barbola
  • Content: Threads
  • Order by date
  1. barbola

    Insert data Access 2007 to SQL 2008 table

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

    Inventory List error

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

    Pivot Table data source can't be modified?

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

    SELECT Permission Denied on object 'tablename'...#229

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

    query works without Totals but then....

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

    Update tab control fields from another tab

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

    Separate form for new records from updating records?

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

    Saved Exports won't run Union Query - Too Few Parameters

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

    Created runtime package, where is my database?

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

    2000 and 2008 on the same workstation?

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

    new to triggers

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

    Query doesn't work in Access but works in SQL

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

    Call SQL Stored Proc to calculate a field in a table in Access 2007

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

    Sp help to calculate field values

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

    run a query after record is added or changed

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

    combo box not changing form fields

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

    Sales Integration SOP with items

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

    new to Pervasive, know nothing

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

    Simple Chart

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

    Report has no data

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

Part and Inventory Search

Back
Top