Search results

Thanks wazz; this works great, except I am hoping to be able to accommodate both hyphenated and non-hyphenated names (i.e. John Boxer-Smith and Jane Jameson to yield "JBS" and "JJ" respectively). Would it help to run the expression on the First and Last Name fields separately and then...

I am using the following expression to give me the first initial of the first and last names (concatenated into the "Name" field): Initials: Left([Name],1)+Mid([Name],InStr([Name],""),2) Does anyone have any ideas on how I might be able to accommodate for hyphenated surnames (such as: John...

I realized after looking at Bob's solution that I had inadvertently fixed the problem myself. Somehow the code wasn't working (either Bob's or my original) because of the underlying recordsource. The RS for the form had been based on a nested query unnecessarily. When I adjusted it to...

Thank you!!!

Here is the db

In the OnCurrent event of the form that holds both controls.

This doesn't seem to work either; I did double-check the field and all of the "blank" fields are in fact Null and not zero-length strings.

I have a command button on a form that I only want to enable when the value of one of the text fields is not null (has data) and want the button to be disabled when the text field has no data. For some reason, the code does not seem to be working; any suggestions? If IsNull(Me!ApplID) Then...

Yes, the recordset is updateable in the query and also when I open the subform on it's own. Allow additions is set to yes, and YES, the main form is also updateable. Originally the RS was simply the table on the many side of the relationship, but I changed it to a query with both the parent...

I know this should be a simple "duh" solution, but some of my Access skills are getting rusty, and after an hour of searching various terms, still haven't come up with an answer. I added a subform to a main form with the correct parent-child linkage setup. Mainform Parent field is PK, subform...

jardiamj - Thanks, this works perfectly! It is run via a form as part of an append query and does exactly what I want it to. Thanks again!

I was hoping to be able to achieve this at least somewhat automatically; so that the db users won't have to be trying to figure out which records to append and not to append on the fly...

I have an unmatched query that I want to use to find all the records that don't match (obviously) the ID fields, but I also want to set additional criteria on the ID field so that it doesn't pull archived data out of the first table. So basically, T1 has the full set of data, old and new. T2...

Thanks for the explanation! That explains why, when I try to use a parameter prompt in the query design pane, it doesn't return the null value records, too, I guess. Again, thanks for your help on this--much appreciated!

AWESOME! Works perfectly on all the queries. I wish I knew what the difference was between what I had set up and what you set up, but I'm just glad it's working now! Thanks so much!!!!

I have a bunch of queries set up with outer joins so that they should return all records from one table and only matching records from another table. The problem is, they aren't all working as they are supposed to be (and oddly, some of them are). Here is the SQL statement I'm using and the...

I'm reworking a database that someone else designed in which they used the following code to pass values selected from a combo box into a memo field with comma separators. I would like to accomplish the same thing using a multi-select list box but I'm not having much luck. I admit, my coding...

I have a report that displays recipe cards; ingredients list is generated with a subreport. The basic setup works fine, but I want to use a form to filter all recipes that contain certain ingredients. When I enter an ingredient parameter into the query that drives the main report, I get the...

I thought I had this figured out, but for some reason it's still not displaying correctly. I need to display text values as the x-axis (poor, fair, good, excellent) in that order. The values are linked to a numeric "scale" so that Poor = 1 (in separate fields but the same table); both fields...

I have been experiencing several issues related to Compact and Repair on my database. The original file is 125MB and I deleted some obsolete records (not many though) and several unused tables, forms, and reports trying to get the db back down to a more manageable size for off-site users...