Search results

  1. V

    Filter data in subform with buttons on mainform.

    Replace: "[COLOR] = Blue" With: "[COLOR] =" & """Blue"""
  2. V

    Clear and Exit Form

    For this I cheat a little (I use the code thats created via the button wizard), I would use the code below to undo the last record and then just exit. Granted you will want a IF statment if you want to warn a user etc. '------------------------------------------------------------ '...
  3. V

    Filter data in subform with buttons on mainform.

    With Me.frm_HISTORY.Form .Filter = "[COLOR] = Blue" .FilterOn = True End With
  4. V

    DateAdd Problem

    The reason for it would be to return all data for the last week, without it you would only return dates from 7 days back, and nothing from 6 to 0 days back.
  5. V

    Many-to-Many Grouped into one larger table?

    I wanted to see if there is any issue with combining a bunch of smaller many to many fields into a larger table. For instance I have my Staff Table that is used quite a bit in my forms via a Multivalve field (I know never use them) and I am now changing over to a traditional many to many. What...
  6. V

    Lock everything on form except for one combobox?

    Shot in the dark but did you also do? Me.cboSearch.Enabled = True
  7. V

    Setting Default Values in Subform Based on Other Controls

    Can you use a nested if statment to also check if Forms!frmBlockEntry!StartTime.Value is null? Something like If Nz(Forms!frmBlockEntry!StartTime.Value, 0) = 0 Then End '(or what ever action you need)
  8. V

    Password protecting multiple forms

    I dont know what your reason is for this but, you should be aware that anyone with access to google would be able to bypass that in a second. Disable Shift, F11 etc. This will help a little. Someone with more exp will need to help with the code side.
  9. V

    Listbox simalar to Multivalue Selection

    Hey guys, I am replacing a BUNCH of Multivalve fields in a database I need to help migrate to SQL. I need help creating a selection option that’s similar to the multivalve option in access 2007 natively. I also need to have the VBA add and remove records from my join table as the values...
  10. V

    database now needs to be global

    Very good point, this is going to be intresting as this is my first, as you put it, multi national system. I do have one thing going for me, I belive everyone that will be working with this tool should be in the US. We will see where this heads but thank you for the feedback!
  11. V

    database now needs to be global

    Ok the Short of it is that I have created a database that was made for the US only so I have phone number masks and US address fields and zip codes. Now my company is going global in a big way, we are talking about most major countries. What tips can you guys give to prepare for this type...
  12. V

    Query based on row in continuous form

    I just knew it was going to be something simple.... I needed to use [Forms]![frmMain_toplg]![subform1]![SiteID] I have everything wraped in a main form, I just spaced it out >.<
  13. V

    Query based on row in continuous form

    Thats what I first thought, I just ran over all the details a second time and everything is correct. The form is open (the combo box is on the form itself) The Spelling is correct I do have a ReQuery set but its not the issue at this point Without the Criteria the query works fine Adding the...
  14. V

    Query based on row in continuous form

    Ok I thought this was going to be simple but I must be missing something. I have a continuous form that has multiple tabs in the form footer. Anyhow I have a combo box on one of the tabs that is working with the following query. SELECT tblSiteStaff.SiteStaffID, tblSiteStaff.FirstName...
  15. V

    Question Mail Merge - Multiple values for one record

    So I have thought about this and I am not sure that its possible at this point. I have created a million reports that have sub reports to show multiple rows of data for a particular record. Now I want to see if that’s possible with a Mail Merge. I might have a table that looks like the...
  16. V

    multiple lookups to the same table

    Scrach that, It works as posted above! Not sure what I had setup wrong but after restarting the database its now working >.<
  17. V

    multiple lookups to the same table

    Ok so I have a table tblSite that has about 6 lookups to a staff table tblSiteStaff. This is so I can add in multiple staff into a Mail Merge, but anyhow my SQL is as follows: SELECT tblSite.*, tblSiteStaff.*, tblSiteStaff_1.* FROM (tblStateProvince INNER JOIN (tblSiteStaff RIGHT JOIN...
  18. V

    Double click a combo box to add data

    Google is your friend, http://lmgtfy.com/?q=notinlist+video
  19. V

    Change SourceObject for Subform after popup is closed

    I don’t have rights to distribute all the code, so uploading is hard to do I really do appreciate the assistance and I will try to get this unbound option working.
  20. V

    Change SourceObject for Subform after popup is closed

    The main form works on a different query but yes the popup and the subform both have the same query as a record source. I guess I dont understand the unbound option very well, wont that still have the same problem as it still access the same records? I am trying to figure out how to set it...
Back
Top Bottom