Recent content by rafi2

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!

Anyone? I'm really stuck here...help would be great! 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...

Both ways worked...thanks for the help!

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

What would be the actual VB code for "move to the last record"?

Thanks, Neil. My PK is not an autonumber. It would have to be supplied by the user. This would be via an unbound text box on the form. As for the VB code behind this, once I've set up my queries, would I just use a series of DoCmd.OpenQuery "queryName" statements? And one more thing I...

Thanks for the info. In the end, the records will not be exact duplicates. This copying functionality would be useful in instances where the user knows that a record will be mostly the same as an exisiting one, so that they will only need to make a few changes, rather than enter everything from...

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 tried pretty much every other combination but that one. Thanks for the help!

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

I'm storing anything from a single word to multiple paragraphs of text in the memo field. I wasn't looking for anything in particular by the sorting. Just hoping to be able to eyeball the table by scrolling through it to see what kind of data has been entered in there, as in some instances...

Hmm...that's a bit frustrating. Thanks for the quick response!