Search results for query: *

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]...

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...

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...

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...

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

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...

Hi Guys, sorry, back again! I'm having a bit of trouble with an if command, i think i know what causing the issue but not 100% sure how to sort it. i have a form which has a text box and a check box, if the user has not entered a value in the text box or checked the tick box i want to display...

Hi All, Sorry i'm not 100% on the correct term's. I have a part of code that that i've called 'ValidInput:' this is part of a very long code, what i want to know is if i can call just this part of code from another form? I've set the whole piece of code as a public sub, which i assume is...

Hi All, I need to write an if command to run based on the value of 4 fields. i have a form that has a lot of fields (25 at the last count!) from that there are 4 fields which are vital, but the data is not always available. what i've done is made a form which pops up when the "save" button...

Hi All, I have a field, that i need to put some validation on, in order to pass the field value to another form, previously i've had a hidden caption with Me.Change_Made.Caption = Me.Change_Made.Caption + 1 in the "onchange" setting, this works fine when text is typed in, however users have...

Hi All, I've got a bit of code that works well for the 1st part of a process but i'm not sure how to "undo" the change it makes for the 2nd part. I have this code: (note - i can't spell and "ProjectTitile" is the correct name for the form field!!) If Me.proj_status.Value = "On Hold" Then...

Hi All, I want to disable to access main window close button. i have password validation on my own "Exit" button, which is not invoked with the X. I found this on the web - Option Compare Database Option Explicit Private Const GWL_EXSTYLE = (-20) Private Const GWL_STYLE = (-16) 'Private...

Hi All, Had a bit of a hunt around Google, and this seems to be a bit of a confusing one, i have the following code to send an email when a button is clicked - DoCmd.SendObject acSendNoObject, , acFormatRTF, "xxxx@xxxx.com; yyyy@yyyy.com; zzzz@zzzz.com", Me.email.Value, , "UAT Roadmap...

Hi All, I thought i'd cracked everything on the tool i'm building but something strange has started to happen. As with my previous posts i'm self taught at this Access / VBA / SQL malarkey! Long story short when i click my save button on my form it runs a long SQL query. This writes the value...

Hi All, I'm trying to teach myself SQL & VBA. i've built a database that i'm pretty happy with but i want to do 2 things that i just cant figure out. 1)i want to display just the year, but i want it to update automatically (as part of the copyright text i've added)i've tried tday =...

Hi All, Please help! my Update query is failing: the query is quite long, and i'm guessing its just a problem with my code somewhere, but i'm self taught in SQL / VBA, so dont know what or where to look for the problem! Ok, this is the SQL command UpdateProjectSQL = " UPDATE [projects] SET...