Search results

Can you hide group total if group field is blank is null Hi, I have a report that is mainly listed & sorted by date however I want to group and total by Ex Ref as below. This is fine but many/most are NOT grouped. i.e. no ExRef so I do not want a total, preferably no group footer at all. Is...

Hi, not sure how I can check for nulls in the criteria above The only thing, not yet tried, can I then add another criterea on top of the main one, Seperate statement immediately after this one, to included any records with NULL in the details field.

Hi, Access 2007. Form. I am trying to filter a form so that it does NOT show items selected from a list box. Might be too much to ask Sort of works well and v.nearly there but also hides the record if the "Details" field I am filtering on is null (Seems to be null, "" seems OK, I would prefer...

Thanks for that, It is not a table Object etc that I am trying to get the source of so I don't have the full name. I have a report based on nested query's so I can't find a way to get the SQL To make matters worse I ONLY SOMETIMES want to open the report with a further filter using...

HI, difficult to explain but will have a go. I have a report that is based on nested (I think thats the phrase) query's. Complicated Query based on another query (so I can't see a way to get at the the source SQL to change or use elsewhere) This gives a list of say 20 records I generally want...

HI, Thank you for that, I guess the original function was nothing special but much better than anything I would have thought up but in the end I have pretty much re-written in DAO, which required quite a lot of changes. I imagine I should have started from scratch rather than changing each bit...

Hi, Access 2007 accdb & accde/runtime (recently upgraded from 2003 mdb) I found the code below (Hope I am not breeching any rights doing this)that seems to simplify my age old issue of storing simple variable values that I would like to keep after closing the DB. I do use tables but always...

Hi, Trying use ELookup within a function, using multiple times and easier to pass values and alos do some test on the data. However not really seen this done (Perhaps a bad idea) so struggling to see how the values should be referenced quotes, single quotes etc. DLookup works as below (But...

Hi, Already & have for many years run Access 2007 & but using data (2002-2003). Is it 99% safe to upgrade front & back end from MBD to ACCDB & MDE & ACCDE. I use MyDtabase.mde/runtime most of the time. When I upgraded Access 97, 2000 etc. I kept the old data format then just to avoid any...

Hi, I am trying to import data from an excel spreadsheet. Works fine mostly but I have a date that is formatted in excel "5-Feb" i.e no year, I like it this way. The underlying value does include the year, i.e 05-2-2015 When I use DDE Request as below it imports exactly as formatted so no...

Hi, I use Alt codes to get special characters, i.e. Half ½, Quaterter ¼ etc. alt+171 = Half work OK alt+172 = quarter work OK but 1/3 one third & 2/3 two thirds no NOT work alt+8531 (gives a normal Caps S) & 8532 When entering data in a form or anywhere in Access, even in VBA code view not...

Hi, Reply to my own post as had some good progress. I use google spreadheet link embeded into my wordpress page. In access I have a form with the lists of data, A button that auto selects all & copies. A hyperlink to the google spreadsheet. I manually paste this. I actually publish a 2nd...

Hi, I have report &/or form which lists booking availability, basically a list dates & number of spaces. I would like to publish it to my wordpress website somehow, preferably quick & easy, not too much export import etc. Access 2007. I know I can export to html just note sure if this is the...

Hi, Reply to my own question, It seems it can be done with the .printer class My problem was as per many examples I was trying to open acDesign, which is NOT allowed in /runtime or .mde It seems if opened Preview, the margins etc (& all) can be adjusted. Only tested briefly but done seem to...

Many thanks for taking the time to investigate, I probably have not made myself completely clear When I say runtime, I mean started either with the /runtime switch which locks the program or on a distributed runtime database .mde or .accd. I have computers on the network that don't have MS...

Hi, Put up with this problem for years now but wondered if there is now a solution. Access 2007 RUNTIME I have 2 different printers, 1 for invoices A5 & one for general use A4. I use - Allenbrowne.com/AppPrintMgt.html and can change printers & some stuff but can't change margins. Is there a...

Many thanks for your suggestions, I often use combo boxes with drop down and use the up & down arrow for these & if on the same form causes problems. I was trying to find a good system for all my programs & keep consistant with something fairly obvious for other users also. I think the Z & X...

Hi, In my forms I would often like to move forward or back a records, usually a date by keyboard alone. The keyboard arrows are good but they are normally used to navigate along a line etc. Page Up & Down again better & often used for moving between records but do sometime need there native...

Hi, Many thanks for your reply All very good ideas & suggestions. I assume you mean by "adding the Criteria [Forms]![Form1]![MyValue] to your InDate field in your record source" that I change the whole select statement in the source to the new filter requirements & change it back afterwards...

Access 2007 .mbd Hi I have a tabular form that is based on a select statement (Query) in the source property. It filters & sorts from this select statement. I have just added a Me.Filter = "[Form1].[InDate] = #" & MyValue & "# " Me.OrderBy = "Indate DESC" This all works fine, filters & sorts...