Search results

I think all you need is >0 without quotes in the criteria line. Any value that is greater then zero can't be null, so that part is redundant

Hi, My code seeks to create a PDF file and then email it to a recipient. Can I get the code to "pause" until the file has been created? At the moment, it returns an error because the file doesn't exist, but that's because I haven't yet had a chance to confirm the filename and location. I...

I don't think the second way will work. You *might* be able to do something like IF AND(Me.Text1=5,Me.Text3=10) = True msgBox "Hi" but I have never tried it. But the first way looks right to me

There's a lot of stuff in that document and it's hard to take it all in, especially if you're self-taught like me and have some gaps in your knowledge and maybe some bad habits. If I understand correctly, you have two tables, one containing records of people of some kind and another containing...

Hi, Your criteria looks right to me and in fact works for me. But I wonder if you're using it on the right expression. I created an expression to get the year of the casedate first and then applied the criteria to that. See various queries in attached database. Does this achieve what you...

Hi, I appreciate that Access can't make up data, but it can write data to a new table which is what I'm doing here. My 'raw' data actually consists of individual dates on which certain processes were completed, over several years. But in order to compare financial years and get the report...

Hi, My table contains a MonthNumber (values 1 to 12) and fields called 'Y10-11', 'Y11-12', etc. which contain numbers of widgets (let’s say) produced in that month. I need a query to calculate running totals for each year and found this thread very helpful (thanks Mahjenk2) Using that I came...

I've never found a way of doing this! It's not the answer you were looking for, but I have always resorted to having labels in normal text and the field itself in bold. The problem is that the "has graduated" label will have a fixed position. So you need to leave enough room for very long...

Hi, Thanks a lot for this. It was the Application.FollowHyperlink I was missing and you're right I can do this right from the text box. For the benefit of anyone else who happens across this thread, the code that works is Private Sub PI_Email_Address_Click() Dim EmailLink as String EmailLink...

I have a main form showing details of a project, with a subform in continuous view, showing details of people who are working on it. One of the fields on that subform is PI_Email_Address. I have set the Display As Hyperlink property to Always and I assume I now need to set the Hyperlink...

Never mind, I got there. Some square brackets make all the difference. I hadn't spotted they were missing from the sample database. If anyone's interested, the function I got to work is: IIf([2012-13] Is Null,Null,Nz(DSum("[2012-13]","MHByMonth","[MonthNumber]<=" & [ExistingMonthNo]),0))...

I have a table called MHByMonth, containing monthly values across several years, as follows (dashes used here just to try and format layout) MonthNumber---2010-11---2011-12---2012-13 1---43---69---44 2---37---100---46 3---34---100---49 4---14---73---75 5---25---73---19 6---11---182---64...

Thanks so much for that! Themes hadn't occurred to me. I changed Use Themes to No, fiddled around some more with formatting (I think 'Use Themes' changed back to Yes at one point), but at least my formatting works now. This is great, thanks again.

Hi, I've built a database in Access 2007 but need to also deploy it to some users using Access 2010. I'm currently testing on a 2010 laptop and the tab control captions are behaving oddly. The caption on the selected tab is invisible (or perhaps white on white) and you can only see what it...

I don't think you can. Tables aren't really meant to be a "display" item so i don't think they have that property. But you can build a form on your table or query, and set the default view to datasheet. Then it will look like a table. And you can set the mdal property on it.

Oh good grief ...it was that easy! I can't believe I spent hours yesterday trying to figure that out. Sometimes the most intelligent approach is knowing the right person to ask!!! Thanks again :D

Hi Galaxiom, No I didn't realise that. One of the huge numbers of things I guess I don't realise about Access. Well thanks for saving me from wasting any more time on this. I'll have a go at the conditional formatting approach. Pat

This MIGHT be happening because you have set the Modal property of your switchboard form to Yes. Do you have any other forms or queries that open while your switchboard is open and do they "pop-up"? As far as I know a form with Modal=Yes will always be on top, so if you change that setting...

I’m trying to format a control on a continuous subform based on the value of another control on that same subform. Main form”frm01Study” has several subforms, one of which is “frm03SpecialtyAdoptions” in continuous view. Two of the controls on this subform are AdoptedSpecialty (a text box)...

Thanks Pat. I tried that but to no avail. Brand new db with freshly imported objects, moved it to the A2007 PC, wouldn't open! I've given up and have rebuilt from scratch. I could save my queries' SQL and forms VBA to text files and re-use them (although labouriously) in the new db. I...