Search results

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

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

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

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

I'm slightly confused with this question as I've got two continuous forms dealing with separate parts of a database and one works and the other doesn't, so I created a test table, continuous form and entry form which does not work either. I've got a test table with 'Acc_code', 'name' and...

I'm trying to import a file that's being updated with information from an RS232 data logger. While there is no information updating the file, it's safe to import the file and then empty it which can be done from DOS copy commands, essentially I do the following: Make a snapshot of the existing...

I've got an unbound form which has a field that I need to relate to from a query, I've got no problems relating to specific records, but I've not quite cracked the ability to select all other records if the field is left at 0. I've tried using in the query under the 'table' field (for selecting...

Hi everyone, I can't get my head around this so I'm looking for some help if possible please, there are two questions, the first is: When in the query, I want the criteria for the date selection to be a question, ie. "[Week Start Date?]" but I want the actual criteria selection to be from the...

Hi everyone, I can't get my head around this so I'm looking for some help if possible please, there are two questions, the first is: When in the query, I want the criteria for the date selection to be a question, ie. "[Week Start Date?]" but I want the actual criteria selection to be from the...

It seems so simple to do, but I've spent ages looking through the forums and haven't found a simple implementation of it. How would you close a form based on a query called 'Retired' if no records are found? I assume it's going to be a bit of VBA code, but I'm still learning VBA. :-(

I have a database that has links to pages behind a password protected website. If you login to the website and enter your username and password so that the session is authorised the hyperlink in the access database has no problems opening. For some strange reason, I've been experiencing the...

Well I've been working on this problem for many a week now and I've finally pulled the last strand of hair from my head and I'm consulting you guys here, 'cause I just don't know. I've got an access database that links via hyperlink fields to stored pages on a password protected web page. If...