Lounge: Databases

Reports and subreports that have worked well for years recently began asking for parameters when encountering text boxes that involve either Date() or Right. E.g., =IIf(<Date() And...

I want to build a form that works in the same way as a table in design mode, that is, being able to drag and drop rows up or down the list. The use is to create a list of jobs allocated to a...

I have a table of work orders. I have designed a query that filters it via a number of combo boxes on a form, but I have run into a snag trying to implement one more filter. I'd like to have an...

Has anyone tried this? Are there any good document references on this?

In a user's Access database, the data is in one .mdb file and the form and reports are in another. There is a customer form with two subforms (one of them is for Orders). The data in the subforms...

I am constructing a database in Access 2003 which lists contact information. So far so good, it looks like this: ID, First_Name, Last name, etc 1, John, Doe 2, Tim, Johnson For...

I have been trying to hide the navigation pane in my FE. I have unchecked the "Display Navigation Pane" in the Access Options but Alas, it is still there..... It is an annoyance to my users who don't...

In access 2007 I want to update my Subform based upon entry in one text field in my main form. Right now the subform won't update unless i close the and reopen it or go to the next record and then...

I have been given an Access 2003 database which produces a report and then attaches that page to an email, based on complex criteria. I have found the area in the code where it creates the rtf...

I have encountered weird behaviour with several reports I created where I cannot save changes in the bottom and right margins from 171 and 208 mm. The reports were using Access 2003 in a...

Created an mdb way back in Office 2003. Upgraded it to MSAccess 2010. Working fine. For some reason had the idea to create a new mdb in MSAccess 2010 and import the tables, queries, etc from the...

I'm inventorying my Lego collection and I'm wondering where I might find an Access database with a well-designed front-end specifically for inventorying Lego. I'm thinking the best place to locate...

Friends, I am having difficulty creating a relationship of tables in a database. I have a table and another table technology company. For each technology has several companies, and for each...

Hi all, I am trying to combine two tables into one. I have some data in one table that I want to update to another table. I semi-successfully created the Make Table query. Problem is, out of...

I have an Access link to an Oracle database that I have used for years. My recent upgrade to Win7 successfully set up the 32 bit ODBC driver to the Oracle database and Access successfully used it for...

I've got a potential customer who apparently has created interactive PDF files to gather information, and he would like to gather that information into a database. He said he's heard of an ODBC...

Is there any way that I can find this old, maybe 2003, message? Hans was answering a question about forms and controls on sub-forms. "I thought you might like to see this message. It's from the...

Hi all, I have hit a rather unusual error, and really would like some advice. There is no rush, as there is a workround in place, but i dont want to leave it this way, if we come accross this...

HI ALL, I NEED TO RUN THE SP ON SPECIFIC TIME AND STARTING AND ENDING DATE FOR THIS I FIND A CODE FROM BROWSING IT GIVES ME THE TIME TO RUN BUT HOW SHOULD I DEFINE DATE PARAMETER MEANS SPECIFIC...

Hi, All! it has been some time since I've been playing with Access database, I was trying to brush up a little :). I have the below event procedure that is giving me debug errors and can't see why it...

Hi. I have a database of routes for spectators going to events, and I have a form which allows you to see the impact on those routes of events on the transport network. I have a subform which...

Can you automatically send a email from microsoft access to outlook on the 1st of every month? We keep our birthday list in access and would like the list of everyone having a birthday that month to...

In Access 2003 (on my system), check boxes on datasheets are by default a fixed size and centered within their field. However, in Access 2010 (again, on my system) check boxes take up the whole field...

I have a database which has worked fine for years. I developed it for a business and maintain it. The business uses it in a networked environment, with the main file on each machine and data file on...

I have a routine set up that allows the email addresses contained in a query to be used as the source for an "E-mail Blast". The routine works perfectly as long as all the email addresses are valid....

Friends, I have this sql statement: SELECT TblAnalista.NomeDoAnalista, TblEmpresa.NomeDaEmpresa, TblProduto.NomeDoProduto, TblPassosStatus.Passo, Nz(,) AS DataDue, TblPassosStatus.C FROM...

Hi, Im new here so please be kind:), ok my dilema is probably quite simple: I have a table Called ImportedTable with the following fields: ACREF (text field), INVRECDATE (date field), REPNAME...

Hello, I am a database novice. I am a Mechanic and I want to make a database to keep track of my work, I would like all the help I can get to make this database. Here is what I need to do with...

I'm working in Access 2007 on a Risk Management DB, changing the tool we use to set the Impact and Probability of a risk. Impact ranges from 0 to 10 and Probability ranges from 0% to 100%. I have...