Search results for query: *

i had a server crash, and needed to rebuild an sharepoint server. on this intranet sharepoint we had three reports that were inherited. they look to an sql db and show snapshots of daily data. i recovered the wwwroot folder from the original server and added it to the new one. installed all of...

i am trying to execute the following "IIF" statement but get errors, i have a calc to figure out number of days a ticket is open. then there is a ct field that i need to add to that, but sometimes there isnt a ct and its null, so i thought i should be able to add the iff statement that if the CT...

I have an access query that gives me a count by days buy type, i want to create a line graph from this, with a line for each type. i can get a single line to work just by the dates and counts, but i cant get it to generate anything if i try to add the type in the code. the attached code works...

i have a macro that pulls data from a specific access table, i do not want to add more updates to the access DB but would instead like to update the macro. the file has now accumulated two years worth of data and the grid is very cluttered so i would like to only pull the current year, but no...

i have a table that has 3 years of data in it. the data is broken out by a salesman, a product type, sales dollars, year. i was able to use a cross tab to get the records to disply as needed for management, but now they are requesting a difference column either dollars or percentage but it needs...

is there anyway to update an as400 table with info from an MS Access db. i read several posts on lots of sites saying journaling needed to be turned on and that the table on the 400 could not have a keyed field i have done all of this but still receive the #7800 error everytime i try to post the...

i have a process that creates an excel chart, i would like for the chart to not have the filter pivot table options. these are gray buttons to the top/bottoms/sides based on the pivot table. CODE: Sub chart_share1() Start_Row = 13 Chart_Name = "NEW PRODUCTS BOOKINGS" Counter = 1...

i have to create a pick list for an order system, and what i have to do as part of this is generate labels. some items have multiple quantities. so example is (ItemNbr, ItemDesc, Qty) 123456 SamplePart 3. i would like the query to dup that particular line into the label table 3 times, then move...

i have a table that an occasional user will not populate a major field, and i need to catch this before it goes any further. i tried the following code for an update prior to pushing this data out but the query fails. the two tables are large and have multiple records but the main links are...

i have a table that an occasional user will not populate a major field, and i need to catch this before it goes any further. i tried the following code for an update prior to pushing this data out but the query fails. the two tables are large and have multiple records but the main links are...

i have an Access db setup to perform a mailmerge for user documentation, and it current works fine from access to word. now they have a twist they would like to be able to add pictures (jpeg, gif, etc) to portions of the documents where needed. i tried to do some playing where the user could...

i have a database running in access 2007 (split db) with a frontend and backend. the switchboard is setup with an add button and an edit button. button 1 the add - opens a form with switchboard option = 2 and it allows users to add new records. button 2 the edit - opens a form with switchboard...

i am trying to work with ASP code, i have setup a windows server 2008 R2 box, have IIS 7 running on it. i have copied and updated some asp code into the default library of wwwroot and some of the pages execute without issues others fail but only give error 500 saying site is down or error in...

i have a few tables in SQL Server2008 that have been in use for a while, i am trying to create indexing on a serial number field to avoid duplicates, i know in access i can change the table field to index no duplicates, in the server do i use the indexes and keys option by right clicking the...

i have been asked to update a link on an sharepoint page. the original report listed a file from a database. i made all of the changes to the database and everything is updating correctly. i want to add a column to the existing report but am not sure what needs to be done. i changed all of the...

i have a main table and i need to verify that a field is the correct number in column1, so i tried an update query with the following code but it returns an error that "Result of SELECT more than one row." but in the combination of field2 and field3 wont have dups but i could have 10 or more...

i have a form that is open through a switchboard with option 3 (edit mode) but when data is entered into the form and the user clicks close the error msg "update without addnew or edit" appears. i have checked that all of the edits and change options are "allow" but no matter what i try it will...

I have a table that will have several part numbers and children parts based on a code. (se example) Item_____Part Number___RecLvl 44 GD0190 0 44.1 GD0189G01 1 44.1.1 GD0115G05 2 44.1.1.1 GD0114P01 3 44.1.1.2 HA0028P01 3 44.1.1.3 HA0028P03 3 44.1.1.4 HA0028P02 3 The main part is itm 44...

i have a table that will have several part numbers and children parts based on a code. (se example) Item Part Number RecLvl 44 GD0190 0 44.1 GD0189G01 1 44.1.1 GD0115G05 2 44.1.1.1 GD0114P01 3 44.1.1.2 HA0028P01 3 44.1.1.3 HA0028P03 3 44.1.1.4 HA0028P02 3 so main part is itm 44 (gd0190)

i have a table that can have anywhere from 10 -1000 records in it. these records are broken out by several buckets but have one field in common with another table. examples for testing included. tble1 - mgrs which has 2 fields mgr#, mgrname. tble2 has mgr# and several other fields i need...