Search results

2007..i enabled the content (trust center)

Appricate Drake, however the attachment included a module and empty form only..should it include more?

HI all, I am distributing the frontend to three Continents. Europe/Australia and USA I would like the user in Australia to see: Local Time / Europe Time and USA Time, the user in USA to see: Local Time / Europe Time and Australia time and the user in Europe to see: Local Time / USA / and...

After a good night sleep i now see my errors in choice of method. I need to go back to basic and simple logic. Thanks for your time and i will not double post any more.

Hi all, trying to make my self understood i wonder if it is possible to include "multiple" syntax in one sub..the same sub would also have to include more code..IF statements etc Private Sub cmbo1_AfterUpdate() Me!cmbo2.RowSource = "Select tbl1.text2 " & _ "FROM tbl1 " & _ "WHERE tbl1.text1...

I apologize for being such a pain..its late over “here”..or very early in the morning.. The value lists are 2 columned and i use a Single Row Source Table as described http://www.fontstuff.com/access/acctut10.htm My previous example was wrong. The sql syntax of the row source of each of the...

Ok will try again...

Nope... I see i do not explain my self clearly. The value A in cmbo 1 should cascade a related valuelist in cmbo 2 and another related valuelist to cmbo 3 Example: Cmbo 1. Country (USA). Cmbo 2. City (New York) Cmbo 3. Bourrogh (Bronx) I managed Country and City but not the Bourrogh :)

ok..i wll try your suggestion, thanks!

here is the code on the after update event of Cmbo1 Me!cmbo2.RowSource = "Select tbl1.text2 " & _ "FROM tbl1 " & _ "WHERE tbl1.text1 = '" & cmbo1.text1 & "' " & _ "ORDER BY tbl1.text2;" i dont understand how i can also add a second combo to be depending on cmbo 1...above code describes the...

I beleive i am using the same method.. I use the same code in the comboboxes after update event ...the only diffrence being that i want Cmbo1 to cascade 2 comboboxes.

Hi all, In the raw source of Cmbo1 SELECT DISTINCT tbl1.Text1 FROM tbl1 ORDER BY tbl1.Text1 Were tbl1 relates to the row source for Cmbo2 How do i add a SELECT DISTINCT to the raw source of Cmbo1 that refers to Cmbo3 SELECT DISTINCT tbl1.Text1 FROM tbl1 ORDER BY tbl1.Text1, SELECT...

Ok, i will go ahead and try your suggestion out...Thanks!

Thanks Gentlemen, The frontend is distributed to 10 users and it does happen that i want to edit a record in a form that someone else is editing...Actually i wanted to be able to shout out “Jack, please logout from record 5”..now i have to shout out to ALL “Please log out from record 5”...(...

:-) the code runs well in sinlge form format..now i understand it better. Mr bobLarsson, i feel much obliged...thanks!

Split Form according to this http://www.btabdevelopment.com/ts/default.aspx?PageId=14

Access 2007 new form feature..Split Form.. Code Private Sub Form_Current() Alert = DLookup("[Alert]", "AlertTypeEx", _ "[AlertType]='" & AlertType.Value & "'") AlertType.RowSource = "Select AlertTypeEx.AlertType " & _ "FROM AlertTypeEx " & _...

I understand, thanks!

Hi, is there a way to display who “else” is editing the same record i am currently working on, i do receive a “sound”..but i need also to identify the user..is this possible? Thanks!

Hi all, i start to discover the advantages of the Split Form, and at the same time its difficult to find relevant information to errors in relation to this set up. “The expression On Current you entered as the event property setting produced the following error: Return without GoSub”.. For an...