Search results

Hi all, I don't know if this is even possible but I thought I would put out some feelers! I have a code that creates a query from my database and uses the record source to create a new workbook in excel with that data. I then have a code that takes control of excel and does the formatting...

Hi All, I've not tried to use a function when building an expression before so please bear with me if I am missing something obvious! I have the following function which is placed in a query to return a concatenated string depending on which comboboxes are currently visible on the form (the...

Hi All, I think this should be pretty straight forward but I seem to be missing something with my code! I have a SQL WHERE argument that builds off of a number of listboxes and eventually creates a query with the result. The issue that I am having is that it doesn't seem to recognise Null...

Hi all, I may be being completeley blind here, however I have been looking at this for two days now and can't for the life of me figure out what I am missing! The purpose of the code below (you may think its a bit pointless!) is to allow the user to input a value that is not in the dropdown...

Hi All, I have set up a code that will export information from a query based on conditions described by functions within the code and I am now trying to take hold of Excel (the information is exported to there)and format the data. I have seen a coulpe of ideas kicking about on the net but...

Hi All, I have some vba code that creates a temporary query and exports this to Excel. This issue that I now have is that there is now a requirement to make each of the field names / labels etc variable and listed in a master table (tblFieldNames). This is working fine for everything I'm doing...

Hi all, I've seen a number of threads about this but most are pretty old and don't really address what I'm looking for. I have the code below which generates a string that I pass as SQL to create a query to bring the information into a subform. This works perfectly well, however I am now...

Hi All, I am trying to create a new query through VBA that will take the SQL as a string for the fields and values required. This will create a query that will then be exported to excel. This is a combination of a few codes that work fine themselves, however I don't seem to be able to figure...

I have a from with subform where the columns that are visable in the subform are controlled by checkboxes on the parent form. I am trying to find a way to ensure that ALL the columns are visible when the form is opened, however I am running into a couple of issues: DoCmd.RunCommand...

I have a VBA code that filters a subform dependent on the value of the current control. This has been working fine until I "tidied up" my VBA (I don't think I deleted anything, just moved things about in the same modules). The filter should show all records that match the criteria from a...