access

Hello, I have a .csv with more than 255 columns (395 exactly), I only need 3 columns but I cannot manipulate the source file manually, that is, I cannot divide it in two. The columns are: 131, 208 and 282 I have tried to do it by wizard but Access won't let me do it because it has more than...

Dear Friends, I am now so close to finish my Access database (2016) which include both Front end and back end. This will be used by around 200 users. I have 13 table and 13 forms. Current size of the access is 30 MB. I think it will be 1 GB after a year. So I have a plan to use SQL Server as...

Hello I've finally figured out how to a formula in Excel to give me SumIFS of all the data I need. Now however I need to convert this to Access if that is possible. Danish Excel formula for SumIf: =(SUM.HVISER(B:B;A:A;">="&A2;A:A;"<"&A2+1/24))/15 Basically my Column A in Excel would be...

Using the code below, everything works well until one of the CompanyName values have an apostrophe in it. VBA generates an error. For Example: CompanyName = "John's Plumbing Supplies" How can I modify the code to be able to update the CompanyName Field in Access when the string has an...

I need to create a sample of "work that needs to be graded". For each person, in each month, I want to pull a 20% random sample. "Person" "Month" "Number of Total Workloads" 1 5 10 1 6 5 2 5 20 2...

Hi all, I am trying to transfer a selected row from a table to the next empty row of a query in MS ACCESS. I wanted to know if this is possible and if so how to go about it. Any help will be appreciated. Thank you

Hello, I'm a full time software developer, helping out a charity with their Access (.accdb) database in my spare time. There I need to work with an existing database that connects basic entities from one table with actions to perform on them in another table; everything is properly linked (1...

I have a query that every day pulls yesterday's data from an sql database and drops it into Access. SELECT Date, InvoiceNo, Customer FROM SalesDatabase WHERE Date=Yesterdaysdate What I need it to do though is when today's date is a Monday, I need it to gather the data for Friday, Saturday...

I create low-level automation solutions with Excel, these are usually small tools that accept user inputs, preform data calculations/manipulations, and generate outputs. I recently ran into a file-compatibility issue and need help. I am one small cog in a very large company and have no control...

Greetings Folks, I'm trying to come up with a solution at work that will help a few departments. I do not have anyone to bounce ideas off of as I am the only "me" in the company and my knowledge is well intentioned, at best. I'm trying to take away from me manually going into a tool one...

I am trying to get a table we keep updated in Access database to be the dropdown contents in an excel form. I wanted to use the Data Validation tool and select the drop down, but I cannot seem to figure out how to gain the data in my Access Table. My Access Data base is a network file used...

Hi Everyone, I was wondering how I would go about uploading a data chart from Access to Excel. Thanks

Hello all. My goal at the moment is: To open Form1 as background, make it translucent, then use the openArgs to pass a name to open Form2 on top of it. When Form2 is closed Form1 to close automatically. I achieved it easily with DoCmd.OpenForm but then I have to set WindowMode:=acDialog, which...

Tyring to build a report that shows Organization and position that people are in. For example: There is a table that shows all employees (admin) and them in the respective positions Sort ORder Org Big Boss Manager Worker 1 South Group me 1 South Group vacant 2 North Group Tom...

I currently have an Access DB and Excel workbook that are linked and updating tables and graphs properly when I refresh from Excel. What I would like to happen is user selection from a drop down on the Excel worksheet launches the update of the Excel document via linked Access queries. The...

Hi guys, I have an Access database with the following tables - Clients, IT2019, IT2018, IT2017, IT2016 etc. A client can exist in multiple IT... tables, or just one (depending on when a client joined). All tables use the field ClientCode to identify clients (This is the primary key in all...

Hello. When developing, I have found it convenient to use TempVars because they maintain state even when my VBA project does not. In addition, I don't have to run a load procedure every time I restart my code. To provide a bit of validation and intellisense, I wrap them in properties in a...

Hi there to all Mr Excelssss men. Ok, i know we can type an sql query and bring data to our excel. What a want to do, is to type something, which in this case is an Invoice ID number, and that triggers sql query and give me back some fields. I actually have the query that brings all the records...

I have a table that has serial numbers with dates that show when a job was entered, the date it was closed and the date it was installed. The Date of the installation is on the incorrect line and I would like to have it put onto the correct line. How can I do this in Access without going thru...

I'm a CS student in my 4th year, my professor wont grade my assignment because i didn't populate a ListBox correctly (I got a 10/200 but i have an option to turn in 1 revision). The ListBox named "lstCateName" displays a property type (castle, villa, manor) from a table named "tblProperty" on a...