Search results for query: *

Hi listers, Help, please. My brain is a puny thing. I have a "Projects" database that includes these tables and relationships, among others: tblProjects - pkeyProjectID fkeyClientID tblClients - pkeyClientID txtClient fkeyGroupID tblGroup -...

Hi all, I'm facing meltdown in the face of what is most likely a very simple operation. I set up a command button on my form to call an external application, which outputs a *.csv file. The file consists of a number of rows and columns of test data results. There are 2 things I'd like to do...

Hi all, because I've tinkered with Access a bit, I've now been asked to be an advisor on something much more ambitious: an inventory database that will allow the user to call an external application (in this case, LabView) which will perform some test, and return a value. Ideally, this value...

In order to cut down on redundant typing, I've set field values to default to the values in previous records. The problem results from one particular value of the combo box cmbProjectType that is supposed to trigger the visibility of a text box (txtMapCopies). I.e., if cmbProjectType =...

Hi all, I've put the following code into the page footer section in order to keep the "Submitted By" text on the bottom of the last page only. However, the only value "me.pages" ever has is 0, so it doesn't work. Can anyone point out where this went awry? thanks! J...

Hi all, I'm trying to generate a report showing projects and clients in a given month. All well and good. The bad is that there are Individual clients, Miscellaneous clients, and regular clients. Individual and Miscellaneous clients have an associated name or organization; regular clients...

Ok, I'm sure this is a no-brainer for someone (most everyone?) out there...just not for me. I have a "Project Tracking" database. I'm trying to set up a report that will list the numbers of projects and clients responded to during a particular time frame. All well and good. The...

Hi, I have a question about forms and deleting records... I have a main form and a subform: frmActions subfrmPersonnel If my subform is in 'continuous forms' view, I cannot delete a person without getting an error (specifically, "You tried to assign a Null value to a Variable that is not...

Hello all, I am working on an "Incident" database. For each incident that occurs, the fix-up crew can make multiple actions (reconn, clean-up, etc.) So I have a main form (frmIncidents) linked to a continuous subform (subfrmActions). On the subform there is an option button that...

Hello all, I've gone through every "Dcount" post and am still banging my head against this one...so here goes. I have an intersection table tblActionMaterial ActionID (pk) MaterialID (pk) In an Action subform I allow the user to enter materials used to complete that...

I'm stumped. I have a continuous subform with a combo box ("Materials") that allows a user to choose which materials he used in a given project. The user then enters the number of these items i.e., "Rebar" "24" "PVC" "18&quot...

I'm sure this is out there in the archives somewhere, but I haven't hit the correct sequence of keywords to get me to it... I'm writing an "Incident" database. For each incident, there's a given "Action" subform. For each Action, there is also a continuous...

Hi all, **Cluelessness disclaimer: I know very little about servers, and am only forced into this situation because the person who originally set up the system left town.** I'm in a satellite office, and I use an offsite license manager to run one of my software programs (ESRI's ArcGIS). We...

hi listers, I have a combo box (Personnel ID) in a Main Form that asks the user if he/she wants to enter a new ID, if it is not already in the underlying Personnel table. If so, a Child Form pops up, the user enters the new data, and then closes the window and goes back to the Main Form. The...

hi listers, I've scanned through the archives and couldn't find the answer to these problems. I think they're easy ones, but I don't know how to do them. My already low Access self-esteem is sinking even lower...aaackk. I have a combo box on a form ("Form Parent") that allows the...

Hello listers, I've run into (yet another) Access problem that has me stumped. It started with an unfortunate finger spasm that deleted my latest and greatest "Incidents" form. To fix the problem, I imported the same form from my most recent backup. After that, I got an error...

Hi listers, yes, it's newbie time...this is no doubt an incredibly dumb question, but the problem has me stumped, and I couldn't find anything like it in the archives. The large problem: how to link to a table that has dual primary keys. The details: I am dealing with 4 tables: tblIncidents...