Recent content by Isskint

Happy New Year all!:) Can anyone confirm if arnelgp's code worked? I have a similar requirement using the modern chart option, but that code does not work for me. I get Object doesnt support this property or method.

Many thanks CJ. :banghead::banghead: where is there a dark corner???:eek:

Hi All, So i have 2 tables: Invoice List and Case List. The fields of interest are; [Invoice List].[Customer] - Short text [Invoice List].[Invoice Date] - date-time [Case List].[Customer] - short text [Case List].[Created On] - date time I have a query that returns records in [Case List]...

Thanx Minty and arne. Minty, this may work, even with them having access to tables, they can only set the pointer currency, so only one default at any time. Oh i have already had that conversation :banghead: along with other conversations about the problems that can be caused by them accessing...

Sort of making sense:p OK so in the table you have [Ranked Group], do you have another field that stores the multiplier factor (EG [Ranked Group] = Group One [OtherField] = 2? This would result in [Sectional_Space_Available_CM] * dlookup("[OtherField]","[SourceTable]","[Ranked Group]='"...

Is [Ranked Group] on a separate table or in the same table as [Sectional_Space_Available_CM] ? If on a separate table, you could use a Dlookup() to return the calculation value form another field. If not then nested IIF() statements are the answer

Hi all I have a currency table that stores the currency name, trading code and exchange rate. I also have a TRUE/FALSE field for the default currency (the base currency being used by the company using the database). At any one time only 1 currency can be the default. Currently I use Before...

Hi Doc Yep, only the PK property was removed. I reinstated it and everything works fine.

Hi Doc, Split FE / BE. BE on company server, FE on users PC's. However, i did have to do a C & R this morning on the BE. Can the repair operation remove a PK?

Hi Colin, I had used that checklist (from memory) before posting. However, I have just gone through again to be sure. And I found it. One of the source tables in a JOINed field did not have a PK. How does a table suddenly lose it's PK?

Hi all A database that has been in use for 3 years, has suddenly today decided a query data source is not updateable. The query includes PK and FK from all parent record sources. The parent record sources are updateable manually. I tried deleting and recreating the query and form that are...

Hi All I have a table of technical terms (1 field) [tsTrm]. Users enter details of work performed in a long text field [wkPrf] of a separate table. What i would like to achieve, is as you type, lookup of the [tsTrm] records matching the current word, and 'suggest' that word. Most reports...

I have managed a work around. Each spreadsheet/database etc that is linked to this main BE database, now logs connection time and userID and disconnection time. Thus i can look at this connection table to identify who/what is connected.

Yeah i have asked my IT people about this also. Doc, strangely the response i have from them today, was Doc, you work for them?:confused: Appreciate your thoughts and suggestions on this guys

Yep, you should be able to use the dateadd() function.