Search results for query: *

Okay, this is a complicated setup but I will do my best to describe it. We are part of a very large network with static IP's. We recently relocated our offices and were told that not enough IP's were available to go around. They gave us two IP's and I proceeded to split one of them with a router...

The command button is used on multiple switchboards and works perfectly for every other one, I did try to replace it anyway but I am not familiar enough with command buttons used on switchboards to create a new one that works properly. I also tried changing the option button that was associated...

I wish that was the case. That is the way that it is acting but that is not the case. It is being opened with the switchboard in edit mode.

I have a form that is opened from the switchboard in edit mode but no records are shown. The form is linked directly to a table and has no filters. I can use Remove Filter/Sort to view records but I cannot do it via a macro. I have tried setting the Allow Filters property to No but this only...

You are a genius! Thanks. I was on the verge of duplicating everything without a filter.

I tried using the Like * but I could not get it to work. I also tried using setvalue in a macro to set FilterOn to No, but it would not let me use setvalue for that property. I am open to either so long as I can apply and remove the filter based on a criteria. The criteria I am trying to use is...

Nevermind. For some reason just that column was linked to a different table (Data_1 instead of Data). It worked fine after I corrected the table. I didn't think it should have been that complicated. Thanks for your help.

I've tried True and False also, no luck.

The data type is Yes/No but when I use yes or no as the criteria for a query filter it does not filter. Is there a specific way to reference it? Thanks

I have users "login" using a username and password for their section, which then filters all records for their section. I want to have a "master" account which has access to all records, but without removing the filters entirely I can't get it to pull all records. Is there a way to filter for...

I want to filter out records if a check box is checked but I can't figure out or find how to reference the criteria for the query. Yes/No doesn't work and neither does True/False. Any ideas? Thanks. Brent

Okay, obviously I am not going to get any help here, other than people stating the obvious. I have more than a basic knowledge of access and have created a number of local databases for different sections and offices at work, good enough for them to ask me to do a central database for the entire...

Okay, the macro that I have now is a work in progress that I created specifically to call the switchboard after the other things were done, the problem is in calling the switchboard to a page other than the default. I can have the macro open the switchboard but it always goes to the default...

Thank you for the help but that does not accomplish what I want it to do. I have other things that need to be done as well upon changing switchboard pages, therefore I have to use the main switchboard buttons to run a macro to accomplish them prior to changing pages and effectively leaving me no...

Quick and simple. I have several switchboard pages. Is there a way to call a particular switchboard page (not the main switchboard) with a macro? Thanks.

I did use the switchboard manager to setup the switchboards. The problem is that when a section is selected from the main switchboard I can either have it run a macro or go to another switchboard. I need it to do both. Either run a macro to set the section and have the macro change the...

I have a central database with everyone in the company. I have all my forms and reports setup to be filtered by sections but I would have to have a switchboard button for every instance of every form and report (which would be a huge mess of switchboards!) I want to have the main switchboard...

I have a form with a list box. The list box is the only editable item on the form. When an item is selected it opens a modal form to edit the record. The problem is that when the form with the list box first opens, the list box has the focus but you have to hit the down key or click on one of...

I have the same problem with a client's pc that I built. Soyo MB K7VME Socket A 350 Watt PS AMD Athlon XP 3000+ @ 333MHz FSB 512Mb DDRAM (Ultra) 200Gb HD (Western Digital) OnBoard 32Mb Video (PCI or AGP? Windows XP Pro When I originally built the system I tried installing a Powered By ATI...

Thanks Ben for the help. I will try that and let you know how it works. However, I don't know that a clean install will fix anything as this was the second clean install since the problem started and it caused the problem during the os install. Also, (I'm not sure about this but) i seem to...