Search results

allan, you need a bit of VBA to sort this out, using the Split function. These threads should get you started: http://www.utteraccess.com/forums/showflat.php?Cat=&Board=84&Number=1105240 http://www.utteraccess.com/forums/showflat.php?Cat=&Board=82&Number=1091393 RV

I guess you basically only would like to insert new addresses. Create a temp table in Access. Import your Excel data into this table. Next, run a query that imports all rows into your source table in Access. Add conditions to your query so that: - addresses already in your source table will not...

What Pat likely means is to use the query she suggests as the source of your form. RV

So apparently not related to Access. You better do some googling on 3026 - Not enough space This will throw up quite a couple of hits. You'll have to have a look yourself at the links as there can be zillions of reasons why this issue occurs. RV

What you need is a query. Include all tables and required columns in your table. In your query, join all tables as per the relationships you defined on your tables. Export the query to a txt or csv file. RV

Is your combo box set up as a bound control? Bound as in bound to the underlying record source of your form? RV

You don't store calculated values in tables. Use a query. RV

Definitely not a good plan. Beeter to provide users with the ability to generate their own queries. Although I wouldn't advise using Access ;) If you persist, have a look at the Table Defs collection. Also you'll need in depth knowledge of VBA. And you'll need to find ways to ensure...

Add a condition on the query field you're comparing against the value of your combo box. Would be something like tablename.columnname = Forms!formname!comboname OR Forms!formname!comboname Is Null RV

Have a look at this thread http://www.access-programmers.co.uk/forums/showthread.php?t=106711 RV

Not sure but try this. Import your file using the import wizard. Click on Advanced. Set the parameter "Code Page" to Unicode. Save your import specification. Make a note of the name you give to your spcification. See if this solves your problem. If so, you can build an import mechanism using...

You need to use a GROUP BY whenever you're using aggregate functions, such as SUM, MIN, MAX. GROUP BY groups your calculations. So, as per Matt's solution, you'll end up having exactly what you need. Read up a bit in Access Help on GROUP BY and aggregate functions. RV

How 'bout this condition s.lname <> Left([a.name],InStr([a.name],",")-1) RV

Put this in the On NO Data event of the report: MsgBox "No data found" Cancel = True RV

Not sure what's you after. Normally, you would raise Orders coming with Order Lines. Your Invoices would be based on Orders that have been shipped. Hence your Invoice Number would be issued when your Invoice is generated. You' d use some VBA to automatically generate a new sequential Invoice...

Do you store each and every single task in a single column in yout table? I'm asking because if you would create one row per task, you should be able to use one and only one button. Otherwise, post your database so we can a quick look. RV

If you want to use events for validation purposes, it's the Before Update event you should be using. After Update runs, well, after your date has been updated. Hence you too late ;) RV

OK, use Keith's suggestion then. Put the code in the ON Click event of each and every button. RV

Yes. Add a column to your query and totlaize your 5 columns. Do not store calculated values in table. So remove your Total Estimates column from your table. RV

Base your report on a query instead. RV