Search results for query: *

Hi, I am using a code that use a combo box in excel when there is a validation list in the cell. Everything works perfectly except one thing. When the code is done the cursor in the combobox is at the end of the text. I would prefer the text to be highlighted so I dont have to select it by...

Thank you for this fast answer, it's working perfectly. Frank

Hi, I would like to know if it is possible to link an Excel sheet in Access without the first 4 rows. I have an excel file wich is use by many users with the header in row 5 and when I link it to Access, the names of the fields change if the first row of the Excel sheet changed. Thanks Frank

At first I was looking for only one type of code and then we had to change it for all the codes to check the absenteeism. Now I have more that 100 different codes to check. But I assume the exemple I gave you in the last reply is relevant to the new situation. The TblEmployeeData has those...

Thanks for your answers. But I still have a problem with the results. I have different code for someone who is sick depending on the reason. PHV I used your query and I change it a bit: SELECT DISTINCT X.EmplNo, X.Day FROM qry2, [SELECT A.EmplNo, A.Day, A.Code, COUNT(*) AS Rank FROM qrycode...

Exactly what I'm looking for. Thanks Frank

Hi, I'm trying to count consecutive data in this table: EmplNo Day Code 1 1 Sick 1 2 Sick 1 5 Sick 1 6 At work 1 7 Sick 2 1 Sick 2 2 At work 2 3 Sick 2...

Hi, I am trying to figure out how to do this query/VBA code in Access. I have a table name tblResults with those fields: fldCompetitionID fldJudgeID fldCompetitorID fldResult The results are ordinal (rank 1st, 2nd, 3rd,...) with no tie allowed Here how the relative placement works: 4. A...

Hi, I am using a VB code in excel, and I want to use the value of a named cell in my If...Then...Else code. I can't figure out what I should use to code it. My cell is name "Test" and my code looks like this: If cell name "Test" = Red Then ..... Elseif cell name "Test" = Blue Then...

I will try to be clearer. If the itemnumber I scan is Not Null then I want the code to update the itemnumber to "in" and add the time and date to my table. After that I want the code tu run the Query1 another time (over an over again till the itemnumber is Null) Else, I want the code to stop...

Hi, With a barcode scanner I will scan the items that are "out" in my table, as they come back in. After being scanned, I want the items to be update to the new status "in". To do that I created a table with those fields: itemnumber dateout status (in or out) datein Then I created Query1 to...

Hi, I have a database with a table name Schedule wich contains thoses fields. EmployeeNo WeekNo Year Dayofweek (Sunday, Monday,...) Shift (Day, Afternoon, Night) Start (beginning of the shift) Duration (how many hours of work) Description (type of work to be done) Data in that table would...

Thanks for your reply, its working noew. But is ther a way to code it without typing Description1=... for every value. I have more than 40 values to type and if I use the Not Description1=... i would have to type more than 50 values. Also, my report represent 3 shifts per days for 7 days, so...

Hi, I'm trying to add an If...Then code in my report to hide some fields. One the field is a descritption and if its equal to 5, 7, 8 or 10 I want it to be invisible. My code goes like this: If Description1=(5 or 7 or 8 or 10) Then Description1.Visible = False Else...

Wow, thanks James This thread reduce the opening of my report from 11 minutes to 12 seconds. Frank

Thanks again PHV, Your reply are really appreciated. I had to modify the subquery a bit to make it work like I want: SELECT A.IdEmployee, A.Description, A.Date ,(SELECT  Count(*) FROM Lates B WHERE B.IdEmployee=A.IdEmployee And B.Date>=A.Date And B.Date-A.Date<28) AS NumberIn28Days FROM Lates...

Hi, thanks for the help but it's only giving me a result of 1 for every record. I think Access doesn't recognize the # part before and after the [date]. Also, what is the difference between [Date] and [date]. If there is any my computer consider that they are the same. Thanks Frank

Hi, I have an employe database with details on everyday of those employes. There is an a particular event that I want to track by date. If the employe has been late 4 times during a period of 28 days I want the report or the query to show it to me. I was thinking of something like that in a...

I'm glad it's working. Frank

Hi, you can add a field name Count with the source =count(*) in the group footer. Then in the format event for the detail put this code: If Count < 2 Then Detail.Visible = True Else Detail.Visible = False End If With that code the detail of the groups with more than one store wont be...