Search results for query: *

Hi, any help gratefully received: I am working in imperial (Miles/Yards) and have found that it is not possible create a custom number format that will deal with imperial linear distances: yards and miles. Put simply, I need to determine the difference in Miles and Yards between e.g. Mileage...

Hi I have 2 tables with similar data TBL1 ROW | CO1 | CO2 | START MILEAGE 1 | ABC | 200 | 123.456 2 | ABC | 200 | 200.005 TBL2 ROW | CO1 | CO2 | START MILEAGE 1 | ABC | 200 | 400.00 2 | ABC | 200 | 125.00 I would be very pleased to know if there is some SQL out there that...

Hi, I have an Access SQL query to convert String to Numeric, however it is returning whole integers only - not returning numbers after decimal points. The table concerned has mileages in 000.0000 format as string, (it's data extracted from a very old database) however the SQL below is returning...

I have a very large table that has five rows per Identifier (five rows represents five days' activity). There are many identifiers in the identifier column. Next to the identifier column is a "status" column. The (vast) majority of the time the status remains the same against each identifier...

I have a very large table that has five rows per Identifier (five rows represents five days' activity). There are many identifiers in the identifier column. Next to the identifier column is a "status" column. The (vast) majority of the time the status remains the same against each identifier...

Hi, an open question regarding functionality of BO. My (large) organisation is finally upgrading from Windows 2003 to 2010. However, although we have had no clear communication on this, it is widely expected that MS Access will not be part of the Windows suite (due to cost / maintenance.) I...

Hi all I have had this handy bit of code kicking around for ages that simply selects email addresses from all emails in a folder (inbox) and dumps them in an excel file. The only problem is since I moved companies (using an older version of MS Office) the addresses appear as a form of code that...

Hi - any help gratefully received ! Am brand new to an team where a colleague has asked me to help her out and find a solution to enforce 4 decimal places in a table that is being updated using a query. The SQL in the query fails to enforce this in the table (SQL below), so I was wondering if...

Hi, sorry this should be quite straightforward but I cannot crack it - any help gratefully received ! When running the code below in a workbook, I am getting the error "runtime error '9': Subscript out of range" At the point indicated [highlight #FCE94F]below[/highlight] [highlight...

Hi - re-posting from MS Office forum any help gratefully received ! I have a very straightforward ms excel formatting macro which for reasons beyond my simple mind gets a Compile Error "Expected Function or variable". I have run similar macro without a hitch for a long time, and may just be...

Hi - any help gratefully received ! I have a very straightforward ms excel formatting macro which for reasons beyond my simple mind gets a Compile Error "Expected Function or variable". I have run similar macro without a hitch for a long time. Have just 2 days ago upgraded to 2010. (The...

Hi, I have searched for solutions to the following problem; but maybe haven't phrased my searches properly - any help very gratefully received ! Put simply, I want users to be able to enter some pre-determined data on an Issue Log, and then populate the rest themselves The key data sits in a...

Hi all, any help very gratefully received ! I have a database in which I have included Allen Browne's code for an Audit Log http://allenbrowne.com/AppAudit.html However, i am getting Runtime error '3131': Syntax error in FROM Clause at db.Execute sSQL in the following section of...

Hi This is an almost identical request to this 2007 thread, which unfortunately doesn't have enough detail in the responses for me. http://www.tek-tips.com/viewthread.cfm?qid=1422496 I need to write a macro that copies information from a number of spreadsheets in one folder and appends the...

This is probably childs play - I have a query that searches names from three different name fields in table InformationContact ______________ SELECT * FROM InformationContact WHERE [Enter Contact Name]=[Contact Name #1] Or [Enter Contact Name]=[Contact Name #2] Or [Enter Contact Name]=[Contact...

I need to query two tables to establish differences in stored data and updated data received from customers, which I have done succesfully using join properties within a query; I then output the result to a report (xls) For reasons of volume, what would be really useful is to get some code that...

I need to query two tables to establish differences in stored data and updated data received from customers, which I have done succesfully using join properties within a query; I then output the result to a report (xls) For reasons of volume, what would be really useful is to get some code that...

Hi I've been asked by my manager as a one-off if there's a way of running some VB code in MS Word to get data from forms returned to our team as scanned forms - PDF files. We need to get the actual data into word rather than just the image and unfortunately our organisation may well be against...

Hi, I'm running some jobs from Access in Attachmate, and need a simple VB If ... Then statement to either populate a field or move over it if the field is already populated - what's the easiest syntax to use to determine If the field is already populated ? Many thanks, not a coder, I just use...

Hi, I'm running some jobs from Access in Attachmate, and need a simple VB If ... Then statement to either populate a field or move over it if the field is already populated - what's the easiest syntax to use to determine If the field is already populated ? Many thanks, not a coder, I just use...