Search results

I discovered that habit awhile back. Since someone on this website taught me about normalizing & naming conventions a few databases ago, I change the names of all the controls I reference to txtFieldName to minimize the confusion. I think I missed the "Date" thing here because that particular...

NOW I get: . I get this only if I delete the txtName2 field, or the part in it referencing IMGStatus. If I just delete the LastName part of the text in the control, it looks for that. It doesn't seem to hurt anything if it is there. I can reduce the box almost to nothing, make it invisible &...

Thanks. Taking out the... tblNameList. ...part seemed to do the trick. I was able to compile it after a few more corrections. Now...back to solve the original problem!

Worked great! Thanks! I wish I had tried that before I tried to put a "blank" and "Not Applicable" fields in 2000 fields so that they would show up. I finally posted b/c I was missing 6 records even though I thought I had gotten them all!

By the way, I forgot to mention before that I DID go back & take a few hours to replace all references to "Date" with "DateStart". Thanks for the suggestion.

WOW! That sure sped it WAAAY up! I have not yet made it to the problem above. On the Debug, I got the following message: for this code: Private Sub Form_BeforeUpdate(Cancel As Integer) Me.RecordUpdated = Now() 'tblNameList.txtModifiedBy = Environ("UserName") End Sub Private Sub...

Thanks for your help. I will try these.

I am working with a report based on a query with many interrelated tables. This query pulls data about individuals and their rotations through various departments, their pay status, etc. One of the Report Headers is Departments. In addition to being related to the individual records, the...

I am working with a normalized database that has MANY tables. Most of these consist of lists of options to select from for the primary table. The primary table is linked to the secondary tables (and those to tertiary tables) by Primary Key ID fields, and the other tables contain additional...

Thank you so much everyone! I finally decided on a bit of a combination, since the IMG field has a few diffferent types of data in it, plus conditional formatting for the bold. This works just great! If IMGStatus Like "IMG" Then 'Types IMG names in Name field, only showing exra spaces &...

I have been playing with these If...Then...Else Statements all day for the above question & sort of answered that one, but I am looking for the answer to the Name problem. How can I write a Trim AND/OR If...Then...Else Statement to accommodate any combination of: LastName, Firstname...

Resolved(?) but I am not sure why it did not work the other way This is what I have now... If txtAction Like "Enter New*" Then Me.txtRecAction = Date Me.txtEffectiveDate = PayStatus Me.txtSpecialty = Specialties ElseIf txtAction Like "Terminate - Transfer*" Then Me.txtRecAction...

I have a report that has a series of fields in a row in "detail" that is designed to look like a table or spreadsheet when it is run. Is there a way to set ALL the fields in the row to grow if one does so that all the boxes will be the same height in the completed report?

I am working on a report that displays different things in [txtRecAction] based what is in various fields in the underlying query. I have this so far: If Action Like "Enter New*" Then Me.txtRecAction = Date ElseIf Action Like "Terminate - Transfer*" Then Me.txtRecAction =...

I have been playing with this trick for a slightly different purpose (I will come back to the other as soon as I solve this problem) & have come across an strange phenomenon... Why would [Date] work in Me.txtRecAction = Trim([Date]) But [Date]...and [ActionComment] and [RRBText] do not work...

OK, it displayed the exact same text I had in [txtName]. Thanks...This is a GREAT start, I never would have thought of putting it in an unbound box. I would have spent 2 hours playing around with the "On Open" or "On Load" events on the [txtName field] But my next question is, how do you...

No, I am willing to, but I am relatively new to VBA and VERY clumsy with writing it from scratch.

I have a report field that is currently displaying: =Trim([LastName] & " " & [Suffix] & ", " & [FirstName] & " " & [MiddleName] & ", " & [Degree]) For example Doe Jr., John Ralph, MD or Doe , Jane Ellen, MD I would like it to do a few things more based on those fields & others in the query...

I am working on a database that I would like to use a dialog box to select criteria for a query that a report is based on. The report is data for an annual report...a list of names & other information on residents rotating for the year. Since this is for a University, the year begins on 7/1 of...

Using = Environ("UserName") instead of = CurrentUser worked great! Thanks!