Search results

Thanks for the replies all. Plog, Your assumption on the result I want is correct, apologies for not posting that initially. I modified your queries to show actual table and field names but it's not getting rid of duplicates. When I checked the query results against the main data table...

Can anyone else help?? Thanks

I can't post the exact data, due to the nature of the business, however I can post an example of what I'm trying to get. How our system works is that we may have 3 (or more) deliveries of a product to make. Now, to make these 3 deliveries we don't make the product in 3 different batches, we...

Hi guys & girls, I'm having a little difficulty finding an answer to this one - I assume it's a query of some kind that I need, but I'm no expert on them. Here's the scenario: I import a big Excel file into a new table, it has no duplicate rows, but it does have duplicate values in column...

Thanks guys! I had to enable "Microsoft Office Objects 12.0" in references, I assume because it's a slightly older version. Seems to work perfectly, thanks again to you both.

Thanks Trevor, I'm getting an error though: "Method 'FileDialog' of object '_Application' failed" Should I have enabled a reference or something to allow this to work? Thanks for your time!

Hi all, I've figured out how to append data using VBA, it's this simple bit of code: DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "NewMasterData", "Shortage List.xlsx", True However, I want to do two things: 1) Prompt the user to select which file to import. 2) Not...

Sorry, yes, "average duration" is what I was getting at.

Good afternoon (Or morning, if you're in the US!), This seems like a simple request, however my brain and Google aren't helping me. I have a table, which contains amongst other things, a raised date and a completed date. What I'm trying to achieve is an average date to complete, so we can...

sxschech: Thanks for that, I never thought to bracket them both, I'll use that in future! Pat: Thanks for the detailed response, I wasn't sure how it would behave if the field was null. So far I haven't had any null fields so it wasn't an issue, but once this is up and running I would...

Hello all, I'm pretty new to the world of SQL queries, I've always stuck to VB and Excel in the past... As a result, I'm struggling on things that I'm sure most would find easy. I've Google'd this to no avail, so now it's time to cry for help! I have added two new fields to an SQL query, as...

Thanks Plog, that should do the trick!

Hi guys & girls, I'm building a query, that looks in a couple of Combo Boxes and a couple of Text Boxes for data, then displays info based on what it finds. Mostly the query just looks for things like "mduffield" (ie, the username) and it works just fine. However, I'm trying to make a...

Ah brilliant, I hadn't thought about checking the file status before loading it - great idea! Thanks for your help!

Hello all, I have a quick question which I'm sure a lot of you will know the answer to straight away... A database I am developing displays PDF files in a web browser that is on a form. If the PDF file exists, all well and good - users can print, email it etc. If the PDF file doesn't exist...

Ah that's great - DoEvents did exactly what was needed. Thanks for your help! Mike

Hi guys & girls, I "borrowed" some file copying code from the web and modified it to suit my needs. It works just fine, but isn't very user friendly. The goal is to have a form load, 4 labels which are black text that individually change to green text as each file is copied. The code I...

Morning all, Currently using this code: Dim strExcelFile As String Dim strWorksheet As String Dim strDB As String Dim strTable As String Dim objDB As Database On Error GoTo ErrMan strExcelFile = "G:\whatever\whatever.xls" strWorksheet = "WorkSheet1" strDB = "\\whatever\whatever.accdb"...

Thanks for your quick response, it worked wonders :) Mike.

Good afternoon all, Having built a fairly complex database, I'm ashamed to say I've stumbled on something that's probably very easy to solve. OK, I have a table full of data. On my form I select a date from a combo box which then generates a report that contains a chart, showing information...