Search results

That's brilliantly easy. Thanks!

I know for sure that any text following the uppercase will always be lowercase, so I don't have to worry about extraneous capital letters. I obtained this table from an official source, and I would like to use it in my database, however only the capitalized words are relevant for what I need...

Hi, I've got a report that shows the same piece of data in numerous places throughout the report. These are all text boxes with the same record source. However, in one of the text boxes, I would like to display the data entirely in capital letters. How do I set the formatting for this...

I've been stumped on this and could use some help... Fields in my table contains some words that are in uppercase and some in lowercase. I would like to delete all the lowercase letters and keep only the uppercase ones. For example, if a field contains the following text: CHLOROSULFONIC...

Yes, that worked great! It really speeds things up too. Thanks!

Hi, On a report I have a date field, which I have formatted as yyyy mmmm dd. This comes up as, for example, 2006 February 28. I'd also like to have it in this format on another report, however with the month written in French. Is there any way I can do this?

Hi, Thanks for your reply. I'm using each subform for basically focusing in on specific data in from a single table. The table I'm looking at has the following fields: ProdID# (primary key) Heading Code Each subform is a datasheet view to enter records of Code for a unique ProdID# and...

Can anyone provide assistance with the above error? It comes up when I try to open a report from my form. The form has 15 tabs and approximately 5 subforms on each tab, which I suspect is causing the problem. I have found some help on the web, but I am not sure how to use it...

Hi, This should be an easy one...I would like to save a record part-way while filling out a form. I know this can be accomplished by pressing Shift+Enter, but does anyone know the vb code for saving a record while working on a form? Thanks.

Thanks! That vbCrLf worked very well.

Hi, I have a report which concatenates several items together in a text box. To do the concatenation, I have followed the instructions as described here. What I would like to do now is be able to introduce a new line in the middle of the concatenated items. I have tried creating an item...

That's exactly what I have...a flat table. I do realize this is a poor design, but is there a way I can do what I had originally thought to do (ie, writing a custom function to do the search)? If I were to re-do the structure of this, can anyone suggest how I should lay out my tables...

Yes, they are indeed table column names. As are 1ING, 2ING, 3ING, etc...

Can anyone provide me some tips as to how to pass a record to VB in order to analyse it? What I'm trying to do is show a specific field from a record, based on a user's input. I have successfully used the Expression Builder with 14 nested iif statements. When I try to add a 15th iif statement...

Hi, I was wondering if anyone knows a way in which to display a parameter on a report's header, when the report contains no data (that is, when the query on which the report is based on, does not find any records with the manually entered parameter). I've added a text box with its control...