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 derfloh 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: *

  1. ncalcaterra

    How can I perform calculations on multiple baserows in my horizontally

    Here's my tiny example... I have a report with a column definition that includes a column for calculating the % of Gross Sales as well as a column for calculating the % of Net Sales. In the Row Definition, I set the CBR to row 280 (gross sales). A little further down in the rows I set the CBR...
  2. ncalcaterra

    Batch uploading photos and adding user defined info to all images

    ...folder to load images from") If Not IsEmpty(strFolderName) And Not strFolderName = "" Then strFile = Dir(strFolderName + "\" + "*.jpg", vbNormal) While (Not StrComp(strFile, "")) If Len(strFile) > 1 Then strFullPath = strFolderName +...
  3. ncalcaterra

    Adding filename to a separate text field when batch uploading images

    I was able to hear back from DBPix and the problem was resolved by taking the following action to the code I pasted above: Replace the following line: DBPixMain.ImageLoadFile (strFullPath) With this: If DBPixMain.ImageLoadFile (strFullPath) Then [PathField] = strFile End If...
  4. ncalcaterra

    Adding filename to a separate text field when batch uploading images

    ...folder to load images from") If Not IsEmpty(strFolderName) And Not strFolderName = "" Then strFile = Dir(strFolderName + "\" + "*.jpg", vbNormal) While (Not StrComp(strFile, "")) If Len(strFile) > 1 Then strFullPath = strFolderName +...
  5. ncalcaterra

    Import/append sprdsht into an accss table, using file browser

    Hi, I know there are a lot of posts out there on importing an excel spreadsheet into access, but I can't seem to paste them all together to find something that works. Here's what I have: table name = tImageLog primary key of table "tImageLog" = ItemID (data type = number) form name = fAllInOne...
  6. ncalcaterra

    SQL Mirroring

    1.) I user I was referring to was a domain user with admin rights on the local server, ie NOT the domain admin as I originally posted. 2.) After successfully running the SQL service under this user account on a new instance AND using a log backup as well as a full backup, everything worked...
  7. ncalcaterra

    SQL Mirroring

    While attempting to mirror two sql servers without a witness server, the following error kept coming through right at the end: The server network address "TCP://MOSSSQL-B.mka.compute-1.internal:5022" can not be reached or does not exist. Check the network address name and that the ports for the...
  8. ncalcaterra

    Sites with no content

    We have several thousand sites with a hierarchy such as: http://acmelive.acme.com/projects/atl/2009 Each site contains the same document and list libraries. The 2 that we are most interested in are: > Documentation (document library) - Contains several file folders for organizational...
  9. ncalcaterra

    SharePoint sites with no documentation

    sure, our structure is setup like such: http://xxxxx.companyname.com/Projects/SDG/2009/2009_0826/Documentation/Forms/AllItems.aspx We have multiple file folders within the "Documentation" document library. We want to search all the the subsites of "Projects" (and their document libraries) to...
  10. ncalcaterra

    SharePoint sites with no documentation

    Hello - we have been killing ourselves! By any chance, is there a way to run a list of sites that have no documentation stored in them? Any help would be GREATLY appreciated. Thank you. MOSS2007
  11. ncalcaterra

    Daily Usage Report

    ps... it would be great if some of the fields on the report would be "file path", "file size", and "date" either read or written to. I'm hoping for an export of raw data into either a .txt or .csv file format. thanks again for any insight.
  12. ncalcaterra

    Daily Usage Report

    Hello... We have a few servers running windows server 2003 standard. Is it possible through either tools that the server has itself or a third party software, to run a daily report that will list the "files" (not directories) that were either read or written to each day. Any help to point me...
  13. ncalcaterra

    Concatenate fields using multiple IIF statements

    thanks so much euper & sahmiele! both methods work great. i appreciate your quick response - they've made my life much easier! enjoy
  14. ncalcaterra

    Concatenate fields using multiple IIF statements

    hi there... i'd greatly appreciate any help on this little annoyance of mine. i have the following fields: Address1 Address2 City State Zip they may or may not have values in them, depending on the situation. however, i still would like to concatenate them into a "nice" flowing string with...
  15. ncalcaterra

    Adding records using a data access page

    hi there - i'm new to creating data access pages, so please forgive this simple question. to use a very simple example, i have a "clients" table and a "clientnumbers" table. the clientnumbers table is the "many" side of the one-to-many relationship between the two tables. i'm creating an...
  16. ncalcaterra

    IIF Statement Confusion

    ...below: txtAFee1Total CmpdF2P CmpdF2LS Heres where i'm at now: =IIf(nz([CmpdF2LS],0)=0 and nz([CmpdF2P],0)=0,0,IIf(nz([CmpdF2LS],0)=0,[CmpdF2P]*[txtAFee1Total],[CmpdF2LS])) In plain english though, i want "0" to appear if both CmpdF2P and CmpdF2LS are null - otherwise, if CmpdF2LS is null...
  17. ncalcaterra

    Creating records based on multiple items selected in a list box

    hey ken, yes, it is bound to tCorrespondence.
  18. ncalcaterra

    Creating records based on multiple items selected in a list box

    Mostly for just entering data, but it would be nice to use if we ever had to go back and look something up. thanks ken
  19. ncalcaterra

    Creating records based on multiple items selected in a list box

    from tProject (which has the following fields): ProjectID ProjectName thanks Ken!
  20. ncalcaterra

    Creating records based on multiple items selected in a list box

    hi! would love some help on (what i'm sure to most of you is simple) this list box problem... i have a form with the following fields (form name is fCorrespondence and the table name is tCorrespondence): CorresID EnteredOn EnteredBy CorresDate TransmittedVia ReferenceNo Task From To...

Part and Inventory Search

Back
Top