Search results

Hello all, I'm trying to think of a purely SQL way of selecting records from a single table for a listbox where the data for the project's reference cannot be like another. To illustrate, the table might have three records containing these values in the reference field like this: REFERENCE...

I can't, I'm afraid, no. The real data is confidential, I have no facility for uploading images here, and the real [Invoicing] table contains a lot of fields which are irrelevant for this purpose. There are no relationships involved. I only gave the relevant information and test data which went...

Hi, I was hoping for a query-based solution to the following problem. I already have a complicated mixed VBA/Report-based solution but it's becoming too cumbersome to manipulate. I have a table [Invoices], where each record pertains to one invoice, e.g.: Company / JobID / InvoiceNo /...

I have a problem with creating a query summarising some crosstab data. I have a database designed to record employee performance for each activity they perform. I have created a network of queries and OWC graphs to present summaries of this raw data, which is linked to a form which filters the...

Thanks for the reply. I'm afraid I don't see how a procedure to change the date/time property of a file is relevant to a way of fetching the current time from an internet clock though.

Hello, I have a database which relies heavily on VBA references to the present time and date as stored by their local system. However, one of the computers is incapable of storing local date/time information for very long, even with a new battery, and we're not authorised to simply replace that...

Thanks a lot Sean. The date field is actually called Activity_Date and the test data is nothing like the actual data. I wasn't wanting Activity_Date involved at all, so I modified your crosstab query to: TRANSFORM Count(qrySkillsCompleted.Skill) AS CountOfActivities SELECT...

Hi, I'm having difficulties trying to get a table ("skills") which lists all employee activities/skills joined with employee-specific queries (e.g. "david_count") of another table which logs every activity completed by any staff member ("completed"). The intention is to create a query ("matrix")...

Hi, I hope someone has an answer to this: I've been pondering for a while if it is possible to have VBA write each line of code that it executes while going through in a process to a log, in order to monitor for blocks of code which are slowing it down. So for each line of code VBA processes...

Ah, brilliant. Who knew that Access did something that I didn't even need to code in! Perhaps I've been over-relying on VBA and SQL though. Out of curiosity (and it's simply that because I've copy/pasted 'Set db2 = filepath' all over the place and it's working fine) would I be able to open a...

The Access GUI seems determined that I only pick values or fields that come from the CurrentDb, but I want to refer to a different one. I've been doing my research but found little of use. Essentially, where [Table] is a table in a different database to the Table/Query RowSourceType combobox...

I'm trying to open a recordset contained using a different database in VBA6, but said different database just doesn't want to load when I don't use the full path, throwing run-time error 3024, where it can't find the file. So: Dim db as Database Dim db2 as Database Set db = CurrentDb...

Yeah if you refer to my first post, that's the workaround I had been using. Oh well, I'll just have to suck it up and go on a typing marathon..!

There's far too many lookup fields to do that, perhaps 70 per table, with over 11 tables, and perhaps a good fifty values in your average table-level lookup field. I could store it in whatever way, I just need to work out how to get into the table-level values. Browsing around the internet, and...

Yes, I was referring to a lookup field. I didn't know what they were called at table level because I did not put them there en masse and I would like to strangle the person who did :) So, if there are twenty table-level values in a lookup field, your proposal will enable me to retrieve these...

Hi there, I've got myself in a bit of a muddle here. When you have a field which has a dropdown list of options in the table which you have to use to edit it, I have found that it is not possible to use a recordset to amend it - Access insists that you use the original dropdown menu to select...

GTH: Thank you very much - I modified your code to compare more tables than just 2 and the program's now complete. You have my gratitude! Mike: Queries are still used depending on the purpose, but they're less effective in some situations, like where there's an arbitrary split. The whole system...

Interpretations of the same-named fields are all exactly the same at all times. Otherwise they'd be called something different. The system that I'm working with is not as chaotic as that! You're correct about this 'data refinement process' though, for example there are identical fields with...

Yes: at least 9 more tables to come and the program is to dynamically compare the fields of the new tables with the old tables upon request. 'Modifier' in my context is one record in the table 'Modifiers'. Each of these records contain a unique name, the names of several tables, and the fields...

HiTechCoach, I'm comparing tables automatically to save users from manually comparing tables between different sources. If the design tools had been used in an 'optimal' way when the tables were being made in the first place, this wouldn't have been necessary. But they weren't, and it is. This...