Search results for query: *

Everytime I run the following code: SELECT (All_Urls.[Computer Name]), (-1 * (All_Urls.[URL Address] LIKE '*att*') * Sum (All_Urls.[SumOfTotal Time])) AS [SumOfSumOfTotal Time] FROM [All_Urls] GROUP BY (All_Urls.[Computer Name]); I recieve an error stating: You tried to execute a query that...

Everytime I run the following code: SELECT (All_Urls.[Computer Name]), (-1 * (All_Urls.[URL Address] LIKE '*att*') * Sum (All_Urls.[SumOfTotal Time])) AS [SumOfSumOfTotal Time] FROM [All_Urls] GROUP BY (All_Urls.[Computer Name]); I recieve an error stating: You tried to execute a query that...

I have this in a module called import: Public Function Import_Data_Enter() Dim strFileName As String ' you could make this global if need be dlgCommon.ShowOpen strFileName = dlgCommon.FileName If strFileName = "" Then End DoCmd.TransferText acImportDelim, "import&quot...

Everytime I run this code, DoCmd.TransferText acImportDelim, , "Activity_File", strFileName, False I receive the followin error: Run-Time Error '3066': Query must have at least one destination field. The problem that I cannt figure out is that Activity_File is a table not a...

Like the title says i need to programmatically import a text file into access. I found that I can do this from File->Get External Data->Import. I also found the macro code for transfer text. Transfer text would work except that my file name that I import from changes. For instance the name...

Hello All, I have two modules that need to be ran from the switchboard and I was going to use a macro to run them, but I can not figure out how to do this...Can some please help. The idea is so that if runme is selected it will excute the code in the runme module. Thanks for everything. Shane

How do i write a macro that would create/undo relationships between tables? For instance if I have table1 and table2 both with phone number as a feild. I know how to manually do this and it works but I wanted to write a macro to do this. Thanks, Shane

Hello, Here is what I am trying to do…Not sure if it is possible: SELECT [Activity File].[Computer Name], Sum([Activity File].[Total Time]) AS [SumOfTotal Time] INTO [ATT/IBM URL's By Computer] FROM [Activity File] WHERE ((([Activity File].[URL Address]) Like "*att*" Or...

Hello, Here is what I am trying to do…Not sure if it is possible: SELECT [Activity File].[Computer Name], Sum([Activity File].[Total Time]) AS [SumOfTotal Time] INTO [ATT/IBM URL's By Computer] FROM [Activity File] WHERE ((([Activity File].[URL Address]) Like "*att*" Or...