Search results

  1. B

    transferspreadsheet doesn't go in order???

    I know a really old thread but thanks for the LINK instead of Import advise. Not quite sure why people always think we should not expect data to be imported in the same order of an original source, just seems odd, shy does it have to change, if you want to change it then you do a sort or alter...
  2. B

    How to transpose row headings as column headings, cross tab query perhaps?

    Hi, Just now looking to implement proper, being fussy now ... Is there a way to put this in a form, so that the fields can be adjusted, colour, size, centralized etc. I have added as a subform & the crosstab.query as the source so it works but thinking would like to manipulate the display.
  3. B

    How to transpose row headings as column headings, cross tab query perhaps?

    Hi, Gone with ebs17 as the first I tried & just worked perfectly & seems an elegant solution but thanks arnelgp, will have a good look at that solution also. Thanks again,
  4. B

    How to transpose row headings as column headings, cross tab query perhaps?

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

    Query to group on Day with sum total on a field & filter on Time but NOT group on the time

    Hi, Very many thanks "In Column "TmHour" the Total row should be set to Where rather than GroupBy. That may be all that is required." WORKED I thought I had tried that & actually most of the other sum functions, just to get a dumb value to avoid the GroupBy but I guess not. Put it back to the...
  6. B

    Query to group on Day with sum total on a field & filter on Time but NOT group on the time

    Hi, Thank you for your prompt reply Not helped & can't see why it might?
  7. B

    Query to group on Day with sum total on a field & filter on Time but NOT group on the time

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

    DoCmd.RunCommand acCmdDeleteRecord is deleting a record on a different form!

    I had tested, did not get an error message, it was deleting a record OK jut the WRONG on from a different form I am now using Me.RecordSet.Delete & cannot replicate the problem I would have liked to know why it somehow the focus goes to this form, even stepping through the code, does not show...
  9. B

    DoCmd.RunCommand acCmdDeleteRecord is deleting a record on a different form!

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

    DoCmd.RunCommand acCmdDeleteRecord is deleting a record on a different form!

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

    Is there a way to Identify different front ends (same accde name) using VBA, local name or even folder share name?

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

    Is there a way to Identify different front ends (same accde name) using VBA, local name or even folder share name?

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

    Is there a way to Identify different front ends (same accde name) using VBA, local name or even folder share name?

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

    Open form, populate once open, but wait before continuing code. Modal not suitable

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

    Open form, populate once open, but wait before continuing code. Modal not suitable

    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 &...
  16. B

    Forms conditional formatting & DataBars, v. slow. Is there an alternative or way to speed up? The numbers are shown instantly

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

    Forms conditional formatting & DataBars, v. slow. Is there an alternative or way to speed up? The numbers are shown instantly

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

    VBA to construct a string, then add RTF formatting so can be Pasted into a memo field

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

    VBA to construct a string, then add RTF formatting so can be Pasted into a memo field

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

    VBA to construct a string, then add RTF formatting so can be Pasted into a memo field

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