Search results for query: *

You need to link the tables using primary key field, i.e. a field that contains unique values. It looks like you currently have them linked on the WorkOrderNumber field, which does not contain unique values.

In that case, forget the Access Bible and stick with the Developers Handbook. IMHO, no other Access reference rivals the ADH. You might also take a look at the Access VB Help files. They can be a bit dry, but explain the basics rather well.

Access 2000 Bible Access Developers Handbook

If it's walkthroughs you need try: Microsoft Access 2000 Bible by Cary N. Prague & Michael R. Irwin For more hard-core development technique: Access 2000 Developer's Handbook by Paul Litwin, Ken Getz, Mike Gilbert

For the following example, I am querying a table with three fields: "FName", "LName", and "Date". The query's SQL syntax would be: SELECT Table1.FName, Table1.LName, Table1.Date FROM Table1 WHERE (((Table1.Date) Between [StartDate] And [EndDate])); Then, I place...

If I understand your question, you want to choose records where pay_element_id is one of the three values you've indicated. In this case you simply add a WHERE clause to your query: SELECT dbo_emp_pmt_pay_element_detail.pay_element_id, dbo_emp_pmt_pay_element_detail.tot_current_monetary_amt...

Try this: Declare Function GetUserNameA Lib "advapi32.dll" (ByVal lpBuffer As String, nSize As Long) As Long Public Function GetUserName() As String Dim UserName As String * 255 Call GetUserNameA(UserName, 255) GetUserName = Left$(UserName, InStr(UserName, Chr$(0)) - 1) End...

You can use the OpenForm method in a If...Then...Else construct: If IsNull(me![FormControlName]) Then DoCmd.OpenForm "YourForm", , , ,acFormAdd" Else DoCmd.OpenForm "YourForm", , ,"CustomerID = 'whatever'" End If Hope this helps! japapuss

You need to modify the combo drop-down) box's AfterUpdate event to evaluate the value of the combo box, then take the appropriate action. One way this can be accomplished is with a Select Case statement. Assuming you have a simple combo box with just one column, and have more than two issue...

Hi, Is there an easy way to force off users who are currently logged on to a machine/domain, or who might have connections open to a particular machine? Thanks, japapuss