Search results

Hi All Tearing my hair out with this one. My access db front end is based around a navigation form and on lots of the hosted subforms there are command buttons that trigger code that does "lots of stuff" then navigates to a different form. On many of those forms the "lots of stuff" includes...

Hi All I'm currently running a db with an Access front end linking to a SQL server back end. I'm fairly new to SQL server and it's been a steep learning curve but I've got past the immediate hurdles of learning elementary T-SQL for my pass through queries and using "dbSeeChanges" for my DAO...

Hi All I have a very large collection of reports serving as template letters for different scenarios, which I want to update to use a new record source query returning different fields. To do this I would need to update the record source for each report and for each of the relevant fields...

Hi All My database front end is structured around a navigation form and each tab on the "main" navigation bar has its own selection of tabs on its respective "sub" navigation bar. For one of my "main" tabs I have a public sub that determines which of its "sub" tabs are visible in different...

Dear All I'd be very grateful for a steer on the conundrum below. My table logs episodes of care in particular health services, so each record has (amongst other things): - a patientID (denoting the unique person), - a sequenceID (denoting the uninterrupted sequence of episodes of care for...

Dear All I'd be very grateful for a steer on how to get the DCount function working with date critera. The idea is to have a function on a form that checks that the user isn't entering a record that already exists on [tbl], by comparing the date being entered on a form with dates that already...

Dear All When I use DoCmd.Outputto to create a spread sheet from a query, most (but not all) of the date fields appear in the resultant spread sheet in the format DD-Mon-YY, despite the fact that hh:mm is included in the data in each cell (which you can see when you click on it). Is there any...

Dear All I have a table in which each record has a start date and an end date. The following query appears successfully to count the number of occasions on which one record within the table overlaps with another: SELECT Count(1) FROM tblMain AS t1 INNER JOIN tblMain AS t2 ON [t1].[id] <...

Dear All My database is currently in use in three offices and each office has its own discrete copy. I now wish to combine the three databases so that all the offices have access to the same data - and in order to do so I must append all of the table data together, and one particular (the most...

Dear All My database employs an extremely long and complicated union query, which is only going to get longer and more complicated. It struck me today that all of the 30-ish select statements in the query share one common WHERE clause. Would that union query run more quickly if I based it on...

Dear All I'd be very grateful for some help with what feels like a humiliating simple problem. I want an append query to create a new record in a table and populate that record with fields from a form. Some of these fields are free text, others are from combo boxes (which is, I suspect, where...

Hi All I wonder if anyone can help me with a problem around joins in a query? Let's say I have tblOrders and tblPeople. tblOrders contains a PersonID field corresponding to a record in tblPeople. Each record in tblPeople has a PersonName text field. The tables are set as related in...

Hi All I would be grateful for some help solving a problem that seems so absurdly, insulting simple, that it shouldn't even be a problem at all. I have a date field in a table. I wish to display in a query: Column A representing the month. Column B representing the number of records in...

Hi All At present I have a tblData, a tblPeople, a long union query and a report that displays its results. On a form I select a person from tblPeople (another field on that table contains their email address), run the query and report in that person's respect and email the results to them...

I want to be able to set text boxes so that if one enters a date and a time it displays in the format "dd/mm/yyyy hh:mm", but if one just enters a date is displays in the format "dd/mm/yyyy". Is this possible? Stipulating "dd/mm/yyyy hh:mm" means that when you just enter a date it adds "0"...

Hi All I wonder if anyone can shed some light on this maddeningly nonsensical facet of Access 2010? A few months ago I created a report that displays the results of a long union query comprising a dozen or so individual queries, each containing an expression that yields a date (or sometimes...

Hi All Sorry for anyone who's already seen this - total rewrite needed so I've edited. I'd be very grateful for some help. The records on my main form are navigated by a combo box, and that combo box is set up to display the records alphasbetically. The form itself defaults to the earliest...

Hi All I'm still fairly new to Access, and am attempting to solve a problem that I seem incapable of describing to google in such a way that it returns me a solution, I would be very grateful if one of you lovely people can help. I want to create a cascading combo box - so far so simple...

I approach this knowligarchy as a wretched and humble supplicant, a beginner Access user who has hit that first brick wall that no amount of googling and tutorials appear to be able to help me over. It is probably, hopefully, a fairly simple question - but I'm stumped. I have attempted to...

Greetings. I am a beginner Access developer from London. I have had this calling rather thrust upon me, and as such I am currently paid to punch my screen, tear my hair out and cry. This state of affairs has not been improved by my attempting to skip this polite formailty and launch into a very...