Search results

Another thing to try is to wrap the criteria parameter reference in the record source with an eval function. ie: instead of: Forms!Yourform!Yourfield try: Eval("Forms!Yourform!Yourfield") Sometimes this helps resolve parameter prompts in various situations. Sometimes not. Easy to try though :)

Assuming you've gotten the SQL right for the lookup, there will be two columns in the source query. The drop-down will show only one column at a time, and that column is the first visible column. So, if you are storing the number value from the first column, but want to SEE the text, then you...

Good point :)

A slightly different wya of doing it would be to do something like: If Weekday(Date) = 2 then Set Fn = fs.Getfile("H:\RIMARY D.002") Else Set Fn = fs.Getfile("H:\RIMARY D.000") End if That way, if the day is a monday it looks for the other version. Otherwise, it uses the standard...

There should be a space after the table name... not sure if that's the only issue but it's the first one I see. If that doesn't work...try using Msgbox strSQL, vbinformation to look at the sql statement just before you execute it. It may show you the problem.

Yep...much the same as Stopher's. I came up with it independently but hadn't noticed there were other replies beyond the first page, so my post was redundant. As for the point I was making, your output required a piece of information that was not inherent in the data you were using. The first...

I tested it in a quick db and the function itself works fine with Bob's modification to the input datatype. The issue may be to do with how/where you are calling the function. If you're using this as the control source for a textbox control it should look like: =VRSVfMScore1([textfieldname])...

Edit: Never mind. Didn't see there were two more pages of replies after the first page. :o Lagbolt is right. However, it can be done. The key is to recognize that you're asking the database for information that you haven't expliclty provided to it. To whit: look at ytour output. There's a...

Are there any vba modules that set the SQL of that query programmatically? Maybe the sql is being rewritten when you perform some other task during use of the database. ???

In your db, the text box control that is bound to the RentAmount field is named 'MonthlyRent', whereas in my example all the code refers to a textbox control named 'RentAmount'. If you change the control name accordingly, it should all work. Once you've made the change, re-enter the weekly...

Try: IIf([Dt] Between #08/01/2010# and #08/07/2010#, "Wk1", "WK2") Er, Ninja'd :)

Not sure what your experience level is but, assuming you know enough to use vba to execute a SQL statement, I would simply use the after update event of your 'denied' control, to ask the user whether they wish to create a 'duplicate' record for the approved action to be recorded on, and if so...

I use this method to export queries that use search criteria derived from forms all the time. Of course, I never use the form filtering approach so it hadn't occured to me that he wasn't using a parameter query as the source for his subform.

Have you looked into the Docmd.TransferSpreadsheet method? http://msdn.microsoft.com/en-us/library/aa193071(office.10).aspx

Not sure what you're doing to cause that issue as the expression works fine for me. I can't really debug your situation without seeing the database itself but here's a quick and dirt database I whipped up showing the code working just fine. Maybe you can figure out what you're doing wrong by...

Hmm. Well, not to be a jerk, but your table design is about as non-normalized as I've ever seen. Repeating information within fields, between fields, lack of primary keys, etc. Relational databases do not function remotely well if they're not normalized. The way things stand right now, you're...

Er...what? Where did this StaffMember field come into play? I don't see it referenced in your OP or in the If statement that TrevorG provided. You would only include the staffmember field in your rates table if the rate depends on two things: the date and the specific staff member. And if that...

Happy to help :)

Trevor's suggestion will work but I'm not sure I would take the same approach myself. Let me paint a scenario to demonstrate the issue I see with it. You implement the suggestion and everything goes swimmingly and the database is completed and put into production. However, the bean counters...

I have barely touched Access 2007 but this source ( http://msdn.microsoft.com/en-us/library/bb258192(office.12).aspx ) seems to indicate that you can't disable the ribbon entirely, at least, it seems like maybe you have to replace it with a customized ribbon instead? (so I wonder if you can...