Recent content by cj-1289

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...