Search results

Hi all, So sorry if this is a really stupid question, but it's been bugging me for a while and i can't find a simple solution. I use custom categories in the navigation pane to make finding the right objects easier (duh) but now I have quite a lot of custom categories and they are stuck in the...

I haven't even clicked the link yet, just wanted to say thanks for the reply :D

Hi all, I have never used Access to create charts and graphs before, I have always found Excel to be the better tool for that particular job. As a consequence I have never really learned how to do charts in Access at all... But... I have been asked to get one of our more complicated reports to...

Thanks I just put the items from the left into a sub form, it's a bit of a faff but perfectly functional. I Just needed a common sense way of looking at it :) Cheers,

Hi all, I was wondering if there's a way to set objects so that they don't get pushed down if an object above is set as Yes in the CanGrow property? Alternatively, can a report be split into columns? I know this would usually be a stupid idea, but I have been asked to replicate a form...

Hi all, I don't know if you ever solved this but I have had the same problem and just spent two hours on Le Goog trying to figure it out... So for the sake of anyone else who finds this thread, here was the painfully simple answer which worked for me... Set the parameters in the Select query...

ah the extra set of brackets trick... I tried this before and found it didn't help, but now having tried it again I can see it does! I've been playing around with it, it seems the code only changes if it is saved and reopened in the design mode (rather than SQL view) my guess is Access...

Hi all, I have written a query which allows the user to search records of a table of incident information based on a number of criteria (for example sake let's limit that to PersonnelID, SiteID and TrendID). I've done this simply by specifying that each criteria equals a control on a form, or...

Hi all, I have a quick question but it's basically impossible to google an answer! You know when you want to point at a control, you typically write =forms!myform!mycontrol... But I've always been curious; when you start to write, Access suggests what you might be looking for, and right off...

Just brain-farting here, but I suppose technically, this presents a many to many relationship between employees and PurchaseRequests, as each PR can have one, two or zero employees, it's then down to the joining table to declare whether that employee is raising the request or authorising it...

Hi all, Sorry if this is a dumb question but I'm struggling to find an elegant solution to this one - yet it seems so simple. I have a table called 'PurchaseRequests' which contains two fields both of which relate to an 'Employees' table; one field is RequestedBy and the other is AuthorisedBy...

Thanks as always, my sanity is saved.:) Edit: Oh except it's still removing the £ symbol and not showing the final zero if it's something like £1.90 - but I should be able to fix that in the query too...

Hi all, Sorry if this is a really dumb thing to ask, but I can't get my control to stop showing all the decimal places when the user clicks on it. To be clear, I have a text box showing an average price. I have set the format property to currency and set decimal places to 2, which appears fine...

It's a sad day JHB, I printed it and same problem, the ones that were loaded at the time printed but the rest is blank. This is making so little sense right now :confused:. You can do that??? I can't figure out how, do tell :)

Hi JHB, yes I've been displaying in print preview, this is where i noticed the problem. But I tried putting it into layout view and strangely the images did load, although it was a lot slower. Not sure if i can get the users to print from this screen though... thanks,

Hi All, I posted a question the other day about using hyperlinks to display pictures on forms and reports (http://www.access-programmers.co.uk/forums/showthread.php?t=257891) and the problem was solved (thank you Access-Programmers!) However I am now encountering another problem in that they...

I was going to ask why but then I found this: http://allenbrowne.com/casu-14.html I will move the calculation. thanks again!

Paul you are my savior once again, it worked perfectly thank you very much :) For the benefit of anyone else in this situation, here's my solution: - create a calculated field in the table with the hyperlink address (called evidence in my case) - set the calculated field to this, using Paul's...

Hi all, I have a database which creates hyperlinks to a network folder full of images (too many to attach to the database) but I can't figure out an easy way to show those images in forms and reports. I think I'm 90% there, looking online I figured out that if i create a text field (not a...

Hi Chuck, This is fantastic thank you for writing in so much depth. I have some questions though so I hope you still check in online :) My trouble is with the export code, how do I tell it where to save the files to? Here's the code I copied off you, highlighted where I changed to my own...