Search results

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.

Nice little utility ridders. Something to add to my toolkit :) Nothing to help with external application connections to back end though (unless i am missing something?)

That looks about right :)

Conditional formatting seems to be the answer here.

Thanks ridders, I already capture log in / log out data on this database, so seeing who is logged in is easy. I also have a way to 'kick out' active users if required. It is not the who i am trying to identify. What i want to try and identify is the names of other DB's and excel spreadsheets...

hi stu_c Would you want to keep the formatting? Simplest method of achieving this (but loosing formatting) is to output the report as HTML to a temp file, then open up the temp file source code to grab it and pass it along to the body argument of an HTML email that we create within VBA. If...