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: *

  • Users: karassik
  • Order by date
  1. karassik

    Subform Addition #Error

    I thought I might repost so, someone else who has had a similar experience could post.
  2. karassik

    Passing Data from on form to the next

    You could use a tabform, but in the update area use a continuous form. That way you would be able to update the original record many times.
  3. karassik

    Linking Forms

    Include is code in the Command button's on click: Dim stDocName As String Dim stLinkCriteria As String stDocName = "NewFormNameHere" stLinkCriteria = "[JobID]=" & Me![JobID] DoCmd.OpenForm stDocName, , , stLinkCriteria JobID should be replaced with...
  4. karassik

    Subform Addition #Error

    I am running Access 2000. The problem form is for tracking Hours. I have a main form that hold employees names and a continuous subform is fed off of those names. The subform holds the date and hours and operation, so one day could have multiple entries. I have some a Text box on the bottom...
  5. karassik

    Crosstab Query Combination Question

    I solved it by putting all the OperationID's in the Pivot area: PIVOT tblHoursDetail.OperationID In (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17);
  6. karassik

    Crosstab Query Combination Question

    Sorry I want both All and Last Week. So in crosstab I can't have two. I am building two crosstab queries then combining them with a select query. I am having problems with the Cross tab left join, it won't show all records (OperationID's) from my operation table, only those with numbers in...
  7. karassik

    Crosstab Query Combination Question

    I am using Access 2000. I have a crosstab query built on jobid as row, summary actual hours as value and operationID as column. I would like to have essentially the same thing in the same query, but limit the acutal hours dates. It won't let me have more than one value per crosstab query. Do...
  8. karassik

    One to Many Query Question

    I figured it out and you set me in the right direction. I needed to use a subquery in my index field. HAVING (((tblRemainingHours.RemainingHoursID) In (SELECT Max(tblRemainingHours.[RemainingHoursID]) AS [MaxOfRemainingHoursID] FROM tblRemainingHours GROUP BY tblRemainingHours.[JobID];))...
  9. karassik

    One to Many Query Question

    The TOP Statement gives me the most recent one record of the query, where I want the top value for each JobID not just the most recent one. I can't believe I can't figure this out. Thanks.
  10. karassik

    One to Many Query Question

    Maybe I misunderstood how to do this John, but I am still getting all the records on the many side (in tblRemainingHours for each JobID). I have = Max([RemainingHoursID]) in the RemainingHoursID, or SQL: HAVING (((tblRemainingHours.RemainingHoursID)=Max([RemainingHoursID])) if I instead use...
  11. karassik

    One to Many Query Question

    I do have an index key, I think...the Primary key for tblRemainingHours? I'll try that, but how does one sort by DEC? Ascending? Then how would I get the last record. I'll try the max of my index. Many thanks. Nishan
  12. karassik

    One to Many Query Question

    Thanks all who read and answer my and everyone elses questions. I am not quite sure how to go about this. I have a main table: tblJobs and JobID relates to many records in tblRemainingHours. I want to get the most recent remaining hours date (RmgDate) record in my query. I have tried using...
  13. karassik

    SQL in VBA Problem. Semantics?

    Hello and thank you for looking at my problem. I get an error stating that "number of query values and detinations are not the same. Can anyone tell me what is wrong with the following code in Access 2000 written in VBA: Dim stSQL As String DoCmd.SetWarnings False stSQL = "INSERT...
  14. karassik

    ComboBox Sort Question

    I am not exactly sure how to go about this problem in Access 2000. I have a form built on employee records, and a subform with hours, operation etc. The operations are in a combobox fed from another table. I was wondering how I limit the operations combobox depending on the employee? Ie. Joe...
  15. karassik

    This one is complicated

    You are going to need to do a little VBA codework. Look in FAQ's for sending email. There is code there that descibes how to do this (in VBA).
  16. karassik

    Serious Database/Access corruption problem

    Yes it is set to compact and repair. It was a replica. And I solved it by again creating a new DB linking the tables and then importing everything that wasn't corrupt. Interestingly, the first two times I tried this I tried to import everything from a replica. Somehow this made Access...
  17. karassik

    Serious Database/Access corruption problem

    Well I hope someone else has had this issue, though I really wish it on no one. I am using Access 2000 and have built a pretty sizable DB that is split, with four different FEs on personal networked boxes and the BE on the Server. This has worked beautifully for quite some time as I have made...
  18. karassik

    special addition question

    Ya, I think I'll have to do each weekday, then sum it. I think that the "[HoursDate]">[MaxDate]-Weekday([MaxDate],2), works better because I don't want five previous days, I want Monday on to MaxDate.
  19. karassik

    special addition question

    OK, so to get that most recent monday: [MaxDate]-Weekday([MaxDate],2) This works correctly, but when I put it in the dsum fuction as such: =DSum("[HoursDetail]","qryHoursDetail","[HoursDate]" >[MaxDate]-Weekday([MaxDate],2)) it returns nothing. Any suggestions?
  20. karassik

    Any experts?

    I don't think I understand your question. Wouldn't your subform query be for just that record on your main form, thus allowing you to enter anything you wanted for that mainform record. Or maybe I don't understand your question. Nishan

Part and Inventory Search

Back
Top