Search results

Drayloc, You have a little design issue first. The company information should be in a company table like this: tblCompany CompanyID, CompanyName, CompanyAddress, etc. On the form you put a combo box with the company table as its source and the combo is bound to the CompanyID When you open this...

I know I could post from work yesterday, but it doesn't work today. Even got personal laptop from car and used guest network, but something is preventing me from posting. If you want, email me at apollo@earthlink.net and I can post reply there. Otherwise, wait a few hours until 7:00 p.m. tonight...

Yeah, sorry, the combos can't have a control source, just clear out the reference to the table in both combos and the text box and lock the text box, you don't want anyone typing stuff in there. In your original scenario you needed to store the combo value in the table, which you do by binding...

Batox: Open the query in design mode and right click on the upper half field where the tables go. Select properties and if in 2007, click on the field again. You want to find the properties option. Once in there, locate column headings and type in whatever you want. Perhaps...

If I read you correctly, your goal is to display three fields of information. So two combo boxes and one text box. Combo1=repname lookup and display, Combo2 = writercode lookup and display and textbox1 to display the agency code. Right?

OK, then you need to change a text box to a combo box and then synchronize the two so they are on the same record. The first text box will be the rep name in the first column (and you can concatenate FN & LN here) , the second box will have the writer code in the first column, then you need to...

RJBailey87, You can do simple math in a query and give the formula an alias "Problem" followed by a colon. Try this: Problem: IIf([tblCompensation].[Compensation]=[tblCompQC].[Compensation],"OK","Error") I tested this on a simple compensation table and changed some values so they would be...

LaRockera02, can't post from work, will reply from home in about nine hours from now, noon on Monday. Hope you get this.

trigirl67, The process is simple, create a new form (or use the existing one) and while in design view, click on the box in the upper left corner with the secondary mouse button and you will get a little menu. Select properties, which is the properties of the form itself. Click on the All tab...

vbaInet, Thanks for setting me straight, I focused on the last few posts and only read the original code, I never saw the four scenarios. Lesson learned. My apologies for barging in, thought the dates were going through as strings rather than dates. Having read them, you could set up four if...

Jibb, Don't think the input mask is the way to go. Using #0, allows numbers less than ten, but it puts a space in there and you want a zero. You are trying to mix a number with text and that only works if the two are in separate fields and you concatenate them afterwards. But there is a way to...

Harrold, You asked, "am i supposed to assign designationDate to each designations" and the answer is yes, you are basically recording a transaction, or promotion, so enter the date it happened. Later, when you need the most recent designation you can sort the query in decending order by date and...

David, Welcome to the database world. As you are finding out, setting up the tables can be the trickest part. You try to have fields that are unique to the subject of the table and relate it to other tables to avoid duplication. And by unique, I mean a one to one relationship. So with people...

Anders, You don't need multiple answer variables and you do need to check the dates before you start anything. Try using the code below, it has worked well for me. dim Answer as byte 'not a string dim Criteria as string dim strMSG as string Dim strSQL as string If isdate(Date1) = false then...

Well, one problem is your fee table is based on a year, and the loan table is based on a month. And you have no dates involved, which may be OK because loans start in any month, so month 1 doesn't mean January. One suggestion would be to change your fee table and include a month number...

I think the easiest way is to have a table with the three fields [WritingCode], [RepName] & [AgencyCode] populated with the appropriate information. The Writer table should look like this: [WriterID] [WritingCode] [RepName] [AgencyCode] Then on your form, rather than a text box, you use a...

The basic premise is wrong. You are using numbers where you need dates. Change the table and add two new fields: ProjectStart and ProjectEnd as dates. If you really need the month number, try TheStart: Format(ProjectStart,"m-yyyy") which will get you 12-2011 as text or StartMonth...

Carl, Using the employee table you pull all the Employee IDs in column0, the name in column1 and the DepartmentID in column2 as the row source for the Breachercombo box. When you select Carl Law, you get both IDs and you use them as criteria for two list boxes. If you want one list box, the...

trigirl67, When you use one combo, you move to that record. When you use two combos to whittle down the selections, you are filtering/fishing for the right record. If this is the case, let me suggest that you use two forms. One is a continuous form that will display just enough info for someone...

George82, For this to work you need to organize your data into two tables. The color table will have "ColorID as an autonumber field, "ColorCode" as text because of the leading zeros, and "Color" which has the names. Something like this. ColorID ColorCode Color 1 0025...