Search results

  1. V

    Close A Form If No Records

    It would be great if you linked that post for other users.
  2. V

    Refreshing a Form

    Why not add a button in the subform that on click runs DoCmd.Requery
  3. V

    Help with Many to Many SQL 2005

    Ok guys, I have a database with about 7 join tables used to combined a set of locations with there staff members so its like: tblSite tblStaff tblSiteStaff With all the two FKs in tblSiteStaff etc. This setup works just fine in my database before I upgrade to sql. After the move I am no...
  4. V

    Question Many to Many Worked fine in access but will not allow insert in SQL

    Hey guys, I get to stay at work till I resolve this so any help would be great So I have my database all ready to be upgraded to SQL server 2005, everything for the most part works just fine. After I upgrade with the Microsoft SQL Server Migration Assistant 2005 for Access tool, my...
  5. V

    Phone call from MS Access form

    What is this "Dial-up Modem" :p
  6. V

    Phone call from MS Access form

    I belive you will need to look into the Skype API to do this, if you have IP phones with Avaya/Cisco/InterTel you might also be able to do this if you use there remote users software. You might want to provide more information about what you want to do, its not as simple as I want to make a call.
  7. V

    Strange vertical graphical glitch when using JPEG as background

    :eek: I love it!
  8. V

    Strange vertical graphical glitch when using JPEG as background

    I am going to guess that you are going to need Me.Repaint in some way. But I mostly wanted to post and say, nice looking menu! Puts mine to shame :(
  9. V

    Design - Form opening another form in a box

    Use a subform, then use the command buttons to change it. This is the code you would need, Just replace everything with what you want and assign to the onclick event. Me.frm.SourceObject = "frm" Me.frm.LinkChildFields = "C" Me.frm.LinkMasterFields = "M" This is just how I would do it...
  10. V

    Help with filtering with Combobox

    First thing I see is that your calling forms "qry" frm = Forms qry = Queries tbl = Tables Doing this will help you later on when you need to select data sources etc. Why not have your search directly on frm main? I don’t see why it needs to be on another form. Same goes for the add...
  11. V

    Help with filtering with Combobox

    The attached file is missing qryEmployData & qryEmployAtt did you send the correct file?
  12. V

    Variable Subforms from Main Form

    Would something like this work for you? Private Sub FrmStaffView_AfterUpdate() If Me.FrmStaffView.Value = 1 Then Me.frmSiteStaff.SourceObject = "frmSiteStaff" Me.frmSiteStaff.LinkChildFields = "tblSite.SiteID" Me.frmSiteStaff.LinkMasterFields = "SiteID" Else...
  13. V

    Many-to-Many Grouped into one larger table?

    Thank you for that feedback! Sounds like I will go with what works and stop trying to create shortcuts :)
  14. V

    Creating a subform to manage team members

    If possible save the file in a Access 2003 format, you will get more help ;)
  15. V

    Help with filtering with Combobox

    Thats because its not a form, its a table. If you want a form you would need to create one, then add it into frmEmployData as a subform.
  16. V

    Help with filtering with Combobox

    Wait till you start working with multivalue fields, then find out that you need to redesign the entire DB because they dont work as easy as you planned :)
  17. V

    Help with filtering with Combobox

    Did you add any data? I did not add any records other than the lookup tables. So add a few records and I think your issue might be resolved. Also make sure you spend some time seeing how I set it up and make sure its what you expect.
  18. V

    Continuous Forms problem

    Subforms are based off Parent and child relationships. So if you are selected on record A in the main form, you need to also have a record A in the subform or you wont get any data. I normally do this with a ID field.
  19. V

    Help with filtering with Combobox

    Also he is using attachments so he cant downgrade.
  20. V

    Help with filtering with Combobox

    This is quite true. This DB has some issues with basic design, I have attached a revamped database based on your data. This should make your question a little more simple as it might not even be needed anymore :)
Back
Top Bottom