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 Rhinorhino 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: rccline
  • Content: Threads
  • Order by date
  1. rccline

    Highlighting Duplicates with Conditional Formatting

    I have an MS Access form that is based on a query. I want to apply conditional formatting to highlight the field on the form if the data is already in the dataset. the query name is qry_copyrequest. the table name is tbl_copyrequest the field with the duplicates is BOOK-PAGE-2012 the...
  2. rccline

    Running R script from Access module

    I would like to run an R script I have named "iterate.R" from an MS Access module via a command button on a form. I found the following code on StackOverflow, but something is wrong when I substitute my path. Link Sub RunRscript() Dim shell As Object Dim path As String Dim...
  3. rccline

    How to write the Dsum "WhereCondition" on Subform

    I would like to show the total of my subform on the main form. I have tried to create a textbox on my subform using =Sum([WI]) I have seen and read examples, but in my case, this formula only returns the message: #error I tried to use Dsum that I read in thread702-1778486. The...
  4. rccline

    How do you refresh the conditional formatting of a textbox on a form when related field is changed?

    Using expression [copy]=-1 I have set the conditional formatting set for field [Field1] on my form to display a conditional background color when boolean field [copy]=-1. How do refresh the conditional formatting to change when the field [copy] changes? Thank you! Robert
  5. rccline

    Hyperlink field on my access form will not work.

    I have a table and file name: tblRunsheet.pdfpath field pdfpath is the full path and file name to a pdf document residing in a folder on my computer. PDFpath field is hyperlink type. The path opens my file if I copy and paste into windows explorer. Field property is set to hyperlink type...
  6. rccline

    DoCmd.RunSQL will not run

    I am trying to create a simple SQL command in a module. The SQL string passes to the SQL following the DoCmd.RunSQL, but my code stops at the line DoCmd.RunSQL SQL I get no error... It just doesn't run. What could be wrong? Thank you. Robert Public Sub UpdateFullPath() Dim SQL As String...
  7. rccline

    Excel: Extract a variable string from string within a Cell

    I have a column named "Description." Each row of the column contains a sub-string I need to extract from the string within a cell. The substring is in the form of three sets of numbers. The first number can be either a one digit or a two digit number; the second and third numbers are always two...
  8. rccline

    Conditional Formatting on a form returns #Error

    I would like to apply conditional formatting to a field on a subform. If I set Myfield ]] I added the DLookup to add the field to my subform. =DLookup("T-R-S", "qry_HHH", "Criteria='string'") I then set my conditional rule Value = DLookUp("T-R-S", qry_HHH","Criteria = 'string' ") The Apply...
  9. rccline

    Access fails to import one field from a Text File

    Houston Central Appraisal District publishes a text file that contains 1.6 million rows of data. All data but the key field will import. I tried breaking the field into a smaller size, importing from the text file, 800 rows of data. The key fails to import. I then saved my smaller sized...
  10. rccline

    Hyperlink event to open an Adobe Acrobat PDF file

    Reference: http://www.tek-tips.com/viewthread.cfm?qid=1139663 http://www.tek-tips.com/viewthread.cfm?qid=1257256 Referencing the above links, I find that I can get the click event (run from a command button on my input form) to open the named file (Document.pdf). My table is tblIndex and the...
  11. rccline

    Record date that a record is modified.

    I have Access 2016. I would like to record the date a record is modified. The code should replace the former date if the record is subsequently modified. This is what I have tried... which does not work. ModDate is the name of the field that the modification date should be recorded...
  12. rccline

    In thread703-1030548 DHookom wrote:

    In thread703-1030548 DHookom wrote: QUOTE: Captain Awesome, Is [Confirmed Total] a field in your report's record source? If it is a control name then you can't "Sum()" it. You can only Sum() expressions based on fields in your report's record source. There are other ways to get the sum...
  13. rccline

    How do I exit sub on error 3162?

    I have a sub to run an append query. If the append query has no records, the code breaks. How do I exit the sub on error? Thank you! Option Compare Database Private Sub cmdAppendImportContacts_Click() Msg = " Are you sure you want to append imported data into Contacts table? Click Yes...
  14. rccline

    Excel: Structured table reference & column names. Column names not recognized.

    I have created a table in excel using Ctl+t The headers appear filtered. If I try to create a formula referencing the table, I get the name of the table automatically, but I cannot get the names of the columns. =sum(tbl_Sales) the named table "tbl_sales" appears and I can use tab to...
  15. rccline

    Promblem with Access data imported into excel

    I connect to an access table from Excel. The data comes with filters set. I cannot remove the filter. The presence of a filter is not significant to me, but I cannot use the data for a vlookup. Something seems to be wrong with the way the data is imported into Excel. I have tried referring...
  16. rccline

    Problem with Dsum in TextBox

    I am at a loss to get Dsum to work on my form. FieldName represents a number. =Dsum("[fieldname]","[qryName]", "[criteria]") where the critea is "[FieldName2]=[form name].Form![control name] If I use as criteria: "[FieldName]=1" I get an answer. If I use the following criteria, I get...
  17. rccline

    Duplicate records

    I have a form based on qryLeases. For each LeaseID there is just one record. Only one record (Lease) shows in the query when I run the query. I linked as subform fsubTract to the form which has multiple tracts for each LeaseID. The form and subform are linked by LeaseID. I want the tracts...
  18. rccline

    Developer's Access Runtime - error message

    I am trying to create an installer for "MyApplication" using Access runtime 2007. When I get to the last step, I get the message: Primary File "MyApplication" cannot be found. I am not sure what the error message means. What am I doing wrong? Thanks.
  19. rccline

    ControlTip Text Lookup

    Can I do a lookup for Controltip Text? I want to show a controltip for a field in a query result. Thanks. Robert
  20. rccline

    MS Access on sharepoint

    What is necessary to have a sharepoint website for Access? Any special software other than Access? do I need a developer to set up the system, or can I do it with a sharepoint host? Where do I start? thanks. robert

Part and Inventory Search

Back
Top