Search results

did you try Dlookup! xample: if you have a field names id ID from Table 1, you wan to get the Ename of this Id from table 2 "must not contain dublicate IDs) type: Me.Ename = Dlookup("[Ename]","[Table2]","[ID]=Forms![Form1]![ID]") that's what i understood!

this would be helpful... http://www.access-programmers.co.uk/forums/showthread.php?t=176989 Filling and updating fields of a form based on a selction from a combo box HAMMAM

i think this will work for the Lines, coz i realy couldnt; fine the Chr(?) value for a comma,, this takes the new lines chr(3) whicjh can be sometimes used for multi-lining a masgbox.. the idea here is to count the separe packets of data and store this counter in a variable or use it to determin...

mmmmm we should move to a 2 tables state... Main and sub. the main "as I understood" should be the one with the From To fields and the sub shouldbe the one with the uniques reference,, "looks like a product and its shipping transaction refered by order id" thus.. you ca use the grouping better!

let the lookup field be a combo box use the after update event of the combo box to fill the data in the quantity box using the Column(indez) prop Example: Private Sub Combo1_AfterUpdate( ) Me.Qnty=Me.Combo1.Column(2) End Sub where Colmn(2) here is the 3rd Column (index starts from 0)

Re: Change the Default Access Spalsh screen And?........

I suggest the following... Creat a new field that is a merge in the field "from to" together, group by it,, REMOVE THE FROM TO FIELDS FROM THE LIST thanks

Hello "What name?" try this,,, 1- in the after update event of the combo write this code "example" Me.Adres=Me.Company.Column(1) Me.Manager=Me.Company.Column(2) and so on... notes... adre and Manger are the fields to be filled or updated.. company is the name of the combo box containing...

WRITE this line directly in the Criteria section directly under the field Rate... =DMin("[Rate]","[Table1]") note.. this can also display all the min results, means if you add more records with 100 rate the will all be displayed! THIS IS THE QUERY... IT SHOWD THIS...

I think this can be done by this code for example you wan to show Fld2 and hide Fld1 Fld2.Properties("ColumnHidden") = True Fld1.Properties("ColumnHidden") = False but exactly how in the Query.. i really didn't try.. but I will, cos codes can be only written on forms and its better to have a...

1-filtering comboboxex based on each other is not a tough, yet not simple thing,,, you should be able to write the SQL statemnet to filter them...as you say you have experience with VB, C, MySQL and PHP for web design etc that's a very great thing so you need your knowledge in SQL to write down...

i SUGGEST THE FOLLOWING... 1-design the table so as to include the "levelofdetail" field .. which will add "using the code" an ident just like happens in MS Word.. thus in the same table you can add different levels of details and the report will appear with idents "if i get the idea well"

that's good too.. but he wants the user be not able to click.. cos focus can be taken by click or move tabe. so you cn set the tabe stop peop to False

As you try to make a dynamic query allow me to suggest this,,on each filed you tich.. change the SELECT statement that the query is based on...example... 1- if you have the fields ID, Nm, Salary and you wan to check them into or out of the query using adifferent selcet statement each time 2- or...

glade that it helped... thanks alot

Can just put a picture or a screen cap of your form! let us just ave a look at the situation... if you have 2 combo box for choosing different authorities you need to re-fill the second so it includes no more the selected authority in the first one,,, if you have only one combo for on project...

thanks for tips... i will stop solving the non-problems i will stop acting like an expert while i am not,,, i will stop using the ooooh opps and others you mentioned and use the vomite smiles instead i will seek that little bit of the respect others gained by trusted advice i will not find any...

the same thing i did! I suggest using conditional formating alon with a fild that each time take odd then even numbers and apply the condion on every field so all fields in the same record are colored with the same color, then the next record will change.. Thus..the mod thing will work...

if want to keep it active but under conditions .. use the If statement and in the Elese part use Exit Sub Ex: Private Sub Finish_AfterUpdate() If Me.UserName = "Admin" Then Call RecordChange Else Exit Sub End If End Sub Where UserName is a control "Text, Combo,,,,etc" HAMMAM

And try this too,, i trid and it worked,, please not.. the dropdown wont work if the cursor is not in the combo..i.e the combo has the current focus,,, Set the Locked Properity of the combo to yes and the Enabled to yes.. thus the cursor can be put in the combo but editing is not alloed.. use...