Search results

Anyone has any work-around with this??? I have tried different change in properties but still not able to get that done...

Thanks RainLover. I am using Access 2007...

Greetings Everyone, Sorry for the delay in posting this back - I was away for a while. Ok - I have attached just a sample Database. When you open the Database, it opens up default to Form2. When you right-click on upper left corner on the MS Logo, you have an option to actually customize the...

Here is an example of my Table - Let say it consists of a total of 50 employees from 5 different department. I have them listed in a table with other personal information as well... Dept EmpId LastName FirstName Salary Addresss Phone etc... My Dept are FIN/ FAC/ OPS/ TRANS/...

Greeting People, I have a question. I have a Table with employees from different departments and I created another form for their daily attendance details. What i want is - if a director from department x needs to fill in attendance for all his employees, he just select his department from a...

Hi, Sorry for the late reply... I was OOO for a while. I am not getting any error message but it's only when i click the button for the event to take place, it never happens. :banghead: OK. My Main problem is that I want to hide the "Customize Quick Access Toolbar" when the users right-click...

Yes, I am hiding them but when they right click on the Access Icon on the Top Left, they are having the option to customize....:banghead:

Greetings, I have a split Database into Back-End and Front-End. I want to hide the Access Customize Option in my Front-End. I have tried to make the Database ACCDE but the option still appears to Customize the Access Database. I also want to know why is it that when i make a Database...

Greetings, I have a split Database into Back-End and Front-End. I want to hide the Access Customize Option in my Front-End. I have tried to make the Database ACCDE but the option still appears to Customize the Access Database. Can someone please help? Regards, Sunny

Use the below code: You will be able to call the Quote number details by using VBA but first of all, you will need to create a report comprising of all the details you want to see for the quote number. [CODE]DoCmd.OpenReport "Rpt_Name", acViewReport, WhereCondition:="

Yes Bob, I managed to open the Database. It is working fine now. Appreciate your help! ;)

Hi ypma, Thank you for your help! This is what i wanted and bu checking your db, i know what was my mistake. In my query actually, i added a criteria [Enter Emp ID] and this is why it was always prompting me for Emp ID. Once removed, it is working perfectly fine. Regards, Sunny

Oops. not able to get that open or transfer that to 2007. Can someone please convert the attachment to access 2007 and send that back - Thanks! Regards, Sunny

I am currently on Access 2007. Here is below what I am doing: Table: Emp_ID Name Position DOB Hire_Date I created a Query to have the below: Emp_ID Name Position DOB Age Hire_Date Tenure (Time With the Company) My Report contains all what i listed in the Query. My report is taken from the...

I created a form and add a text box. Label name is Employee ID and Text Box Name is Emp_ID with no Control Source. I then added an image on that form and on click, I have added the Event Procedure on Click Private Sub Image11_Click() If IsNull(Me.Emp_ID) Or Me.Emp_ID = "" Then...

I tried the above and was not able to get a resolution. It is prompting again for the Emp ID in the Pop-Up... My Report record source comes from a Qry_List. Name of the Emp_ID in the report is txtEmp_ID and control source is Emp_ID. In my Form, name of the Text Box is Emp_ID and no control...

Greetings, I have a Table with Emp_ID and Details of my Employees. I have created a query and set parameter [Enter Emp_ID]. When I pull up a report, I get a pop-up and it asks me for the Emp_ID. When I input same, I get the information I need. Everything is good so far... My Question... I...

Works Perfectly Fine - :)

Hi Paul, How to I go about creating another field in the table that will have the User Level Access to the form name and how to call that by using the below code... Sorry for that... I have pasted the codes correctly now!!! Private Sub cmdEXIT_Click() DoCmd.Quit End Sub Option Compare...

Greetings, I have been :banghead::banghead: for several hours with a code here. I have a table with EmpID, EmpName and EmpPassword. I want to set up user login form to call up other forms. With the below code, if a user enters a username and password, it looks if it matches the table and...