Recent content by viveleroi

  1. V

    left three characters from string using query

    In MySQL I can use the LEFT(3, field_name) command, but I essentially want access to pull all records from a table where the the first three digits of a number field match those pre-selected by a form drop down. This database is in Access 97. Is there a way to compare the first x number of...
  2. V

    create spreadsheet like report with counts

    I have a table with hundreds of records that have two fields I want to count: a rating and a code field. I want to see counts of each code for each rating in a spreadsheet-like chart: For example: R: A B C C: 1) 0 4 1 2) 1 3 6 3) 0 1 10 There are four ratings and thirty codes, and...
  3. V

    open blank form when connected to table?

    I have a form that is connected to a table - when I open the form it loads the first record in the table. How can I make it open a blank form, ready to add a new record?
  4. V

    run VBA if/else statement in report?

    I figured it out - the sub line should have been: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Not Prive Sub Detail_OnFormat()
  5. V

    run VBA if/else statement in report?

    I can't get this to work with OnOpen or OnFormat: Private Sub Detail_OnFormat() Me.initPTO = 40 End Sub I have verified that initPTO is a true field in the report. This is just a test, I really have an if/else statement but thats no good if I can't even assign a value to a field.
  6. V

    run VBA if/else statement in report?

    I have a report and I want to do an if/else statement for each record in the report. It essentially says if the value of one field (from a query) is x, then assign a value of y to another field in the report. But I cannot figure out how to do this. The code works in AfterUpdate on forms, but...
  7. V

    run code on report open

    I have a query and some if/else statements that need to fill in fields in my report when it is opened. This code works fine on a form, but when I add it to the reports it wont run. I'm not sure what OnOpen/OnCurrent/Onwhatever to use to make sure the code runs when the report is open. Dim...
  8. V

    nested IFs not working, though top-level does

    The first level of IFs work fine, but none of the inner ones work. I'm new to VBA but not new to programming... why won't these work: If (rs.Fields("EmployeeStatus") = "Non-Exempt") Then initPTO = 20 If (DateDiff("yyyy", Now, rs.Fields("CorportateHireDate"))...
  9. V

    getting list box data from table in access 97

    I just decided to go with a seperate table for that list instead of a single field. It is not the best logically but its all I can do in Access 97. Thanks!
  10. V

    getting list box data from table in access 97

    That works, except for the fact that Split is not a valid function in Access 97 because it was introduced with vb 6. All I am trying to do is store multiple list box data in a database.
  11. V

    getting list box data from table in access 97

    I have some VBA which places values from a list box into a single field in tblTracking, seperated by commas: 1,3,8 How can I seperate these values after pulling them out again into an array, so I can loop through that and highlight the appropriate selections in the list box?
  12. V

    cannot group by name using this query

    This query pulls different vacation time calculations from a table and another query, and calculates items. As it is below it works just fine. Except, it displays each record for each employee, when all we want it to do is sum up the calculations for each employee, and then display the final...
  13. V

    left join, then an inner join fails

    nevermind I fixed it - somehow I had a single field name wrong.
  14. V

    left join, then an inner join fails

    I have this code, but tblFloat.Hrs pops up in a box when I run the query asking for a value... so something is wrong... any idea? SELECT tblEmployees.FullName, tblEmployees.PTOAmount, tblEmployees.CarryOverAmount, qryEmplyeesWithUsedPTO.DateUsed, qryEmplyeesWithUsedPTO.Hrs...
  15. V

    extracting year from date field?

    If I have a query like: SELECT * FROM someTable and in the table I have a Date field (with Date format of course), how can I pull any record with a date in the year 2004? The field in is MM/DD/YYYY format, how do I just get the YYYY out, and check to see if: SELECT * FROM someTable WHERE...
See more
Back
Top Bottom