Search results

Hi, I have a table with each day & totals related to that day. Dates will vary and number, perhaps 20 or more but I think will restrict to 30 although data may ask otherwise but will have to worry about that on the screen space. I know not really how access is meant to process, display data...

Hi, I am trying to sum total the two values as below but Grouped per day ONLY, 1 total for the 7th, the 8th etc. etc. However I need the TmHour to filter the results just between those times This causes it to no longer be grouped by day but per time hour also. I just can't work this out, any...

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...

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...

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, 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, 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...

Hi, I have a rtf field (emailreply) on a form. It is made up of simple strings & other fields e.g. me!emailreply = "hello" & me!Names & "how are you" & "this is your address" & me!Address me!Names is a field & textbox (normal NON rtf) if Me!Names is "Bob & Jake & Jill", when me!emailreply is...

Hi, Just getting into custom menu's, They work well but would quite like to ideally grey out or hide menu options that should not be available depending on where the focus is. I can of course test & stop if running but prefer its not obvious to use from the drop down menu itself. CUrrently...

Hi, I want to be able to type data into Outdate1, e.g. press enter Process stuff on the value but keep focus on Outdate1 & highlight it, ready to type over without manually deleting. If in the AfterUpdate of the Outdate1 control I have .. Me!OutDate1.SetFocus Me!OutDate1.SelStart = 0...

Hi, Have code below copied from others, I added the, Set oItem.Unread = False (with or without the "set", makes not difference) It does not mark as unread & still in Outlook & server as unread. I have seen others that loop through separately afterwards, just to clear but not tried but also not...

Hi, Trying for graphical representation to show a level depending on values. e.g. I have a table and the values will vary from 1 to 50. I have the textbox set up with conditional formatting using compare to other records so as to get the fill in bar chart effect. Trouble is the bar is already...

Hi Never really noticed this before, I know there is overhead with BE on local network (gigbit) but I have large tables with 10000+ records & a get minimal slow down really. However I have a BE table of only 5 records, lookup of rates depending on a dates range. I am testing as noticed in...

I have a form that has a form footer with totals I use to use =Sum([Cost]) but this was incredibly slow. Pleased found much faster way using recordsetclone & adding up via recordset & updating unbound text boxes, great works well if I press a button but cannot find a way for it to work on...

Hi, I have a BE on a wired LAN. Very rare for interruption but power outage or just resetting a Switch/AP without remembering to close all FE (I have 4) give me the above error. I usually have to click 5 or 6 or more close or X on the window before access closes. It can of course happen from...