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!

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!

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

Thank you so much! It worked perfectly. This table had over 6000 records, and this completely saved me from having to manually touch up each one of them.

Thanks, this looks like a good approach. One question, though, how does one run a function on a table? (ie, how do I pass the argument TextIn to the function). I'm a bit new at this, and was initially thinking of using an Update Query to modify the table.

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