Recent content by scottmvinovrski

try creating a marco openform. It will ask you form name and if you use a switchboard it will pop up

Hey everyone, I am using the formula: =DateDiff("d",[Submit_Date],[Closed Date]) to calcute the time it is taking to get an issue resolved. Is there another formula that takes out the weekend since they are not working days?

Keith I understand what everyone is saying and thanks for your help, but does this mean i can move the table to my copy of the front end or everyone's copy of the front end? Just wondering since about 20 ppl have front ends?

Paul or Rural Guy, If I do switch the switchboard table and move it to my front end do you think this would cause any problems for those who are still using the switchboard. Or do you think I should just create a form that acts as a switchboard on the computers of those who need further access...

Rural Guy, I did make a copy of the DB on their desktop of the front end. One problem though, since the switchboard is linked to the tables on the back end anytime I change the switchboard the change is seen on the Front end of all the users. I originally had a tab on my switchboard for...

I have front end users that process work through a switchboard and that data is logged in a back end shared drive DB. I have a question and haven't really been able to find a similar problem that someone else might have encountered. Anytime I edit the switchboard on my desktop it edits on...

Thank you both for your help. This does give me the understanding on how to complete the task as painless as possible!

Dennisk, Thank you for the follow up. That appears to be clear now. 1 question though. If they have a copy of the front end on their computer and a shortcut, couldn't the user simply click on the front end and get full access rather than clicking on the shortcut?? Just trying to play devil's...

If anyone can explain how they setup the shared drive database as far as shortcut with security please advise if my thoughts are not correct. Why would you load a copy of the front end onto everyones computer and then create a shortcut that directs them to your shared drive? Can someone clear...

Doc Man, Thank you and I understand your position on searching the forum first. I have done that and there are a vast amount of great responces from everyone on here that supports this forum. That being said my confusion still has not been answered. I understand making a copy of the front end...

Hi everyone, I am going to be implemeting security on my split database but have a question? The database will have the back end on a shared drive and I will copy the front end to the desktops of the people who will use the database. My question is such that when I use the Access security...

Peter, Would that be the listed users when you click on the properties of the folder??

Hey everyone, I am in desperate need of your help. I have a split database that I am trying to enable multi users access to the database. I created a folder on the share drive with the front end and a folder on share (BEN) with the backend. I have changed the settings via options, advanced...

Place them in the Report Footer section of the report. Create a textbook and in the control source use =Count([Whatever your table name is]) to get the count of all the records in that report

Thanks for the reply Keith. Sorry about using the wrong lingo for the confusion i was using the terms we use hear at work for the process of the database. Nonetheless, can you explain were in the record source i can do this? Thanks again.