Search results for query: *

I am using Access97 front-end for an application. SQL Server 2000 for the back-end of the application. (ODBC remote linked tables) i have the update (after) trigger on one sql table, and all works fine when manually changing the row to the specified criteria... trigger fires.. and email...

Has anyone experienced this error with Sql upsized Access DB's? I have a purchasing system upsized from access to sql and it's been working fine for about 1 1/2 years, then about a month ago, people started getting errors. The screen would freeze (about 40% of the time) when a record was...

Has anyone experienced this error with Sql upsized Access DB's? I have a purchasing system upsized from access to sql and it's been working fine for about 1 1/2 years, then about a month ago, people started getting errors. The screen would freeze (about 40% of the time) when a record was...

I am developing in Access 2002 (file format of Access 2000) and saving down to Access97. None of the DAO Objects are being recognized "Dim Db as Database", does anyone know a reason why?? The Tools..References option on the client's Access 2000 is greyed out as well, so i can't check...

I have a stored procedure i want to use, but the dataadapter won't generate a dataset, because it doesn't recognize the #tmp tables the sp is using. How can i use an untyped dataset to accomplish this. Normal SQL: SqlDataAdapter2.fill(Dataset21) Datagrid1.Databind() '''where the Datagrid's...

Anyone experience this problem and know how to fix? When in design view, the images won't show, neither in preview but when I upload site, image links work fine, and display fine. Whole site is stored on my http://localhost with XP and uploaded to web server. Import images into local site...

Has anyone had this problem? If you are working in VS.net, I've got some .aspx files open and i can toggle between design/html view. But I went to duplicate this file, and did a "Save As", and typed in a new name. Well, form1.aspx closed and form2.aspx the "save as" file is...

I am working on a group by query: Original Table: -pk- -pk- AssetID TsfrDate TsfrFrom TsfrTo 1522 09/01/2002 <null> TX 1522 10/01/2002 TX NV 1523 05/01/2002 MN IL 1523 06/01/2002 IL MI 1523 04/01/2002 <null> MN...

Access VB won't compile (recognize) the following simple SQL operator: in() How do you perform this needed operation in access vb. Ex: Dim Loc as Integer Dim sLocList as string Loc = 20 sLocList = &quot;20,21,22,23,24&quot; If Loc in(sLocList) then ''do this else '''do that end if It just...

I have a date field &quot;RecheckDate&quot; in SQL. I need to update the Day to 15 for all rows. 05/31/02 will become 05/15/02 06/24/02 06/15/02 08/23/02 08/15/02 What is the best function to use to accomplish this? I had trouble using the...

Does anyone know if I can force a particular doughnut slice color to always be a certain color? I can change the color but CR is only storing my colors based on listing of categories in my group..i.e. First = Red Second = Blue Third = Yellow I would like it to be based on name...i.e. Medical...

ok, I have a PO System, SQL database. This morning i was playing around with the web publishing wizard...you know...oh cool, what's this do... Well, the wizard halfway completed the first time...and I set it to update a web page EVERY time the data in one of my tables changes. Now, whenever...

I'm just trying to edit/add a new row and I keep getting a message stating &quot;Key column information is insufficient or incorrect. Too many rows were affected by update.&quot; This is a table created by and linked to access. I can modify existing rows but not any I try to add. There are no...

Here's a trickier one I need help with: I have a data set like: Co JE Code 20 1010 20 1011 20 1012 21 1010 21 1011 21 1012 23 1010 23 1011 It needs to be resequenced like this: Co JE Code 01 1010 01 1011 01 1012 01 1013 01 1014 01 1015 23...

In SQL Command is it possible to do this? Update compcode Set Seg1 = '28' Where Company (begins with 'R')??? In VBA, I would say: Where Left(Company, 1) = 'R' thanks in advance

Does anyone know a query that will shift the data in 3 columns over one place to the right. Ex: Seg1 Seg2 Seg3 Seg4 01 400300 700 01 400325 700 to Seg1 Seg2 Seg3 Seg4 01 400300 700 01 400325 700 This is for large datasets... thanks

ok, (access 97) I have a query that is dependant on a linked Excel Table. I need to either: a) Change the linked file address during run-time of this linked table. (if possible, which property?) or b) Delete the linked table and recreate it using transferspreadsheet command. This part I...

Has anyone run into a limitation on the number of controls you are able to put on a form? How about a way around it? thanks for any info.

I am trying to create a resulting crosstab or pivotfield query that will give me a second value at each intersection. I can get the single cross-tab query ok, but having trouble with the second value. The resulting set will be used to graph an opportunity or bubble chart. Example:crosstab query...

I've run across a problem viewing my embedded reports on certain platforms. I'm using the command Report1.PrintReport to preview the report from the Report Control in Access 97. It works fine on 75% of the computers but on some, it flashes a blank preview screen for a split second then...