Search results

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()...

Realizing I'm a total idiot now. I found something within one of the controls that was causing the problem. Duh! Sorry to waste everyone's time. BTW, yes there was supposed to be that difference between Buy and BY...Thanks for catching.

I have a section of VBA that is working almost 100% properly, but I'm having trouble with something. When I double click on a property within Form A, then Form B opens and much of the data is filled in based on the values in Form A. I recently added two properties to Form B and just like the...

pbaldy is the man! Thank you! That was the problem.

Sorry, forgot to post the sql SELECT [LiquidationTies].[Brand] + ' Mens' & IIf([AttributeData_Ties].[AZ_pattern_Style] Is Null,'',' ' & [AttributeData_Ties].[AZ_Pattern_Style]) & IIf([AttributeData_Ties].[AZ_theme] Is Null,'',' ' & [AttributeData_Ties].[AZ_theme]) &...

Thanks pbaldy. Always so helpful :) I did the debug.print strSQL. Then i took that string and put it into a query designer. it worked exactly as I needed. The error I'm still getting is: Run-tim error '3061': Too few parameters. Expected 1. I also fixed my variables I was setting to...