Search results

Hello I got this query with a subquery and it takes couple seconds to run. However if I try to go to the last record, export it to Excel via ExternalData tab or Make Table, my Access stops working and then I get an error message there is not enough memory. I am getting lost here as in the end...

I am trying to design query or queries that will calculate my Opening / Closing Inventory and Production requirements. I import data from Excel into a table that gives me Opening Inventory figure for the first week (16/05) only. I got a function that assigns current week commencing date when...

Hello Can please someone point me in the right direction how to solve below problem? I have below table in my database where I have different products, sale date and sale value Product Name| Sale Date| Sale Value Product 1| 10/05/16| 100 Product 2| 10/05/16| 150 Product 1| 11/05/16| 125...

Hello!!! I got a fairly complicated Stock Cover calculation in Excel that I am trying to replicate in Access. Unfortunately this calculation in regular Excel uses a combination of Offset and Match to get right values from matrix tables. I was doing some reading online but so far I was...

Hello I have VBA code that imports Excel files from a specific folder into table A and then appends some data from table A to table B. I need now to amend this code so after importing into table A it would check if values from column 1 in table A are in column 1 in table C and if not...

Hi I am trying to run below to update multiple records in the same column and get error message saying characters found after end of SQL statement. I tried to remove ; but then get a syntax error. Please help UPDATE [tblMonthly] SET [Date] = #20130701# where [File] = 'A'; UPDATE...

I use a simple code (below) to import text files from a folder. All works well but now I need to populate a value from particular record for all records from this file. I have attached an example of my table after importing all text files. I need to add another column and based on this...

Hello! I use below simple command line to start a macro in my Access database. Usually all works well. I start my bat file, command is executed and macro does its job. However it always fails if I have a session of Access already opened even if it is a completely different database. If I use...

Hello! I am trying to concatenate multiple rows into one record. I googled it and found many functions in VBA that do the job. However my problem is that my query will be linked directly to Excel file and then I get an error message saying that Excel could not recognise this function. I could...

Hi, This drives me mad, I cannot sort below query in descending order by absolute value. If I do not use sort, all works fine but as soon as I try to sort by absolute value I get message to 'Enter Parameter Value'. I just cant understand why. I tried to replace Abs([Variance (W2 - W1)]) with...

Hello! I have a problem with below query. It doubles some records. I kind of found the issue but I do not know how to fix it. Basicially I have two tables, which are Linked tables and they are linked to two Excel files. Each of the tables has almost the same information: Stock Number...

Hello, I have attached a sample of a database, which hopefully illustrates my problem well. Table 1 has all the items I am trying to sell with sell by date after which I cannot sell this item. Then in Table 2 I have forecasted sales. So now I am trying to calculate stock consumption to see if...

Hello! I have a tabular form with many rows of records. Users add some additional information and now I would like to insert it into a new table. I tried to use below code and it works but it inserts only first row out of many. So I just wonder how to amend it to insert all data? Pls help :D...

Hello! I am having a problem with below and I wonder if anyone could help. I have a report, which is based on query that links various table. There is also a form, which starts when the report opens, which has dual function: 1.) user selects criteria to filter out only particular customer but...

Hello, I designed a simple form that has a listbox and a subform. I am using Northwind database for testing. I would like to be able to display on a subform only records based on a value of a list box. I created a listbox using a wizard and selected an option 'find a record on my form based...

Hello I am about to design my first form in Access and I think I am trying to bite more than I can chew ;( So I would really appreciate any help I can get. Basically I need to design form that looks very similar to either Split Form or Subform. I have attached a print screen of what I...

Hi Guys, I am using below code to import various Excel spreadsheets into Access. However every now and again below code goes into error, usually because there is no ‘toimport’ range in the Excel file. So I would like to use On Resume Next, so it can import all other files. But in order to do...

Hi Guys, I wonder if someone could help me with my problem. I have a table with order number, products and their stock status. So I may have some orders, where there is enough stock for some lines but not enough for others. So based on the line status I would like to create an additional...

Hi, I am using below Union Query to unpivot attached table. Basically this is a table with some clothes and their sizes (in yellow). Now my problem is that below query works well only when all sizes are in the same row but as per attachment I may have them potentially over three different rows...

Hello! I am using below Macro for importing Excel files into Access. The code works very well but unfortunately now I need to modify it. My knowledge of VBA is extremely limited (below code I just found and modified a little bit), so I would appreciate help. I need to add two additional...