Search results

I have a question about keyboard shortcuts. I know you can create a keyboard shortcut by adding the & symbol in the text of a label, and then your alt key will do something in combination with the modifier. Is there a way to create a keyboard shortcut that would move the cursor to a combobox...

This seems like it should be an easy setting change, but i can't find it... I have two database with combo boxes used as search fields. I've used them for years, and they were originally created with Access 2000, in case it matters. This week I just created a new database with Access 2010. I...

So I feel like this should be easy but I'm not finding an answer by searching. I have a form that's using a query as a record source. Normally that query is empty, as it's just linked to a temporary table, so when I open the form, generally I'm on record 1 of 1. On that form is a button...

I'm looking for some suggestions on a workflow for a database. Here are the details: I maintain a website that is used for online registrations. Until now, when a visitor would fill out a registration form, that information would be emailed to someone, and that person would take the email and...

I have a form with a combo box that holds Cities. The row source is a Select statement that finds all the unique values that have already been entered into that table. I'm trying to eliminate misspellings (New York, New Yirk, NewYork), so I'd like to limit the field to list values, and use...

I hope this might have a simple answer. I'm trying to create a report that is basically a full sheet of return address labels, all identical. I've got a report created that's the size of a single label. What's the best way to print 30 of those per sheet, to fill up a whole sheet of labels? I...

I'm using some VBA code to save a report as a PDF, and then email that report off to a small number of people. I've been getting complaints that some people are not able to open the PDF, as it shows up as garbage text instead of an actual attachment to the email. I think it has to do with the...

I have a generic email form that I open via some buttons on a contact form. Button 1 populates the body of the email form with text 1, button 2 populates it with text 2, etc. I use it for standardized emails to individuals in my contact database. I want to run some VBA code that attaches...

I've got a frustrating problem. I have a database that calls a compiled DLL. It works perfectly on one computer, which in case it matters, is running Windows 7 with Access 2010. But on a second computer running Windows 7 with Access 2010, when I open the form that calls the DLL, I get the...

I hope this is an easy one... I have a combo box that's got it's rowsource linked to a table, and when an item is selected, it updates the field associated to it in the combo box's control source. But there are times when the value I need isn't already in the rowsource table and needs to be...

I have a database that I wrote a few years ago in Access 2000 originally. It has a form with some command buttons to open reports with data from the current record displayed in the form. Here's the code for one of the buttons: Private Sub AcceptanceLetter_Click() Dim strReportName As String...

I think this might be fairly simple, but I'm at a loss as to how to do it. In a report, I want to set a text box's record source to the value of a field name in another table like this: CurrentData.ControlSource = DLookup("[CurrentTEC]", "[tblCurrentTEC]") There are times when the value of...

This might be hard to explain, but I'll do my best. I'll keep my example simple and say that I have a report with 2 group values, Leader and Support, each with 1 detail record within it: Leader -Mary Support -Bill I also have a table that's not part of the control set for the report. Let's...

I'm trying to do something simple...to set the background color of a report textbox based on the value in that box. I've got a bound text box showing the value of a field MasterContactID. For this example that value is 2166. I want to compare that value to the value of a field in another...

I'd like to build an update query, but it's a little complex and I can't wrap my head around it. I have a table with, for this question, we'll say has 2 fields: ID and Experience. The Experience field has 1 of 6 possible values in it for each record. So the table may look like this. ID - -...

I have a database that tracks recommendations for people. So one of the tables contains a person's name, what they're recommended for, and the event number that the recommendation came from. e.g.: John Doe, Head Honcho, 75 John Doe, Head Honcho, 74 John Doe, Head Honcho, 74 John Doe, Head...

This might be a tall order, but here's my question. I have a database that I've been asked to create that tracks name/address/phone, etc. I've created it with Access 2007 and it's nearly complete, but now I've been asked to add login security to it. The login isn't so much to keep people out...

I've got a database that tracks name/address/phone, etc for a large group of people. I've recently added the ability to include a person's photo on the forms and reports. I've done that by saving the photos with the naming convention of [firstname]_[lastname].jpg and then using VBA, the...

I have a report that displays details about insurance policies, including the monthly cost of each. It lists a person's name and all the policies that each person owns, and then totals up the monthly cost. I want to change the "Total" slightly. Right now it does a Sum of the values in the...

I'd like to know how to select a checkbox on all the records in a form's recordset at once. For example, I have a continuous form with a checkbox on each record that I want to use to select which records to print in a report. I plan to filter the form to only show the records I intend to...