Search results

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.

Any suggestions or is there a better way to go out than a marco?

Hi Everyone, I am trying to create a marco that will bring me to my form that is sorted by only the ones pending completion. I have a request form that upon front end opening it is automatically assigned pending status. My goal is to have a buttom either on the switchboard or form that will...

I am attempting to move a secure database location. How do you change the location of the security since it is still trying to read off the old location. The database opens up fine with the passwords. Then I deleted the old folder it was in and try to log back in and give me the security upon...

Thank you that works but how do you change the location of the security since it is still trying to read off the old location. The database opens up fine with the passwords. Then I deleted the old folder it was in and try to log back in and give me the security upon startup error. So my...

Hi Everyone, I am attempting to move a password protected database to a different folder on our shared drive but I am not sure the steps that are needed to do so. The database is already split. Can someone please assist???