Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

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

    SQL Server nvarchar to Crystal Reports number overflowed an int colum

    Tables and Views contained in a SQL Server database contains a field (Parcel_UID) defined as nvarchar(50) This field contains a 13 digit number (e.g. 1000017299772) I use Crystal Reports 9 to connect to the SQL Server database so that I can use the views to create a report However, Crystal...
  2. mophead

    Excel: named range will not accept new range value

    I have 2 worksheets in the same workbook On worksheet "PIR-DT MTH" there is a cell (i.e. "E3") which contains a string value representing a range of cells, eg. "C4:L32" This range value changes due to specific triggers which aren't important In "PIR-DT MTH", there is a named range called...
  3. mophead

    .asp Feedback form

    I created a feedback form using the template provided in FrontPage 2000. I saved the form on my web as Feedback.htm I configured the Frontpage server extensions on the server to specify how mail should be sent etc. I tried the form out and it worked...cool However, I repeated the same process...
  4. mophead

    Transferring Access data (formula) to Excel worksheet-calculation not

    I am working on a project which basically transfers data from Access tables to Excel worksheets. Some of the data is in the form of formulas. Hence, a table would have a formula field with the formula string/text (eg. =utilities*3). Below is a portion of my code where I am getting the annoying...
  5. mophead

    Transferring formulas from Access to Excel

    I am doing a database application in Access which entails having to transfer a lot of information, including formulas from Access to Excel. I envision I will be running into a lot of problems, but here is one I can't figure out. The portion of code below shows where the problem develops. I am...
  6. mophead

    Using openrecordset with query giving run-time error 3061

    I am getting a run-time error 3061 when using openrecordset command with a query. I am testing and learning code to export table information to an MS Excel worksheet. I have pasted the code below. Now I have used this code over and over several times and never had any problems until now. CODE...
  7. mophead

    run-time error 3061 using openrecordset command with a query

    I am getting a run-time error 3061 when using openrecordset command with a query. I am testing and learning code to export table information to an MS Excel worksheet. I have pasted the code below. Now I have used this code over and over several times and never had any problems until now. CODE...

Part and Inventory Search

Back
Top