Recent content by bignose2

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

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.

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,

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

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

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

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

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