Search results for query: *

I had finished an indepth post on this before my PC crashed I don't have that much time anymore so hopefully this will be enough, please ask any questions and I will try anmd get back to you. I have a query that works fine, but when I try to put it into a cross-tab it tells me it can't find the...

Hi, we have a query running out of Navision into access, this query was setup by someone on site who is presently on holiday.... A shortcut was taken to fix one issue but it has caused another, so in his absence i'm trying to fix the problem. We have a field being cut down to 3 characters...

Hi, I have a form with a sub form. The subform allows (up to) 4 entries with only one variable (Score). I want to total up the scores, divide it by the total number of scores recorded and then return the result to the parent form into a bound variable (Score). All of this works great.... with...

Hi, i'm trying to repeat something i've done before and got working with no problem, this time however I can't get it to work. I have a query I just want to pass from Access to Excel, it works fine in Microsoft query, but when I try to enter the query data into Excel I get the "invalid...

Hi, it maybe that I can work out how to do this but i'm honestly not sure where to begin, so i'm after some help with where to start looking... The quandry is this: I have a table that lists Ingredient and the allergens in them (e.g.) Ingredient 1 | Allergen 1 Ingredient 1 | Allergen 2...

Hi, I have an excel spreadsheet with an OLE object showing another excel spreadsheet. I would like for the user to be able to select a unique identifier (product code) and have the OLE object update to the file that matches that product code (e.g. drop down select code "SG05", OLE object...

Hi, I want to use the following in conditional formmating but I can't get it to work. Seems to be very difficult to find guides / advice on conditional formatting in access as google keeps getting up excel pages. I'm on 2003 BTW. Here is what I would like to conditinally format...

Hi, I have some code as below which I would like to make more efficient, do you know how? I'd also like to add in the "," character but not have it appear before or after if there is no allergen before or after. Thanks in advance :) CONTAINS LIST: [Q_SKU Allergens by Type].[BARLEY]+" " &...

Hi, i'm building a label database (for the labelling software we purchased) for a cake company. I'm trying to make it as normalised as possible however i've come across a quandry that is causing brainaches... I have created a many to many linkiung products and allergens (e.g.: Product 1 |...

Hi, I have a UDF I nicked from the internet, which works great, however: I have one sheet that is the "input" worksheet. I have 2 lookup sheets that use the "vlookupall" UDF to create a list of products that meet the criteria in these 2 sheets from the list provided in the input sheet. One of...

Hi, I found this usefull function online, however I would like it to check 2 columns instead of one; this is the original: Function vlookupall(sSearch As String, rRange As Range, _ Optional lLookupCol As Long = 2, Optional sDel As String = ",") As String 'Vlookupall searches in first...

Hi, We have an application (teklynx labelview if that helps) that I want to link to an excel spreadsheet (as we don't use a database here (as much as I keep pushing for one)). Problem is we have mixed 2007 & 2003 excel versions on machines. The software will only link up to a 2003 excel sheet...

Hi can you help me please to identify what is wrong with my code (it doesn't do anything). I'm not proficient with excel terms. Sub FillEveryOtherColumn() Dim lastCell As Integer Dim lastColumn As Integer Dim i As Integer Dim End1 As Integer Dim Start2 As Integer Dim...

Hi can you help me please to identify what is wrong with my code (it doesn't do anything) Sub FillEveryOtherColumn() Dim lastCell As Integer Dim lastColumn As Integer Dim i As Integer Dim End1 As Integer Dim Start2 As Integer Dim End2 As Integer...

Hi i've found this code: http://allenbrowne.com/ser-57.html And I think i get how enough of it works to muddle through it, however it assumes the use of a set ID as opposed to an auto-number. Can someone please explain (in detail as my brain hates programming) how I can remove the code for...

I've made up the code below because I don't actually know how to code this button, can you let me know how the Ifs should work please. At the moment nothing happens at all! Private Sub Command27_Click() If [sfrm_Company_Division_Register].[Company_classification].IsNull Then MsgBox "Company...

Hi, I have an unbound list box using data that is queried to diplay results based on the values users put into "search" text boxes and one combo box. My issue is when there is a non-exisitant value the query misses the record all together, even when there is nothing selected in the combo or...

Hi, I have investigated this error on google and I believe I know WHY the error is occuring (lack of single quotes) however I don't have the knowledge to work out where to put them.... :( I'm really not great at programming here is my code: ProductDec: Concatenate("SELECT Ing_Dec_Fin FROM...

I have a subform based on a Crosstab query, of which I would like to count the instances of a specific result ("Y") in each column of the subform. E.g. Form: "frmAllergensInProducts" SubForm: "S-frmAllergensinProducts" I'd like to count the subform columns. Wheat,Barley,Oats, etc. Where they...

Hi, I have a cross tab query which is displaying ingredients on rows, allergens on columns and then counting the ingredients containing the allergens in the cells. So basically is is saying for x ingredient it contains x ingredients of allergen type x. For the sake of allowing users to filter...