Search results

Greetings friends, I have a problem that I am sure is simple for you, but is evading me right now. I am trying to create a database for someone who reads meters on a monthly basis. The readings are related to the meter, and have the month associated with the reading. I created a query so that...

Hello and sorry to bother you all. I have a query which is based on a between statement of dates. Between [Enter Beginning Date] and Date() The other column is a count field, which sums the total number of records between the two dates. My question is, how do I display on the report or in...

Greetings all, I have a user who is trying to run an Access database. On everyone elses machine, the application runs fine. When this particular user, on his machine, runs the application on one form we get into trouble. The form is a tabbed form, and only occurs on one of about five fields...

Greetings all, I have a question for you to which I am sure you already know the answer. I have a '97 database application in which I specify the workgroup in the shortcut. "C:\Microsoft Office\blah, blah, blah" /wrkgrp "\\pwrmorahq1\cirs$\cimes\system.mdw" We are now loading Office XP on...

Greetings, I am working on a form which needs to prompt the user to enter data based on specific information. Part of the data looks to see If Me.Code = "220" And Me.LocationOfOffense = "14" Or Me.LocationOfOffense = "19" And IsNull(Me.PremisesEntered) Then Cancel = True MsgBox...

Greetings, I have attempted to upsize an Access database to SQL, and thought that I was realatively successful. I had problems with five tables, but thought I had figured out a work-around. But....... Here is the problem. Five tables upsized without any problem. These tables power subforms...

In a database, when the user logs in I have a query which looks to see what reports the user needs to write, (based on their logon,) and then shows a pop-up form with those reports listed. Until today, I had it working so that if there were no outstanding reports, that the form would cancel. I...

Greetings, here I am with yet another question. I have a form with many subforms. On one of the subforms - OffenseInformation - the user selects offense codes for an incident, and is allowed to enter as many codes as apply, (out of about 50.) On the Victim subform, each Victim must be...

Greetings, I am having a difficult time with something which should, I think, be pretty easy. I have a subform with three fields. Focus should only go to the third field if the data in the second field meets the criteria, else it should tab to a new record on the first field. I have been...

I have a checkbox which, if checked, directs the user to an option box to select an option. If the user selects an option, then decides that his original choice was incorrect and he unchecks the checkbox, how can I get the option button to deselect? I Tried: If Checkbox = False Then IsNull...

I am just wondering what the naming convention is to set the focus from one subform field, to another subform field. I assume you put it in the ON_Exit event something like Forms!MainForm!Subform.Field1.setfocus? Thanks Peter Paul

Greetings, I am attempting to get a statement to work, and need some assistance. From the last field in a subform, I need to evaluate if the OffenseCode = "220", and if the LocationOfOffense = either "14" or "19" If these two conditions are met, then the focus needs to go to PremisesEntered...

I am trying to make a field required, only if certain criteria is met in another field. If ExceptionalClearance < 6 then ExceptionalClearanceDate Is Required? Thanks for any help, Peter Paul

Greetings. I am creating a new form for use which has several parts to it. The subforms are needed to allow for multiple entry of items. On the one of the subform, I need to have a subform to allow for multiple choices. Access will not allow me to have a subform on a subform which is set for...

I have several forms which have an OLE for the users to insert a Word document for a narrative, or for that matter, any other object they choose. I have been having this problem; the user types in a narrative, then exits the field. After reviewing their narrative, they decide to edit it. So...

Greetings, I am trying to do something which I think should be fairly straight-forward, but alas I am not getting it. I am creating a form for criminal incident reporting. One block of information, allows for multiple selection of up to three choices, out of a possible 8 options. When the...

Ok, let me try to explain: I have a field, Offense_Status which needs to have either A - Attempted or C - Completed put into it. I would like to have option buttons for the choice. The book I am using says that I can have the option button enter A or C for true or false, but I cannot get that...

Greetings, I am attempting to do something which I am sure is easy to do, but I cannot get my mind around it. I have a dropdown field which shows codes and a description for the field. I have the field storing the codes, because that is the data which is significant. However, when a person...

I am hoping that someone can explain this to me in a way that I can understand. I can't seem to get my mind around it so far..... I have a form with multiple subforms. The main form has a unique number, a Case Incident Number, which is the parent field to tie the subforms to it. One of the...

I am attempting to create a macro which will move all of the data in specific tables to disk,(from a machine with no network capabilities) to transfer the data to the "headquarters" table. I have gotten this to work pretty slick, except that the narrative field is an OLE, and the data is not...