Search results

Thanks, i see what we are doing here - filtering out anything that isn't coded as "4" then simply counting up what is left. So i've understood that concept, What if i wanted to add a layer of complexity - like have two columns of "Count" values. One counts whether the activity is 3 or 4, the...

Thanks everyone for your quick replies! Wasn't expecting that, am going to investigate these options and get back! Thanks again,

SOLVED : Hi, i'm learning Access and am trying to learn the SQL language for queries. I'm ok building relatively simple queries but am now trying to take the next step by summarizing data with functions. So i am building Queries using the SQL View. I have a table where our Users log various...

Thanks! It must be like watching bambi learn to walk..... Noted. Will do!

Got it. No need to rename it again, just do workbooks.open filename Cheers Thanks for the help

EDIT: Filename is returning the path to my file when i hover over it, its SQLFile that is not working. I think therefore my method for trying to open Filename is wrong...

Hi, thanks but i still get an error? The error says that the variable is not set. Is the function not setting Filename as the selected file?

OK, so i did what you said and created a function for the user to select a file to open However, this has set me back as originally what i wanted was to define a filename as a variable so i didn't have to hardcode it. So, the function now defines the filename - how do i reference "Filename"...

Thanks! Will have a crack at that and report back. Ta

SOLVED How to Make an If Statement go to a line of code Hi, i am getting quite a way into my module now! So first of all, thank you to everyone on here and over the rest of the internet for your help. I am trying to write an if statement that allows the user to go back and select a file again...

That was quite a complicated load of code, most of it was a bit beyond me. So what i ended up with was:

Cheers, will do that in future!

Thanks guys - you were both right. I was massively over complicating things! Got the update sorted now so thank you both

SOLVED Invite User to Select File to Import Hi all, I've got a line of code that opens an excel file to import it into an access table: DoCmd.TransferSpreadsheet acImport, , "tbl_temp_sql_data", _ "C:\Users\7092\Documents\Master\Current Work\DB Folders\sqlexec.xls", False As you can...

Hi, got told off by a mod for a deleting a thread that had a reply. I don't think my account can PM so just apologising and explaining here. I found the answer elsewhere and couldnt find an option to mark the thread as "Solved" so i deleted it before somebody wasted their time thinking about...

Hi, I'm trying to use the transferspreadsheet command but keeping getting an expression error. Can someone check my syntax and see where it is going wrong? DoCmd.TransferSpreadsheet(acImport,,"tbl_temp_sql_data","C:\Users\7092\Documents\Master\Current Work\DB Folders\sqlexec.xls",TRUE,,)...

SOLVED Importing an Excel file as a table n VBA Hi, I'm a VBA novice and am really struggling with this.... :banghead: Anyway. This is what i am trying to achieve. I've managed the first three steps in Excel, but have just found out Access has no macro recorder so i'm now completely...

Hi, I am very new to VBA and am trying to achieve the following: Starting in Access: Open up a new book in Excel Prompts the user to browse for a .txt file on their system File is opened in Excel Sort the data to columns (based on various parameters) export the data back into an Access...