Search results

  1. V

    Splitting DB's

    I hope this is a quick question with a quick solution. I have created a DB, that has 10 users, 5 are on site and the other 5 of off site at various locations. In order for everyone to have access I have put the DB on a Network folder, being able to access the current DB is contingent on being...
  2. V

    Splitting the DB

    Thank you for all your replies, just a few more questions. 1. The event will be both adding new customers and updating old customer information, the customer information is further split into 6 different tables connected by the customer ID number. If I just put the DB locally on all...
  3. V

    Splitting the DB

    I have read through a couple of questions about splitting into FE and BE database, I have an odd situation and thought I would reach out to see what the best solution would be. I have created a database that I will have 3-8 users updating and entering info at sponsered events. The issue that I...
  4. V

    Best way to Import Data

    Good Morning All, I have a functional question that I hope you all can help with, I am not sure what is the best way to set up information. Here is a little bit of background: There is a National Database which stores information that I work with, but I can not manipulate it or use it in any...
  5. V

    Making a form entry dependent on another

    I put the event in cboCatogory
  6. V

    Making a form entry dependent on another

    yes the category box remains empty no matter what choice you make. Everything in the unique category tables are a subdivision of FFSMIS Here is an example Program: Disaster Response Subcatogory: Training Exercise, Collateral Outreach, Crisis Incident Training Program: Family Advocacy...
  7. V

    Making a form entry dependent on another

    Here is the code I tried but it just coming in with blank options On Error Resume Next Select Case CboFSMISS.Value Case "Casualty-Disaster" cboCategory.RowSource = "Casualty_Lookup" Case "Exceptional Family Member" cboCategory.RowSource = "EFM_Lookup"...
  8. V

    Making a form entry dependent on another

    I know this is probably in here somewhere not sure where or what to look under to find it. Basically I have two form entries one called Program and one called category. When a user selects a lookup entry I only want certain categories to show. I have created tables containing these look up...
  9. V

    Outlook Calendar Sharing

    I have a co-worker who set up a calander for classes and was recently let go. Her account is still active, but I need to get to her calander to share with the new employee taking over her job. When sharing permissions were set up I was only given editor permissions. Is there anyway to share...
  10. V

    Linking two different db's

    Can you link different databases through buttons? For example I have a database named Siezed property and another named evidence. I don't want to have all this information in the same database as there are more than 3000 entries in each one. but I would like for someone to be able to have the...
  11. V

    How can I get blank records off my report

    Thank you for your help, I think I understand how you suggested to work it out. I will try it and see if can set it up.
  12. V

    How can I get blank records off my report

    That is how I had it before, but I need the property to be in one record for a mail merge that is used down the road for example. The ID 6840 could have three different individuals who own three seperate items apiece. In the letter I need a table to list all property that belongs with one person.
  13. V

    How can I get blank records off my report

    I have attached a sample of my data. I have a record that has several spots to put property in (i.e. property 2, serial 2, value2, there are 8 data fields like this in each record.) I set it up this way so that a mail merge will include all property for one person. The issue I am having...
  14. V

    Empty records in Query

    Thanks for the "to grow" advice, I will google and research to find the nodata event code.
  15. V

    Empty records in Query

    Hi all I am not sure if this is even possible, but I thought I would give it a try. I have a basic report for seized cars and a sub report for seized property, The reports are linked by a time frame, i.e. user enters start and end dates. It is very possible for the car query to be empty but...
  16. V

    Save and lock report

    You could publish it to Word and save it there.
  17. V

    Using Subtraction in a report

    Any help or guidance on where to look would be great. On my report I have a calculated field for a monthly total cost that reads sum=([total cost]) what I would like to do is subtract this from a field in my table called "amount funded". Thank you for your time
  18. V

    Report not pulling correct dates

    Changing the date format on the form worked. Thank you!!!
  19. V

    Report not pulling correct dates

    I took out a lot of un needed info, but the final report is a compilation of many reports so I left them all there. I hope I attached this correctly. Thanks for the help
  20. V

    Report not pulling correct dates

    Today I queried 10/01/2009 thru 01/05/2010 The query pulled 09/21/2009,09/28/2009,10/01/2009 and 01/01/2010,01/04/2010
Back
Top Bottom