Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sblanche

    Select Query will not make changes to database

    When I do my other "Select" queries and make changes to the data from the queries my table data is changed. However the query below will not allow me to make changes. The data from the query is correct but can't make changes to it. One post said to change Record Set type to "dynaset" or...
  2. sblanche

    Look up at table level vrs. row source

    Thank you so very much for the link to "the evils of Lookup Fields in TAbles". I have people pushing me to move the "pick lists" from the Form "row source" to the table "lookup" tab. I knew there must have been a reason I designed it that way in the first place but after 10 years I could not...
  3. sblanche

    Look up at table level vrs. row source

    I have a DB that I designed 10 years ago. We need to redesign. We have about 10 fields that have some simple look up values. An example would be the type of case. They are either C, L, A, or M. I may at one point add more types, but for now it's the 4. Instead of putting those picks at the...
  4. sblanche

    Access 2003 and Adobe PDF maker

    We had a problem with our Database not allowing more then 3 people in at a time. Once I removed the Adobe PDF maker from Access no problem at all. I'm assuming it's a network setting but I could not get our network support branch to research and find out what could be done. My only option was...
  5. sblanche

    DB from 2003 to 2010 "On click" not working

    That was the solution! It wasn't a "trusting" location (like some people I know--sorry different post). thank you so much for the help. Tek-tips has save my sanity more than once.
  6. sblanche

    DB from 2003 to 2010 "On click" not working

    I have a DB that was created in 2003. We have upgraded to 2010 and most of the Command Buttons "On click" will not work. When you click on the button it just sits there. On a form I have a very simply button that when you click on it, the data is to be saved and the form close. Any help...
  7. sblanche

    additional problem with one-to-many and dates

    Previous, I had the problem below listed in the tek-tip thread. dhookom helped by giving me the answer of "Create a crosstab query that set the row headings to your tblMain fields, Column heading to DateItem, and Max of [Date] as value." Now I need to add another column that will calculate the...
  8. sblanche

    Can't find wp12us.wpt

    Just installed WP 12. I made sure I could view all files and folders (even hidden) and I can't find the wp12us.wpt. Even did a search and still no luck. Thanks SLB
  9. sblanche

    exclusive db rights

    Turns out the problems was the Adobe Toolbar. I had to: On the computer running Adobe, open the Add/Remove Programs dialog from Control Panel.  Click on Adobe 7.0 Standard/Professional, and click "Change/Remove".  Chose "Modify" from the wizard and when it gets to the optional plug in page...
  10. sblanche

    exclusive db rights

    I had an Access 2000 DB, with multiple users, that ran fine with more than one user accessing at a time. The office upgraded to Access 2003 Friday night, I did not get any calls Monday about Access problems (could be that only one user had it opened at a time on Monday). Monday, night, SMS...
  11. sblanche

    Query and report one-to-many

    Works Great--Thank you very much
  12. sblanche

    Query and report one-to-many

    I have 2 main tables. TBLMain has the names of cases (law office). The second table, TBLDates, has all the dates of the cases. A one-to-many relationship. A single case can have many dates. TBLMain - OCCNumber; CaseName; Case Attorney TBLDates - Date; DateItem -Date is the actual...
  13. sblanche

    Menu bar problems in Word 2003

    I do use the Work menu but it has limitations which is why I was also creating my own and hyperlinking to my files. Word 2000 allowed me to create 3 of my own menu options and I could give the hyperlink a descriptive name that would be helpful (instead of renaming my files). Also, you can have...
  14. sblanche

    Menu bar problems in Word 2003

    Sorry, to be confusing. AFter I created a blank menu option, still in the "customizing" mode, under "Categories" on the right hand side of the screen, under "commands" you can drag up to the empty Menu option "OpenSubDocument" then under "OpenSubDocument" you can "assign Hyperlink" to a file...
  15. sblanche

    Menu bar problems in Word 2003

    Here is what is happening (and it is very inconsistent). I add 3 additional menu items to the menu bar. Right after the "Windows" option but before the "Help" option. All 3 will be blank. Will close Word to update the normal.dot. I will add 10 documents to first menu option. close Word to...
  16. sblanche

    checking enterred dates

    John: Works like a charm. Thanks very much!! SLB
  17. sblanche

    checking enterred dates

    I have 2 tables. One my main (one) and the other a date table (many). On my data entry form I have a date tab. The date tab/table has" In Date Out Date Date Item My users are making data entry mistakes by enterring an out date (5/5/05) that comes before the in date (4/4/05). Is there...
  18. sblanche

    Additional Powerpoint charts

    I have a user who is looking for "stacked bar graph with a line on 2 Axes" and other additional graphs. I checked MS and could not find additional powerpoint charts. Any help would be greatly appreciated. SLB
  19. sblanche

    Access 2000 vrs 2003

    I currently have a large database designed in Access 2000. We will soon be going to MS office 2003. I noticed that Access 2003 has an option for "default file format" to stay at 2000 even if you are using 2003. Since my DB is working fine as a 2000 DB, I am contemplating keeping it in the...
  20. sblanche

    SUM and decimal places

    Wow --what a fast response. Sorry for the basic question but where do I put Round([SomeField],2). I use the Query Wizzard to create the query so I'm not sure where it goes. When I said I use "SUM" it's just an option you can pick for the Total field. Also, I just noticed something about the...

Part and Inventory Search

Back
Top