Search results

Many and many thanks. You saved the day. (mine at least)

I have a problem with my dlookup statement. When i run it separately there are no errors and I get my results but when I combine them together with AND I get error runtime error ‘13’: Type mismatch. All tables are text. This is the code that works DestTAT = DLookup "[TAT]", "tbl Dest TAT"...

Oke, i got it working from a test query, with some adjustments made to the code. But my colleague warned me that you could better set it into tables and not into a VBA module. his argument was, you do not want people from sales rummaging into your code every time the customer has shorten there...

vbaInet, Oke, i think i see your point. i have to divide it up-to multiple query's. First a query that i use for strictly Z numbers and days. A second query that filters Z numbers customers, destination and days. from this query i can build a query that filters Z numbers and department and...

Here is a copy of my databese, it is zipped. Look at the query qry test to.............. tbl TAT is the lookup for days. http://www.edsretired.nl/forumposts/WVL.zip

I tried this and every part is now shown 3 times with different run times (TAT). SQL SELECT [tbl WVL_Data].[Serv order], [tbl WVL_Data].Project, [tbl WVL_Data].[Sales doc], [tbl WVL_Data].Customer, [tbl WVL_Data].CustName, [tbl WVL_Data].[Name 2], [tbl WVL_Data].[Customer pur nr], [tbl...

Good day all, I have again a problem with access tables and query's. Now i need to give parts a run time. This is a complex situation. On the work stock list i have to give all the parts total runtime (TAT) from start to finish. We start with MAT numbers like Z42 is equal to 5 days run time...

Thank you sir

boblarson, the code for test is above the sub look Sub test(wc As Integer) Sheets("Print vriendelijk").Select ActiveSheet.Range("F2").AutoFilter Field:=6, Criteria1:="" & wc, _ Operator:=xlAnd Range("A2").Select Range(Selection, Selection.End(xlDown)).Select...

Hello, My code works partialy. As soon as it hits Call test("060C") i get a runtime error 13 Type mismatch. What am i dowing wrong. :banghead: Sub test(wc As Integer) Sheets("Print vriendelijk").Select ActiveSheet.Range("F2").AutoFilter Field:=6, Criteria1:="" & wc, _...

Ehhhhhh, so simple :eek:(hit myself on the head) many thanks.

Hi, I have a aquarium of 260 liters. Once in a while i need to refresh 20 to 40% of the water. I have in excel a height width and depth cell and a cell with the calculation =B3*C3*D3/1000 I now want to calculate the height minus 20% of water, so i can mask-tape it and tap the water. i know...

And again thank you for your help NickHa. :D

Hello all, I have a table and in this table i have a field called MainWrkctr. The records shows 1000/2600, 1000/2400CK, 1000/1600 and so on. What i need is only behind 1000/. I tried a update query Replace([MainWrkctr],"1000/","") Also MID ([MainWrkctr],5,4) and Right([MainWrkctr],4) But all...

I have altered my SQL in my original database and it works. I picked yust random dates for my test.

There is something wrong with the calculation. see zip Inter-mu Test day numbers query qry Day numbers field TBL Inter Mu I have even a day with 719. that cant be good. :confused:

It works fantastic, made a test query and it works. Tomorrow at work i will implement it to my database. so once again thank you for your help. :D

NickHa, many, many thanks.

Thank you for your reply NichHa, but where and when do i use this. Is this VBA? sorry, for my ignorance, but i am a access beginner. (I made some infopath forms and now i am bombarded the IT wizzard!)

Hello all, I need to calculate a start date to a day number. Lets say start date is 01-01-2012 corresponding to day one of the year. And end date is 10-03-2012 corresponding to day 70 of the year. I need this calculation in a query where i have a start date field and a end date field. we work...