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 also logged in to SQL Server Mgmt Studio using the same username and password that this Access db uses, and was able to run the SELECT statement with no errors. I even created a DSN on the network and it worked for USER1 but it didn't work for USER2 until I changed his back to using the DSN...

Your comment implies that you use different passwords on different workstations ("another workstation that has the same SQL password for linked tables") - what happens if you use the same username and password?" They are using the same username and password that I created on the SQL Server in...

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

dbo is the owner It works on another workstation that has the same SQL password for the linked tables. I got this first user to work by re-selecting his local DSN instead of one on the network. But now when our receptionist tries to use it, I know she will get an error and I will have to point...

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

Thanks but No that's not the issue, and I figured it out. I have a form with tab controls. TabX has a subform. TabA has unbound text fields that I want to show some data that was entered in the subform. When TabA is selected, I want it to show the updated data from TabX. I didn't know how to...

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 ended up creating a new form for new orders. It works great, less code haha. Thanks.

Well, I use a text box that displays for entering a new Order. If they want to select an existing order, the combo box displays. I don't know how to use just one box. If I have an unbound combo box, then how does a new entry get saved? If it is a bound combo box, then for some reason the...

I don't understand but put that line of code with True where it's a new record as selected in the option group, and put it as false for existing records. It was working okay, but now I am trying to use code to change the option from New to Existing if the user enters a Customer Order # that...

If I do this, then I still have to change my combo boxes to text boxes and vice versa. I want the user to be able to select a customer for new orders but not for existing orders. I want the user to be able to select the existing Order from a combo box, but use a textbox to enter a new Order...

OK thanks. I think I can work with that. I am having another issue, new thread :)

The default property is a single form. The form has a tab control with subforms on some of the tabs. Am I blind? I cannot see a Data Entry property on the field. It is not on the Data tab, or Format, or Event or Other or All. This is Access 2007. thanks.

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

What is the parameter bug? My Query1 and Query2 have parameters, as does a query that is used in those queries. I am able to export to Excel. It only give the error for Text type. I looked into specification sets and that told me nothing.

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

actually the database is 2000. I found the accdr file in the user's programs folder, renamed it to .mdb and copied it to the network share, and told him to use that. thanks