Recent content by BrentJ

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.