Search results

Hi, I have a simple report, laid out in 4 columns. One of the columns is an ingredient concentration. The concentration can be a single value or a range, for example 1-5. When I have the report open and click the 'Analyze with Excel' button, the report opens up in Excel, and everything comes...

Hi, Here's (probably) an easy one. Anyone know what the VBA code would be that's the equivalent to pressing F9 to refresh? This is in Access 2003. The Microsoft Access help describes F9 as "To refresh the contents of a Lookup field list box or combo box". Thanks!

Hi, I'm wondering if anyone can give me some advice on how to do the following: I have a form with a subform. The subform displays a list of ingredients for the item shown in the main form. Each record in the subform (ie, each ingredient) has 3 Yes/No values associated with it. The item on...

Hi, I'm doing some string contcatenation in my VB code for a report. I've used vbCrLf when I need a new line, and I'm wondering if there is a similar function that will do a backspace, ie remove the last character from the string? My code would then look something like this...

Hi, Can someone help me with this... I've got a main form with 6 subforms. The main form is associated with the "one-side" table. Each subform is associated with its own "many-side" table. What I would like to do is be able to click a button on the main form to make a copy of the record and...

Hi, I've been given a table that was created in Word, and I need to import this into Access. The contents of some of the cells in the Word table are multiple paragraphs that I will be importing into memo fields in Access. The problem I'm having is that when I tried copying and pasting the...

I'm trying to figure out the proper syntax on how to use an OR statement in the evaluation of an IF statement. For example, I'd like to do something like this: IF Me![Type] = 1 OR IF Me![Type] = 2 Then .... Else ..... End IF Can someone please show me the proper way of writing out...

A quick question... is it possible to sort a table by a memo field? I have a table and am able to sort by other, non-memo fields, however when I place my cursor in the memo fielld I would like to sort, the sorting option becomes 'greyed-out'. Is there a way around this?

This sounds like something that should be easy, but I just can't seem to get it working... I have a form with a datasheet subform. I would like to have an unbound text box on the main form automatically display a certain value based on values entered in the subform. For example, I am only...

Not sure if this is possible, but can a lookup field on a form also be also used to store free text? I have a table where some phrases are stored, and its three columns are named as such: Code EnglishPhrase FrenchPhrase I use these phrases on a report, based on a Code I assign to a certain...

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...

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?

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.

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...

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...