Search results

I have my database done, for the most part. But I want to add a lookup to a field in my Component table so that I can associate a particular number (paragraph number in a pub) to a failure mode description. In the Failure Mode table, I have associated a paragraph with a failure mode: Example...

I've done a quick search but haven't found a solution. I am trying to sort within a query before making a report from that query. I need to sort by date. Currently, it is sorting by date but by month instead of by year. So my data is being sorted similar to this: 11/30/2004 10/18/2005 . . ...

Okay, now for my next question . . . with heartfelt thanks for Rich for helping with my last question in the Forms forum. I wish to make this resource (db) that I'm working on (purchase log) available to my certifying official(s) to assist in official audits of the purchase program. Therefore...

I used to know how to do this so it’s doubly frustrating for me. I have a small database with 2 data tables, Purchase Log and Transaction Details. Purchase Log has the following structure: Transaction # - this is a text field (and my key field) because it will be assigned elsewhere – I’m just...

I seem to have all the "off the wall" questions but here goes anyway. I'm building (or trying to!) a database for our local 4-H club (at no charge -- they don't even know it yet). I'd like to present it to them later this winter to use for their 4-H shows. Generally, the class list will be...

I haven't been here for awhile since I haven't had time, lately, to "play" much with Access. However, I recently started working on a new database that is geared toward a new club. The club will eventually be holding competitions. I'm hoping to already have a solution in place for us to use...

http://www.access-programmers.co.uk/ubb/Forum4/HTML/005557.html It's down the page a way (re: Lookup)- I got some help from Jack but am having trouble with the results! Sorry about the "redirect" post but I need to get this done and I'm SO very close! :P

I have a membership database. I want to be able to print membership cards for each member using business card stock. Fields to be included would be: 1. concatenated field containing first and last name. 2. Member # 3. Membership Level Any tips on the best way to do this, if it's even...

The place my sister works for needs to track companies to which their people are "cleared" to go and how long they are "cleared" for that location. I've developed a simple database that allows her to either input or view all "clearances" for each of their people. However, if a new location...

I have a "contact" database that needs to be updated on a regular basis with information that I download in .csv format and save into Excel format. I'm trying to expedite the transfer of data from the spreadsheet to my database so I don't have to enter each contact individually (which is how...

I have a database that needs to be available to other people via a network drive and I've made the dBase "read-only." My problem: Currently, the users can open the input form via the menu (it's an "Edit Data" type selection but they can't change any data) so that they can view individual...

Hi all, I have an application I'm working on with separate tables for clientiand policies. The policy table is linked back to the client table via clientid (one client to many policies). The client info comes up in one form and the user can then click on a command button to open the linked...

I used the form wizard to make a form from a parameter query. It worked great and I was really excited because this will be invaluable for the semester project I'm doing. I then put a command button on a form previously created (using the wizard) that should open the new form (and thus request...

I'm currently designing, on paper, an application that I'm trying to develop to track events. I can't give specifics but will try to elaborate a little. To give more detail, I'll have options similar to the following in my main menu {sub-menus contained in brackets would show up as a new menu...

I have a report that has a blank page after every page that has data on it. How do I get rid of the blank page?! Also, how do I get the report to repeat column headings on each page? It only puts the column headings before each grouping. My problem is, each grouping has several pages and I...

I'm pretty sure this has been covered before but, of course, now I can't find it. I'm using Access 2000. I need to input "inventory" for several locations, one location at a time. How do I set the form up so that, until I change the location in the location box, it stays the same as the last...

Okay, here is what I want to do: I have form that requires input of a ship name and number. I'd like the number field to fill in automatically based on the ship name that the user inputs into the ship name field. To that end, I developed a table that contains each ship and its associated...

I'm a relative "newbie" to Access and have stumbled through most of what I've done on my own. What I'm wondering now is, can I use one form to input "same-as" data into various tables? Here's some background to give you an idea of what I'm doing. The purpose of my database is to track...

I'm pretty new to Access but have succeeded in generating the tables and queries I need as well as some reports. However, I do need to generate some charts. I've succeeded in generating the typical bar chart but I'm getting side-by-side results when I actually want stacked results. Excel...