Search results

Hi just noticed that the link doesn't display all correctly hopefully this will work: so this is the one from the web page I want to replecate as a hyperlink in access: http:// lp34web.w34:4524/baa/jsp/order_information/osm/orderinfo.jsp?packageUser=apipso79.w34:IPS_MON&ordnr=0996653&baaSubmit...

Hi I would like to know if it is possible in Access 2007 to add a button/hyperlink where by the order number (as in the example below) is being sourced from another field [ORDNR] i.e. replacing the 0996653 for example with a lookup to the ordernumber held in another column...

Ahh well didnt know this - I have been running this for about 6 weeks now with at least 2 people over wifi. I have seen some crashes, but touch wood, no corruption yet! and the data being in processed at point of crash has been saved successfully. Thanks for that though - I will request that...

:eek: whys that?

thanks for this ... I think you're right and I will contain it. Many of the 'new' requests are now around the form designs and how they suit each area, I want to finalise and then leave well alone! :eek: try to!

Hi CJ_London, Thanks for your response/advise.... very much appreciated. The front end is growing as the users are demanding more! I have 3 different areas of the business requesting specific changes and so it's growing, it would also be nice to separate for my sanity! I will put the frontends...

Hello, I am looking for advise on the following senario: I have (on a company network) a FrontEnd .accde and a backend .accdb - currently ~ 10 users (some over wifi - slow!) The FrontEnd is becoming a rather large file ~ 10 MB and is also becoming slower. I am looking to separate this in to...

Hi thanks to you both I have fixed my date time! Final statement is: endDate: CDate(Mid([DZ_ZPKT],7,2) & "/" & Mid([DZ_ZPKT],5,2) & "/" & Mid([DZ_ZPKT],1,4))+CDate(Mid([DZ_ZPKT],9,2) & ":" & Mid([DZ_ZPKT],11,2) & ":" & Mid([DZ_ZPKT],13,2)) It was the '+' that I didnt know about! :-) happy now!

Hi I have a similar issue, I have added a save button, and request the users to click prior to moving - works but can go back into the error msg loop if they forget. Tried to figure out a save function after update (sort of thing) but gave up! Hope this may help a bit!?

Hi Brian, thanks for the suggestion. I have looked at some of your old posts and each one makes sense to me ! But a question would be how to join date and time? Hopefully just a '&' !! I'll feed back tomorrow... Thanks

OK thanks I will try again; as I said though, I have tried and couldn't get the desired result - it wouldnt join the space hh & ":" etc.... to return HH:MM:SS. I give it a go at work tomorrow, and let you know how I get on.... Thanks for everything so far.

Yes I wrote the code and yes I understand it. My experience level - I am not bad, lets say! Are you sating that I need to expand the mid statement? If so, I have tried and couldn't get the desired result - it wouldnt join the space hh & ":" to return HH:MM:SS can you please help expand...

Sorry but not getting this.... In the table I am selecting in the query, the value is text 20130225060621 this is a date and time YYYYMMDDHHMMSS I want to, in the query, select the 1000's of values in column named dz_zpkt_ak If I do nothing I get all the date values in the text format. But I...

I have just done this today. ('I need help' is right) But what I did was; 1. build DB, all tables forms queries report etc. 2. in MS 2007 you can (on the top menu) split the DB, this creates 2 files. 2.1 one holding just the tables 2.2 the second everything else but the tables, this file...

Hi Many thanks for the reply - OK so I have tried: test: CDate([dz_zpkt_ak],'DD/MM/YYYY HH24:MI:SS') and test: CDate([dz_zpkt_ak],"DD/MM/YYYY HH:MI:SS") but just get error... what am I doing wrong?

Hello, OK I have been going in circles, and I hope someone can help!?! I am connecting acces to oracle servers via ODBC . in the table there is a date time stamp - format data type text: 20130225060621 I would like to convert so that it is recognised as a date so I can calculate against...

Hello - all, New to the world of forums / posting etc but have used this site for help!:) Working in the UK for Rolls-Royce Motor Cars, and have a new job that can be assisted greatly by MS Access - yippee! but as you all probably know the Access stuff can be a bit :banghead: Any how look...