Search results

No problem. Always glad to lend a hand.

Open the properties for the sub-form and set "Data Entry" to "Yes".

No problem.

Yes, I can understand that IT departments can be frustrating to work with. But unless you control the back-end as well as the front-end, you gotta play their games. Sorry it's so frustrating for you. Let us know if there's anything we can do to help.

That is a quote mark. You probably have a quote matching problem. Try doing a Debug.Print of the filter at each step as you build it until you find the problem.

I fear regardless of what you do, you'll need IT buy-in. They'll need to give you a user ID, probably one for each user (so they can control security as employees are hired/fired). Your SQL DBA will also need to set up security on the database or its objects.

Hmmmm. Is this on a company network using Windows? If so: On the second screen of your ODBC setup, you can click on the "With Windows NT authentication using the network login ID.", which will not require you to install anything but the ODBC driver on all the machines. Then in SQL Server...

No problem. Enjoy!

No quotes. I'll try it when I get home tonight in a different version. Agreed on the rest.

I just took a quick look. You don't need to do all this. You can use a simple form (with no subform) to accomplish this. In fact, you shouldn't have to write any code at all unless you want a little finer control. Check out Allen Browne's search demo: http://allenbrowne.com/ser-62.html...

Is there a reason you wouldn't use Windows authentication for this? Then the user wouldn't have to enter a SQL Server login and the DBA can control individual security if needed. If not, try reading Banana's excellent ODBC article on this site.

Of course, the experienced gentleman with an excellent taste in reading material got it right. Microsoft has a nice little tutorial on his recommended method on the Office/Access training site. On my version of Access here (2003), I get a "#Error" message when I use "=Sum(0)". Any idea why...

This is a tough problem to overcome. For the first part, just store the images in a database table via an OLE object. Microsoft has a nice writeup on that here: http://office.microsoft.com/en-us/access/HP052802251033.aspx To make them smaller, you need to convert them to a more compressed...

The simplest way is to use Access built in "Filter for:" functionality. You do this by right clicking on the bound field you want to filter on (at run time) and typing in your criteria in the "Filter for:" section of the context menu. If you really insist on writing additional code to do this...

I consider myself a moderately intelligent guy but I have no clue what you're asking for. Can you re-state the problem?

You didn't mention the symptom. But you can't do a sum on "0". You can verify this statement by using this: =Sum(0) This should give you an error. Try something more like this: =IIf(me!Invoice.Form!chksent=True,Sum(me!Invoice.Form!txtinvoiceamount),0) If that doesn't do it for you, post...