Search results

I am guessing your "field" is really a combo box. Open the form in design mode and the properties sheet for that "field". Select the events tab and locate "On Got Focus". Click on the button with the three periods off to the right, select "Code Builder". This will open VBA and create an event...

I had a user ask me if repeated typing of the same letter can cause a combo box to move to the next one. It's tough to describe, so here is the example. The combo box lists states by their two letter abbreviation. You hit c and it goes to CA, California. She wants to hit c again and have it...

Possible solutions: 1) When you open the form to modify the record, close the main form (the one with the subforms). Then when you close the modify form, open the main one. This will cause the main one to open with the newer value. 2) Don't use tables as the recordsource for the subforms. Change...

Hey Yorksdummy Thanks for the feedback; it helps. My concern was the restriction of hard coding a restriction that does not allow a duplicate. I am a Junior, my Dad and I lived in the same house while I was growing up, so we had the same zip code; would your design allow that? What I do in...

For a command button and a label, get to properties and on the "Other" tab there is a "ControlTip Text" field where you can put a hint as to what the button will do. This acts like a roll over. There is also a "Status Bar Text" field where you can put a longer message that appears in the bottom...

For clarity, edit the primary key field names. The ID in Answers would work better if you called it AnswersID; same with questions and category. The quick answer to your problem is that you need to change the Answers and Category text boxes on the form to combo boxes. The row source for the...

Assuming you have the chart on a form, you should make some room on the form for an option group box where you can click on one, two, three or all four data types. Put a go button next to the options that would delete all records from the temporary table supplying the chart, and re-run the query...

This appears to be your first post, and you have not given enough information to get a good answer. Is your front end an Access form or a web page? If it's an Access form, you should know there are modules behind each form where you can write code. And each box on the form has events associated...

What you want in the second form is called a foreign key. The two forms should look like this, PersonID, FirstName, LastName, EmployerID. The person id is the primary key and set as autonumber, the EmployerID is a foreign key and set as Long Integer. Now the other table, EmployerID, FullName...

As I read this I am wondering what type of data would justify this request? What are you trying to do? You are kind of describing cascading combo boxes, which implies the three fields are primary keys in their own tables but you have them all in the same table. If you want an answer, you won't...

Glad you found a solution, which is what I would have suggested, does not equal the current record. However, I wanted to chime in with another thought. You should be working off of two tables, or three total. The table with the person's information, which has their primary key PersonID...

You need an unmatched query, or in your case, all the medals from the medals table that don't match the ones already in the person's table. If you go to Create in the menu and select Query Wizard, then select the "Find Unmatched ..." and step through it you will get the query for the subform. It...

SpikeyA, I don't want to sound like a jerk, but data is not usually stored that way. You are building a table in a database the way you would build a spreadsheet, horizontally, rather than vertically. Your table, dbo.KPIREPORT should look like this: [Stock No], [Sales], [SoldOn], the last one...

In the interest of spreading the knowledge, I wanted to post the workaround to my own problem, especially since I did not really solve the posted issue. After speaking with a colleague at work, he gave me some possible options and views sounded like the best one. On the first database DB1, I...

I need Access to link to tables in two different databases that are located on the same server. When the FE is opened, the connection to the first database works, all twelve tables connect. The problem is with the connection to the second database. This connection kind of works, the two tables...

Looking at your string, I would also add: try not to have spaces in the table names nor the field names. Try tblPrePackType for the table and PrePackName for the field before key SQL words, like from and where, you need a space in "WHERE ((([PP Type TBL].[Prepack Type])=[Forms]![Prepack Edit 2...

Yeah, that worked. Thanks JHB. I changed the option to "don't move" so the cursor stays in that box rather that doing a tab. It makes sense now, these forms displayed only one record, so "move to next record" had no where to go.

In Access 2010 I am entering a number in a text box on a bound form, hitting enter and the After Update event does not fire. When I move off the text box, the event fires. This is particularly annoying when a person is typing in their password, hitting enter and nothing happens. It also fails on...

I kind of solved the issue by using Right(TBN, Len(TBN) - 4), but I really like mid So typing mid( give me no hints about what to type next, like string, start, stop etc. But it is a good thought so I did a search throughout the entire project for "mid(" and "mid" and I found the problem. I...

Windows 7, Office 2010 VBA 7.0, Access left and right functions work fine. I enter a mid(TBN,4,99) where TBN is a string variable, in this case, the table name. I want to get rid of the "dbo_" that precedes linked tables for a project. When I compile it, I get an error that VBA "expected array"...