Recent content by kenwarthen

That's a nice sample database, but it doesn't specifically answer my question as to how to split a string value like "1437|1.00|10 for 10" into the pipe separated values and display those values in their own textboxes. Ken

I have a report based on a crosstab query in an Access 2007 database. Some of the report's textbox controls display values that look like "2349|1.00|10 for 10". I'd like to split the values separated by the pipe character and display each in their own textbox control. Any help or advice on...

Sorry. The rest of my code snippet got dropped Dim rs as Recordset Dim strSQL as String Set rs = Currentdb.OpenRecordset(strSQL) With rs 'Put your recordset code here End With rs.close Set rs=Nothing

Try using DoCmd.OpenQuery("QueryName") instead of the SQL statement. If you're going to use a SQL statement try something like the following Dim rs as RecordSet Dim strSQL as String Set rs = Currentdb.OpenRecordset(strSQL) With rs

I've had similar problems with SQL statements. For me it's usually a syntax issue that my bad eyes missed. particularly with quote marks nested within double quote marks. I like to put a Debug.Print statement after the creation of any SQL statement in my code. That helps me spot syntax...

Mac, Take a look at the attached database. I've added five images that display when the labels F1 through F5 are clicked. Is this what you were looking to do? Ken

Open your form in design view. Access has an image control on the toolbar. Click it, and then click anywhere on your form. Acces will prompt you for the location of the image. Select your image and click the open button. The image should now appear in the image control on your form. Give...

Put each of the images you want to display in controls that are exactly the same size and in the same position on the form with each control's visible property set to No. In the OnClick event of your command buttons enter code to change the visible property of the desired control to Yes.

Sorry, my browser crashed. You can set the ribbon name of a form using Me.RibbonName = "rbnName" Ken

You have to uncheck the Display Navigation Pane in the Current Database settings for Access options, or from VBA you can select an object in the Navigation Pane and then hide the active window using the following code: DoCmd.SelectObject acTable, "tblContacts", True...

With your form in design view, right click on the ListView control. A pop-up menu will appear. Select Properties from the ListViewCtrl Object item. A multi-tabbed dialog box will appear. The properties I discussed in my earlier post are on the General tab. Ken

If you're looking for the Office icons for applications, like Word, Access, Outlook, etc., you can get them from your installed software using a free utility like IconsExtract. If you're looking for internal application icons like the ones you see on buttons within an application, Microsoft...

Interestingly, your ribbon works fine on my machine. I believe the only reference required for Ribbon customization is Microsoft Access 12.0 Object Library. When I did my first ribbon customization I didn't want end users to have access to all of print preview features and functions. I found...

Sue, I plugged your XML code into my USysRibbon table in an Access application I have developed an it displays without error. I use the Office 2007 Custom UI Editor to test my XML code for syntax and other errors before pasting it into the USysRibbon table. It found no errors in your code...

Forms!formName.labelName.caption = "Whatever"