Search results

Why can't you use the & operator? Is this in VB6 or VB.Net?

In order to set your strLastRecord variable you need to assign it to a recordset. As you have it there, it assigns it to the sql text, but doesn't give it a value. One method would be to run code like below to assign Public Function getLastRecord() As String Dim db As DAO.Database...

Just last month I did something eerily similar to this. It was in VB. We had a list of Cost Centers and within each Cost Center there is a list of Managers. For reporting we needed to create a seperate workbook for each Cost Center and then a worksheet for each manager in the Cost Center...

Wow. That was weird. When I posted this question it would only show me the default East, West, North, South datapoints in design view. There was no option to change colors or anything. After your posts, it now shows my datapoints and is allowing me to change the colors. **Twilight Zone**...

Here is a way to fill your listbox. Private Sub Form_Load() Dim LoadFiles As String Dim strFill As String LoadFiles = Dir$("c:\dev\*.*") Do While LoadFiles > "" strFill = strFill & LoadFiles & ";" LoadFiles = Dir$ Loop lstFiles.RowSource =...

[RESOLVED] Altering Chart Properties? I have a line chart built in Access. Is there anyway I can change the line colors like I can in Excel? The default fuschia, bright yellow, and bright blue are horrendous.