Search results for query: *

Firstly I am not sure if this is the right forum, apologies if it is not. From tSQL dataset we have a value which comes out as a total number of seconds. We need to display this as HH:mm. we thought we had it cracked when we found: =Format(Timeserial(0,0,Fields!TotalTime),"HH:mm") However...

Good afternoon, When running the following code i get a Compile Error "Loop without Do". Have also tried it with a For - Next loop but similar results. Any ideas? there are no other do's or loop's within the module y = 8 Do y = y + 1 If dots >= 5 Then dots = 0...

Private Sub dd_Name_Change() Dim strSQL As String strSQL = "UPDATE tblVar SET [AgentID]=" & Form_frm_EditAgent.dd_Name.Value & ";" DoCmd.RunSQL strSQL DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70 End Sub What the above should be doing is when the...

I run the following from a command button: Dim strSQL As String strSQL = "SELECT tbl_Agents.[AgentName], tbl_Agents.[Aspect_No] " & _ "FROM tbl_Agents " & _ "WHERE tbl_Agents.[TM_ID] = " & Form_frm_TMs.dd_TMID.Value & ";" DoCmd.RunSQL (strSQL) And get...

I have a query lets call him Bob_The_Query. And i have a boolean who we will call Ted_The_Bool I need VBA code which will return Ted_The_Bool as True if there are no records returned whan i run Bob_The_Query. All help is muchly appreciated.

Have a query that i want to build but am not sure of the terminology to search for so I will attempt to describe the problem: I have two tables [b]tbl_Names[b] Name Andrew Simon Barry [b]tbl_Records[b] Name|Product Andrew|Apple Andrew|Banana Simon|Pinecone Barry|Apple Simon|Apple Dave| Apple...

Am new to SQL and Queries in general I have two tables, i need to display the number of times each name appears in each table. If the name doesnt appear in one table but does in the other it should display a null value for the first table. And vice versa. I came up with the below: SELECT...