access

Hello all, I have a .dat file that opens up in an access 97 application. I would like to copy one table from the file and certain columns to a new access database. I was able to copy the whole table in excel however I am stuck on how to do this in access so that way I can skip excel all...

So I am not sure if this is better to do in Excel some way or Access. So I have a Excel file with Open orders. I update it every week. Right now I do it manually. Basically I have notes on some of the open orders of why they are still open etc. So when I pull the new open order report I need...

Hello All, I am completely new to access and was trying to do this with Excel Power query and was successful however the data is so large that it is taking forever to run, so I decided to give access a go. Here is the situation, I have 10 locations I manage and each day I receive a csv file for...

Hello All, I currently manage 10 Locations and for each location I have 6 different CSV files that contain anything from sales to employee ect... I have cleaned up the data using power query with conditional formatting as not every column is used and some calculations are being done along with...

This has probably been posted but I have been looking for it confused for quite some time. I'm quite new to access - have written a few queries but am looking for a solution which doesn't seem to fit anything I have found as yet. I have a database with linked tables with 1 to many...

Hello I've recorded a Macro that imports some data from an Access database Query into a specific sheet in my Excel-file. I would like to change the path, so that it prompts me for the location of the .mdb file instead. Sub Makro1() ' ' Makro1 Makro ' ActiveWorkbook.Queries.Add...

Hello, I am hoping that someone can help me.... I have read some information about storing dates in an access table, but I am unsure about how to go about it. I am wanting to be able to lookup dates from a table based on a start date and a frequency (being weekly, fortnightly, monthly etc.)...

Windows 10 v20H2 (19042.1083) MS Access 2019 I've recently upgraded to this version of Access, so I'm still finding my way around differences from previous version of Access. I'm sure there is a very simple and quick answer to this question but, currently, I'm stuck. I'm trying to do...

Hi, I have very basic VBA knowledge so please go easy on me :) I have a query "qry_Data_Ref_Wk_Date" which returns a Min Date "ProcessDate". I would like to use "ProcessDate" to apply an After Date Filter to another query "qry_Data_Filtered" by whatever means works best and stops me having to...

Hello! I am new to this forum and somewhat new to Excel/Access VBA. Have been able to find solutions to most my problems in this forum already except for this one. I have an excel workbook used for doing quotes. It's more like a form than anything. I want to use Access to store the quote...

Hi All, New to the group so be gentle. I've tinkered with Access for quite a while but I've come across something that I just can't get right. I've got a database of assets that have been surveyed, the survey is imported into the database and the various assets need reassessing within a set...

I've split finished databases before and understand how and the benefits of doing so. I have a project right now where I'm sequentially adding departments to a database. Right now, the first one is finished and I'm ready to move to the second. The first department (that's already functional in...

In Access 2016, I try to follow this howto on ui automation: But I keep getting that "undefined" error on the function WalkEnabledElements. It is the first function call after DIM ... as... Where I get a different error if I do not set the dll reference, so that's not the problem... Any...

Hello, I am trying to create an expression that will control a users date input in reference to a pervious field. This is what I currently have: [Field 1]<=[Field 2]<=[Field 3]<=[Field 4]<=[Field 5] Field 1 has an expression/Validation rule of: <=Now() Essentially, I want the first field to...

Hello. I currently have a working vb script in access. 1. Takes a template.. abc.xls 2. opens up the template 3. exports customer data into particular tabs within the template 4. saves and renames the template according to the customer name 5. script then picks the next customer and repeats...

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