Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. yoshi88

    Highlight text in combobox

    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...
  2. yoshi88

    Link an excel sheet starting at a specific row

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

    Link an excel sheet starting at a specific row

    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
  4. yoshi88

    Count consecutive data

    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...
  5. yoshi88

    Count consecutive data

    ...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 AS A INNER JOIN qrycode AS B ON A.EmplNo = B.EmplNo AND B.Day<=A.Day GROUP BY A.EmplNo, A.Day, A.Code ]. AS X INNER JOIN...
  6. yoshi88

    Count consecutive data

    Exactly what I'm looking for. Thanks Frank
  7. yoshi88

    Count consecutive data

    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...
  8. yoshi88

    Relative Placement

    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...
  9. yoshi88

    Excel, refer to the value of a named cell

    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...
  10. yoshi88

    Loop in a Macro ?

    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...
  11. yoshi88

    Loop in a Macro ?

    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...
  12. yoshi88

    Continuous form problem

    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...
  13. yoshi88

    VBA code If then problem

    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...
  14. yoshi88

    VBA code If then problem

    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...
  15. yoshi88

    Potentially speed up form operations dramatically

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

    Count number of record in a certain time frame

    ...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 A...
  17. yoshi88

    Count number of record in a certain time frame

    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
  18. yoshi88

    Count number of record in a certain time frame

    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...
  19. yoshi88

    How to skip certain groups based on a condition

    I'm glad it's working. Frank
  20. yoshi88

    How to skip certain groups based on a condition

    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...

Part and Inventory Search

Back
Top