text:
I have an export function below that will export my table "Test" to an Excel Spreadsheet. However I want it so i can choose where that data in the "Test" table will go in the Excel Spreadsheet i.e. I want to export all the data in to Cell "B2" of the SpreadSheet - at the moment it will export all the data into "A1" Any help or ideas? Private Sub Command3_Click() 'Export function 'EXPORTS TABLE IN ACCESS DATABASE TO EXCEL 'REFERENCE TO DAO IS REQUIRED Dim strExcelFile As String Dim strWorksheet As String Dim strDB As String Dim strTable As String Dim objDB As Database 'Change Based on your needs, or use 'as parameters to the sub strExcelFile = "E:CSCLDMSLDMSDatabaseAppLDMS_Spec.xls" strWorksheet = "WorkSheet1" strDB = "E:CSCLDMSLDMSDatabaseAppLDMS_IFF_APP.mdb" strTable = "Test" Set objDB = OpenDatabase(strDB) 'If excel file already exists, you can delete it here If Dir(strExcelFile) <> "" Then Kill strExcelFile objDB.Execute _ "SELECT * INTO [Excel 8.0;DATABASE=" & strExcelFile & _ "].[" & strWorksheet & "] FROM " & "[" & strTable & "]" objDB.Close Set objDB = Nothing End Sub
Hi, I would like to rename my access file. My problem: I have many pivot in excel link to this database so if i rename it all the links will be down...How can i resolve this?:confused: (of course rebuild all pivots could be a solution but I have around 50 pivots behind my database) Thanks for your help!
Hi All, I have an MS Access table that currently links into word as a mail merge. Great! Sample data as follows: Tutor Student Mr A Donald Duck Mr A Mickey Mouse Mr A Minnie Mouse Mrs B Joe Bloggs I want to produce a mail document that allows me to address each tutor separately, along with the respective student names in a grid. Now I've setup the document, but when I view each document it produces the list of all students for each tutor. e.g. Dear Mr A Your students are: Donald Duck Mickey Mouse Minnie Mouse ------------------- Dear Mrs B Your Students are: Joe Bloggs Is this at all possible? Thanks:)
There is a lot of info on the internet and on this forum about the possibilities to export data from gridview, datalist etc to Excel.This isn't the problem. But what i am wondering is, what are the criteria for the server to be possible to export to a excel file.I have a function to export to excel a datalist, and locally on my Pc it goes wel, but when I place it on the server it doesnt work anymore. The export file (XLS) is empty. So localy I get data into the excel file en remote I get no data in the excel file.
Hi all,I have a code that will write my data from a tempimport table to a orderstable. Then deletes the temptable. What I need help with is how to check a value in my temptable before writing it to my orderstable. Below is the code I have so far and it works great but doesnt check for duplicate data before writing.I have looked at alot of differnt codes here and just can not seem to get a code to work correctly.I am using VB6 and the tables are in a SQL 2000 serverCode:Private Sub cmdImport_Click()Dim rst As ADODB.RecordsetDim xrst As ADODB.RecordsetSet xrst = GetRecordSet("select * from tempimport")Set rst = GetRecordSet("orderstable")Do While Not xrst.EOF With rst .AddNew !ponumber = xrst!ponumber !sfname = xrst!sfname !slname = xrst!slname !pfname = xrst!pfname !plname = xrst!plname !phone = xrst!phone !streetaddress = xrst!streetaddress !aptnumber = xrst!aptnumber !city = xrst!city !State = xrst!State !zipcode = xrst!zipcode !student = xrst!student !studentpassword = xrst!studentpassword !Parent = xrst!Parent !parentpassword = xrst!parentpassword !isp = xrst!isp !isppassword = xrst!isppassword .Update End With xrst.MoveNextLoopMsgBox ("Import Finished")GetRecordSet ("delete tempimport")End SubCode:Function GetRecordSet(ByVal SQLString As String) As ADODB.Recordset Dim myConnection As New ADODB.Connection Dim myRecordSet As New ADODB.Recordset 'assign connectionString myConnection.ConnectionString = ODBCString 'open SQL database myConnection.Open 'set CursorLocation myRecordSet.CursorLocation = adUseClient 'get recordset myRecordSet.Open SQLString, myConnection, adOpenDynamic, adLockOptimistic 'return adodb.recordset Set GetRecordSet = myRecordSetEnd FunctionThanksClarkEdited by - clark on 2/15/2005 9:50:20 AM
HiI have written a database in Access 97 that uses replication. I have recently discovered that some users have Access 2000 and that it does not givew the option to just open the db but just gives the option to convert it.I'm afraid if it is converted access 97 users would not be able to use it.Is there any way that I can include code in my db to stop the db being converted, something that automatically just opens the db without prompting the user.Any help would be mmuch appreciated.thanksCooks.
I was wondering if it is possible to add additional data to Excel document created from gridview. What I want to do is to manually add data to certain rows and columns (date, couple of titles, etc), but I'm not sure how to do it. Currently I'm using the following code: [Code]....
I use ObjectDataSource and DetailsView for Updating records . my Bll input parameter method is an Object instead of regular parameter . So i though i could make my own ObjectParameter in ItemUpdating event of DetailsView and i need some modifiation on the data that user input on boudfield in detailsView . I don't know how to access BoundFiled data from ItemUpdating Method of DetailsView.
I have the program structure as below. How can I set some label values in the gridview row from dropdownlist in selected index changed event? how to write ddl_selectedindexchange? <asp:GridView ..... <div..> <asp:dropdownlist runat="server" onselectedindexchange="ddl_selectedindexchange"></dropdownlist> <asp:label runat="server" id="label1".....> </div> </asp:GridView>
How can I copy a set of data from the existing data in UI.
How could we Export an image to Excel on top of a gridview, using Respone.Write
I want to create a button which exports the grid view contents only (not the menu and the master page) into the CSV format.
I'm trying to ling access to a table in Informix/Unix and I got this error "The operation failed. There are too many indexes on table xyz_Informix Delete some of the indexes on the table and try the operation again" This is the only table I'm bringing in to access. I do not want to use any of the indexes. How can I fix this problem? Can I modify the registry to accept more indexes? Thank you Joe
I am reasonably new to writing VB Code managing uptil now to get by on wizards and queries. Please help: I am trying to programme an on click event from a command button to recognise when a record held within a table is ready for archiving. Unfortunately I cannot get it to do anything, any advice would be welcome before I take the long walk out of the window? Private Sub cmdArchive_Recs_Click()On Error GoTo trappingRoutine Dim db As Database Dim rs As Recordset Dim x As Variant Set db = OpenDatabase("I:WORDLWMBriefcaseDatabaseWIP.mdb") Set rs = db.OpenRecordset("select * from tblAction where [lblArchiveFlag]=-1") x = rs.RecordCount MsgBox (x) Exit Sub trappingRoutine: Call modLorisMods.inLineTrapper(err.Number, err.Description)eam. Lori:<
menardo writes "Hi there! I'm a very newbie in SQL programming. Can anybody help me how do I start to learn scriptings. Can you give me the process or scripts on how to export it?? Thanks in advance. -menardo"
1. I am using VB 6.0. I have a customer database. I have created a program using DATA command from the toolbar (and linked it with Access file) such that when i select the customer code ...the whole info of that customer appears in the respective text box.But here i want to use Combo Box instead of DATA command so that i can select the customer code form the pull down menu of the combo box.How can i do this....NEED HELP....????2. Also i gAve the link of DATA command to an ACCESS file (.mdb) but when i run my program on some other computer.....the program gives error asking for the same location for the Ascess file which was on the first system. How to rectify this....because i need to create the programs and send it to somebody ......... the other person may copy the folder (containing program file and the Access file) on any drive may be C:,D:,E:,.....please help...thanks....
hi,i have a supplier table in access.in vb form i have command button,text1.when user press the command button it should delete the specified record (i.e. text1.text).Please suggest me code for ADODB or ADODCnote: i am using ADODCthank youregardsmadhu
Hi Folks I am fairly new to VB. My problem is this.I have created a form in Vb, i want to open a table in an access database. i need open the table in edit mode so i can enter data imeadiatly. The next problem is how do you add a new record, using code?Thanks in advance.
I am trying to send a spreadsheet via Outlook automatically by using a button. How can I do it?.
Hi guys, I have an Excel app in which I have created a custom toolbar. This app.xls is loaded on a website and accessed via an ASP link (I dont have access to the ASP code). When the link is clicked it offers to open the app from there or save locally. Everything works perfectly when saved locally and executed but not when open from here is selected. In this instance the app works fine except for the menu. Each and every option (which just point to macros within the app) results in an error box - File Reservation. App(1).xls is being modified by xxx Open as Read-Only, or choose Notify to be alerted when it is available. The buttons offered are Read Only, Notify and Cancel. When I make the file available from my own webserver it works just fine, even with multiple simultaneous users. Anyone know what the ASP could be doing or is there a setting within IIS that could be causing this? Both webservers are IIS, I have control of mine and not the other. Thanks... Dennett---Have done some more investigations and what is happening is that a copy of the spreadsheet is being opened from the webserver into Excel (which creates a temporary version into an IE5 temp directory. Filename.xls All macros triggered by buttons etc on the worksheet work fine and when I check the macro assigned to the button it gives a reference such as 'Filename[1].xls!macroname' but every item on the toolbar has a macro reference of the form 'C:dirdirdirIE5tempdirFilename[1].xls!macroname'. It's prepending the path to the local copy of the file. When toolbar item is selected it tries to run the macro in the temp file instead of that loaded into memory. Since the temp file is marked read-only I get the sharing violation error. Any ideas why it's doing this and how to overcome in the VBA code for the toolbar creation. The .OnAction directive is being used in the vba to trigger the macros eg - .OnAction = "FaxMacro4" Can I programmatically refer to the macro in the .onaction so as to stop this occuring? Thanks ... Dennett
I want to add a command button to the spreadsheet at row, col. I get an error when I run the following code.Code:Dim btn as OLEobjectSet btn=Activesheet.OLEObjects.Add(ClassType:="Forms.CommandButton.1")btn.left=3btn.top=ActiveCell.Topbtn.width=45btn.height=12btn.name=(frmName.ContestantName, Len(frmName.ContestantName)-3)btn.caption="Check"The error first comes up as "Can't enter break mode at this time." (Since I am stepping through) and Error 438 Object doesn't support this property or method.Problem is, I can't figure out which method or property it objects to.Any idea how I can add a btton that I can later click on?
I have a text box who's value is increased (or decreased depending on which of 2 cmd buttons is pressed, button 1 is the increase button button 2 is the decrease button). My problem is I don't know how to pass the value in the text box to an Excel spead sheet. I'm sure that this is a newbie question but I haven't found an answer to it anywhere yet. If the question requires any additional info I would be glad to provide it, but I have a feeling that it is too simple of a question to need much info. Thank You
Hello all, I'm new to using vB and especially in Excel. I've got Excel XP and am trying to use it to create a workbook for my Fantasy Football League. The problem I'm having is arranging the standings week by week. The league has 2 divisions of 4 teams each and I would like the standing to display the team with best record at top of each division. Also, if two or more teams have the same record, they need to be displayed in order of points.If anyone has any suggestions or comments, please post. I'll check asap and thanks in advance for any help.rossboy69
Hi,here's a easy question for the most of you ;-). I add a Button in a Excelsheet. How to i connect this with a key shortcut? I tried to do it the same way as in VB (add a '&' ín the caption property) but it didn't work. can anyone help me pleasethanksakademos
Hi im trying to clean up and format a textfile that contains data as shown below and write the result to an Excel spreadsheet: 006252721954103167 2002090100000000N 045562081973091467 2002020100000000N 045800521973030667 2002031300000000N 116915141950110967T1996040100000000N 116915491956031367T1996040100000000N 116915571959042167T1996040100000000N 904323631954031467T2004012120040331N 904376671976070667T2004010120040331N 904382721975040267T2004010120040331N 905005041946062667 0000000000000000N 905005211967020567 0000000000000000N 905005391951062667 0000000000000000N This is what needs to be done: * Each line consists of 36 characters * These lines need to be divided into columns(cells) as follows: cell 1 = char 1-8 , cell 2 = char 9-16 , cell 3 = char 17-18 , cell 4 = char 19 , cell 5 = char 20-27 , cell 6 = char 28-35 , cell 7 = char 36. Cell 1 and 3 is fine as is. Cell 4 can contain a 'T' or be NULL. Cell 2,5 and 6 are containing dates in format YYYYMMDD eg. 20030423 . I need it to look like this YYYYMMDD eg. 2003 423 If Cell 5 contains only zeroes,then it should insert default value of 20001201.(this should also be formatted as above) If Cell 6 contains only zeroes,then it should insert default value of " " or it can be NULL. Cell 7 cannot be NULL and should contain only a 'N" or 'Y' if it is NULL it should put a 'N' to the cell. The result must be in a Excel spreadsheet. Im working with hundreds of thousands of records, and Excel only allows 60 000 records per file. Therefor i need to break the resulting file every 60 000 records and create another resulting file containing the rest of the records till there is no more. Can you please help, this is very urgent! Im using Visual Basic at the moment. This is a doozy for me and im still new at this...If anyone knows of an easier way to this please let me know... PS: I can't use Excel formatting in this file because the program that uses the result files does not recognise the fields. Thanx in advance! L
Hi all. I'm trying to set the range of cells plotted on a chart in Excel by first finding the last cell that actually contains data. I've basically got the two pieces of code I need but I don't know how to put them together:t = 0Dot = t + 1ActiveSheet.Cells(t, 6).SelectLoop Until ActiveCell.Text = ""t = t - 1This locates the last contiguous cell of data in column 6, but now I need to convert this somehow to a .Range for the chart command:ActiveChart.SetSourceData Source:=Sheets("Sheet1").Range("E2:F11")But this t variable is returning an RxCx kind of info. I don't want to use a Select Case Loop because I think (guess) there is a way to make the range like:("E2:Fx") in this case x is actually tso, how can I do that?Thanks allWengang
how to read and write records hyperlinked content from excel by using PHP
Hi All,I have search this forum, found sound answer that came close but not enough information. I am trying to relink tables from a postgres database to access 2000. I am using docmd.transferdatabase which is working, but; I am prompt with a dialog box "Select Unique Record Identifier". I have put a "create index" statement in my code and I am still getting prompt with a dialog box. Does anyone have any suggestions. By the way, I am using a odbc connection. Partial code follows:'Open the connection With cn .Open "DSN=dsnconnection" End With If init = 0 Then 'Detect if this is the first time we have run this function init = 1 'Mark we have been through here End If strSQL = "SELECT viewname as vname " & _ "FROM pg_views " & _ "order by viewname" With rs Set .ActiveConnection = cn .Open strSQL End With On Error Resume Next Do While Not rs.EOF stable = rs![vname] rs.MoveNext If (stable = "acct_devices_v") Then On Error Resume Next DoCmd.DeleteObject acTable, stable On Error GoTo 0 DoCmd.TransferDatabase acLink, "ODBC Database", "ODBC;Database=myDatabase;UID=username;PWD=password;DSN=dsnconnection", acTable, _stable, stable DoCmd.RunSQL "create unique index myIdx on acct_devices_v(id);" End If Loop 'CleanupIf rs.State <> adStateClosed Then rs.CloseSet rs = NothingIf cn.State <> adStateClosed Then cn.CloseSet rs = NothingEnd SubThank you for your help.B. Davis-
Hey all. Here's an interesting one dealing with IE/Excel. I've completed an application I've been working on for a long time now for the most part and I'm having some final issues. What I have done is created an excel VBA program with a main menu that lets you access many different forms. On to the problem.I've put the files out onto our Intranet and they are going to be accessed via the Intranet homepage. My problem is this. When I click on the link to open up the main menu of the application I get my own msg box I created that says: "You have other Excel workbooks open. Please close all workbooks before trying to create a request.", vbInformation, "PHIS Request Forms". This doesn't happen when I run the main menu excel file locally from windows explorer. It runs just fine.The crazy thing is that when I put a break point on the workbook_open event so that I can see how it loads from the start, it doesn't go to the error message ever in the code. When it gets to the line "If Workbooks.Count <> 1 Then", workbooks.count does equal 1 and it goes to the Else statement and loads everything properly. Once it finishes loading everything out of nowhere that error message I created about other excel workbooks being open popped up. I'm fairly sure it has something to do with how IE opens an Excel file from default. The actual Excel application window doesn't show up until the very end which is not how the application runs if you were to run it by double clicking the file in let's say windows explorer. I'm also thinking that the frmMainMenu.show is giving it a little trouble too.Here's the code: Code:Private Sub Workbook_Open()On Error GoTo Err_Handler 'Changes the Caption from saying "Microsoft Excel" Application.Caption = "PHIS Request Forms" FindAppIcon 'Call Change Icon module functions 'Reset the caption for whether or not main menu loaded Sheet1.lblMainMenuLoaded.Caption = "" 'If there are other workbooks open, it will prompt the user to close them If Workbooks.Count <> 1 Then MsgBox "You have other Excel workbooks open. Please close all workbooks before trying to create a request.", vbInformation, "PHIS Request Forms" 'ActiveWindow.ActivateNext Sheet1.lblMainOrOther.Caption = "OtherForm" 'Stops message box in WindowDeactivate event from showing Workbooks("Access Request Form (Main Menu).xls").Close SaveChanges:=False Exit Sub 'If there aren't any other workbooks open, it opens the main menu Else ActiveSheet.ScrollArea = "A1:H40" 'Restricts the vertical scrolling Sheet1.lblMainOrOther.Caption = "Main" 'Tracks which form is being displayed to the user Sheet1.lblMainMenuLoaded.Caption = "Loaded" 'Tracks whether or not the main menu loaded Sheet1.lblMacros.Visible = False 'Gets rid of 'enable macros' error message Sheet1.Unprotect Worksheets("Sheet1").Cells(20, 7).ClearContents ActiveWorkbook.Protect Sheet1.Protect HideBars 'Calls function to remove menu bars SetProgramOptions False 'Calls function to remove gridlines, scroll bars, etc... ActiveDocument.Saved = True Application.WindowState = xlMaximized frmMainMenu.Show End IfErr_Handler: 'MsgBox Err.Number & Err.Description Resume NextEnd SubTo any that at least give an attempt at helpin me out on this one cheers!
i have a pc which doesn't have sql server installed. is it possible to link tables from .mdf file sitting on the pc into access database?
Hi, I have a question. Can MS Access table link to Outlook? Suppose there are Tom and Sue persons: Sue manage the acc.mdb database file, The database has one table which is called "input", Sue made the form, the form is come from "input" table info. and also Sue made one button to send the specific record to the Tom via outlook, once Sue send out, the mail has created a link, which link can open the document (NOT attached file). Once Tom receive the mail from Sue, Tom will click the link to open the document, and also fill out one signature inside the document, after filled it out, then the signature will automatically populate in the specific field of the "input" table in the acc.mdb database file. Can MS Access and Outlook do above situation? Please let me know, thanks a lot.
I'm importing MS Outlook Contacts to Access by "Access Link Table". I have a data in "Contacts Note Field", but this field is not importing to Access. Only following fields are inporting to Access. First Last Title Company Department Office Post Office Box Address City State Zip/Postal Code Country Phone Mobile Phone Pager Phone Home2 Phone Assistant Phone Number Business Fax Home Fax Other Fax Telex Number Display name Email Type Email Address Account Assistant Send Rich Text Primary File As Home Address Business Address Other Address Journal Web Page Business Address Street Business Address City Business Address State Business Address Postal Code Business Address Country Business Address PO Box User Field 1 User Field 2 User Field 3 User Field 4 How to fix it?
Dear all, Does anyone know if ti is possible to link an access table to one stored on an intranet site? This is used for logging help desk calls and various locations need to look at it at the same time. I have tried it and seems to work but I get a "Not a valid file name" message thanks for looking
Access 2000 How do I link a table to excel table so if I add or change things it changes in the other. Bub :rolleyes:
Guys (Girls?),I have found some code on this forum that works great to open a website from VBA, but since it does refer to Internet Explorer, I suppose it will not work if the user of my spreadsheet does have a different webbrowser on his/her computer than IE. Is there a universal way to open a website from within VBA with "the standard program associated with the .html file extention" or something?The code I am referring to is:Sub VisitWebsite()Dim ie As ObjectSet ie = CreateObject("INTERNETEXPLORER.APPLICATION")ie.NAVIGATE "http://websiteaddress"ie.Visible = TrueWhile ie.busyDoEventsWend End Sub
I'd like to code an array of buttons on an excel spreadsheet where I can reference the index number of the button in a shared subroutine Is that possible?
I need to find some way to determine which cell a command button is "located" within so that the macro which it runs can perform its operations only on that row. Any ideas?
I have a database with two tables (tblPhotos and tblPhotoComments). My tblPhotos tables has the following fields: pid, apid (albumID), title, description, uploadDate. In the tblPhotoComments table I have the following fields: cid (primary key), pid (foreign key), cname, comment. Now, I have a webpage used to view a large version and details of an image clicked on the gallery page. On the gallery page each photo is linked with the following address: viewp.aspx?pid={0}. On my view page I have two listviews. One to display the photo and the details and one for the comments, both with the pid = query string field pid. The comments listview allows for inserting records and the insert template is located on the first field. How can I make it that when I fill out the information (Name and comment) the pid of the query is transfered to the tblPhotoComments table in the database, so that when the page refreshes, it will display all the comments that have the pid of the query. I tried doing something with the insert statement in my sql statement, but couldn't seem to get it to work.
I have multiple csv files. I need to copy all of them into 1 Excel file with multiple worksheet for each ... how can I acheive this by writting C# .EXE application?
I have error: Cannot insert explicit value for identity column in table 'UserDetails' when IDENTITY_INSERT is set to OFF. I'm trying to insert a record through a BLL (Business Logic Layer) class with an 'Insert' button attached to the FooterTemplate of a GridView2. My code: [Code].... [Code].... BLL layer code: [Code].... The field 'idUser' is autoincremented. When I use SqlDataSource with a DetailsView, add option it adds a record and autoincrements the 'isUser'.
i have a form with several checkboxes....i want to insert the selected checkbox values in to a single column in the sql database..
I need to read a table from a dtgrid there is one code for example?
I am new to silverlight and I am wondering if it is possible to access silverlight object data from the aspx page that host it. Or have silverlight write to a hidden field on the page on client side. What I am trying to do is to use silverlight to upload file via WCF (client to WCF Service directly instead of posting data back to the web server then forwarded to WCF service). When uploading a large file, user can still do some data entry etc. And once the upload is done have it write some data return by the WCF service to the aspx's hidden field and postback to the server on submit.
I want to transfer data from a access table to a sql table. Simple by clicking a button. first off all i set up and OleDbConnection and a SqlConnection in my web.config file. This is the code i use in a b button method for transfer data for 1 tab le. [code]....
I am using Visual Studio 2008. I created a New Project ASP.NET Web Application. I created a Textbox named VisitorName. The visitor puts in their name and it goes in VisitorName.Text There is a Label that says "Which do you own?" There is a RadioButtonList. It has Cat, Dog and None. There is a button that says Add to list. The button needs to add the results of the above items and put them in the list. Now you keep adding people and their pets. Once there are all entered you press send and I get the results for everyone entered during that session via email. I have no database access and the information does not need to be stored in such a way. I would like to use a datatable or datalist or something to that sort. Oh and I would like the visitor to be able to click on a name in the table and edit the data using the form controls not in the datalist or datatable itself.
In gridview, one of my fields is date. (i have editing enabled). I want, everytime i update the gridview, to get date and store it in [date] field in database.
Iam working on asp.net application,there is a datagridview control displaying the groups of users.....On clicking each group in the datagridview personal info of all the user in the particular group has to be populated and displayed in a spreadsheet.
I have a table with 5 rows and have data in it is there any drag and drop functionality in jquery that i can use to change the order of data inside the table
Count from table Code and show how meny record with the Code are in Table Info--In Field Code in Table CodenameI use this CodenameUSISENI am traing to count how many record are in Table Info with this Codename = US,IS,ENand if I add more Codename into Field Code I still can count from Table Codehow many recoer are in Table InfoIf somone can show me A sample so I can tray this and use to count and show the sum into ListboxTable CodeField CodenameTable InfoField Codename
The attached Access XP file demonstrates my problem. I've included a form to make testing easier. Each record in the Projects table has one or more linked entries in the Keywordlink table, showing keywords that apply to that record. Each record in Projects has a Yes/No 'Utility' field. A third table, Keywords, supplies the keywords that the user can apply to records in Projects, using the subform on the main form. The Keywords table also includes a True/False 'Utility' field. I have set this to True for for the first three keywords. I need a query, a series of queries or some VB code that updates Projects_Utility for all records to True if and only if the record's linked entries in Keywordlink include all of the keywords for which Keywords_Utility is True (a boolean 'and', as opposed to an 'or'). Otherwise, Projects_Utility must be set to False. In the attached file, with the current settings in the Keyword table, the 'GetSelectedProjects' query should then produce single-row listings for ClientA and ClientF. I'd appreciate any help you can give me on this. I'm not a programmer, but I can manage a bit of VB code if I have to.
I have three dynamic text boxes. variables respectively (caption0,caption1,caption2). My xml file is structured as: <?xml version="1.0" encoding="iso-8859-1"?> <captions> <caption>Roll over this</caption> <caption>This is the first Caption.</caption> <caption>This is the second Caption.</caption> </captions> I am trying to create a rollover where when you rollover caption0; caption1 and caption2 are displayed in sequence. Everything works except though only the first caption is ever displayed. For the other two I get "level0.caption1" and "level0.caption2" instead of the text in the xml file above. How do I parse the data so that each of the variables are assigned the text in the xml file?
er trying to develop in asp.net and I think this is the best site that I visited ever.I'm trying to develop webapplications with some controls like calendars, textbox, check box etc. in order to allows to the user to built a query made by himself (and complementing with strings), and of course only to display data according to the gathered information by the controls.
I am new to formview .My formview works fine, when I insert data into the database directly and then do an update on it. It throws an error when I try to insert a new record. The error just says "An error occurred while updating the entries. See the inner exception for details." How to insert data into the table using an entity dastasource?
I implemented PreviousPage to get data from previous page for my search function and display the returned data into a gridview. The gridview's allowpaging is enabled, but every time I go to next page, my previous page data is lost... how can I resolve that?
How do display a list of data returned from the database like this. [code]....
How can I load (copy) the data that is present in the GridView into the DataTable? I am planning on loading the DataTable from GridView and update a row from the datatable and load the newly formed data with the GridView. Note : Here I am not using datasource.
i have a formview <formview> ,,,,, </formview> in the formview i have a lot of fields , ID , Name , Email ,,,,,, etc how can i copy the name to textbox ,?! i have try this : protected void Page_Load(object sender, EventArgs e) { TextBox txt = FormView1.FindControl("Email") as TextBox; Tetbox1.text = txt.text ; }
I am using ASPNET2008 with VB Scripting and not C# Scripting I am encountering new problem. On the WebFrm1, I just don't know how to write the coding to retrieve the CUSTOMERID data in order to retrieve the details from SQL SERVER table to fill the textbox controls.Here is the decription of the GRIDVIEW column In the GRIDVIEW1 on the left edge one of the column is SELECT button which let the userclick on it to select the specific CUSTOMERID on the column next to it on the right. Here are the coding from SOURCE <asp:ButtonField ButtonType="Button" Text="Select" CommandName="SelectClick" DataTextField="CustomerID" > </asp:ButtonField>
I am using asp.net 3.5 framework and mysql as my database. When i am saving malayalam data in to the database having datataype blob, it saves like '????'. But when i insert the specified value directly using the mysql query browser, then i can able insert the correct malayalam value.
I am displaying data in a datalist.i have to repeat the same data vertically twice.
I am relatively new to the .Net development world and I am trying to convert the C# DataList Editing example shown on the ASP.net Quickstart Tutorials page to use a actual database for the datasource, instead of the in-memory example that is given... Can someone give me an example of how the behind code would look like when using a database for this example, instead of using the data in-memory, as the example does... I have the DataList template setup correctly to look like the example does, I just cannot figure out how to load my data in from my database. Any SQL database example, with two or three fields, would be enough to illustrate how this can be done... note that I am looking for a specific solution to the example given on the Quickstart Tutorial.
what i have is a gridview and i have added a new control , textbox, what i want to do is bind the value from a particular column in the Usercontext.searchedresults ( datatable) to it. The issue is that the datasource for the gridview is a Dataview (whcih is a filtered number of columns from the datatable) that does not have that column in it but the Usercontext.searchedresults does have it. i tried the following but doesnt seem to work Text='<%# UserContext.SearchResults.Select("INV_NO = " + DataBinder.Eval(Container.DataItem, "InvoiceNo") + " && INV_LINE_NO = " + DataBinder.Eval(Container.DataItem, "InvoiceLineNo"))[0]["D1_CODE"] %>'> NB: D1_CODE is the new column ..
I need to bind some data to my ASP.Net 3.5 calendar control. The data will be appointments and the fields are appointment datetime and title. The title field should display in the proper day of the month. Also, when a user clicks on a date in the month calendar, they should be redirected to a form to add a new appointment.
this is my ocde [Code].... for this i want show data as india:assam india:bihar india:up but it show the result 0 0 0 why the queary not woriking correctly i am using mysql database.
currently, after allowing the user to login, the controller calls the function in the DAO which retrevies the info from my oracle database. this is the current part of the code that i have, which only allows me to get 1 item from the database and stores it to the string. [Code].... I would like to get more then 1 data from the database such as the the user's name, birthday, userstatus etc.. and put them all into a session data, to allow them to be used throughout the website.
I want to load data from database and show randomly in datalist.. like when user see the page all the data from database showing on the page using datalist or listview. and when the user refresh the page, all the data randomly changed and show in the datalist or listveiw..
I want to give print option to print all data in datalist.
I have a datalist that is populated via a database. I would like to enable the user to update a single field. I have followed the msdn tutorial for updating data within a datalist .. this is working marginally - when I click on 'edit' the datalist disappears, then when i search for the same entry again, the datalist becomes the editable version - [Code]....
I have a DataList for displaying FAQ's from a table that contains the following columns - Question, Answer, Dept and Subject. If there are multiple entries for the same Subject, I'd like to group them together using the one Subject heading as in the example below: Subject 1 Question 1? Answer to question 1. Subject 2 Question 2? Answer to question 2. Another answer to question 2. Still another answer to question 2. My question is how can this be accomplished; the code is pasted below. [Code]....
I have a datalist. I put a linkbottun in itemtemplate and set commandname property to SELECT. I wante when a user clicked on it retrieve information from there. I use this code snipet : Dim dli As DataListItem For Each dli In DataList1.Items Dim i1 As String = DirectCast(dli.FindControl("lblpid"), Label).Text Dim i2 As String = DirectCast(dli.FindControl("lblpname"), Label).Text Dim i3 As String = DirectCast(dli.FindControl("lblprice"), Label).Text Dim i4 As String = DirectCast(dli.FindControl("lblcategory"), Label).Text Session("pid") = i1 Session("pname") = i2 Session("price") = i3 Session("category") = i4 next but it retrieve information of all items in datalist where as I want information about itmes which is select. how can I reach to the index of itme which is clicked?
i am still stumped with this operation: i am trying to retrieve a GridView selected row data..here is my code.. the commented part that gives me the selectedindex works just fine....but the one giving the selected row cell value does't work and there is no error.. The update operation is done successfully...weired. i need to assigned selected row cells values to variables ..do some calculations and then re-assign the result calculation to cell[9].. protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { string s = GridView1.SelectedRow.Cells[5].Text; TextBox1.Text = s.ToString(); //string s2 = GridView1.SelectedIndex.ToString(); //TextBox1.Text = s2.ToString(); }
The date displays just fine in the grid. I am having trouble with deleting the row in the grid. I have researched and played with different things with the grid, but I can't seem to get it to work. Most examples are in VB and I coding is C#. What happens is the code (see *** in C#) doesn't return the column 0 (UserName) from the GridView. So the next statement blows up becasue there is no UserName. I used a ASP.Net VB book I got from a VB class I took to come up with the code. When I typed in "grdUsers.Rows(e.RowIndex)"... I got help from Intellisense, but the rest of the line ".Cells(0).Text"... I got no help. I included below the code that I think is pertinent to the problem I'm having. [Code]....
When I click on my GridView header "End Time" all the rows which contain the string "N/A" disappear. Here is my code: [Code].... Note: GetSortDirection returns "endTime ASC" or "endTime DESC" and save in ViewState: [Code].... Then I fill the DataAdapter and use the ViewState info to sort it: [Code]....
I want to drag table columns of a ajax.loaded table.... is this possible with a jQuery-Script?
Basically, I want to copy all the data which is in my excel sheet to my table. I have succesfully connected into my database using this code:Set newworkspace = Workspaces(0)ODBC_DSN_Type = "ODBC;DATABASE=;DSN=BCP"Set dbase = newworkspace.OpenDatabase("", False, False, ODBC_DSN_Type)and then I began uploading my excel data into my table (table is currently empty) using this code:Dim Rnum As Integer, Cnum As IntegerDim CelVal As String''''UPLOAD EXCEL DATA INTO TABLE''''Set xlapp = CreateObject("Excel.Application")Set xlbook = xlapp.Workbooks.Open(pathfile & "" & file)Set xlsheet = xlbook.worksheets(1)xlsheet.Selectxlapp.DisplayAlerts = Falsexlsheet.Rows("1:1").Delete 'field names in excel sheet'''count the number of rows in the excel fileDo xlsheet.Cells(Rnum + 1, 1).Select CelVal = xlsheet.Cells(Rnum + 1, 1).Value Rnum = Rnum + 1Loop Until CelVal = ""Set dumptable1 = dbase.OpenRecordset(tablename, dbOpenDynaset)ReDim RecArray(dumptable1.Fields.Count)Cnum = dumptable1.Fields.CountFor rrow = 0 To Rnum - 2 dumptable1.AddNew xlsheet.Select For ccol = 0 To Cnum - 1 xlsheet.Cells(rrow + 1, ccol + 1).Select RecArray(ccol) = Trim(xlsheet.Cells(rrow + 1, ccol + 1).Value) dumptable1(ccol).Value = RecArray(ccol) Next ccol dumptable1.UpdateNext rrowuploading my excel data is almost successful. However, whenever it comes to row 64 of my excel where my records is, it gives me an error message:"ODBC – call failed. (Error 3146)" which meansUsing an ODBC connection, you tried to perform an operation on data in an ODBC data source. This error may occur when the ODBC data source is on a network drive and you aren't connected to the network. Make sure the network is available, and then try the operation again.I don't believe that the connection is the problem since when i look up to the current records of my table using MS Access after error occurred, i see all 63 records in my table but somehow the above error will pop-up & the copying of records will not be continued. it will stopped to the 63rd row of my excel and i have like 540 racords/rows with 8 fields/columns still to be added.Can somebody tell me why is this happening? I have observed that when I tried to do in excel a copy & paste of selected rows and save it into the same file that i use for uploading. this problem occurs but i don't know how to fix it.pls. help me. i really, really need your help. thank you very much.~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~
i have a datatable to bind the gridview in my page. now i need to have a export button in near gridview, if we click the button then the gridview values (datatable) to excel.
I want to prepare a excel sheet where the data can be populate from the datagrid. I dont want to create another datagrid to delete the controls. Can any one share the C# code?
HII am making a database to hold on customerthe database is ok and worksbut when I make new record and call customerand then I need to put on the customerthe work and it can be 1 or 5 or more worksThen I need to write to table cust the customerand to table work the work I put on the customerI am traing to link from table cust the record IDand the record in table work If someone can show me sample how I can do thisI realy realy need this Please someone help meor where I can find working sample, "only add new" "Delete" "and call data"this is wery important for me to make this workI use dbgrid to show the customer worksin table cust I use fieldName addressphonein table works I use fielddatenrtextcostcost2link = same number and ID in email@example.com: firstname.lastname@example.com
I made this form and I need it to read the data and write the data to a table and its not working heres the html form I left off the doc type so it dont take up that much room <form> <h1>Telephone Directory</h1> <br> [code]........
I have come from MS Access and am working through a couple of textbooks on ASP.NET 4. I am using the Gridview control connected to an SQL data source control. As an exercise I am converting my simpliest MS Access page which is simple a form to request a new stock item in our engineering stores. I have a normalised table called [stock_requests] and part of this is a field calle [failure_mode]. This field is an integer and there is another table listing the possible values for this field. This other table is called [failure_modes] and has two field: [id] < the primary key [mode] < the text to be displayed In my main table [stock_requests] in the field [failure_mode] I store the [id] from the [failure_modes] table for the applicable record in the [failure_modes] table. So for example if someone wanted to select "Catastrophic" as the failure mode the [stock_requests].[failure_mode] field would be 1; if the user selected "Gradual" as the failure mode the [stock_requests].[failure_mode] field would be 2 etc. Now, the gridview wants to display "1" or "2" but I want to display "gradual" or "catastrophic" without using views and all the headaches that brings. I have managed to sort out editting by using a templated field where I have a drop down list in this cell and I databind to a second SQL data source (imaginatively called SqlDataSource2). what is the best method for displaying the text 'Catastophic' or 'Gradual' etc. when in normal mode (view mode)? Is it another templated field and what is the basic approach I should use? I reckon I should be able to work it out once someone points me in the right direction.
When using NET, what is the preferred method to provide a data file back to the user in excel or other data formats?
I need to copy data from excel to asp.net gridview. I have to select a row and press Ctrl+C to copy from excel, then I have to paste it in Gridview.
I am trying to show data on a datalist, but with some caveats.1. WHERE the User Id = the querystring id pass on the url2. WHERE the table 'resume', the 'permissions' column shows as '1'orWHERE the table 'resume' the 'permissions' column contains within it any number from 2-4, any of which matches one or more numbers in the 'permissions' column of the 'contacts' table (but WHERE the 'contacts' table where the url querystring id = column 'myuserid' and the signed in Profile.UserName = the column 'theiruserid'Its complicted, but i dont know how to reference another data table when selecting data from the first table...?
Basically, for each group of rows belonging to the same category, I'd like to display one big "category" header above those rows. So, for example, i have the following example data: name, category, ID jim, sales, 2 jane, sales, 5 john, sales 8 randy, marketing, 6 sandy, marketing, 44 I'd like to display it like so: SALES jim, sales, 2 jane, sales, 5 john, sales 8 MARKETING randy, marketing, 6 sandy, marketing, 44 I'm using the Datalist control, and the way I've been approaching it is to store the "current" category within some string variable, and for each row that's displayed, I compare the category with the "current" category variable to see if they're equal; if not equal, then I display a new header for the new category and store the new category in the "current" category variable. Sounds simple enough, but I'm having trouble on how to approach this (I'm new to ASP.NET, former ASP user). this is what I have so far: <table width="100%"> <asp:DataList ID="DataList1" runat="server" DataSourceID="SqlDataSource1"> <ItemTemplate> <tr> [Code].... * Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control.
I have a table loaded in an array like so : $table[0][ID] $table[0][text] $table[0][text2] $table[1][ID] $table[1][text] $table[1][text2] $table[2][ID] $table[2][text] $table[2][text2] ...... now I want to sort this table using the ID column.
I created a button on spreadsheet's toolbar. How to connect (link) it to vb code within excel spreadsheet, that is, when I click on the button, it can start the vb program within excel spreadsheet? - thanks
There is a MySQL database located on my remote Linux server. I have written a .NET Windows application to export data to this MySQL database. I want to know whether there will be any compatibility issues regarding .NET / Linux?
I have the code to export a table from an Access db to an excel spreadsheet. however, I'm not sure how to hard code the password based on the working code. I don't want the user to know the password and current when this code runs, it will display a window asking for DB password. I need to hard code it based on my code.Also, is there a way to save the Excel Spreadsheet name with the current day and time??[code=vb]Private Sub ExportToExcel(strMdbPath As String, strExcelPath As String, strTable As String)Dim AccessDB As Access.Application Screen.MousePointer = vbHourglass Set AccessDB = New Access.Application AccessDB.OpenCurrentDatabase strMdbPath AccessDB.DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, _ strTable, strExcelPath, True AccessDB.Quit acQuitSaveNone Set AccessDB = Nothing Screen.MousePointer = vbDefaultEnd Sub''must change this and make it dynamic.Private Sub MDIForm_Unload(Cancel As Integer)On Error GoTo Err_Exit: ExportToExcel "C:SchedulerSchedulerSchedule.mdb", "C:JobTestTable.xls", "Job" Err_Exit: MsgBox "Database wasn't saved!", vbCriticalEnd Sub[/code]Can anyone help???Thanks,efarhat
I have the code to export a table from an Access db to an excel spreadsheet. however, I'm not sure how to hard code the password based on the working code. I don't want the user to know the password and current when this code runs, it will display a window asking for DB password. I need to hard code it based on my code.Also, is there a way to save the Excel Spreadsheet name with the current day and time??Code:Private Sub ExportToExcel(strMdbPath As String, strExcelPath As String, strTable As String)Dim AccessDB As Access.ApplicationScreen.MousePointer = vbHourglassSet AccessDB = New Access.ApplicationAccessDB.OpenCurrentDatabase strMdbPathAccessDB.DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, _strTable, strExcelPath, TrueAccessDB.Quit acQuitSaveNoneSet AccessDB = NothingScreen.MousePointer = vbDefaultEnd Sub''must change this and make it dynamic.Private Sub MDIForm_Unload(Cancel As Integer)On Error GoTo Err_Exit:ExportToExcel "C:SchedulerSchedulerSchedule.mdb", "C:JobTestTable.xls", "Job"Err_Exit:MsgBox "Database wasn't saved!", vbCriticalEnd SubCan anyone help???Thanks,efarhat
how to lock an excel spreadsheet cell with vb code? - Urgent- thanks
how to unlock an excel spreadsheet cell after locking it with vb code? - Urgent- thanksPlease provide me with a bit more detailed code
I'm new to this MotoBlur concept, but I like having an automatic contact backup.. I imported my contacts from the IPhone using their web site and it worked instantly. I also synced with the Gmail contacts and slowly I'm merging them. how the hell do I export the contacts to a new fresh CSV as I make changes on the phone? Does Motorola want me to use Motoblur forever? They don't have an export feature anywhere on their site.
Guys and Gals,I have written a small vba script that executes from a command button in excel. All it does is search the spresdsheet for duplicates and highlights the duplicate cell in red to make it easy to spot. However it is not highlighting the last duplicate of any run. The last duplicate is being seen as an original or unique entry, this is the same for text as integers. Please have a look at my code and let me have some pointers.Code:-Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _ "=COUNTIF(A1:G5000,A1)>1" Selection.FormatConditions(1).Interior.ColorIndex = 3 ActiveWindow.LargeScroll ToRight:=-1 Columns("E:F").Select Application.CutCopyMode = False Selection.NumberFormat = "$#,##0.00" ActiveWindow.SmallScroll ToRight:=-3 Columns("B:C").Select Selection.NumberFormat = "$#,##0.00" Columns("G").Select Columns("G").AutoFitThanks in advance for any help.Steptho.
I am attempting to import and parse a text file into an excel spreadsheet. The user starts the import with a command button. The user can select the file to import and then the information is placed into Excel columns. However, I receive an error message on my QueryTable.Add command. I cannot understand why; the QueryTable.Add command returns a QueryTable, which is the object I am setting it to. The run-time error indicates "Run-time error '13': Type mismatch." The code follows, with the line causing the run-time error in purple:Private Sub btnImportCOA_Click()'Import USPS ACS file 'Variable declaration 'CONSTANTS Const ForReading = 1 'Open text file as Read Only Const FirstCol = "D" 'First column available to be used for imported records Dim FileToOpen 'Name of file to import Dim ValidFile As Boolean 'Flag indicating if user chose a valid file Dim fs 'File System Object Dim ts 'Text Stream Object Dim strHeader As String 'Header record from import file Dim FirstRow As Integer 'First row available to be used for imported records FirstRow = 5 Dim qtCOA As QueryTable 'Query table built from data returned from import file 'Prompt user for choose file to import FileToOpen = Application.GetOpenFilename(, , "Choose COA file to import...", , False) 'Verify user did not click 'Cancel' button If FileToOpen = False Then 'user clicked 'Cancel' button Exit Sub 'no file to process End If 'Sequential access to import file Set fs = CreateObject("Scripting.FileSystemObject") Set ts = fs.OpenTextFile(FileToOpen, ForReading, False) 'Read header record from file strHeader = ts.ReadLine 'Close file ts.Close 'Determine first available open cell to append records to end of recordset While Worksheets("COA").Range(FirstCol & FirstRow).Value <> "" FirstRow = FirstRow + 1 Wend 'Parse file into records Set shCOA = Workbooks(1).Worksheets(1) Set qtCOA = shCOA.QueryTables.Add(Connection:="TEXT;" & FileToOpen, Destination:=shCOA.Cells(FirstCol, FirstRow)) With qtCOA .TextFileParseType = xlFixedWidth 'Length of each field from import file .TextFileColumnWidths = Array(1, 8, 7, 16, 6, 1, 1, 3, 47, 1, 28, 60, 35, 1, 28, 60, 43, 66, 2, 4, 8, 1) 'Column data type for each field of import file .TextFileColumnDataTypes = _ Array(xlGeneralFormat, xlGeneralFormat, xlGeneralFormat, xlGeneralFormat, xlGeneralFormat, _ xlGeneralFormat, xlGeneralFormat, xlGeneralFormat, xlGeneralFormat, xlGeneralFormat, xlGeneralFormat, _ xlGeneralFormat, xlGeneralFormat, xlGeneralFormat, xlGeneralFormat, xlGeneralFormat, xlGeneralFormat, _ xlGeneralFormat, xlGeneralFormat, xlGeneralFormat, xlGeneralFormat, xlGeneralFormat) .Refresh End With
I have done a simple gridview application.But now i want to place the gridview inside a html table.
I got data from different 2 tables and then this selected data trying to insert into new table. Selected data have multiple records. how may i insert selected multirows into new table which has already been created into db. Select fname, lname, Addresses.address from Persons Join Addresses on persons.ID = Addresses.PID The result for this will be multi reocords then how can i insert into new table[already created]. within StoreProcedure
I have a table like pid color make style 01 blue 2004 open 02 red 2002 close 03 red 2003 close 04 blue 2006 open 05 red 2007 open 06 red 2008 open 07 blue 2007 close Now I want to select all records with red color then add another column named num to the returned result which will display the number of each record instead of the pid, which in this case would be num color make style 01 red 2002 close 02 red 2003 close 03 red 2007 open 04 red 2008 open Finally I want to select records with the user specified number range for example If user specifies 2-4, I want to bind these values in a repeater control. Here is what I have done: [Code]....
is it possible to export displayed content of asp.net page to pdf.if yes how


text:
FOR IMMEDIATE RELEASE: TUESDAY, JAN. 18, 2011 (Revised)
Media Advisory — Census Bureau to Hold Web Conference on Release of Local 2010 Census Data
Public Information Office
Release Information
The Census Bureau will hold a webinar to discuss the upcoming release of local-level data from the 2010 Census. States use these numbers — which include data on race, Hispanic origin and the voting population — to redraw the boundaries of their congressional and state legislative districts. The Census Bureau will deliver the data state-by-state on a rolling basis in February and March.
The webinar will provide a detailed explanation of what kind of data will be available, how they will be released, what geographies will be included and how to access the numbers. It will conclude with a question-and-answer session for reporters.
Monday, Jan. 31, 1 p.m. EST
Cathy McCully, chief, Census Redistricting Data Office
Online Press Kit:
Conference details:
Audio conference access information
Toll free number: 888-324-9312
Participant passcode: CENSUS
Questions and answers are limited to media
Online presentation access information
Please log in early, as some setup is required.
URL: https://www.mymeetings.com/nc/join/
Conference number: PW2880841
Audience passcode: CENSUS
Participants can join the event directly at:

subset: commoncrawl


text:
Here is the deal. I am getting a pretty decent amout of money back in taxes this year and am going to put at least two months of horse training in with it. Here are my options and if you think of anything different please tell me, I'm super tired right this moment and open to ideas.
Option A:
I send Oggi (2003 APHA breeding stock mare) back for 2 months of western pleasure training, the trainer is fantastic and get her that much closer to be show ready. She's already got 2 months under her cinch but I am going to keep putting training on her no matter what.
Option B:
I send Rain (2006 Arabian x Pinto mare) for her first time to the trainer. Very easy going. I really should get her broke to ride just to get it over and done with. I can sit on her but we don't move much just turns and flexing. I'd be sending her for 2 months solid.
Option C:
I send both for a month each and maybe just save up enough for another months training for each while they are in training. It wouldn't be guarenteed that I could afford 2 months for both but both could use it desperately.
Also I really want to send Nova (2010 AQHA Dun Filly) in for some touch up work for the halter show season (to work on her showmanship). I could easily show her this season and get her show career started off right.
What do you think?


text:
I've always resisted any offers from friends to join camera clubs as I've never liked the idea of competitions, battles etc.
However, I've recently joined a new independent photography group in my area. It's based on the ideals of IPSE (www.ipse.org.uk) and LIP. We don't have battles or competitions. It's a very supportive group, it gives us the chance to see and discuss each others work. Most people are digital, but it's not important to the group -- it's the image or the portfolio of images that count.
What do other people think of the independent photography group movement?
P.S. We're based in Shropshire around Shrewsbury, so if anyone is based in Shropshire, Powis etc. and is interested then give me a pm. We've got an exhibition next month in Shrewsbury. There's a very basic website at http://sites.google.com/site/marches...ntphotography/


text:
Country Inn Granola
Prep Time: 10 minutes
Yield: 2-1/2 quarts (10 servings)
- Crisco® Original No-Stick Cooking Spray
- 8 cups rolled oats
- 2 cups shredded coconut
- 2 cups sliced almonds
- 1/4 cup wheat germ
- 1 1/4 cups Crisco® Pure Canola Oil
- or 1 1/4 cups Crisco® Canola Oil with Omega-3 DHA
- 1/2 cup honey
- 1/2 cup chopped dates
- 1 cup raisins
- 1/2 cup dried apricots chopped
- 1/2 cup dried cherries
- HEAT oven to 350°F. Spray large baking sheet with no-stick cooking spray; set aside. Combine oats, coconut, almonds and wheat germ in large bowl. Whisk together oil and honey in small bowl. Pour over oat mixture; toss to evenly coat. Spread granola in even layer on prepared baking sheet.
- BAKE 20 minutes or until golden brown, stirring and tossing every 5 minutes. Let cool. Transfer to large bowl; stir in dried fruits. Store in an airtight container. Serve with milk and brown sugar, if desired.
Rated 4.8 out of 5 by 4 reviewers.
Rated 4 out of 5 by vheitman delicious I used the Country Inn Granola as a topping for my yogurt and it was great. April 17, 2013
Rated 5 out of 5 by DKStraub Very Good The granola tastes very good and is good for you. You can't go wrong with this granola. March 30, 2013
Rated 5 out of 5 by cricketwood Sweetens plain yogurt The Country Inn Granola is great mixed with plain Greek yogurt. It adds a touch of sweetness and crunch. March 24, 2013
1-4 of 4


text:
Has anyone taken a Cantonese uni course/lessons in Hong Kong?
I'm thinking of taking a Cantonese course in Hong Kong next year but don't know which is the best to go for.
I have seen some at the Chinese University of Hong Kong as well as the University of Hong Kong and some others - has anyone been on any of these courses? If so, were they any good and would you recommend them?
Would love to hear more detail from anyone who has taken any good Cantonese courses in Hong Kong!
I studied at the Chinese University of Hong Kong and thought it was a good program. They use Yale, but all written materials also include Chinese characters. They have a four week intensive summer program for beginners, as well as regular (three month) term sessions for begineer, intermediate, and advanced. It is definitely worth consideration in my opinion, but you might find it a bit expensive. My only negative comment is that too many people in Hong Kong speak English, so if I were to do it again I would look for a course in China, not Hong Kong. I need to be in a place where I have no choice but to speak Cantonese!
Rob: Thanks for that - just want to find a bit more about the course and the experience really. What was the teaching structure like? Ideally I want to focus on my speaking skills - was there a lot of focus of reading and writing? And how was it being based in Shatin with the other students - was there much stuff to do in your free time (I know it's pretty far out from Central)?
Jing: The focus is very much on conversational Cantonese. Yale is a great way to achieve this, to learn to speak and understand oral Cantonese without having to learn the written language. I think it makes sense to start with a romanzation system first to give you a foundation, and then focus more on written Chinese at a later time at your own pace. If you "follow" me on italki I can send you some more information, or send me your skype/wechat contact information and maybe we can have a chat about it in Cantonese (or English).
Add a comment
More discussions
- British accent please ( how or where do I find real British English conversations to learn the accent ¿)
- English sounds like other language
- Association
- Thinking about moving o Japan for 3 to 6 months.
- Deutche band
- where can I find videos to heart the Aussie accent?
- Help for English!
- how to say in german ?
- Help with giving directions!
- EU visas. Teach English while studying a foreign language


text:
Your cart is empty!
Chaser 5-Hour Energy is a powerful blend of vitamins, enzymes and other energizing nutrients designed to help you get going fast, and keep you going for up to 5 hours.
Features of Chaser 5-Hour Energy Drink
Active Ingredients
Per Tablet: Magnesium Oxide 400 mg USP.
Inactive Ingredients
Purified Water, Glycerin, Glucuronolactone, N Acetyl, L Tyrosine, L Phenylalanine, Taurine, Malic Acid, Caffeine, Natural Flavors, Ascorbic Acid, Potassium Sorbate, Sodium Benzoate, Pyridoxine Hydrochloride, Niacin, Proprietary Blend : (Enzyme), Sucralose, Cyanocobalamin, Folic Acid.
For best results, take Chaser 5-Hour Energy on an empty stomach. Take it twice a day to help you perform at your best, morning, noon and night. Shake well.
Phenylketronurics: Contains Phenylalanine. Tamper Evident: Do not use if seal is broken.
This was my favorite drink as a kid and I still love it. This tastes more like an orange than the obviously artificial plain "Orange" flavor Kool-Aid. t's the best flavor so I guess I'll be stocking up!
This product would assist me in weight loss and gives me more energy. This is high in fiber and added no sugar in it. It also contain so many vitamins and minerals. It tastes delicious mixed in with fruit, almond and coconut milk.
This sports drink extends endurance, it is naturally flavored. The taste is actually pretty good. This is my sports drink for long distance running and triathlons. I think Accelerade is a great product for the serious athlete.Highly recommended.
I like the taste of the product, especially the fruit fusion and watermelon flavored. It is a great mix of caffeine and amino acids. Highly recommended.
Kool-Aid has the best flavor.I drink a lot in summer.This is my favorite cool drink and i loves it.


text:
Buzz: Shane Doan and the Sharks (Now The Pens)
1:22PM: According to the Pittsburgh Post Gazette, via PHT, the Penguins have made their offer for Shane Doan and that there is "mutual interest"
8:31AM: In the San Jose Mercury News, via Spectors Hockey, Shane Doan's agent Terry Bross indicates that should Doan leave Phoenix, he would be very interested in joining the San Jose Sharks.
The report indicates the the Sharks, along with the LA Kings, have offers on the table for Doan.
It has been reported that Doan is likely to stay out West if he doesn't stay in Phoenix.
It has been suggested that Doan may not make a decision until the end of this week.
Doan reportedly has an offer from an Eastern Conference team worth $30 million over four years.


text:
Tuesday, October 23, 2007
© Copyright 2015 Gwinnett Daily Post
The Dalai Lama and a rock star walk into a Waffle House. The Dalai Lama scans the menu and orders chili. The rock star looks over and says: "Man, I should pray for you."Sounds like a joke. But it could have happened this past weekend in Atlanta - if the Dalai Lama went to bed later or Kid Rock ate earlier. This weekend, Atlanta experienced an odd convergence, one of the world's great spiritual leaders coming to town at the same time as a guy sporting a CD called "Rock N Roll Jesus." I'll give you one guess which one was arrested after a late-night altercation at Waffle House. The Dalai Lama was in town to be installed as a visiting professor at Emory University, which is just around the corner from the restaurant where Kid Rock, birth name Robert James Ritchie, got into an altercation that led to his arrest and the arrest of five other members of his entourage early Sunday morning. Apparently Kid Rock, the self-professed "Hick-Hop" artist, and his crew aren't quite as at peace with the world as the man staying only miles away from where they got in trouble. Though he has the No. 1 album on the charts, that didn't stop Kid Rock, in town to play the Tabernacle on Saturday night, from being pulled over after his tour bus left the restaurant. Over at Emory, things were much more calm and refined. It was a big weekend for the school, which welcomed the Dalai Lama for his first ever teaching professorship at a university in the United States. He was officially installed as a professor on Monday, with the students giving him a faculty ID card as a gift. The student who presented the ID to the Dalai Lama, very recognizable with his shaved head and flowing robes, said she figured he didn't need it to prove who he was. But the students wanted to make sure the exiled Tibetan spiritual leader knew he was welcome at their campus. It was a nice gesture, one that makes for an interesting juxtaposition between the visitor on a quest for peace and the one on a quest for afterhours hash browns. Between the man who fights (figuratively) for a free Tibet and the one who fights (literally) at the slightest provocation. Between the man who says: "I am just a simple Buddhist monk - no more, no less" and the one who says: "I'm a cowboy." That these two men could be in the same town on the same weekend with each representing themselves in familiar fashion says a lot about us and our tolerance. It's not always perfect, but everyone gets a chance. So we've got that going for us, which is nice. E-mail Todd Cline at firstname.lastname@example.com. His column appears on Tuesdays.
More like this story
- Dalai Lama installed as professor at Emory University ( October 27, 2007 )
- World briefs ( October 10, 2008 )
- World briefs ( October 7, 2009 )
- Dalai Lama brings message of compassion to Gwinnett ( October 8, 2013 )
- World briefs ( October 18, 2007 )


text:
There will be a lot of movie ads during the Super Bowl
Since its origins, television has always been supported by the movie industry. It makes sense since they're so interconnected (television is mostly an ad-based revenue stream and I've heard that the marketing budget of a lot of studio films is something like 40% of its total cost).
I'm sort of sorry to hear this. I'm not a sports fan but have always tried to catch the Super Bowl because of the clever commercials. It's not likely that Star Trek or X-Men Origins: Wolverine is going to do a Bowl-specific ad. On the other hand, if they did get Hugh Jackman to dress in costume and puncture a football with his claw, or Chris Pine to vaporize it with a phaser, it would be the talk of the water cooler the next day.
The commercials of Super Bowl XLII: A summary
Super Bowl XLII is all done except for the cleanup and the hangovers. And, you are probably doing one of two things right now. Either you are joyously celebrating the win of the Wild Card New York Giants over the undefeated (until Sunday) New England Patriots, or your are cursing out that f@#&ing Tom Brady and coach Bill Belichick for screwing up a perfect season and, most likely, starting a new sports curse in New England.
Oh well, at least you have the commercials to take your mind off of it all if you were a Patriots fan. This year's crop was pretty diverse with a mix of serious and humorous ads. Plus, a little star power thrown in just for taste. Thanks to Jason Hughes, Jen Creer, JJ Hawkins, and yours truly, TV Squad has postings about every new commercial that aired, from the E-Trade baby to the guy who attached jumper cables to his nipples.
If you're scratching your head on what the hell I mean then jump over to the next page, where you'll see a list of links to all of our commercial reviews.
Budweiser: "Rocky"
Oh, and of course Hank makes the hitch team the following year. The high five at the end between the dog and the horse was just perfect. I don't know what it is, but Anheuser-Busch simply has one of the best advertising and marketing teams as they virtually never miss when it comes to their Super Bowl ads. Another banner year for them it looks like.
Sony Pictures: "You Don't Mess With The Zohan"
It's not baby-talking Adam Sandler, it's not sensitive yet funny Adam Sandler, it isn't even serious and angry Adam Sandler. It's Adam Sandler as Borat. Well, from the preview that was shown it seems like he's channeling Borat.
I guess Adam is taking a break from some of his more serious roles to go back to his wacky comedy roots. However, since this isn't Cinematical I'm not going to debate whether or not this is a good idea for Sandler. All I'm going to do is rate the preview. Eh, not that funny. Seen it all in plenty of other previews before. Maybe the movie will be better.
Toyota: "Big Wheels"
All kidding aside, I like how this commercial appeals to the immature masochistic side of me. I'm talking about the side that would like to get on a big wheel on a steep hill with little to no padding and roll with only a few bails of hay resting between me and imminent death.
That's seems to be the demographic Toyota is shooting for here, and I'll be damned if they didn't nail it.
Coca-Cola: "Carville & Frist"
That said, I think I could have picked some opponents that would have made for a much better commercial. Don't get me wrong, I know politics is in the air and it was very timely to have Carville & Frist together in a commercial, I have two quick ideas that could have worked just as well.
E-trade: "Baby Trader II"
Remember that E-trade baby ad you saw in the third quarter? Well, the fourth quarter version of the commercial was about the same, except there was someone making balloon animals in the background.
I'm not a big fan of the talking baby commercial, even if it is popular. As many parents will agree, we aren't in any hurry for our children to talk Because, once they do start speaking they don't stop. Then, they start talking back to us telling us that we need to get them this toy, or need to get them that item of clothing. Before you know it they're screaming at you because you won't spend one thousand freakin dollars for a Hannah Montana ticket because, you know, you like to pay the mortgage, and ...
Um, was that out loud? Anyway, cute baby and okay commercial.
NFL.com: "Super Ad"
Personally, I thought Matt Hasselbeck's commercial was a little bit more entertaining, but Chester Pitts commercial wins in the inspiration department hands down.
How often do you hear a tale of a normal person getting plucked from a dead-end, everyday type of occupation and becoming an elite athlete in what is arguably the most prestigious professional sports association in this hemisphere?
Amp: "Jumpstart"
Here's what I didn't notice about this commercial until I saw it again on my DVR -- there's a little notice at the bottom of the screen that says 'Warning: Do Not Attempt". What are we talking about here? Are they telling us not to place jumper cables on our nipples (because, if that's the case, then they're too late) or are they telling us not to dance to Salt n' Pepa's Push It? I think we need some confirmation here.
Either way, this was one of the funnier commercials during this year's Super Bowl. I mean, how can you go wrong with a overweight guy who gets down to a popular 80's dance tune. It just proves that sometimes you need to go for the crass rather than for the smart to get your message across.
Bud Light: "Ability to Fly"
While this commercial was funny, I don't think it's up to par with the typical commercials they put out there. There was just something off about the pacing and really just the overall concept that left me wanting a little more.
Victoria's Secret: "Model"
Do I really have to say anything about this ad? It features a Victoria's Secret model dressed in a lingerie, holding a football, and looking sensually into the camera. I guess if there words to say about this ad they would be: perfect, wonderful, best ad ever, amazing, and...Duh!
Hey, it's the Super Bowl -- holiday for the male chauvinist pig! You expect me to be sensitive and caring? If you want that then call Alan Alda or Hugh Grant. Me, I'm just going to stare at her a little bit more.
E-trade: "Baby Trader"
Stick a baby in a Super Bowl commercial and make it talk and puke? You've probably still got a winning combination on your hand even though it's absolutely disgusting watching anything puke.
Gatorade: "Thirsty Dog"
I have never owned a pet in my life here on planet Earth. So, watching a 30 second commercial of a dog lapping up the water in his bowl wasn't that intriguing to me. Maybe it was interesting for pet owners as they were able to compare the way this dog drank as opposed to their dogs.
Having said that, I think that this was a clever ad pointing out that we humans should be replenishing our bodies with fluids just like our pets do. Granted, we need to do this with Gatorade, as the ad states, not with good old fashioned water. That, of course, would be sacrilege. Frankly, I think the Derek Jeter ad was more entertaining than this one.
Hyundai: "The Genesis"
Buying a Hyundai Genesis, that's what.
It's not that I think Hyundai makes a bad car. On the contrary, I think that Hyundai makes atrocious cars. Everyone that I know that has ever owned one wishes they would have gotten a Honda or a bicycle. I'm not even kidding.
Doritos: "Mouse Trap"
I admit it. I laughed out loud.
TV Squad Hot Topics
Most Popular Articles
From Our Partners
- 'The Voice' Season 9: Meet Blake Shelton's Team
- 'The Bastard Executioner' Recap: Can Lady Love Prove She's Pregnant?
- 'Scream Queens' Recap: Who is the Hag of Shady Lane?
- 'The Voice' Season 9: Meet Pharrell Williams' Team
- 'iZombie' Season 2 Premiere Recap: Major and Blaine Wrestle with the Zombie Cure's Side Effects
- More From BuddyTV
- Kate Hudson Shows Off Her Enviable Abs
- Jay Leno Tags in for Jimmy Fallon During 'Tonight Show' Monologue
- Tom Hiddleston Reveals the Real Reason Loki Wasn't in 'Avengers: Age of Ultron'
- Kanye West Says Fatherhood Made Him 'Rethink' The Way He Raps, Believes 'KUWTK' Should Be Winning Emmys
- The Dangers of Celebrity Yo-Yo Diet Transformations
- More From ET


text:
From the September 8 edition of Fox News' The Kelly File:
Loading the player reg...
From the June 26 edition of Fox News' Outnumbered:
Loading the player reg...
From the March 4 edition of Fox News' The Real Story with Gretchen Carlson:
Loading the player reg...
Fox News hosts defended the practice of catcalling, insisting women should "let men be men" and downplaying the harmful impact widespread street harassment has on women.
On the August 28 edition of Fox News' Outnumbered, hosts highlighted a New York Post opinion article that suggested women "deal with" "flattering" catcalls. Co-host Kimberly Guilfoyle defended street harassment saying, "let men be men," and, "look, men are going to be that way. What can you do?" Guest host and Fox contributor Arthur Aidala reenacted his personal signature "move" -- aiming a slow round of applause at women on the street, which one host said she'd find flattering:
Fox News made light of the real threat that domestic violence and stalking pose to women during a discussion of a man's arrest for violating a restraining order.
On January 10, Thomas Gagnon was jailed for reportedly sending his ex-girlfriend, who had a restraining order against him, an email invitation to join Google+.
While discussing Gagnon, Happening Now co-host Jon Scott downplayed the gravity of violence against women by suggesting that men don't take restraining orders seriously because they "know there are a lot of overly-vindictive women out there." Guest Fred Tecce similarly made light of stalking, joking that the email should have said "I'm cold hanging out here hiding in the bushes behind your house." Tecce and fellow guest Arthur Aidala quickly swept aside co-host Jenna Lee's observation that the perpetrator may have had a history of violence, as Tecce joked that "she had to get a restraining order because the guy was trying to get his ring back and she just didn't want to give it back to him":


text:
Golden crosses in both the Gold Trust SPDRS ETF GLD, +2.12% and the Market Vectors Gold Miners ETF GDX, +8.05% suggest higher prices for bullion and miners, alike in the near term. And while a similarly gilded crossover still awaits silver — basis the iShares Silver Trust ETF SLV, +4.68% — that market's triangle pattern may already be tipping silver's hand.
I've been talking about the likelihood of higher prices for both gold bullion and the gold miners for a month now, ever since both the GLD and GDX made successful trend reversals in early June and late May, respectively. Often, what's good for the gold is also good for the silver, and having neglected to talk silver a month ago when that market was making its low, the looming golden cross in that market provides a great opportunity to make up for lost time.
Golden crosses are technical patterns involving a pair of moving averages: one short-term, one longer-term. And while every market chartist and crafty technician will have his or her favorite set of moving averages (the 5- and 20-day moving averages were a popular combination when I first began studying golden crosses over a decade ago; the 8- and 34-day moving average combination is among the more popular combinations used today), the point behind gold crosses remains the same: a shorter-term moving average crossing above a longer-term moving average is referred to as a "golden cross" because it implies that the market may be gaining momentum to the upside.
Figure 1. A golden cross in the GLD.
By contrast, a "death cross" occurs when a shorter-term moving average crosses below a longer-term moving average. Here, the pattern reveals that momentum is likely accelerating as well, only to the downside rather than the upside. SLV, for example, has been under the sway of a "death cross" since mid-March, when the ETF was trading at just over $32 a share. The iShares Silver Trust ETF is down well over 13% since then, including its bounce from the mid-May lows.


text:
My Account
About Us
Privacy Policy
Customer Service
Contact Us
Get Social with us
Order Online or Call Toll Free 1-888-229-3020
Visit Our Blog
Gift Reminder
Photo Accessories
Photo Accessories
Photo Accessories and
Scrapbooking Supplies
that are as fun as they are functional can be tough to find, especially when you're looking for the perfect Scrapbook Embellishments to add personality and dimension to each and every photo. Luckily, at StorePhotos.com, we carry a great selection of scrapbooking supplies that are perfect for making your album and scrapbook pages pop! From acid free glue to archival safe
Photo Mounts
, we have everything you need to build scrapbooks and photo albums that are both beautiful and memorable. After all, isn't that what scrapbooking and photo albums are all about? Start making the most of your memories by getting the supplies you need for an unbeatable price!
Magnetic 4x6 Photo Holders
Magnetic 5x7 Photo Holders
Magnetic 2.5x3.5 Photo Holders
Photo Memory Cleaning Cloth
Photo CD Markers
3-D Self-Adhesive Black Letters
3-D Self-Adhesive Silver Letters
3-D Self-Adhesive Gold Letters
Permanent Photo Memory Fix Roller
Removable Photo Memory Fix Roller
Photo Mounting Squares Auto Mounter
250 Photo Mounts
500 Mini Photo Mounts
Photo Memory Mounting Taper
3-D Foam Dots
Pioneer Photo Albums
New Photo Albums
Classic Photo Albums
Leather Photo Albums
Magnetic Photo Albums
3-Ring Photo Albums
Frame Photo Albums
Designer Albums
Fabric Photo Albums
Sewn Photo Albums
Baby Photo Albums
Wedding Photo Albums
Natural Paper Albums
Mini Photo Albums
Cheap Plastic Albums
4x6 Photo Albums
5x7 Photo Albums
8x10 Photo Albums
3.5x5 Photo Albums
Wallet Size Photo Albums
APS/Panoramic Albums
Digital Photo CD Photo Album
Pioneer Scrapbooks
New Scrapbooks
12x12 Scrapbooks
12x15 Scrapbooks
5x7 Scrapbooks
8x8 Scrapbooks
8.5x11 Scrapbooks
Jumbo Scrapbooks
Frame Scrapbooks
Leather Scrapbooks
Fabric Scrapbooks
3-Ring Scrapbooks
Snapload Scrapbooks
Scrapbook Kits
Travel Scrapbooks
Wedding Scrapbooks
Baby Scrapbooks
Refill Pages
Photo Album Refill Pages
Scrapbook Refill Pages
Extension Posts
Photo Storage Boxes
Digital Photo/CD
Wedding Albums
Baby Albums
Photo Accessories
Scrapbooking Supplies
Mounts and Corners
Glue Sticks
Memory Tape
Photo Album Closeouts
Scrapbook Closeouts
Photo Box Closeouts
Album Inspiration
Summer Scrapbooks: Ways To Celebrate The Sunny Season!
Keep Your Special Day Alive With These Wedding Scrapbooks
StorePhotos.com � Your One Stop Shop For Archival Photo Storage!
Create A Storybook Of Memories With These Bound Photo Albums
Leather Photo Albums: A Stylish And Practical Way To House Your Memories
Mother's Day Scrapbooks Think Outside The Box!
Wedding Scrapbooks � The Big Pictures Of Your Big Day!
Leather Family Photo Albums � As Classic And Timeless As Family Itself
Baby's First Photo Album � The Cutest Album You'll Ever Create!
Easter Scrapbooks Remind Us To Be Thankful
Magnetic Photo Albums � Easy Organization of Your Memories
Memory Scrapbooks � Your Life At Your Fingertips!
Pioneer Scrapbook Supplies � A Charming Choice!
Essential Scrapbook Materials Enhance Your Memories
Large Scrapbooks For Lots Of Memories!
Graduation Scrapbooks Get Top Marks!
Wallet Photo Albums � Take Memories On The Go!
Simply Stylish 4x6 Photo Albums!
Show Your Appreciation For Your Furry Family Members With Pet Scrapbook Albums!
Fathers Day Scrapbooks Are Tops For Pops!
Capture Your Special Day With Wedding Picture Album Layouts
View More...
Sign up for special offers and announcements!
We respect your privacy
Order Online or Call Toll Free 1-888-229-3020
Get Social with us
My Account
About Us
Privacy Policy
Customer Service
Contact Us
Site Map
Copyright © 2002-2010 StorePhotos.com. All Rights Reserved.
eCommerce Design
by Solid Cactus


text:
I think we should all be taking notes here, guys.
The following link will direct you to some really important baby rules.
Sullivan, I'm going to say it's okay if baby has a snorkel properly fitted.
♥ Married my best friend in 2009
♥ Baby Boy born 04/24/2012
♥ Baby Girl born 10/16/2013


text:
Published Wednesday, January 30, 2013
As I caught clips of the inauguration, I wondered if Martin Luther King Jr. and Abraham Lincoln were rolling in their graves.
Both men fought valiantly to free black Americans, to afford them opportunities to prosper, to be paid a honest day's wage for an honest day's work and be paid the same wage as the white American next to him provided he did the job just as well.
Men who wanted black Americans to be able to walk into any school of their choosing, get on a bus without having to sit at the back, to drink from any water fountain they chose or eat at any lunch counter they desired. Men who didn't deign to have the black or white Americans be dependent on the government, be told what medical insurance they were required to buy and, take from those that had worked hard and earned their money and give to those that were lazy so everybody had an equal share just by virtue of being born. Men who wanted black women and men to have freedom, justice, opportunity without fear of retribution.
President Barack Obama placed his hand on the Bibles of King and Lincoln and said he would defend the Constitution of these United States.
The same man wants to take away liberties, rights and tax until there is no money except what goes to the government and that the only two classes are government dependents and the politicians in Washington.
He is a man who would rather tell black Americans he will take care of them whether they aspire to take care of themselves or not, a man who has made women running around screaming for an Obama phone and Obama money the norm, and people that criticize people like that are called racist instead of honest, revenue -producing Americans.
If King and Lincoln were alive today, would they believe their dreams of freedom and justice and judging a man by the content of his character not the color of his skin had been realized, or would they realize that somewhere along the way the words that JFK used -- "ask not what your country can do for you, but what you can do for your country" -- became just that, empty words and not realities.
Lisa Gunter, Newnan


text:
Have you sold gold jewelry?
posted at 3/4/2010 4:17 PM ESTHave you sold gold jewelry - or other personal belongings made of gold - to a jeweler or internet-based gold purchaser?
How much did you get for your gold? Do you think you got a fair price?
Share your stories and experiences with selling gold.
Re: Have you sold gold jewelry?
posted at 3/5/2010 9:15 AM ESTI sold a bunch of empty 18K and 14K ring settings, broken chains and single earrings to the local jeweler in my town last week. I was surprised by how much he gave me. Also, when I said I'd like a store credit instead of cash, he gave me 13% more.
Re: Have you sold gold jewelry?
posted at 3/5/2010 9:50 AM ESTi'd like to know where to sell it.
Re: Have you sold gold jewelry?
posted at 3/5/2010 10:39 AM ESTIn Response to Re: Have you sold gold jewelry?:i'd like to know where to sell it.
Posted by chunkletI can help. I am part of Party of Gold, a very well respected gold buying company. We do in home parties and pay very competitive prices for your gold. When you host a party you'll receive 10% of the total we pay out.
Re: Have you sold gold jewelry?
posted at 3/5/2010 10:58 AM ESTYes, I sold some jewelry last mont at a store called The Family Jewels in Northampton, MA. I was very pleased with the outcome. I also sold gold jewelry to a jewelry store in Holyoke last year and also walked away with a fist full of cash. Why anyone would ignore the legitimate jewelers in their community in favor of mailing an envelope to an unknown company is beyond me.
Re: Have you sold gold jewelry?
posted at 3/5/2010 11:20 AM ESTTuscarora: So how much is a fist full of cash?
Re: Have you sold gold jewelry?
posted at 3/5/2010 11:31 AM ESTEVERYONE: Hold on to your gold!
Its important to remember that the value of gold does not change but its the value of currency that has gone down and booms the golds market price.
Re: Have you sold gold jewelry?
posted at 3/5/2010 11:31 AM ESTMy wife had a Party of Gold shin dig at our home.
After consuming some Crown and soda, I would offer 10% more than the party of gold woman. She of course became slightly irritated.
More Crown/soda....I increase my offer to 15%.
And to be honest I still think I left money on the table.
PS Send more Crown.
Re: Have you sold gold jewelry?
posted at 3/5/2010 12:52 PM ESTA good friend of mine has a locally based company that buys unwanted Jewerly.
According to them, they have the highest payouts out of all the online sites out there.
Re: Have you sold gold jewelry?
posted at 3/5/2010 1:35 PM ESTIwantthegold.com They email you an estimate of your gold value so you can say yes/no. Safer than a jeweler.
Re: Have you sold gold jewelry?
posted at 3/5/2010 2:28 PM ESTHello Chunklet,
My name is Darren Danico. I am the Director of GoldenGettogethers. Unlike most companies in the industry that pay 10% to host a party we pay 15%. We also average approx. 70% on spot price. You can contact me for a no obligation discussion on what to look for and how to get the most money for what you have. Even if you decide to go to someone else I hate to see people get taken advantage of. My e-mail is firstname.lastname@example.com My toll free # is 888-727-2798 and just ask for me. I look forward to hearing from you.
Re: Have you sold gold jewelry?
posted at 3/5/2010 5:00 PM ESTI sold my gold at a "Party of Gold" house party. I had 2 rope chains, 1 open loop chain, 1 herring bone necklace, 1 rope bracelet, 1 open loop bracelet, 1 very thin gold bangle, 2 rings, and 3 pair of gold hoop earrings. I received 750.00. That was actually better than the amount I was offered by a local jeweler. Could I maybe have done better? Yes, but would I have really put the effort in to getting multiple estimates? No. This was an easy and fun way to make some cash off of stuff that I would never have worn and potentially might have just thrown away. If you do your research and go in with realistic expectations you'll be ok. I do have to say I can't imagine That I would ever mail my stuff off to some random place in another state.
Re: Have you sold gold jewelry?
posted at 4/22/2010 5:58 PM EDTStop getting ripped off. Sell to the refiners and get 95 to 99% of it's value. Dillon Gage Refinery, 11312 Indian Trail, Dallas, Texas 75229, phone 888-436-3489.
Website: http://www.dillongage.com/Metals/RefiningServices/tabid/31/Default.aspx use them if over an ounce of gold covers $30 fee
Dillon Gage would be our first choice. They pay 98% of the gold value on the first 50 ounces and 99% beyond that. There is a $30 assay fee per lot.
They don't accept gold-plated items. They do accept gold-filled "if you have 10 pounds total weight of gold-filled or more." The terms are less attractive than for karat gold – 80% of the gold value – but unless you've been a busy, busy burglar, you're not likely to have anything close to the 10-pound minimum.
Dillon Gage has been in business for 33 years, and we had no difficulty contacting the refinery whenever we called. And D.G. is one of the players in the industry.
Precious Metal Recovery (a division of Northern Refineries), 29509 Sierra Point Circle,
Farmington Hills, Michigan 48331, phone 800-882-7729.
Website: http://www.preciousmetalrecovery.com/
PMR pays 95% of the gold value, but they charge no assay or other fees. They are accredited with the Better Business Bureau and claim "many happy customers."
They will accept gold-filled, but only in quantities of "at least 8 lbs." They don't accept gold plate, because "it's not worth the cost to extract it."
One negative: on a call during business hours, we could only leave a message. They did call back the same day but then cut the call short. We had a better experience with Dillon Gage.
Which smelter gives the best return? Dillon Gage charges an assay fee but pays a higher percentage of the gold value, so they will net you more cash for orders over a certain weight. At today's gold price, here's a good rule of thumb: if you have over one ounce of gold, Dillon Gage pays the best return; for silver, anything under 45 ounces would fetch a better price from PMR. Higher metals prices would lower the weight threshold at which you would do better with Dillon Gage.
You may find other refineries you like better. Basic due diligence standards apply: check fees, turnaround time, and reputation.
Re: Have you sold gold jewelry?
posted at 8/26/2010 6:11 AM EDTyes, and quite a bit of it over the last year or so, and learned a lot. gold parties are usually a rip off, and in many cities and towns are illegal. apparantly too easy to get rid of stolen goods, hosts can be held liable. I prefer dealing with local dealers who are licensed and are actually held accountable by law and are licensed, very good luck with Goldcrafters Exchanges in Stoughton, and Weymouth. Fun and interesting places to use. Their many repeat customers show me they are pretty good to deal with. Also great for buying from.
Re: Have you sold gold jewelry?
posted at 6/19/2014 7:49 AM EDT
To be honest i never been experience having gold even though i have a nice status in life ,right now i have a 3 job and one of them is being a real estate agent at http://www.parhaattoimitilat.fi/ where i really enjoy it cause in a year i can earn lots of money from it.


text:
Peter Krause and Lauren Graham Go From TV Siblings to Real-Life Couple
"Nobody knew about it for awhile, because we like to be at home, cooking and not going out," Graham told Redbook in its upcoming Sept. 21 issue. "I've also been really protective of it, because it's important that you can buy us as brother and sister on the show."
This makes Krause and Graham the latest in a line of faux incestuous TV couples -- actors who play relatives on-screen while engaging in a romantic relationship off-screen. Married 'Dexter' stars Michael C. Hall (Krause's 'Six Feet Under' castmate) and Jennifer Carpenter portray (adoptive) siblings Dexter and Debra Morgan.
On 'Brothers and Sisters,' the characters of Rebecca and Justin found out their were half-siblings during the first season. Meanwhile, the actors involved, Emily VanCamp and Dave Annable, were dating. Later, the characters discovered they weren't actually related and became romantically involved -- and eventually got married. But off-screen, VanCamp and Annable broke up. On Facebook, this one would definitely be labeled "It's Complicated."
Do you think it's weird when actors playing relatives hook up off-screen?