Search results for query: *

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...

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...

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...

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...

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...

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

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...

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...

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...

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...

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

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...

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...

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...

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

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...

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...

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...

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...

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...