Search results

Hi, I have a couple of linked tables from SQL (I prefer to use the built in Access query builder to build queries) in Access O365. If I create a query using the like parameter with a wildcard I don't get any values back but if I just query the actual value I do. I could give an example but...

Hi guys, I cant get my head around what appears to be a simple sql select statement and was wondering if someone can help me please? I have 2 tables table 1 has all the data Im after but is linked to table 2 by a Request_ID Field. They say a picture paints a thousand words so...

Hi, Trying to export values from an Access table no matter how I format the date it doesn't export properly (the export works but the date specified is ignored) strFile = "C:\" & Format(Date, "ddmmyyyy") & ".csv" strDateEntry1 = Format(InputBox("Please Enter From Date...

Hi, Im looking to automate the process of linking my Access DB with an ODBC connection to an SQL DB with VBA (unless theres an easier way to do it?) - can anyone either point me in the right direction of some sample code - that's if this is possible at all? Thanks

Hi, I cant seem to get my insert statement to work, Ive checked (although I could be wrong) for reserved words and I don't seem to have any. Ive declared what the fields are so that should be ok, it just wont insert: Dim sEmployeeName As String Dim sLogonAccount As String Dim sDepartment As...

Hi, I have 3 select queries which Im trying to output to a combo - Ive tried a UNION query but I get an error ODBC-- call failed ODBC Driver SQLBase..... Firstly is do the results need to match within a union query? I mean they have no relationship what so ever Im just trying to populate...

Hi, This code was copied from another location (not this forum) and before I just copied and pasted it I wanted to understand what exactly it was doing and how to trigger it correctly. Private Sub Form_load() Public Sub TestCode(strDomain As String, strGroup As String) Dim objGroup As...

Hi, Im trying to work out how I show only fields which have text in them. For this I have a formula which works out if that field is true or false (contains text or not) and now Im trying to display the ones which show text only. I've managed to do this within the supress format but because...

Hi, Ive had a complete blank... Im trying to output my VBA code to a report but I cant for the life of me think how to do it. Here is my code: Dim strEmployeeName As String strEmployeeName = EnUsername DoCmd.RunSQL "SELECT StrConv(Replace([sUser],""."","" ""),3) AS Employee...

Hi Guys, recently and for no apparent reason I am starting to look at SQL queries and understand how they work (this is coming from writing VBA queries and using Access A LOT). Im creating a very basic SQL query as you can see and I can browse to the table which I am getting the error about...

Hi, I currently have 2 separate crystal reports which I would like to join as one. Can I create a Union query within crystal as I can within Access or is there a better method to achieve joining the two? Thanks

Hi guys, Im trying to join two queries as I am unable to use just a single query but I cant use a union query as the query fields aren't exactly the same. Both queries have a PO_Detail field as every PO has a PO_Detail number assigned to it. 3 of the same records are in both query...

Hi Guys, Im trying to delete values from a table based on the selected values of a listbox. The listbox values have a hidden column which related to the ID on the table to which I am trying to delete from (if that makes sense). If I use the following code: Set ctl = Me.Results_listbox...

Hi, Ive added breaks and the variables are returning their values fine when I hover over them, but can I see where the syntax error is - can I..... strSQL = "SELECT TimesheetTable.sUser, TimesheetTable.Activity, TimesheetTable.Hours, TimesheetTable.Project, TimesheetTable.[Task Date]...

Hi, Am I being stupid or is it possible? I have a query which looks up records from a table, now what I would like to do is append the word All Projects to this query - is it possible, and if so how? Thanks

Hi, This one is really puzzling me and I cant see why I cant get the values to match. I have 3 tables joined as attached and Im trying to use the PO from the PO_Detail table to display the Description from the Material_Req Table. The two values are linked as the description in the Material_Req...

Hi, Im looking to export my listbox values to a single workbook BUT a new sheet is created per export. There are 6 listboxes in total and I already have the code to export a single listbox but if I try to use this code its going to overwrite the csv each time - I was wondering if anyone could...

Hi Im looking to check 3 sub forms for values and if they contain any then delete them. After a bit of googling I discovered that you should use recordset.recordcount - to which I tried but I get method or data not found - is this a valid method? My code to which Im using is: If...

Hi guys, yep me again... How do you show dates within SQL VBA? As Ive been struggling with the below code and cant for the life of me get it to work. Im sure its the date that's incorrect and Ive tried putting #'s in but still it errors with type mismatch. Could someone enlighten me please...

Hi, Im trying to output my query results and am a little hesitant as to which method is the best. Would you output the results to a subform or a listbox? I mean there must be a reason as to which method is the preferred method and I cant seem to find out what it is? Thanks :banghead: