Search results

Hi all, A sanity check please? I have the following nested IIf query that populates a field depending on a couple conditions. It has worked for ages, but only gets run once a biennial. This morning I got a compile error. Has IIf syntax changed perhaps? Query: UPDATE Member SET...

Is the best way: create one form and then open it differently for adding new vs editing existing records create one form to insert and one form to edit, where the edit form is bound to a query, and the insert form saves data following a button's click event. some other method? I guess I need...

I'm trying to do a tally of election types using count, but am getting the wrong answer. In the database, LocalGovernments have Wards and Ward have Elections. An election can be one of two ElectionTypes ('In Person' or 'Postal'). Every Ward in a LocalGovernment has the same ElectionType. I...

I have a subform (datasheet) inside a subform (single form) inside a form, and am only seeing one record in the datasheet subform. I am creating a database of database jobs that need doing (basically a ToDo list). The main tables look like: Databases <-1----m-> Jobs <-1----m-> Tasks In the...

Hi all I have a table where the number of fields is causing problems. I want to split the table into 3 or 4 tables with related sections, but am not sure how to maintain the connection to the logical row of data, and how best to do this in Access. The data relates to council budgets, and...

Solved: Uneditable textbox Hi all I have a form that when opened will either allow new records to be added, or allow existing records to be viewed, depending on the OpenArgs. When existing records are being viewed, the user can click an 'Edit' button to allow that record to be edited. In add...

Hi all I am trying to code a duplicate remover that allows the user to check that the two records really do refer to the same person before hitting the big red delete button. I have this code: sql = "SELECT Caller.GivenNames, Organisation.OrgName, Caller.Phone " _ & "FROM Caller LEFT...

[Solved] - Write conflict - This record has been changed by another user ... Hi all I've got a form that shows existing records. The user clicks a button which opens a form allowing the shown record to be edited. When changes have been made, the user clicks save, which saves the data and...

Hi I have a form that collects (contact logging) data that will be saved to two different tables. Up to now, I have been saving the master info, and then querying the table (using the data I just saved) to retrieve the primary key in order to correctly save the detail, but it strikes me that...

Hi all I have a form that allows input of historical finance data. I want to give the user a field where (s)he can input a financial year (eg 2009/10, 2007/08). Do I do this as a date field, or a string field? I've had a search, and I think this was a similar question...

Solved: OnClick event - pass this control to method Hi all how do i tell a method to do something to a clicked control? I have a form with a bunch of labels and a bunch of buttons, and I want to run a method whenever one of these controls is clicked: Private Sub manipulateControl(ByRef ctrl...

Hi all How do I do this? I want to have a form that opens with Author info. On the form is a table with books by the author (book title, year, publisher), and when the user selects a book in the table and clicks a 'Show Detail' button, a subform becomes visible with detailed information about...

hi all I have a subform with a bunch of textboxes. I've set the subform to datasheet view only, so the textboxes appear like they're in a table (or a multi-column listbox). My question is: what event do i program a response to, when the user clicks the Row selection 'button' at the beginning...

Hi all, I have a report that prints data about a number of different offices, listing sections and key staff in those offices. Some have more sections than others, but the data for each office fits on one page. I want to know if i can center the information on the page, so that the data for...

Hi all I have a couple of linked tables and I'm trying to run a query to put data on a form. The tables are: Topic(ID, Subject, Detail, etc); Solution(ID, SolnNum, ShortDescrip) which both have 1-many joins with TopicSolution (ID, TopicID, SolutionID). A Topic can only have none, one or two...

Hi all I'm trying to put together a phone call logging system that has (amongst other things) a Call table (ID, SubjectOfCall, AdviceGiven, CallerID) and a Caller table (ID, Name, PhoneNum). I'm trying to form a query that will tell me, for a given subject, the number of calls, and the...

hi all I'm trying to create a parameter query where the user supplies a list of years, and the query uses the IN operator with the supplied criteria. eg if the user wants data from last year, 2007 and 2001, they type the following in the parameter dialog: (2001, 2007, 2009) Access tells me...

I'm working on a database of candidates for council elections, and I have a query that usually returns between 2 and 5 rows of data, (min = 0 max = 15). The data contains 4 fields (given & surname (strings), votes received (int), and is elected (boolean)). I want to display the query result...

Hi all I have a continuous form and I want to make it so that it does not update the underlying table until I click the Save button at the bottom of the form. That is, if the user makes a bunch of changes and then hits the cancel button, I want the table to be at the state it was before the...

ok, I've now worked out how get multiple records on one form with a continuous form, but I've now got the problem that when I click a toggle button on the form, all of the toggle buttons for that field change (ie every record's toggle button changes). The toggle button is bound to a Yes/No...