Search results for query: *

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

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

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

Thanks guys

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

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

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

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

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

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

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

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

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

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;

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

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

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

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

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

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