Group, I am trying to have access add a hard return after the short_desc data so that resolution_resp starts about two lines below the short_desc field. I am...
Try: "Short description of issue: " & [short_desc] & vbCrLf & "Resolution Response: " & [resolution_resp] "Good people do not need laws to tell them to act...
You could also use vbNewLine which is more intuitive and easy to remember. ="Short description of issue: " & [short_desc] & vbNewLine & "Resolution Response:...
Is there a way to record on a report the last date actually entered in a field? Here is what I'm trying to achieve: If the manager runs a report from 01/01/04...
=Max(MyDate) Tom Hamilton
Department of Human Assistance
Sacramento County (916) 875-2758 Office
(916) 601-6174 Mobile ... Is there a way to record on a report...
Dave- Try adding a text box with this in the Control Source: =Max([MyDateField]) .. where MyDateField is the name of the date field in your Record Source. John...
I have a form that reads a query that joins two tables. It displays two description text fields when they are different: Select...where key1 = key2 and...
Thank you all that responded! It works like a charm! Thanks, Isaiah Vi IT Analyst County of San Mateo Human Services Agency Business Systems Group 400 Harbor...
Steve- It's not the form, it's your query. Please post the SQL from the query and a brief description of the tables involved (including Primary Keys). John...
I created a form from a table using the form wizard and all was well until I decided to add another field to the table. It is a lookup field, [MemberType],...
Mark- Did you click the Combo Box control in the Toolbox and drag and drop the MemberType field from the field list, or did you just add the combo box and set...
Hi Group, Has anyone found a "workaround" for this known bug in Access2K where the SendObject function silently fails due to too many characters in the email...
I have some data that I would like to merge or combine together, so I am asking for some help. The data would be similar as follows: 1st Initial name 1st...
John, My Toolbox doesn't have a field list from which to choose the desired field. It just has icons for all the Access controls which I can drag and drop to...
Mark- Choose Field List from the View menu or click the Field List button on the toolbar when you have the form in Design view. Click the Combo Box in the ...
John, THANKS! Worked like a charm. Mark Espinosa Newbie ... http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/q7folB/TM ... __________________________________ Do...
Works beautifully on a month to month basis...can't seem to get it to work on the year end totals. It grabs Jan 1 and 31 and then stops for the year end. Your...
Dave- I would have to know more about the structure of your report and how you're grouping it. Max([MyDateField]) should work both for group footers (for the ...
I have a user that when entering data will often recieve an error stating her data may not be saved; sometimes it is saved and other times it is not. This...
... It is possible that you have record locking enabled in the properties of your database. What Access does with Lock Record is that it really locks a whole...
If you have both users sharing the same database with all the tables, queries, forms, reports, and modules -- that is a bad idea. You should split the...
Steve- For a multi-table query to be updatable, the join must be defined from the Primary (or unique) Key in one table to a foreign key in the other table. You...
hi, i am trying to figure out how to achive the following... i have two fields in the same table, end_date and status. what i want to do is, if current date >...
Well you learn something new every day. I wondered how Access used keys, when you don't have to define them. But now I know. I made one the PK, and I guess...
How does Access (any version) handle those occasional "collisions"? Error message...crash the dbase, or just unable to update the record at this time, sort...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
