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: *

  • Users: sblanche
  • Content: Threads
  • Order by date
  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

    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...
  3. 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...
  4. 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...
  5. 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...
  6. 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
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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
  12. 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...
  13. sblanche

    SUM and decimal places

    I have a table with 10 fields (FieldA, Field B, etc) where we enter numbers using 2 decimal places (.02, .75, .08, etc). In the table setup the "Format" is "Standard" and the "Decimal Place" is 2. When I do a query using "SUM" in the "Total" field, I get numbers such as 7.259941225511. I only...
  14. sblanche

    Copy Profile to another computer

    I know how to copy a profile from one person to another on the same computer. What I need to do is copy a profile from one computer to another. (The group in charge of our network will not allow me to use Roaming Profiles.) The reason--We have 25 new computers. In the past, what I did was...
  15. sblanche

    convert Access 2000 DB to Access 2003

    We currently use Access 2000. I have one large DB that is not a front end/backend and smaller one that is FE/BE. Both do not use logins or security. Has anyone experienced problems converting to 2003? Thanks for your help, slb
  16. sblanche

    Fields with blank entries

    I have a table with 25 columns. Some columns will have entries (such as .25, .75, etc) and some will not. When I do a query to add the fields-- Total: [column 1]+ [column 2]+ [column 3] and so on-- as long as there is an entry in the column it adds fine. If there is a blank, it will not...
  17. sblanche

    typing in the decimal character

    In my table, I have a field with the data type of "number" and the "decimal places" set to "auto". When I type in .20 or anything with the "." it changes the entry to 0. I have tried changing the "decimal places" to 2 but it still does not recognize the ".". I can type in numbers without the...
  18. sblanche

    "Review document" feature problem

    I can repeat the problem on different computers with certain documents. Users are using the feature where the "reviewer" can go into a document and make possible changes. The "Author" then goes into the document and either accepts or rejects the changes. Documents that have gone back and...
  19. sblanche

    Should I upgrade to XP from W 2000

    I work for an organization with about 10,000 computers (running Win 2000). Replacement computers have XP installed. In some offices, when a computer needs to be reimaged (because of unfixable problems) they are changing to XP. Should I do the same thing? Is there a good reason to go to XP...
  20. sblanche

    Combine queries

    I need to combine 2 queries results into a third query. A basic example. I have 1 query with 5 fields OCCNumber, case, attorney, InDate, and Outdate. The first query gets a result of 10 records. The second query uses the exact same fields but different critera and gets a total of 5 records...

Part and Inventory Search

Back
Top