Search results

Thank you, that put me on the right path for working out the problem, in the end I've used CreateObject("Shell.Application").Open "https://crm.zoho.com/crm/org123456/tab/Accounts/" & Me.AccountID This opens the default browser and yes as I'm already logged in, shows the correct record.

Hi Everyone, I think this might be a permissions issue, but maybe someone specifically knows and as it starts on an Access Form, I thought I'd post it here. I've got a hyperlink which is supposed to go to, as an example: https://crm.zoho.com/crm/org123456/tab/Accounts/123456000654321 I'm...

As often happens, throwing the question to the forum seems to makes the brain think differently, so I've got the following ugly :cool: code, but it works and someone might be able to sweeten it up or re-use it for themselves. It forms the correct sentence based on the choices returning a...

I've been trying to think this one through and thought I'd throw it out there for some pointers as I think someone must have done this before. I've 5 yes/no fields, call them Alpha, Beta, Charlie, Delta and Echo. I'd like to place on a report, an English wording to the selected fields...

Just to let you all know, I was unable to use the dates for comparison within the VBA code, in the end I've had to refer to queries instead which work fine. I've got no explanation as to why the VBA doesn't work, but the problem has been worked around. Many thanks for your help.

I meant that I'd read that date fields store the time even if you can't see it, but I'm not sure if it's true or not. I've changed the coding again and added a couple of visual references to show me what's being found, with: MsgBox DLookup("[check_date]", "[healthcheck]") MsgBox...

Sorry Plog, I realised I'd missed the # at the end of the line when I pasted the code from the VBA screen, but the function still returns 0. It also still returns 0 if the comparison =#02/03/2015# (which I tested as that's the date stored in the healthcheck, check_date field.

Hi Everyone, I'm trying reference a dcount on two fields, one is a string and works fine, the other is on a date which does not. I've investigated the problem and found a couple of references to making sure I use a # symbol to reference the date but I think the thing that's throwing the...

I'll try rewriting the statement tomorrow and let you know if I'm able to get the syntax correct, I'm unfortunately still learning much about SQL.

I've been trying to write and rewrite this SQL statement and I just can't get it right, I would like to use UNION to join two tables and return a list of entries excluding duplicates which works fine on its own if I only lookup the tetra_issi and radio_call_sign fields, but I also need to add a...

Hi everyone, I'm having a strange issue with my memo field on my form when using Rich Text for formatting. I have to use a combination of the vertical scrollbar and the up/down cursor keys to navigate to the entire top and bottom of the memo, neither will singularly do the job. The cursor...

Hey everyone, I've tried wording my search descriptions several ways to try and find possible answers to this problem, but as of yet have drawn blanks. I've got a database that I'm going to be using on a tablet PC. In programs like Internet Explorer, if there's more information to be shown...

The capture program can only write to one log file although you could close the program, wipe the log file and re-run the program to keep the log file down to a minimum - the only problem with that is everytime you do so, you loose the last 12 hours of data. There are up to 500 radios online at...

The filestamp reference is an interesting idea, but the frequency issue is a must as the program needs to provide 'live' feedback to show portable radio operators as they log in/out and talk over the air so there could be very infrequent activity or a burst of conversations over a short period...

I've been thinking over this problem and I'm not sure the best way of resolving it, if it's possible even. I've made a frontend database that displays data from a database log created by a third party program. The program updates the database log everytime an event occurs and I simply (not sure...

Hi Everyone, I've looked in depth at the varying ways of re-linking my FE database to two BE databases located at two different paths. The closest I've got is by using FRefreshLinks code but I couldn't work out how to set the passwords. The scenario is the following: FEDatabase.ACCDB (2010...

I'm not sure if that's the best heading for this question but I'll give it a shot. We're pulling loads of data from various spreadsheets with lookups to create a group of cells that when compile will form an HTML script so we're automating the creation of our index pages. We've just modified...

I'm trying to create an update query based on an open bound form. During testing I'm getting a strange result where in a select query (for viewing purposes) I've got Expr1: and Expr2: which reference fields on the form like so: Expr1: [Forms]![Module Program]![postcode] Expr2: [Forms]![Module...

I don't know if it's possible, but is there any way of forcing the random autonumber generator in tables to be a positive number only? The autonumber as I've searched on the forum can be a positive or negative number and I'd like to use the random autonumber feature as a primary key for account...

I'm not sure what criteria I'd find this under if it's already been covered, but perhaps someone already knows and can point it out, or a solution would be appreciated. I've got a table which contains 2 fields, with the second field called 'default' denoting which of the items of the list is to...