Search results

  1. B

    Query Math With Dates

    the only other criteria is that another field says that it is an "Open" issue. all 4 of the dates that i have are open and yet it is only finding 3. what do you think could be wrong with the way i set up the query
  2. B

    Query Math With Dates

    ok. that helped a ton. i can get the number of days difference like i want. now how come when i run a query to find where a field "Is Not Null" (its a date field), it will not find all of the records where this field has a date entered?
  3. B

    Query Math With Dates

    I want to have a query that will subtract a Due Date from todays date and tell me how many days are left/passed in either a positive number or negative just like the DateDiff Function. how do i do this?
  4. B

    setting the record set of a Query

    Can i edit a query to equal a SQL string just like i do for my reports? for my reports i say: DoCmd.OpenReport "Check Filter", acViewDesign, , , acHidden Reports![Check Filter].RecordSource = strRecordSource DoCmd.Close acReport, "Check...
  5. B

    creating a table to export to excel

    how easy is it to have access create a table and export it to excel, and then have fields on an already made spreadsheet filled in.
  6. B

    Can a Query Accept value from a string.

    NM...i just did it the long way.
  7. B

    Can a Query Accept value from a string.

    i have 3 checkboxes A, B, and C. If A is checked i want the Query to search for A in a field. if A and B are checked i want it to search for A and B. Therefore in the query could i have 3 columns for that field and say where strA OR strB OR strC. so in my code if A and B are checked then...
  8. B

    Can a Query Accept value from a string.

    Can i create a query that will have a string in the Criteria box, where that string is assigned a value in VB code? for instance: Dim xyz As String xyz = "TV" and I put in the Criteria Box WHERE xyz = "Pizza"
  9. B

    Duplicate Records in Continuous Forum

    Is there a way to make sure that no duplicate records show up in continuous form?
  10. B

    Adding list option automatically

    is there a command for adding values to tables?
  11. B

    Adding list option automatically

    This is probably something already talked about, but if i have a combo box that has an "Add New Entry" selection in it, and when the user clicks on it, i want to add what they want in to the table that the combo box chooses from. can I have that "Add New Entry" selection open a form with a text...
  12. B

    How to open a form on a particular record using a combo box

    you can use a query to do this. if you bound the form to the query and have the query search where the combo box is equal to what ever other field your looking to match with it, then the query will do all the work.
  13. B

    Before Update with Combo Boxes

    good point. thanks for the help
  14. B

    Before Update with Combo Boxes

    So does Access have a lot of limitation or can you pretty much get around the roadblocks to do what ever you want?
  15. B

    Before Update with Combo Boxes

    can you default the frames to max or is that pushing it a little..lol
  16. B

    Before Update with Combo Boxes

    how do you take away the Window's OS window red "X" off?
  17. B

    Set Fields on Form from Table Data

    attach your DB and i'll take a look at it
  18. B

    Set Fields on Form from Table Data

    i've gotten that error that Playbus got before and it solved it by including the whole phrase [Forms]![FRM_View_Orders]![OrderDate] = Date
  19. B

    Set Fields on Form from Table Data

    on the On Click Event for the button, create a line of code that says: [Forms]![FRM_View_Orders]![OrderDate] = Date()
  20. B

    hide and display a field on a form

    if you don't want to do that then you can simply update your code for the combo box on the After Update Event to say: If [NameOfYourComboBox].Value = "NameInYourComboBox" Then [NameOfFieldToHide].Visible = False End If
Back
Top Bottom