PERFECT! That was exactly what I needed to see, a sample of how it is used. By following the example I was able to create the same thing and have it display on my report as I wanted it to. I also used the same technique on a couple of other fields so it will have information on the report...
Well I have been trying to work with the 2 examples given in the 2 FAQ's and I am not getting how this works. Is there an easier way to break this down so that it can be understood? I'm not understanding the process or what goes where. Any help would be appreciated.
Thanks.
Ok - I will take a look at both FAQ's that you reccommended and see how I can implement it into my report. If I get stuck I'll reach out again for help.
Thanks for the help.
Thank you for the suggested FAQ's, I took s quick peek at both and they look like what I am looking for. But it looks like a lot of code - would there be anything simplier?
My example would be as mentioned before, if a person works in many states then the info on the report looks like this:
CA...
I guess I was trying to explain it as simple as possible. Sorry if it didn't make sense. Let me try to explain it this way. I have a form, that has subforms that I can select from a list and select one or more items. This information is saved in its own table that through relationships I know...
I have a form that has a combo box that allows me to select many choices. On my report I have the combo box on there to display the information of which I do see and that is what I want, but it displays the choices one underneath the other. How do I get the information to display side by side -...
Thank you for the information. Navigating to the network neighbourhood was the way to make the connection. I did go to all computers and am able to see the link table information on all of them. Problem has been solved, thanks again for the insight. I wanted to give you a star but not clear how...
I think using the UNC may be the way to go but still not clear how to map it. If I go thru the normal route of linking a table, it does not give me the opportunity to name the path. So how would I specify a UNC path?
Thanks
I have created a database that sets on our server (Windows 98). I have a shortcut on 3 computers using Windows 98(which for all of the 3 computers is the F drive) and 1 computer using Windows XP (which this computer is the L Drive) to this database.
In this database that sets on the server...
Well not sure what you mean, but when I open our database the Switchboard opens and then the Database Window, all though it doesn't open fully, you can still see it off to the side. I want them to be able to still select from the Switchboard the various items, reports, forms, inputting...
I don't want the Database window to show when someone opens the database. I have gone up to Tools/Startup/ and unchecked Display Database Window selection, but when I close the database and open it, the database window can still be seen. Any "easy" suggestions?
Thanks in advance for any help.
Thanks for the suggestion, it is almost perfect. I did what was suggested and first it brings up a Message Box that says "You can't use find or replace now", with an ok button. I click the ok button and the blank record will come up of which I can input new information. How can I keep...
Hi,
I have a command button that when I click it, it opens a form that I have assigned it to open, but instead of it displaying the records I have all ready inputted, I just want it to open up to a blank record. How do I do that? At the moment this is the code that I have attached to the command...
Thank You so much, I took your code and after a few hours of figuring out, trying out and testing it out, your solution was a success. I understood some of the code but not all but I went ahead and bit by bit tried to make it work. I think the key had something to do with the bookmark part...
Hello,
I have a subform that I am utilizing and on that subform are 5 command buttons each when clicked opens up a small form that I input information that is unique to that subform record I am on. My problem is as follows, lets say I have 10 records in that subform, if I am on record #6 and I...
Excuse my limited programming experience but I'm not clear on how to implement your recommendation above into the existing ToggleSubform code. Do I merge these 2 pieces of code together or is your ClickCount code a whole new piece of code?
Would I have put ToggleSubform = Null piece of code underneath the line Me![ToggleSubform].Caption = "&View Stains Count"? I tried and it pops up a Run-time error '438' Object doesn't support this property or method.
I have thought of putting 3 separate buttons on there as well but I...
Hello,
I have 3 subforms that I would like to access using a Toggle Button Control, I can get it to work with 2 subforms - clicking the toggle button it will display 2 subforms going back and forth between the two, but I really would like to use this toggle button to display 3 subforms. I have...
Hi,
I am using the Report Date Range form to open up a report by date. (This is the standard Report Date Range form that can be found in the various database that come with Access 2000). This feature is great but is there a way that on that Report Date Range form I can add another unbound text...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.