Recent content by ssworthi

I have been tasked to merge query results with an Excel for; there are not too many fields, two emp # and name. How would I do that; I'm under the gun for time (of course) but thought I'd ask the experts before I try to figure this out. Thanks in advance,

We have been using Dell Axim PDA's to collect our time out in the field which downloads to an Access db. I now want to get a wireless scanner and use barcodes for the employees id's; has anyone any suggestions for a)barcode software b)scanner. Thanks a million.:D

The table field "Priority" is a combo box and it's row source is "High";3;"Medium";2;"Low";1. When I group on Date needed, then Priority but in the report it is reading the alpha character instead of the numeric which causes Low to print before Medium. Somehow I have to have it recognize the...

I will try it and see how it works. Thanks so much for your help.

I did the combo and I can see when I go to that field it's a drop down but what I see is 1 "Low";2"Medium" 3;"High". Is that the string that I should have in there?

I"m a real end user so I definately need some clarification and some help. I open the table in design, I click on the field "priority" which is defined as text. Should I change it from text to combo box, row source "value List",then add the values of High,Medium,Low in the row source as you...

I have a "to do" project data base where it has date/time needed by and the requestor has asked that it also include priority High.Medium. Low. In the form based on the table I have created a drop down with those values but when used in a report I want to have "High" as the greatest value; how...

You're right; there was a space and there should not have been. It works! It's great, thank you so very much!

Does this look right? FollowHyperlink \\bcohome\enterprise\ORCH\groups\Database\Attendance\Attendance.accdb I'm getting a "Compile error: Syntax error" and the above is highlighted in red.

Thank you so very much! I will try that now.

Thank you so much Gina. Do I accomplish this in a button on my form and is it in the properties and written in SQL? I am very new to SQL and learning by the seat of my pants as it were. Thanks for all your help.

I want to have my users have a button on my main form in my one data base be able to open another data base;(other database main form has all the buttons they need for the functions they want)is that possible?

I think I will add the field to the table and run the update query; thanks so much!

So I think I spoke too soon. This is the field that is part of the summing query for the summary sheet; would it be better to add the Invoice filed to the table and run an update query on the table? Or is there someway to update this expression? "Invoice: ([Customer #] & "/" &...

Thanks so very much!