Search results for query: *

Will do thanks for the insight.

Thanks lameid. So is it best to convert my mdb to mde and distribute the front end to each user and keep one back end? I'm trying to learn this as I go so please forgive the elementary questions. Thanks again!!

I have a few Ignorant questions about the benefits of splitting my database. 1. Will it enhance performance? Or is performance in how I distribute the front ends? 2. If data is stored in the back end why do I still have my tables being populated in the front end? 3. I can think of a bunch...

I started looking into this then realized the reports I created in Access are based on selections in a form. I may try using Sequel Reports not sure how to use those but our IT guy said he could lend a hand. Is this an avenue I don't wan to go down ????

I'll give this a shot in Excel. Thanks. As to what am I drilling down? I have a defect table that has different groups(Machine, Operator, Process, Supplier). Under those groups there are reasons. So Machine has like 10 different reasons, Operator has like 15 different reasons etc... what I...

OK first, I'm trying to learn how to use Access without any official training so please be gentle. I've created a bunch of 3D pie charts and have been asked to have each category drilled down by clicking the piece of pie. Would this called a sub report? I'm not sure where to start or what...

Thanks PH I'll give this a try when I get back to work. I used WHERE Level1<>"" and that worked but yours is probably better....right?

This works except when I have an entry in the Dept field but no data in the Level1 Comments field. It returns a value of 1(because there's one Dept??) but it should be 0 or "" because there are no comments. I like what you have so far!! Thanks for the help.

Thanks a lot Jerry !! And thank you genomon for checking the spelling (LOL).

Hmmm I am populating my textbox through a Dlookup function and when I lock the control I can still mess with the text. Perhaps because of the way I'm populating the text box. I guess it's not that big of a deal but it would be a plus if this could happen. Thanks for the time.

I am attempting to build a paredo chart and when I run my query I get the resulsts EXCEPT I am getting a blank value (Level1) with a Total of 0. Why do I keep getting a second value of nothing? Any help would be great Thanks!! Here is the code from the SQLView SELECT tblcomments.Level1...

Locked only means you can't update the table using a bound control. My textbox is unbound. I wanted to have it so the user couldn't click in the box and "jack around" with the text.

I have an unbound microsoft 2.0 textbox (because it displays scrollbars without needing the focus) and was wondering if there was a way to only allow the user to view the text and not be able to change its contents. "Sort of like a label with a scroll bar (I don't know how to do that either)...

I only bound it because it was easier to fill. I typically use the dlookup function when filling a form. There may be a better way but I wouldn't have a clue how. So yeah I unbound it and it works fine. I appreciate your help a great deal. And have a pink thing on me.

After doing some looking I found a couple threads saying something about having write conflicts with bound forms. I did make the form unbound and it works fine. Thanks for the responses. I'm pretty much a noob here so what do you mean when you say update the field on the form itself?

To anyone - I have a form where scrap is entered into a listview control on that form. I have made it so if the user dbl clicks the control he/she can edit the information. I can update the information no problem. My problem comes when I go to close the form I get a message saying Write...

Thanks John I finally got a chance to look into this using the links provided and got it to work. I appreciate your help.

I've been trying this from home and after looking on the internet a while I found some code (below). The problem is after clicking the button nothing happens...Nothing. What am I missing besides a brain??? Private Sub Command0_Click() Dim stappname As String stappname = "C:\Documents and...

Thanks for the reply. I'm using Adobe Acrobat 7.0 and yes it opens fine when I dbl click it in Windows. I can't seem to find the FAQ you are referring to. I will keep searching. Thanks you

When I click the button to activate my code I get a flash then it goes away. Why can't I get the file to stay open? Are there settings that need to be modified? Anyway here is my code. Any help would be great. Application.FollowHyperlink "C:\Documents and Settings\myname\My...