Search results

Hi, Thanks for very fast reponse In all my years never used that method, I will go down that route but would sort of like to know why & if simply a access bug Below does seem to be a real anomaly 4 out of 5 times, "deleted OK" 1 time, debug.print is correct "SMITH/JOHN" but Msgbox StillHere...

Hi, Very strange problem, using the code below, I have a button that delete's the current record, sometimes it works as expected, sometimes does not delete the record but more oddly it deletes a record on a different form, the form is a main menu A, is open but not even the calling form so when...

Very many thanks to you all I am sure one of those will give me exactly what I want. My apologies to RanMan256 as actually, currentdb.Name can give some username infrom from the drive name, not sure 100% of what I wanted but sure would have worked. The Environ("Username") looks perhaps slightly...

Thanks, but as I say they are all the same name. Unless I give all the front ends a different name currentdb.name would all be e.g. "BookingSystem.accde" ref. the DBGuy reply Had a quick google "Try doing a search on "Dev/Test/Live" demo or code." Is this a whole new DB system? My DB I huge...

Tricky to explain, I have 4 or 5 front ends connected to a BE on the same LAN. They have the same name. I might be over complicating this but ideally would like to be able to identify each front end. FrontEnds are on C:\Documents etc. etc. not the same location Pc to PC e.g. pressing a button on...

It may be different or a better way now but I know long time ago when I originally worked on the web control, I spent a very long time trying different methods & opening & using the readystate made it work well otherwise I think was often not populated. Don't really want to revisit the whole...

Hi, Think should be able to work this out for myself but struggling I have a form with a web browser control. I want to view the pdf then decide which folder to save it to, so after closed immediately have the choose folder (ApplicationFileDialog.. stuff I open the form, then once open &...

Hi, Thanks for your prompt replies Took my own advise & making a table & then the form is based on that, so far very fast but a bit of coding to fully implement but not too much. Its strange, done this a few times, really stuck on a problem, think to ask for help and whilst trying to explain...

Hi, Have quite a complex form, lots of fields (need them all on one screen) Would really like to use databars to show rough amounts on 2 fields, at a glance However they are slow to display & the whole form is "calculating" for 7 to 15 seconds, & again if you scroll down, perhaps 30 records in...

Hi, Weird, my login was rejected so slow to reply, OK now, same user & PW, anyway.. Sorry was lazy typing, I do use <b> for bold etc & <br> Crlf It is not hard to re-code some stuff to use a text field on the form but ... aHTMLBody = "This is a <FONT size=5><FONT color=#800000><strong>TEST...

Hi, thanks all for very fast responses. I did try <br> , a bad example <strong> for access rtf. Nothing seems to works in an string variable, using a form field will. I am probably over complicating, I was trying to avoid using a me.field, constructing there, setting focus & using...

Hi, Not sure would help anyway but don't want to use the Forms reference as not used elsewhere. I have code that loops through records & creates a large string/text field e.g. AllDatesX = " Bob 1 June - 10 June : OK Jack 15 July - 20 July : Not OK Jim 20 Aug - 25 Aug : OK" inc. CRLF etc...

Hi Not too good with regular expressions, I have below which returns "15th" Ideally I would like it to just return the th, nd, st part ResultX = RegExSearch("15th December", "\b(\d+)(st|nd|rd|th)\b") I could simply use Right(ResultX,2) but did just think this is probably done in the pattern...

Hi, large RTF text field. Is it possible to Strikethrough text, similar to Ctrl B bold, U underline etc. I suspect not as it does not come up when you drag & select text, where you can change font & colour etc. I image some way could add html tag via VBA but as not that essential not worth the...

Hi, I have a button that sends an email, via MS Schemas, OLE etc. Run on a button single press If I accidently press this twice, almost like a double click, it runs the code twice & freezes & sort of crashes, recovers usually but 30 seconds. I wondered if there was a simple, elegant was to stop...

Hi, Got code below from somewhere else & works FINE if Outlook Options are set to open on the calendar I want it to open on a specific inbox but I get an error "Object variable not set" oOutlook.ActiveWindow.WindowState = 1 ' causes the error I assume perhaps not quite fully open because...

HI, On Forms mostly but also on reports. Condition Format on Unbound field won't work. e.g. FieldX e.g. Value < 0 highlight in red often won't work, but perhaps 50% of time it will, does not seem to matter what the number is -6 is not red, - 11 is red & random number it seems. If I use...

The Saga continues, re-visiting anyway. Mostly use of this field/data is RTF, emails I send out etc. However I also now want to remove the html when it needs to be a TEXT/SMS. on a mission now to find out what is going on.. All below is using the same me!LetterSource, a rtf field in a table I...

Just for ref. rather given up trying to find out but if anyone does know off hand, Replace(Me!PetNames, "&", " &", , 1) does fix easily, although I have a lot of places I need to apply. thanks for any replies.

Even more confusing, I have it set up so I can view exactly the same data but on a plaintext control so it shows all the rtf/html tags, as below, just different names, Bonnie & Lulu & belle, you can see the space is there <div>I am pleased to <strong>confirm</strong> the booking(s) as...