Search results for query: *

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] = " &...

Thanks for your reply, i'm not sure what you mean! Could you expand a bit? On the form i have set the format to dd mmm yyyy, will this not do the same thing? i also have the column in the table set to the same format. would this explain why its saving at 00:00:43?

Sorry, i usually post my code - someone mark me down for a school boy error!!!! - Forms are not bound, code below (as i'm using the form i've commented out the problem code so i can continue without error) code to validate check box & Field Value: If Me.ChkLaunchDate.Value = 0 And...

Hi All, I have a field on a form that captures a project launch date, i have this field in 2 places, in the 1st place its been for a while and works perfectly, and i now want to add it in to another form as part of an update. On both forms i have set "medium date" as the input mask, and have...

Here's all the code: If Me.ChkPaCode.Value = 0 And Me.PACode.Value = "" Then MsgBox "Please enter PA Code or tick box to continue" End If If Me.ChkOneView.Value = 0 And Me.Oneview123.Value = "" Then MsgBox "Please enter OneView ID or tick box to continue" End If If Me.ChkDelMan.Value = 0 And...

Sorry, no i've got 5 values, some will be populkated in the DB some not. I have managed to get my original code to work, what i've done is in the OnLoad i've set the value of all 5 text boxes to "" and all 5 check boxes to 0, then i've run my SQL to pull the data from the database, meaning that...