Search results

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!

Thanks for getting back to me. In the meantime I took it to one of our "programmers" here who advised I was working in a very antiquated db and offered to over the project so I put the two together. I do have one other question if you don't mind. I have a recap page for a utility bill which has...

And now yet a bigger challenge. I met with the Security team yesterday to show what we had done so far.We started with the call log which is basically folks calling in to report something and based on the call # I was able to create a case #.Call # Field: Auto Number Case #field: Me.CaseNumber =...

I created an incident # as an auto number; could I get a case # generated off of that such as MMDDYY-Incident #?

Again I so appreciate your help. If there were a way to get the date/yr somehow in the Case #/Call #/Incident # that would be the ultimate but if we need to use another field that would be fine. I'll take anything. Thanks again!

I put the event "before insert". Should it be before update? It works when I use the before insert without the date; it gives me a number that I have no idea where it comes from but it works.