Search results

Hi, I've created an Access 2010 database and have now found it won't open in Access 2007 which most of our users still have. Is there a way for me to find out which parts of it are causing the problem? I haven't used any fancy new functionality (wouldnt know how to!!) but could Access have put...

Hi, See attached for how I would do this. Bringing all the data together is sensible, then you just need a query to search that data and a form to show the results. I've done this using frmSearch and a subform called frmSearchResults. By removing record selectors, navigation buttons etc...

Sorry...I'm an idiot. I didn't need to refer to the form at all. =DLookUp("[PI Email Address]","PI Names","[Name]=[PI]") works. I engaged keyboard before brain again :o

I have a control named PI on my subform which looks up values from a table called "PI Names" (principal investigators of clinical studies, not private eyes!!) This works OK and allows me to select an entry. Now I want to have the PIs email address, which is stored in the same table, displayed...

Hi, My form is based on a SharePoint list and contains a field called UKCRNID (in SharePoint this is set as a number with 0 decimal places.) My form also contains a label called ViewPortfolioDatabase and I want this label to be a hyperlink, which will change with the value in UKCRNID. E.g...

D'oh! I just spotted a missing dot at the start of the Attchment line in the code. I'd assumed it was a problem in the way I was syntaxing (is that a word?) the filename, but it was far simpler error! This now works and I'm off to experiment with adding the other 29 filenames. I'd still be...

Hi, Using Access/Excel/outlook 2003 for the following I have approx 30 Excel workbooks to send to 30 different email addresses, one each. I'm a complete novice at this stuff and have read lots of posts in lots of places without fully understanding it. The closest I have come is the...

Yes I think you're right. I remember where I got the brackets from. I googled some help last week and found this site http://www.vbtutor.net/lesson10.html ...and evidently misunderstood it!

Thanks Bob. That works a treat! So no brackets required then? Now where did I get the idea I needed those? Note to self...*MUST read help more carefully* Thank you :)

Hi, I'm just dipping my toe into message boxes, never really having had a need for them before. What have I done wroing in the following? MsgBox ("That's not a Monday." & Chr(13) & Chr(10) & Chr(13) & Chr(10) & "ALWAYS enter a Monday, even if the data was downloaded on a different day for any...

OK. I kinda thought that might be the answer. Thanks for your input. My data is already linked to an Access db anyway, so it's no big deal to do a crosstab query instead. I'l need to resequence a couple of processes, is all. godsspeed - good to know I got your wheels spinning!

Thanks for the suggestion. So I'd always need one dummy record for each of the 4 categories? Yeah, maybe I could do that, though that in itself might throw up other issues. There's nothing I can do in the pivot table itself then, it has to be done by manipulating the data?

I know that in an Access crosstab query, I can force column headers to display even if there's no applicable data. Is there a way to get an Excel pivot table to do the same? I'm using Excel 2003 by the way. For instance, my categories will be "<=30 Complete", ">30 Complete", "<=30...

Thanks for that. The delete-then-append works fine, I assume because I'm deleting records and not the actual table. Still kinda puzzled why my way didn't work, but not gonna stress about it :rolleyes:

It's WINDOWS. "Close all the WINDOWS...".

Mary comes home to Belfast after years in London and gives her mother a present of a brand new fur coat, a diamond necklace for her sister and some flash designer gear for her brother. "Mary, you must be doing very well in London", says her mother, "What line of work did you say you were in?"...

Hi - Just wanted to come back and say thanks. That worked. I really appreciate it!

Where do I put that code? In the On GotFocus event of the form I'm coming back to (form 1a)? Or in the After Update event of the contol I update on form 1b? Or somewhere else? Pat, thanks for the tip about saving the record position. The particular "view" shown is unlikely to show more than...

I have a query which joins two tables and includes various calculated values. Form1a shows the results of this query in continuous view. Form1b shows records from Table1 in single-view with a sub-form 2, based on Table2 in continuous view. Each detail line on form 1a has a button which opens...

vbaInet: Yes the table exists. But in my other dbs when I run a maketable query it warns me that the existing table is about to be deleted. In this database it does not give that warning, but tells me that my table already exists. I *know* it does, so I want to delete it and remake it (based...