Search results

I know it's possible, because I've seen it in templates, but I can't work out how to do it. I want to use both tabular and stacked layouts. Why? My data is (for example) Label A Label B Label 1 Field A1 Field B1 Label 2 Field A2...

Thanks for the warning David. I don't think any of users would be interested in changing records delibrately. I'm more concerned about ensuring they can't accidently delete or modify information. I assume in 2007 it's possible to create the front-end to open up without the database window...

I recently split my database into back end and front end to overcome a conflict caused by multiple users (learn something new every day). Now I'm wondering - can I create a front end version with everything locked against editing? I have a very small team of data inputters, and a much larger...

I'm working in Access 2007, with an "accdb" file (I only just noticed that the extension is different to other versions). Just recently (didn't notice when it happened) the database has created a "database.mdb". If I delete it, it reappears after I next close my database. If I try to open it...

I've found the thread http://www.access-programmers.co.uk/forums/showthread.php?t=155950, with the sample database that tells you who in currently in a database. However, I'm running Access 2007, which the author said he had tested it for. I'm getting a debug message, but I don't know if that's...

I'm using Access 2007, which I think may have some bearing on my question. I know I've seen a form (or maybe a report) with stacked/tabular controls, where one field was 2 lines high, and next to it was two fields: This is This is field #2 Field #1 This is...

As part of my database I have a table in which I keep a bunch of proforma email messages. It's very simple with 5 fields: an ID, receipient, purpose, subject line, body of text. Can I program Access to send the standard text to an email message? eg: I have hundreds of projects, some of which...

My table looks like: Project Element Descr prj 1 Ele A Des of ele A for Prj 1 prj 1 ele B Des of ele B for prj 1 Prj 2 Ele A Des of ele A for Prj 2 In some cases Description of Element A for Project 1 and 2...

Thank you so much! I really appreciate your response, AND that you gave me the code. I often know Access will do what I want, and someone will say "just code it like this" but the nitty-gritty of the full stops and commas and quote marks escapes me and I waste 2 hours wandering in the...

Can I program a form's for: if [field x] is null, insert "this text" I can't use the default text of the table structure. In my table, I have (eg) [project], [element], [discussion]. Each project can have multiple elements, each with a unique discussion. Often the discussion (or at least...

I've added new fields to my query "FieldNameNO: not [Fieldname]". I've then set "FieldNameNo" as the control of an unbound checkbox on my report. Glad I only have 8 fields.

I'm trying to create a report that has images (logos/branding) in the header and the footer of the first page only. On page 2 onwards the footer has a report title and page number; no header. I can easily set up the images in the header of the first page using the report header; but I can't...

I have some 'on load' code sitting on a sub-report, for a series of checkboxes (one bound and one unbound showing the opposite of the bound box) Me.Check1 = Not Me.Check2 It all runs fine in the sub-report, but the 'on load' code is not running when I open the main report. I assume I have to...

I am reproducing a report originally designed to be manually completed in Word. The client wants it be an 'exact' replication. On the original form I have a table with three columns - the item to be considered, a 'yes it applies' column (checkbox), and 'no, it doesn't apply' column (checkbox)...

Paul, thank you for replying. Unfortunately, your link leads me to a "there is no post" message.

I have a couple of very simple reports with two or three fields (eg list of road names and their government assigned numbers). These are run from a button on my main form. What is the easiest way to give users the ability to order these reports? Eg sometimes I want to look at the list of...

I'm sure this is a very easy issue, but I can't work out what I'm doing wrong. I am using unbound combo boxes to create filtered queries (using form!form name!combo box). The filtered queries are then used for different reports and forms. However, the combo box is emptying when I click a...

Perhaps examples of my data would have helped keep it clear. An issue would be "Is the site within 200m of a RAMSAR wetland?" All issues are written so that "yes" is the risk. If the answer is 'no', then no further action is required. If the answer is 'yes', a risk category is assigned...

My Access mentor has moved on and I'm learning that database design is always best if bounced around between minds. Particularly, when you're not actually a programmer! My main data consists of - a list of projects, a list of yes/no questions that are to be answered for each project, a set of...

Funny how when you're buried in something every thing seems straight forward and logic - til you try to explain. I have a datasheet: [invoiceID], [weekID], [person], [hours], [cost]. All costs recored against a particular [invoiceid] drop into that invoice. Invoice #1 is for Week 1 through...