Recent content by benkingery

Thanks pbaldy. Is there a way to do a big long static string where the filtered results will not be compromised by a non-entry into one of the fields? Does this question make sense? Is it possible to list out all 12 fields as I've done, but if there is not value in a particular field, the...

Lots of information there, kind of tough to get through with all the specific syntax, but I gather this is probably how this will go. Most of the examples you gave on that tutorial deal with opening a recordset. If I can successfully get the record set to open by building a specific "WHERE"...

I have a form that is showing data from 1 table. That table has 12 different fields on it and I want to be able to filter based on selections I make in a combo box in the header of the form. The filter string must be dynamic enough to allow filtering based on 1 criteria selected, or multiple...

I have a user login form wherein my users authenticate their employeeid as well as their person PIN. If the user authenticates with a valid username/password combination, then the employee id and the role (permissions) for that user are stored on the form and it is minimized to stay open. If...

I have a module like this: Public Function DisplayImage(ctlBrowserControl As Control, _ strImagePath As Variant) On Error GoTo Err_DisplayImage Dim strDatabasePath As String Dim intSlashLocation As Integer With ctlBrowserControl If IsNull(strImagePath) Then ElseIf Left(strImagePath...

I have a table that contains: item | quantity 123 | 1 456 | 10 789 | 4 I need to get this data listed into a table that just has item and for it to look like this: 123 456 456 456 456 456 456 456 456 456 456 789 789 789 789 I understand and have accounted for the obvious primary key issue...

Boblarson, I do have to say you're a genius. Sorry I'm just getting back to this right now. I went on an extended vacation. I just conducted the process with a test version of the DB and it works perfectly. Thank you for all your help.

Seriously, thank you!

Boblarson: Hey I downloaded your program. It has 3 parameters to input before you begin. One of the parameters is the Access Database Back end. I am using a SQL server and connecting through ODBC. Can I still use your solution? Thanks

Oh I like you Boblarson :) Always knew I did. I'll give that a try next week. That also appears that it would be a good function for deploying changes and updates from a central location. I'll follow up with you then.

Distributing that on my network and managing updates would be an absolute NIGHTMARE. Doesn't that kind of defeat the purpose of using Access a an engine for concurrent users?

Yes. Every IS opening the same DB from a network location. They are all sharing the same access file on a public drive

I have an Access front end linked to a SQL Server 2005 back end via ODBC. I have anywhere from 1 - 5 concurrent users in the DB at any given time. I am having some users begin to complain that their Access file freezes every time another user is logged in and has a particular form open. They...

I should have done a little bit more checking. Looks like I needed to concatenate in the value of the form control I was calling in the SQL statement because SQL statements in VBA don't have all the same functionality as SQL statements run through the query section of Access. A great article...

I think I almost have this recordset functioning properly, but I'm a little amiss. Can anyone help me out? I'm trying to update several fields on a form from a recordset. This is what I have: Dim strSQL_AZ As String Dim db As DAO.Database Dim RS As DAO.Recordset Set db = CurrentDb()...