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

    Drag and Drop Data or Picture Symbols on a Form

    Hello again, I have found some info an drag and drop so I assume this can be done. If you have more info please let me know. Cheers. Panos
  2. greekpatriott

    Drag and Drop Data or Picture Symbols on a Form

    Hello Guys, I wanded to ask a few questions to see the limits of access. 1) Is it possible to drug and drop from one form to another? Say that the drug and drop data are from a query or a table, and will be transfered to another table (a new project). 2) Is it possible to have access open up...
  3. greekpatriott

    check box size? is it possible to make the the button change in size?

    Hello, I was trying to modify the check box size on a form, but without success. Is it possible to make the check box control bigger in size??? I was unable to do it. Can anyone advice? Cheers
  4. greekpatriott

    public function todate()

    Thanks guys
  5. greekpatriott

    public function todate()

    I need help,to display the todate day in a query cell. Is there a module that I can write to create a todate() function? Thanks in advance. Totis
  6. greekpatriott

    How to open a field (hyperlinked), using a command button

    Private Sub Command21_Click() Application.FollowHyperlink "C:\Documents and Settings\schristo\My Documents\Nemesis\SafetyPlans\Laws\" & Forms!F_Search!DocName End Sub This works too. Cheers
  7. greekpatriott

    How to open a field (hyperlinked), using a command button

    Ok I found a solution through a thread from this site. There may be an easier way but this works though I have to write the document name in a new field, and to erase the hyperlink since it is not needed. Cheers Private Sub Command17_Click() Dim WordPath As String, DocPath As String Dim...
  8. greekpatriott

    How to open a field (hyperlinked), using a command button

    Correction It should show doc1.pdf, doc2.pdf, doc3.pdf. Cheers
  9. greekpatriott

    How to open a field (hyperlinked), using a command button

    Hello, I have a table as below. One of the fields has hyperlinks to a specific location. If I have a form that shows all these data, how do I create a command button that will open the hyperlinked data? Thanks in advance. Table Index Description Location 1 Document1 C:\my...
  10. greekpatriott

    Criteria Question for a query

    PHV this is excellent. I dont understand the code but it works. This is excellent work. Cheers. I appreciate it.
  11. greekpatriott

    Criteria Question for a query

    & PolicyType &" not insuredItems I think but still something is not working with the question marks.
  12. greekpatriott

    Criteria Question for a query

    PHV, hi SELECT TableB.InsuredItems FROM TableB WHERE (((TableB.PolicyType)='& insuredItems &')); Something is not working. Can you correct the code in the wbere ..... Thanks
  13. greekpatriott

    Criteria Question for a query

    TableA: Field1: PolicyType X Y TableB Field1: InsuredItems Field2: PolicyType A X B X C Y D Y E Y TableC...
  14. greekpatriott

    Criteria Question for a query

    ok this is the fake database I hace created can you help me on this?? Cheers SELECT TableB.InsuredItems, TableB.PolicyType, TableC.PolicyType FROM TableC INNER JOIN TableB ON TableC.PolicyType = TableB.PolicyType;
  15. greekpatriott

    Criteria Question for a query

    This is my SQL. Can anyone correct the where criteria to make it work?? Cheers SELECT T_PolicyInsuredItems.PolicyInsuredItems, T_PolicyAmounts.PolicySection FROM T_ListofPolicySections INNER JOIN (T_PolicyInsuredItems INNER JOIN T_PolicyAmounts ON (T_PolicyInsuredItems.PolicyInsuredItems =...
  16. greekpatriott

    Criteria Question for a query

    Hello, Can anyone help me find the correct criteria for a query? If I have three tables say tableA tableB and tableC and a form FormA. TableA has X and Y values in a field called [PolicyType] TableB has A, B, C, D, E, and F values in a field called [InsuredItems] and the corresp[onding X and Y...
  17. greekpatriott

    can a query display a message through sql??? thanks

    Ok I found the mistake. I had a caption * in the Active_ContractNo properties. Now it works. Thanks Golom (Programmer). I used your code with few additions. Cheers. Here is the final code. Private Sub Command1_Click() On Error GoTo Err_Command1_Click If...
  18. greekpatriott

    can a query display a message through sql??? thanks

    I also used this substitution but also no luck If Len(Forms!Switchboard!Active_ContractNo.Caption) = 0 Then
  19. greekpatriott

    can a query display a message through sql??? thanks

    This is my code What am I doing wrong? Can anyone help out? Cheers. I dont seem to get the message. Private Sub Command1_Click() On Error GoTo Err_Command1_Click If Forms!Switchboard!Active_ContractNo.Caption = Null Then MsgBox "You MUST Enter the Project Number on the Switch Board" Else Dim...
  20. greekpatriott

    can a query display a message through sql??? thanks

    Hmmmmm I dont get it. I did not manage to make the code work. Can you be a bit more specific about the procedure??? Cheers

Part and Inventory Search

Back
Top