Search results

I have an issue with a calculated field that continues calculating even outside of its scope. Assume 2 queries: SubQuery FinalQuery In SubQuery, I have fields including: [Type] [T1 Res] [T2 Res] I have a field that goes: Result: iif([Type]=1,[T1 Res],iif([Type]=2,[T2 Res],"default result"))...

Hi My company's moving from Windows 7 to Windows 10. Additionally, don't ask me why, they decided to move from Office 2010 to Office 2013. During UAT some problems came up. I got a huge UNION ALL query that takes a dozen linked tables and mash them together on some criteria, on Office 2010 it...

Hello So I wanted to use "split" form just to have a little box on the side with the picture of the product everytime someone clicks on a record. I did that, and it works, but for some reason, I can't seem to have all my table's fields in the datasheet part. Only the few fields I have bound to...

Hello, I'm trying to figure out a consistent way to quickly execute a JOIN query between an ODBC data source and an excel range. In this exemple, my ODBC source has a table with [material] and [EAN], I'm running and Excel macro that has about 5000 materials and I want to find their EAN codes...

Hello I've got a query, it pulls sales data according to "cluster". Cluster can be A, B, C, D, or empty. I want this query to be able to pull 2 values by being run 2 times: - Sales of one cluster (empty ones are treated as one cluster). - Sales of everything. To do so, I use in my VBA module...

Hi there, I'm in the need of some help. I open a text file and store it in a collection of array: Open filepath For Input As #filenumber While Not EOF(filenumber) Line Input #filenumber, lineread file.Add Split("" & SEP & lineread, SEP) 'index starts at 1 for simplicity Wend Close...

Hello, I have a column called [Sales Qty] and recently need to sum it so it becomes [SumOfSales Qty]. That simply won't do because the result is used in macros and such afterwards, so I've done the rather silly but efficient method of aliasing my column with its own name: "Sales Qty: Sales...

Hello, I'm making a fairly complex application. At some point, I open a querydef and cycle through its parameters to prompt the user to enter it. Then, according to the type of the parameter, I will put tokens around it (" for string, # for dates, nothing for numbers), and put the parameters...

Hello, I have my main linked table VI, and 4 of VI's fields are to be filtered in a query. To do so, I have 4 very very tiny local tables (less than 20 records) called respectively "soff", "skus", "warr" and "typ", in which the user will only put what he wants in the result, and by doing Inner...

Hello, I have a very basic query. Table VI has 500k records, primary key is VI.ID, and the field I'm filtering is VI.sku, which has an index. If I do: select count(vi.id), vi.sku from vi where vi.sku="ABCD" group by vi.sku The query runs in less that a second and all is well. However, my...

Hello, The second function called by my main sub contains the following line: Set rs = CurrentDb.OpenRecordset("Parametres") If I have changed a piece of code before running it, it raises an error: "The database has been placed in a state by user 'Admin' on machine 'numbers' that prevents...

Hello, I'm trying to use the last() function in my queries, but its behaviour transcends everything I am able to fathom. Please advise. Assume two tables. ------------- ------------- RStatusList Status ------------- -------------...

Hello, I'm experimenting with unbound object frames to embed an excel sheet in Access. So far it worked pretty well but I noticed an issue: If I have an excel application already open and busy, and then open my form, access freeze completely and won't do anything until excel stops being busy...

Hello, An intern joined for a few month, a few months ago, and developped an Access database. He was in comp sci school but having worked with him a bit, he was not very good at anything computer related, especially not programming and SQL. Anyways, I had too much work and let him do his thing...

Hello everyone. Technically this is on Excel VBA since I open Excel from Access and work with it, but I don't think it matters since the problem here is clearly the passing into my function by ref. I don't get my issue at all, and I'm even pretty sure it worked just fine until yesterday and I...

Hello, what i'm trying to do is simple: the user types "201401", and the query has to understand that it's in the 1st quarter, so the period selected will be 201401-201402-201403. Simple, but I can't do it. I tried with a switch function at first but it didn't work so i moved on nested IIF's...