Search results

Thank you for this, i was clearly over complicating things, using the iif the format does not work, keep thinking its days of the year but thats ok, i can work with its native -1 or null output. Thanks.

Hi thanks for getting back to me, what if tbl1.ID IS on tbl.2, but the tbl.1Customer is NOT on tbl.2. I would not see this as the first filter would have removed the ID and i wont know that i need to supply to that customer, it seems queries in Access are limited to 1 task at a time.

If i do that, then i cant apply further conditions.. SUch as, Does the ID exists on both tables Yes Does the Product Exist on both tables No THEN Action ELSE no action.. Does that make sense? I just need it to flag? not filter *Update* - I think i need to use IsArray, but i am not...

Hi Guys, How would i go about the following Statement as a Query. IF tbl1.ID = tbl2.ID AND tbl.1.Customer=tbl2.Customer THEN "y" ELSE "NO" END I tried the following in Expression Builder iff(tbl1.ID=tbl2.ID,"y","n") just to see if it would flag the rows from table 1 as being present in...

Thanks, I am just not used to working with Access. So, i have started using the Queries to move data about and on the whole it works. When looking at True/False flag, its returning duplicate rows to count all 90K records from one of the tables. But i just want a Yes or no against the ID...

@CJ_London, Thanks for that, i will give that go now.

@CJ_London Thanks, i am doing that, reasons we cant store in Excel are manily data size, Excel just crashes out about 65k rows.. thats about 3 months work for us. Long term we are looking for an SQL server based solution, but no one actually spends money in business soo.... I am importing...

@Uncle Gizmo Thankyou for getting back to me, so, my data is actually an oracle generated Excel file. that contains a column call called Channel. From this i need to produce the additional columns of Branding and Service. These are currently "known" things, as in a human knows them.. :-)...

Hi Pbaldy, While you would be right given my example, this is part of a wider workflow i am trying to put together. Now Access might not be the right tool for this but.... I have a table in an access database that is a full history of my depts output. Every day, we get sent 6 new excel...

Hi , In MYSQL, i can use the CASE statement to take 1 column from a table and generate 2 new columns with new data based on that info. Eg. TBL1.Bike BIKE Yammaha R1 Kawasaki H2 Suzuki GSX Honda FireBlade I can then CASE this info, with something like Select Name , CASE BIKE...

Hi, Thank you for helping, with your links and info I have debugged and now resolved my issue. my working code is: Private Sub Button_Import() Call Import_Excel End Sub Function Import_Excel() Dim myfile Dim mypath mypath = "C:\Folder\Input\" myfile = Dir(mypath & "*.xlsx") Do...

I am not sure how this is to be structured into my current code?

Thank you, i added the \ but now i get an error No Installable ISAM found its looking for some .dll file, but i have no idea which or where ??

So to help debug, i wrote the following, Dim mypath As String Dim myfile As String mypath = "C:\Folder\Input" ChDir (mypath) If Len(Dir(mypath)) = 0 Then MsgBox "No file" Else MsgBox "Files Found" End If It tells me that no it cant see any files..

Thank you for that, they are really handy. (as you might have guessed i am pretty new VBA) So, the window reports back, just the Folder path for both myfile and mypath, to which i guess, means the dir() is not returning the list of .XLSS files within the dir? should i add *.XLS to the myfile...

Hi, I dont know what a break point is, I added a Message Box just to make sure the code was running. ill give the debug.print a try cheers

Hi all, I know this subject has been covered and i have been reading a lot of those posts, but i cant find/get to work exactly what i am looking for. I have a folder location that will get 6 new Excel files added to it each day, with names that mean nothing most of the time. But the...