Search results

I am doing a query to populate a listbox from a separate table. When I do the query, I receive multiple returned values, and multiple values that are the same. Can I limit the number of returned values to be a list of the values in the table I am pulling from? Vendor Table- -Only 2 entries...

I have a form with a close button on it. When I press the close button, I want it to close the form without saving the data. When I first open the form the close button doesn't work the first time I click it. It works every time after that, but I can not figure out why it doesn't work the first...

I have a table with IDs 50-59 only, and part numbers that are added by entering a value. I want to find a max value of a part number based on a dropdown. For example, if I choose Divergent from the dropdown, it is group 55, then I want to find the highest part number of that group. Is this...

I have found several posts concerning filtering a recordset, but I am still a little befuddled. I have a text box where a person can enter a keyword to narrow the items on a subform. This is done using a recordsource. My question is, can I then set a filter on that recordsource, and continue to...

What is the best method to pass a value from one form to another when I open the new from from a button click? I have a lot of the information I need on one form, and I believe I could load those into variables and then pass them into the new form from those variables. But, is there a better...

I am trying to print from a form to a report. The problem I am running into is I am getting a long report and I have discovered I have basically the same number of pages in my report as I have entries in my subform. If I have one entry in my subform I get a 1 page report. If I have 2 entries in...

I have a database with two tables, and a form that is bound to the 1st table. I have a duplicate record button on the form. One of the functions I want to happen is when the duplicate button is pressed, one value is copied from the form and added to the 2nd table. The tables are basically set up...

I am having difficulty figuring out DAO recordsets. Supposed to be easy, but I am guessing I am a little dense when it comes to these. Here is what I am trying to accomplish. I have a form and it has a field with an AutoNumber. When I hit a command button, I want to copy that number to a...

I am trying to make a checkbox with different graphics since the checkbox can not be resized. I thought I could stack images on top of each other and toggle between showing and hiding based on if the checkbox was checked. This actually works, but I wanted to hide my checkbox, so I hid it behind...

Please excuse me for this post, but I could definitely use some assistance. I have searched through the forums and I am still struggling. I am trying to populate multiple email addresses based on a table and a yes/no check box. If the checkbox is checked, they receive an email. I have a table...

I am trying to populate an email out of VBA with information from a form. I am just running into one problem. The data that is being pulled for RMA Initiated By in the next to last line pulls the index number instead of the 2nd column which is the name. How can I specify which column to pull...

I am opening a report to send to users in an email using the Emaildatabaseobject in Access 2010. This works great, but I would like to add data to the subject line in the macro pulled from the report I am opening. The reportname is RMA_Admin, and the field on the report I want to pull from is...

Can you update a text box on a form based on input of a date control? Here is what I have. I have several date controls on my form, and I want to update a status textbox based on which of these date boxes is filled out, but I need the status to be filled into the table as well. Do I update the...

I am really struggling to wrap my head around how to make cascading comboboxes work. I am working on a database for returned products, and I need to break down as best as possible what the problem is. I thought the best way to do this would be cascading comboboxes. What I am trying to do is have...

Is there an easy way to create a matrix? I was thinking of a crosstab query, and it seems to fit, but some things I would want to change. This is the layout I am looking to develop, but I wanted to know if it is really possible. Down the left side would be training requirements, across the top...

Hello all, it has been a while since I have worked with Access, and so I have not been here as well. I have a database for training. I have a table of employees with one of the criteria being active which is enabled by a check box. I have a second table of all of the training data. When I add...

I am not sure this is possible without some programming in the background but thought I would throw it out there anyway. I have a database we are using to track committed shipment dates and revised shipment dates. If we slip on a shipment it gets a new revised date and we let the customer...

I have been working on a timesheet program, and I believe I am pretty close to being completed with the input functions, but I have run into a snag. I have a form that basically directs a person to add a new timesheet or edit an old timesheet. I have two comboboxes and I have been able to set...

This seems like a pretty hot topic right now, but I am running into problems with this. I am trying to filter a timesheet using two listboxes. I must be doing something wrong. I have an timesheet table that pulls information from the employee table and date tablem to create the timesheet...

I looked through the forum and I am not finding an exact match to my problem. It seems simple enough, but I can't seem to sort it out. I am working on a timesheet program. On one form I have 2 listboxes. One has all of the employees, and the other contains dates the timecard needs to be...