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. cgarts

    Finding a certain number

    Could something this simple work? SELECT Tblx.Num90 FROM Tblx WHERE ((Right([Num90],2)=90)) Best, C
  2. cgarts

    Access automation

    Ok DanKay1, I have it working. Code that works for your problem if I understand it correctly. Updates your initial values for "Coverage" based on the following: 1. From one to three records may share the same "Policy" number. 2. "Amount" will be different if more than one record share a given...
  3. cgarts

    Access automation

    jjlogan or anyone who knows the syntax on this sort of work ... I was trying to sort out the logic for DanKay1, but I am missing something in the code I have suggested for him. I am getting errors, and would like to be more helpful to DanKay1, and would like to make that sort of code workable...
  4. cgarts

    Access automation

    DanKay1, I have been thinking about how to get a number for how many policies share the policy same number, and then update your Coverage correctly. My inclinationt would be to have a query do a lot of the heavy work for you before you process the Coverage field Have the query sort first for...
  5. cgarts

    Access automation

    DanKay, Sorry to dig around that question at length: but given that your whole set of records sounds like it is entirely deleted and replaced monthly, and that you are not adding lots of records in the interim, but just populate the db all at once, then I'd suspect you are fine to work up the...
  6. cgarts

    Access automation

    DamKay When you posed the problem, Policy 01 is entered twice, once for Amount 20, once for amount 40. That's the duplication I refer to: two records for 01. Your original wording: Database Policy Amount Coverage 01 20 02 25 03 15 01 40 I suspect...
  7. cgarts

    Access automation

    Maybe I'm missing something, but it looks like the coverage values, 01, 30 , 31 are redundant information, and that the information about policy coverage is not only already in your database, but intrinsic in the same table. If I have that all correctly, then I would use similar code to...
  8. cgarts

    Duplicate Field Names in Different Tables?

    Hi, For brevity and clarity: CustName1 CustName2 EmpName1 EmpName2 What say? C
  9. cgarts

    Sort by Column Instead of Field

    Can you move the calculation into the source query for your form, than treat it the same as your other columns? C
  10. cgarts

    Dynamic form: creating button/control at run-time

    Glad I could help! C
  11. cgarts

    Unlock all controls on Page 1 of Tab Control

    Peryan, I'm not sure if you can programmatically sort out which control is on which tab page (someone more sophistcated might have a method) , but you can name them so that you can control the properties of only specific groups of controls - like the ones in a given part of a form, or of a...
  12. cgarts

    Problem with Strings

    Thanks AceMan. A star from TheAceMan is ... well, a star from a star... I ran into the issue with the 2048 character limit a while ago. I've Googled around quite a bit, using search strings like "2048 limit access listbox rowsource." To something of a novice like me, it looks like "User...
  13. cgarts

    deleting parts of a string contained in a value of a field

    Also maybe the OldValue property if you can use it. C
  14. cgarts

    Problem with Strings

    Aceman, I'm a novice so I ask this to be better informed. I am hoping soon to learn more about, and to use callback functions since callback functions are presented as not being subject to the 2048 character limit. Is the limit you are referring to elsewhere in the process, or am I reading...
  15. cgarts

    Problem with Strings

    Could a callback function get around the 2K limit? C
  16. cgarts

    Makeing a filling cabinet.

    Are8Jay There are lots of image management programs out there, but if you are trying to create a table of image paths, and text descriptions, and want to program it yourself, then I believe you can do it with Access / VBA using FileSystemObject and Dir function - no ActiveX controls, no common...
  17. cgarts

    Discussion: philosophy of UI design

    Hmmm... maybe it's presumptious for someone still learning Access to toss out UI design preferences to a forum with lots of seasoned pros, but I have a really good UI concept, and I use it pretty much everywhere.. It's driven by several ideas. 1. Visual simplicity wherever possible. 2. Show...
  18. cgarts

    How to display customer combo box column headers

    This will show up as ModelDescription in the header SELECT TblModel.ModelDesc AS ModelDescription FROM TblModel Whereas this will show just ModelDesc in the header SELECT TblModel.ModelDesc FROM TblModel In the query design view, you can put YourDesiredHeaderName and a colon ":" before the...
  19. cgarts

    Import csv file into one record

    Googling "FileSystemObject read file txt" yields sites with clear code samples: http://www.4guysfromrolla.com/webtech/faq/FileSystemObject/faq2.shtml http://www.juicystudio.com/tutorial/asp/files.asp Check out the ReadAll command. Best, C
  20. cgarts

    Clear all controls on form at once

    Vie, Try these: To "unselect" the selected items in a listbox: YourListBoxName = "" No item will be selected after. You can programmmatically make selections in a listbox YourListBoxName = Some value To set an option group to no selection: YourOptionGroupName = "" All the option buttons will...

Part and Inventory Search

Back
Top