Search results

OK, sorry I thought the "Then" went on the next line. So moving forward I have the attached dilemma. Also, pr2, I don't understand your "inside a Method" comment. Thanks again.

See attached.

Well I'm not starting off too well. The employee names are in the format: Last Name, First Name, Middle Initial-Employee ID I keep getting an error for the statement: If Me.Employee_Name = Doe, John J-12345 Tried enlosing the name in quotes, etc. No luck.

If I use Select Case, don't I have to list every value (i.e. - every employee name)? The list could be 50+ names long. Which is why I thought of using if/then/else.

Seems I would need something like an If/Else statement? If Me.ControlName = (the employees who need a different text color) ControlName.TextColor = NumericalValueOrConstant Else ControlName.TextColor = default (Black) ?

I have a report with a list of employee names (and other information). A handful of them need to be a different color (other than default). There will always be more than 3, so I can't use the conditional formatting tool. I've seen elsewhere on this forum where someone developed a subform but...

Hello all. I need to design an unmatched query on 2 tables to identify employees names that exist in 1 table but not the other (or names are misspelled, etc.). The tables exist in on a server and I do not have the ability to change either. Table 1 has the following structure: EMPLOYEE NAME...

Having solved that as per above, I now need to find the employees that exist in Table 1 but not in Table 2 (or vice versa). So using my expression: WHERE ((([Table 1].[EMPLOYEE NAME]) Like ([Table 2].[LAST NAME] & ", " & [Table 2].[FIRST NAME] & "*"))); And changing the "Like" statement to "Not...

I didn't get a Wizard after I selected Go Advanced, but hopefully I did it right. As you can see I have a table and a form. On the form I have a combobox with field list as it's Row Source Type. So for example if I select "Cats" in the combo box, I would like to be able to get a report filtered...

Thanks. I've been playing around with that for a week, but don't seem to be able to get it. Here's where I'm at. On my form, I have a combobox with the Row Source Type set to Field List. In my simplified example, I can then select either "Cats" or "Dogs" from the dropdown field list in the...

What I'm trying to do is to be able to select the field (not the record) on a form. (i.e. I need a combobox that lists the fields in the table (and not records for a given field)). So then I can select the field(s) I want in my report ("Cats" in my example) and then run a report for "Cats" with...

OK, I'm designing a form that will allow me to select one or more fields from a table, and then print a report depending on the value of the selected field(s) sorted by date. For example, say I have a table with the fields: Name | Cat | Dog | Age Cat and Dog are yes/no fields. So on my form...

OK, that seems to work fine. Thanks.

Hello. I am developing a Make Table Query from 2 tables, one of which has an "Employee Name" field (lastname,firstname) and the other table has separate fields for LastName and FirstName. I've been able to accomplish almost what I need by: WHERE ((([Table 1].[EMPLOYEE NAME]) Like [Table...

Is there a way to do this across the whole table or does it have to be done one field at a time? In other words: UPDATE [Table 1] SET [Table 1].[1st Field] = 0 WHERE ((([Table 1].[1st Field]) Is Null)); This table has dozens of fields. Thanks.

OK, I have a rather large excel spreadsheet that I need to import into Access (2007). The spreadsheet has numerous “Yes/No” fields (users enter a “1” for Yes, and leave it blank for No). The majority of the fields (several hundred) are left blank (indicating No). The Yes/No fields will appear as...

Thanks for the reply, but quite frankly it has been so long since I was working on this project (and I've done so many others since then) that I don't remember the specific issue. I assume that I must've gotten it to work the way I wanted.

I have a report that will contain roughly 30 SubReports. Each SubReport is made up of a piechart and a text control. I need to keep these together in each SubReport so I have placed each SubReport in a separate section (Header or Footer) using Sorting and Grouping. However there appears to be a...

Still makes me wonder why one form acts this way and another (very similar) one in the same db works fine. One of the wonders of Access I guess.

I found a work around (thanks to missingling for pointing me in this direction) by placing a "dummy" control at the top of the main form and giving it a tab stop of "0". This forces it to be visible when the form is opened and the tabs then display below. Not ideal but it works, at least until...