Search results

Yeah sorry report layout was what I meant - just so you can see the report running, if you will, but still have the property sheet displayed. Type in the filter string into the relevant box in the property window and see if that works OK...

Er, skip it then - but have a look at this thread: http://www.access-programmers.co.uk/forums/showthread.php?p=1025736 Banana is basically saying that if you don't actually need anything that's specific only to Access 2010, you might as well stick to a file created in 2003 - 2010 will still...

Well - I've only ever used Access 2007 but I'm pretty sure there is a user level security wizard on there too, have a look in the help file, it'll explain everything.

Welcome to the forum Colin! This is a great site to learn Access, with a lot of experienced people that have helped me out loads... Have you got a project in mind yet?

You could use DLookup here, but having passwords stored in tables like this isn't really the best way of securing your database. For example you can bypass all the startup forms and get access to the tables simply by holding the shift key as you open the database. You're better off using the...

Although - there is a function called DLookup which sort of works in the same way - have a butcher's in the help file at the syntax and see if that does what you need.

Hi, welcome to the forum! Databases don't work in quite the same way as a spreadsheet. If you're looking for a single value, you have to navgate to the correct record first and then get the value out of the field you want. That's a very vague description but if you can describe your project in...

That'll be a crosstab query - use title as the row heading, month as the column heading and a sum (or whatever) of sales as the value.

Gold star for randomest comment of the day, jarryslink :)

What happens if you put the filter string in the form's properties in layout view?

Bugger.... only other thing I can think of is to run this in VBA and substitue a variable for the criteria, which in turn is populated by a select case statement:Dim QryCrt as string Select Case comboname.value Case All QryCrt = "*" Case Else QryCrt = "Between...." End Select docmd.runsql...

I'm not sure if like and between work together - tryIIf([Forms]![Frm_Analysis]![Field1]="All","Like '*'","Between ([Forms]![Frm_Analysis]![Field1] -30) And ([Forms]![Frm_Analysis]![Field1]+30)")as the criteria for your query. This is a bit of guesswork - I'm not sure if the iff statement just...

Have you thought about using the user level security wizard that comes with Access? It'd be much more secure than this - as it stands a user could just ctrl-break out of the code at any time and get into the back end of the DB....

You could do it in VBA on any number of events, depending when you want the filtering to occur:me.filter = "[Certain Field]='XRAY'" me.filteron - truein a form event would do the trick.

You should be thinking about normalising all your data fields - common fields should all be of one data type, otherwise you're going to keep running into problems like this....

Yeah, thought that would be the case. I'll have to bug the boss and get him to buy me another PC then! Cheers Dave!

Hi, welcome to the forum! Yeah that's a few threads there, start with: 1. A data access page should do the trick here. 2. You can populate fields in forms using VBA, but there are a ton of methods to do it, depending on how you're making the selection and where the data is. 3. You'd just use...

Hi, welcome to the forum! It looks like you're trying to create a crosstab query there, am I right? Or is it static values that you want at the top of your form? Not quite sure from your description... could you upload your DB, minus poersonal data, so we can have a look?

Happy Friday to one and all! So, using Access 2007, I've finished version one of the DB I've been writing. It's ready to send out so I made an MDE of it - which doesn't work with 2003. I've done some googling and found out the 2007 MDEs don't work with 2003 'by design', which is bonkers, but...

Have you tried taking the like out?