Search results for query: *

I'm querying against 3 tables to get a count by type and year. The problem is that my counts are off as there are values in dbo_t_goal.assignedTo that are not in table ConsolidateGroups.user. I was attempting to do a left join to pick up those values in dbo_t_goal.assignedTo, but I keep...

Good morning, I'm trying to update a column in 1 table based on information in 2 other tables. No matter how I format the SQL I keep getting the error: "Syntax Error (Missing Operator) in Query Expression 'UsersAndGroups.ACL FROM ConsolidateGroups'. The actual statement is below. Any help...

I also use Textpad and it's great. A coworker of mine uses Homesite (I believe it's by marcromedia).

SleepingSand, I too have a similar problem as mwa. Your suggestion works great if there is no need for a where clause. I've tried different things to get your solution to work with a where clause without success. Do you happen to know how to get it to work with a WHERE clause? Thanks in...

faxof, I just want to make sure my last post answered your question. I don't want to leave you hanging. If it didn't answer your question please let me know. Thanks

faxof, just add the following line of code under the .Application.Cells(iCnt,1) = m_File.Name line: .Application.Cells(iCnt, 2) = m_File.DateLastModified This will put the last modified date in column B for each file in column A. ~Kevin

can you post some of the code that you're using. I want to help, but don't want to take things out of context. thanks

It looks like you're just trying to loop through a directory on your machine and pull the file names into excel. If this is the case try the code below: ------------------------------------------------------- Dim m_FSObject Dim m_Folder Dim m_File Dim m_Files Dim iCnt Set m_FSObject =...

faxof, Try this code in VBA: ----------------------------- Dim m_FSObject Dim m_Folder Dim m_File Dim m_Files Dim iCnt Set m_FSObject = CreateObject("Scripting.FileSystemObject") Set m_Folder = m_FSObject.GetFolder("m:\apps\usage\ad") Set m_Files = m_Folder.Files For...

Doug, Rather than having them type directly into word, why don't you also provide a text box for them to enter their comments. Then you don't even have to visually open word for them to enter the information. you can just create an invisible instance of it and everything will be passed...

There's a property called "Gridlines". One of the options is "0-flexGridNone". It can be set at design time (and I'm assuming run-time as well). Hope this answers your question. ~Kevin

The only way I've figured out how to do it in the past was as follows: Go to the directory where your original form resides. Copy the form file (.frm) and paste it into the same directory. Rename the .frm file to whatever you want. Then double click on the file to open up a new project. In...

Kelly, Here's some code to get you started: ----------------------------------------------- Dim m_objFSO As Scripting.FileSystemObject Dim dtToday As Date Dim oldFile1 as String Dim oldFile2 as String Set m_objFSO = New Scripting.FileSystemObject dtToday = Now() oldFile1 =...

When I first started working with SQL, I picked up the book "SQL For Dummies". It turned out to be a valuable and inexpensive reference.

Assuming your record length(s) are fixed, you could place the following code in a module: ************************************ 'Define a custom data type Public Type timeCardData sVal As String * n 'where "n" is the record length for 'each line of the flat...

Workshop, Try this formula in cell c1: =CONCATENATE(B1,CONCATENATE("0000",A1)) Hope this accomplishes what you were trying to do. Thanks Kevin

What do you have the "STYLE" property set to? If it's set to checkbox, that could cause a problem. There may be some other property that's causing the multiselect to revert back to 0 but STYLE is the only one that I know of that could cause a problem.

In the listbox properties window, all you need to do is modify the multiselect property. You can change it to "1-Simple" or "2-Extended". The simple setting lets you choose multiple entries without holding down the control key. When set to extended, you need to hold the...

Bobby, I'm not sure if I totally understand your question, but if I do, here's what you can do: In your word document, type in a name for your link. Highlight the text you just typed and choose "Insert" then "Hyperlink" from the menu. In the resulting window, just type...

using VBA you can manipulate the menus. If you wanted to prevent the users from touching any of the main menus you could write some code similar to below in the Workbook Open even: ------------------------------------- Dim cb As CommandBar Dim cbControl As CommandBarControl 'Loop through all...