Recent content by paul.clarke

cool, thanks. i done it a different way now. ive used mid, mid and left to get docking date as dd/mm/yyyy, if its blank it just returns //, so ive done if dockingdate = // then do "" else do dockingdate. seesm to work fine.

so how can i get rid of the #error returned value when the docking date is blank. ive tried iif(IsError(dockingdate),"",(dockingdate)) but it doesnt like

actually i think that was my fault, when i was adding fields back in. i have left it with docking date, leadtime and the dockdate2 calc.. and it works. hurr-rah huge thanks..

Thanks. I copied that all into a new blank query, but it returns #error on the dockdate field.

i am selecting alot more database fields than as above, but the SQL was very long, so i shorted it. The only other missing is the date calc im trying, simply dockDate+Leadtime

SELECT Left([DockingDate],10) AS DockDate2, [Agent LeadTimes].LeadTime FROM (scheme_poheadm INNER JOIN ([BRS master dbo import] INNER JOIN dbo_vw_landed_po ON ([BRS master dbo import].OpCo = dbo_vw_landed_po.op_comp) AND ([BRS master dbo import].OrderNo = dbo_vw_landed_po.ono)) ON...

how can i give you a query. do u mean explain it? basically i am selected fields from various database tables, the only calc i am doing is this datefield + a number (leadtime). all other fields are pretty much just dragged from the tables. I have used left(date,10) on some to only return...

thanks for the reply. I can use access fairly well, but when it comes to coding i havent got a clue. wouldnt know where to start, is there a way i can do without vba? if not, where would the vba go. im using a query, not a form

Hi So i have all dates fields set as text fields within Acess, so its format is like yyyy-mm-dd-hh-mm.000000 etc. I can use Left(date,10) to get YYYY-MM-DD, i can live with this rather than DD-MM-YYY. MY issue now is i need to be able to add a number (leadtime) to this date, but it doesnt...

Hi The mouse wheel scrolling between records no longer works on my forms since switching to access 2007. I found this link which should resolve it if i add code to a module etc (link) http://allenbrowne.com/ser-70.html The trouble is i cannot do step 4 as when i goto "properties" and...

Im sure you will understand but due to data protection i think it better not to post any data online, i think though however as my "unmatched query" finds only the new records, i can create an append query from this to append the new records into the table. and therefore if i create a "find...

i dont even know how to post a database here, its massive also. Basically there is 1 query which picks up all outstanding orders from the system, i have linked my blank table (production details) to this and added the fields to the query. The supplier sees the po details and then in the...

potentially yes, for example PO number 12345 supplier could initaially provide a delivery date of april, then next week due to delay etc they could change the date to may, so i will need to update the record for that po to show the latest date/details.

every record in the excel sheet is unique as we have 1 item per purchase order, everything links to or from this po number. I did try use this as primary key, but in some instances the order qty is split so the po records will appear for each spilt so i can track each qty seperatly etc. Am i...

I have created a table for supplier production and i have set up an append query which updates this table from an imported excel sheet with all the data. This works fine the first week. My trouble is when i get the new data from suppliers the next week and import into access again, and then...