Search results

thankyou spikepl! The Excel cells without text data were formatted as Number. Formatting them as General has worked :) Now to get the originator to fix their spreadsheet! Cheers, HG

Hi, I'm having issues with a paste append I'm trying to perform from Excel 2007 to Access 2013. I have various columns of data, a mixture of text and numbers, which all have data in them, and a few columns that have numbers or text. When I copy'n'paste-append into the Access table, the text...

and 1min later I find a work-around... :) it was copy SQL into editor, do replace "SumOf" with nothing.. copy back done! yippeee

Re: My dear Pernickety Pete, I know this is an old discussion but since this thread popped up 1st in google when I was trying to find if there's a way around this "SumOf" nonsense. I agree with the OP, I don't need to know it's a sum, that's what I specified in the query. And, if I only had...

back again... got it working. Not very elegant but at this point in time... I don't care! :)

interesting concept. I would need to process the table but that's possible. thanks for the suggestion.

Hi, Searched and search but can't find anything like this. I have a report where I number pages based on the Store (muliple stores in report but page numbering resets when Store changes) I do this by manipulating the page number field on the report by code in the report sections to reset it...

thanks for the quick reply! It sorta works... works on the 1st occurance but opens the secondary spreadsheet in read mode. On the second occurance (by selecting a different option in a combo box) it waits to get read/write access (pops up a dialog to say Read/write access is now available)...

Long shot... but is there a way to have a file reference without full path reference in a query? Senario... I have a spreadsheet with several queries to another spreadsheet (hope to change this to an Access DB at some stage since that's where the data comes from) that hold valid values for...

ok, seem to have sussed it out... It doesn't remember field properties (well the format ones at least since that's all I have been playing with) when you give a field a specific name (eg. want the system derived name of AvgofVal1 to be Val1). You seem to need to add your names, save the...

not sure about drag'n'dropping to rearrange, never seen or tried that but you could add them to another listbox then process that as a list (probably easier than numbering items as you'd then have to check for duplicates, etc)

Hi Bob. At home now so tried it on Access 2002 and behaves somewhat similar (although not identical). I created a simple DB to test. Table called Data with 3 fields, Classification (Text), Value1 (Double), Value2(Double) Data in table was: Classification Value1 Value2 A 4.23...

your VBA code needs to be able to decipher the order of importance of what's supplied or selected, and that means you need to be able to have a rules (algorithm) that covers all possible scenarios. If you're manually deciding what to run, then assigning numbers to each option then sorting that...

You could have a extra field in your table that you assign DATE() (using a query). A calculated field working of 2 dates in the table works. Tried it, worked ok but not sure if that's usable in your circumstances or a simple update query is more applicable.

Just to add to my frustration, managed to get another one to work, but not the actual name I want! Also, using '1' for the name seems to work ok, but not '2'

Is this normal behaviour? (I'm using Access 2010) Basic aggregate (summary) query calculating the average of several fields. I set the display format (eg. fixed with 2 decimals) in the properties of a field (type is Double) and it displays correctly (ie. 2 decimal places displayed). If I add...

I have an application that does something similar. It has a ComboBox that displays valid suppliers (your phone numbers) powered by a select query on a Suppliers table. Once you select the supplier you want, a listbox is populated with the available materials (your Names). The listbox is...

Yep, your problem is the query won't match the nulls even if you've got a row in your lookup table with a null priority. I don't know of a way to force that to occur so I would run an Update query before your 'order' query to replace the nulls with something else (eg. "Other") that you can add...

if this is a once off... I'd edit the text file :) otherwise (without knowing if there's a fancy way of doing this) I would - import using the comma to split the number into two fields (eg Whole/Decimal) - Use a query to multiple the Whole field by 1000 and add the Decimal (divided by 100)...

I'm guessing you need to link ("cell link" field in format control) your combobox to a cell in sheet1. If you have one of these per row then cell validation using a list (named range on sheet 2) might work better (I tried this and it imports fine)