Recent content by policechiefwiggum

So I have, Thanks SkipVought. Updated, but still getting the same issue! :( FROM ((((((((((((((dbo_ENTITYFAMILIES as x Inner join dbo_ENTITY as a on x.LENTITYFAMILYKEY = a.LENTITYFAMILYKEY) Inner join dbo_ENTITYSTATES as b on b.LENTITYSTATEKEY = a.LENTITYSTATEKEY) Inner join...

Hi All, Ok, this has nearly make me go bald from pulling my hair out! I have a bunch of SQL that is run in Excel that i need to move to Access. Most of them are working fine, but this one is really causing me problems!! SELECT x.SENTITYFAMILY AS [Entity Family], a.SENTITY AS [Entity]...

Thanks TheAceman1 & Majp Searching as you type is what I initially wanted to do, but what I've ended up doing is having an IF statement that runs query 1 if the text box is numeric (using a unique reference column in the query) or runs query 2 (using a text column) because i want o run these 2...

Thanks SkipVought looks like we replied at the same time :)

OK, maybe not the best solution, but i've just changed the text box to a list box and set my sharepoint query as its rowsource

Hi All, I have a linked table that pulls a load of data from an SQL server, i then have a query that filters this data and that query is used as the rowsource for a list box. I then have another linked table that connects to a SharePoint list. This list has a query that takes the ID of the...

Hi All, I have a query that connects to a SQL server and pulls back some data (obviously!) The query pulls back over 2000 results, which is fine as i can navigate through this using the Navigation buttons in the query. I've then got a form which has a List box, that displays this query. What...

Thanks PHV, that was easy :D

I have a login form that has 2 text fields (username & Password) and 2 buttons (login & Close) Currently when a user enters their password and hits enter, all that happens is the next item in the tab list is selected (the login button) so the user has to either press the enter key twice or use...

I should probably add the above is using Access 2010 - i have previously done this but on Access 2003 using an ADODB connection which 2010 doesnt seem to support :(

Hello, I've been looking on google for a few days to try and figure out how to do this, and i've now confused myself! I have a combobox which users will select a product. They then need to launch an external application and an XML file associated with the product. I have the combobox...

Thanks everyone for your suggestions. I'm going to go and sit in the corner with the dunce hat on!! SkipVought you were right! someone had added another project with the same name in to the DB, and obviously the way i've coded it, hasn't allowed for that to happen! Deleted the 2nd entry and...

Thanks for your suggestions guys, still no luck! Me.select_proj.Value = "" Me.ViewProjectIndex.Value = "" Dim ProjectRowSource As String Dim user As String If Trim(Me.select_tester & "") <> "" Then ProjectRowSource = "SELECT [ProjectTitle] FROM [projects] WHERE [UATTester] = '" &...

Hi All, I've started to get an issue with an IN statement. Code below Dim ProjectRowSource As String If Me.select_tester.Value > "" Then Me.select_proj.Value = "" Me.ViewProjectIndex.Value = "" ProjectRowSource = "SELECT [ProjectTitle] FROM [projects] WHERE [UATTester] = '" &...

Dhookom, thanks for your reply Dim strDateDelim as StringstrDateDelim = "#"UpdateProjectSQL = "UPDATE [projects] SET [PACode] = '" & PACodeSQL & "', [OneView] = '" & OneViewIDSQL & "', [DelManager] = '" & DeliveryManagerSQL & "', [PM] = '" & ProjectManagerSQL & "',[LaunchDate] = " &...