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

Well, I figured it out. It seems to be because I was using the Windows 10 developer preview. I moved my database to a Windows 7 box and it worked as expected. Thanks for the help.

Thanks for the suggestion. I can tell you're doing your best to help me. This is a difficult one to explain without being able to see it happen, and I think I'm not explaining it well enough. I'm not trying to use the combo to search and display a matching record in the table. I'm just...

There's not really any code, per say. It's literally just a combo box with a table as the row source. No VBA attached. When I start typing in the combo box, it matches with the first item, and then everything else I type is inserted between the first and second characters of the item that was...

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

Hmm. I could have sworn I'd already tried that. But I tried it again and that did the trick. Thanks.

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

Right, I normally do want to delete the previous registration and keep the new one. I'm mainly looking for ideas on the best way to handle that, among other issues. I could import 10 records, delete 1 duplicate, and move the remaining 9 to the correct table. I'm just trying to figure out the...

Timestamps are a good idea. But I'd still have issue with people who fill out multiple registrations. Sometimes people will fill out the form twice because they didn't fill out some of the optional fields the first time. I'd need a way to deal with those duplicates, and timestamps wouldn't be...

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

Sorry, didn't mean to delete. It's amazing what a 2 year old can do when left unattended with a browser open. :) Thanks for the replies everyone. I got it working with an additional one column table.

I did do some Google searching, but all I found was solutions like you suggested, where a separate table is used. I've done that before and it works, but in this case, the database is already created and being used, and already has actual city names in that field. To use a separate table I...

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

OK, so the encoding option is out. Good to know. As for the version of reader they're using, it doesn't apply. The attachment doesn't even show up as a PDF. The email they receive just has this at the end of it: "begin 666 Team_List.pdf M)5!$1BTQ+C4-"B6UM;6U#0HQ(#...

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

That sounds like a great solution. I'll give it a try. Thanks!

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 found this link and option 1 did the trick for me, which is the SQL option mentioned. http://allenbrowne.com/ser-27.html Thanks for all the help.