Search results

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?

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...

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...

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...

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...

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???

Would anyone be able to explain how I would be able to have the words in my text box "floating" rather than stuck to the top. I understand how to center but cannot seem to figure out how to make it appear to "float" like in excel? Thanks again

Hi everyone, I am trying to create a button on a form that will export only that record. On the command options I do not see there being an option to do such. Can anyone help? Thanks. I would like to export to excel or anything that will capture what I am looking at. I have noticed that Yes/no...

Hi everyone, I am trying to create a button on a form that will export only that record. On the command options I do not see there being an option to do such. Can anyone help? Thanks

Hey everyone, I have a form that acts as a survey asking 11 questions total. Each field in my table is called material1, material2, ect. I have a total field in my table that I would like to be the sum and was told that I have to do this through a query. My only problem is when i query it...

I am trying to calculate ave in a textbox coming from my form, "Scores 1 and Scores 2." I am using in the control source the following: AVE([Scores1]+[Scores 2], but an getting an error #Name. I am very new to creating formulas and such in access and any help is appreciated. I have used a...

Hi everyone, I have a form that I am creating for the trainings at work for their training classes. Upon completion of the class, the trainess fill out an evaluation form based on how well the class was asking several questions rating each question 3 strongly agree, 2 Agree, and 1 Disagree. I...

Hi Everyone, My goal is to design a report that list on the top the report my parameter that i am inputing. Example I have different status, Feasible, Closed, Assigned, ect and I want the name that i place for my parameter to populate. Can you help?

Hey Everyone, I am having a problem with my switchboard. I am trying to have it setup so that everytime one of my user's login, the switchboard pops up. I thought that this was done by selecting default next to the switchboard. I have done this and it does not automatically pop up. Can...

Hey everyone, I am trying to create a notes log so I will have one field for new notes and another field with the entire notes history on that issue. How would I go about doing this since I am relatively new to Access? Thank you:)

Hey does anyone know if there is a template for company error trending or one that is compatable? Thank you:)