Search results for query: *

Steve Thanks for your information, I tried to respond to your post the next day but was having issues getting logged in, relating to my ZoneAlarm and the cookies. To answer your question it is the "user-switching" screen, and I think your assesment of a windows update causing the change is...

When starting up my laptop the dialogue box for password used to leave my cursor in the dialogue box ready to type in my password, for some reason now I have to click on my icon (only one use on this system is me) to have the cursor move to the password dialogue line. Any ideas why this would...

Eric Thanks for your help, I did what you suggested before I posted the original question. The problem with this query the employees that are not in the "task done" table do not show up in the final query. I have done as you suggested and "Set the link to select all records...

A query to combine 2 tables to show omitted employees on a given day A table of tasks done Date Empl Hrs WorkDone 2/3/03 Joe 5.5 Wigit 1 2/3/03 Joe 2.5 Wigit 2 2/3/03 Fred 5 Wigit 9 2/3/03 Fred 2.5 Wigit 1 2/3/03 Bill 4 Wigit 4 2/3/03 Bill 3.5 Wigit 7 2/3/03 John 3 Wigit 1 2/3/03...

Tim Yes there is a primary key, I tried moving it to the field I was trying to target as the field passed to the list box, but still the first field and the lookkup database was the passed value. I am evaluating FAQ702-681. Thanks for your time GaryAksland

Problem how to be able to access the lookup table ( via the Combo Box in primary table) and see the first field and the forth field, I must see field 1 in lookup field to be able to select the proper 4th field. I have set the "column widths" to 1",0", 0", 1" to be...

Paul Thank you ever so much, that GOT IT!!!! Do you know of any manuals with code examples of these types of routines, or any sources on the net. I am just getting into programming access and some examples of similar code would really get me going. Your time and help is greatly...

01-23-2003 09:00 AM Paul I tried the changes with the results listed below. The error repeats (missing operator), being new to the access syntax I am not sure what is ment by (missing operator). Any more ideas? Thank you for your efforts Gary Before the changes myVal =...

Paul I change the ' for &quot; and now the error I get is &quot;Run-time error '3075' Syntax error( missing operator) in query expression '[EmpName]= <actual employee returned here> and [RecDate] = '01/22/03'. This is the line of code -------------------------- myVal =...

Paul I changed the Date field to RecDate field and recieved a compile syntax error at the apostrophe before the mm/, access highlighted that character. Do you have any ideas? myVal = DSum(&quot;EmpHrs&quot;, &quot;tblRanchCost&quot;,&quot;[EmpName] = &quot;& Me.EmpName & &quot; and [RecDate]...

Paul The modifyed version Dim myVal as Single myVal = DSum(&quot;EmpHrs&quot;, &quot;tblRanchCost&quot;,&quot;[EmpName] = &quot;& Me.EmpName & &quot; and [Date] = #&quot; & Date() & &quot;#&quot;) MsgBox &quot;Totals for &quot; & Me.EmpName & &quot; for today are &quot; &...

Paul Thank you for the information I will let you know how it works. Your input is greatly appreciated Gary

In the past I used Paradox for dos with great success, but am switching to access and am having problems with the following. If there are any good access manuals (I have purchased a few) that have examples of code similar to the example below, the title of same would be helpfull. This is a...