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

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

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

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.

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

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

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

Works Great--Thank you very much

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

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

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

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

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

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

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