Search results

I know I should use a form to update database and then generate a report but I was not having any luck with forms and found an easy way of getting what I want through reports. So now I am just trying to make it work :) I am not concerned with a size of database because it will be really small...

Any ideas? I am sure someone must know a nice easy trick to solve this :D I have been trying below code but it works only for text boxes in report header. Unfortunately I cannot add all the lines from the report as it adds only first line. I guess I would need to apply a loop here but I do not...

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

You are right that was a silly mistake to make but then how can I use two listboxes simultaneously? I cannot link sub-form to two different Master/Child fields, so now if I use City list box and select Las Vegas everything works well but I then if I add another listbox with Last Name it just...

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! Yes, this looks like potentially something I would be looking for but how to arrive there ? :banghead:

Hi, Would be really grateful for any help, I do not even know where to start :D Many thanks!

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, Yes, your are right, 'it doesn't work' is not terribly helpful. Schoolboy error :D If I use '" & Err.Description & "' I get Run-Time error 3075, which is basically an error message that I expect to see when there is no 'toimport' range. So it looks like the whole error handling procedure...

Hello! Many thanks for your help. Unfortunately, your code does not work :( I have done some digging and I found out that text values need to be between single '. This solved problem for filename but I can't get it for error description. I tried many different combination and I just can't get...

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

So simple, so neat! Many thanks, this is exactly what I needed. Could you just please explain for my benefit why 'Not enough stock' is greater than 'Enough stock'? Is it because of the alphabetic order?

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 Please look at the table I attached in my first post. I just look at column Size Range to see to which Size Range a row refers to i.e. Size Range 2 for AB. Then I look at quantities in the table and I see that '1' is under column XS in Size Range 2 and another '1' is under S. Then if I...

Hi Based on the attached previously table, I would like to see following result: Item No | Size | Qty AB | XS | 1 AB | S | 1 AD | 27 | 2 AD | 31 | 3 BB | 0 | 8 BB | 5 | 6 BC | 3 | 2 I hope it makes more sense now...

That's the one. Any ideas?

This is from the attached Excel file. Basically this is an order form completed by the customer. Then I need to generate a full Item Name to upload it onto the system i.e. AB1 and corresponding quantity. So there is no data source to use.

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

Many thanks for pointing out duplicated files, I have not noticed it until now :mad: I will change F1, F2 etc to more meaningful names, it was used for testing only. Would you be able to recommend anything to read, so I can learn to do all this magic myself instead of bothering others...

Many thanks for all your help and above code. I understand some of it and rest I am going to google so I know exactly what's going on there. But when I run this code the CustomerName is not updated properly. Code runs without any problems at all but CustomerName is test for all records, whilst...