Search results

I was adding a few print buttons here and there throughout my access database. Now, anytime you open the database -- The print dialogue box opens and wants you to hit "print" in order to proceed..? I tried to see where I might have put in some kind of "on load" event, and can't find one. Any...

Good Morning, It's been so long since I've tinkered with vba, coding, etc and I can't seem to figure out how to 'edit' the code below. I currently hit a button, and depending on data I have entered, it opens an email using my outlook with the email addresses in the BCC. It works perfect...

Good Morning, I've put together an emergency contact form. It holds basic data for different accounts that I have. Each account number may have multiple entries due to more than one contact on the same account want to be contacted during an outage. My list box holds the account numbers, and...

Good Morning, I am attempting to run an update query, but can't get the code right at all. I have run a query with my data that needs to be changed and am hoping someone can help me out. Attached is my query, and form/subform with the tab;es that need to be adjusted. Assuming my query is set...

Good Afternoon! I'm not sure if this is the right place to ask, but, I'm trying to see if an update query would work for me. Attached is a screen shot of my current form/record. Can I use the Yes/No checkbox, when clicked, replace data from one record of my form, to another record in the same...

Good Afternoon, I have an attachment field in my employees table (tblEmployee) where I store unique documents to the employee (Loaned Equipment docs, warning docs, etc) and this works fine. Is is possible to save reports that I run specific to the employee to this particular employees...

Good Morning, I have a sub form that hold pay period ending data for my employees. I also have a button on this form that creates a new record for the employee where I go in and add the new pay period ending date.... Is there a way to be able to make this button add that SAME pay period ending...

Good Afternoon, I've attached the following code to my On_Click event, however, it's not working the way I intended. When the form loads, it makes all of my Serial Number fields visible whereas I only want them visible if the drop down box has selected equipment highlighted. If I go into the...

Good Morning, I'm an amateur when it comes to code. I have two strings that work, but they won't work together. I have Dim strSQL As String and then two strSQL statements. Only one will work, the other does nothing. How can I combine them? They both work, but not together. I can't come up with...

I've created two forms, and need the toggle (Yes/No)button to be able to fill in another form with two pieces of data from the form that has the toggle. (See attached example) I've manually filled in the Customer and Phone on the 'Cut' Sheet from the 'Customer Data' Form. Is there some sort of...

Good Evening, I found a code from another website, that will show you the Computer/UserName/Connect information of all users within the database. I'm not much of a programmer, and was wondering what type of code I need to put where to get this particular code to be able to capture which user...

Good Morning, I created a query that will give me a list of information from a few different tables based on an employee. I've run the query, but it doesn't return ALL of my employees. The data it does return based on employees I do see, is accurate. Any ideas? I've attached a screen shot...

Good Morning, As I build my first database, I now realize that I may have missed a crucial step. I've created a database centered around my employees. I have created various sub-forms and tables with pertinent information that relates to incentives etc. I've always had in mind that I would...

Good Morning, If I am understanding what IIF does, then I'd like to know how I can use it. I'd like to have a criteria in my query that says, If the input you typed in is the matches the name of a manager, then return the list of dates with JUST that manager. If you don't type in the name of...

Good Afternoon, I attempted to search for a thread on idle shutdown for microsoft access, and I can't seem to find one that works. I've found a few codes, but they either error out and don't work, or not what what I am looking for. I have a form created that I'd like to pop up when the time...

Good Morning, I have a list of Supervisors that score 5 random calls for each Telephone Operator. I have set up a query to figure out which Telephone Operators have had a 5 Message review completed and by who. Basically, I want to be able to run the query and see which Operators have had a...

Good Morning, I have a report that I run based off of a query that I want to have sorted by each employee. Supervisors go into my database, and fill in a form for each employee which relates to how they do on their calls in the call center. Each employee gets reviewed on 5 random calls. The...

I have a report which is based off of a query that returns 5 small forms (phone call review forms) per Employee per pay period. So when I run the report, I'm prompted to enter a pay period, which then returns all phone call reviews by operator for that particular pay period. Usually there are 5...

I have a simple form that I have supervisors fill out as they listen to recorded phone calls for telephone operators. They open the form, select their name from a drop down list, fill in the form, and then press a button that saves and closes the form (pic attached). Once they close the form...

Good Morning, As I go back and try to refine my database, I am trying to tweak the code that will place a new space between comments in my comment box. It'd be easier on the eyes to see a space in between comments from other users. Right now, when someone updates the comment box, there are not...