Search results

Hi, I've got a form that sits on the top of a table (company_table). Will (eventually) allow the user to add a new company to the table by entering a text name in the control Company_Name. I'm to put a bit of logic together that will stop duplicate records being created. I thought i would...

Hi, First of all, thanks to everyone who has helped me so far on this little project i've embarked on as my first ever database. I would not have got as far as i have without the time & knowledge that people have kindly shared with me on this forum :) So. My database allows you to log issues...

Hi, I've set up a simple query that returns 6 columns of data. This query then shows on a sub-form elsewhere in my DB. The problem is that the query always appears with a horizontal slider. Allowing the user to scroll across to see the other columns in the query... The problem here is...

Hi guys & gals, This is yet another stop on my Access Education (i'm building my first database) and i was wondering what people's thoughts are! I have a table, which when i first set it up i decided that a couple of the fields had to be mandatory. So, i set the "Required" property of the...

Hi, I'm new to Access and attempting to build a database to improve my skills. I'm a BA so i'm converting my excel issues list into a database with a front end where i can create new issue records this uses a form that sits on top of the issues_table. Howver, i have created a table called...

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...

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...

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...