Search results

I have several forms that contain subforms. I require it to be an option that fields be left blank and saved that way. I get the error "you cannot add or change a record because a related record is required in "tblendreason" (or whatever table the combobox related to. How can I make it so...

Hi there, I have a series of forms for users to enter data about isolated patients. I have two tables with a parent-child relationship. The parent table contains info about the patient (tblPatient), and the child table (tblCase) contains info about the specific visit. There are also tables...

Similar question here: http://www.access-programmers.co.uk/forums/showthread.php?p=890844#post890844 -Z

Hi there, I have a series of forms for users to enter data about isolated patients. The first form in the series contains a listbox linked to a query that displays all of the patients that are currently present and under isolation at the hospital. I have two tables with a parent-child...

I have a similar (almost identical) problem. I DO have a parent child relationship in my db. I'm not sure about the OP, but I find this thread VERY useful.. Im a bit confused by this though.... " "[project Name Field] = forms!CurrentForm!listboxname.column (("ProjectNameColumn#") To...

Hmmm, it also doesnt seem to be opening the correct record, and it leaves the child record part blank....

Now I'm having trouble trying to get the dbl click function working. I've built a form identical to "frmlookup" but plan to lock out all of the controls except for "End Date" and EndReason. Whenever I double click one of the displayed records, I get the error "microsoft jet doesnt recognize...

I actually haven't yet, but I really dont understand what bob means when he says that, so I doubt I could figure it out :) -Z

Thanks very much! -Z

Hi there. I found this example somewhere (see attachment search multiple fields.zip) and thought it would be great for my DB. I have a list box set up in my database's startup form that displays all of the open cases (child records that have a null value in the enddate field). I want to...

The code was Private Sub EndDate_AfterUpdate() Me.cboReason.Visible = (Not IsNull(Me.EndDate)) End Sub But I've just set cboReason to stay visible all the time and ask users to leave it blank unless they are clsoing a case. If you want to see the actual DB I'll be attaching it in my next...

Why the heck should it matter by what method the data was entered? Shouldn't it read the field after its updated? Like the event says? Can I use another event? On dirty or something? -Z I guess I'll just label it so that users dont fill it out.....stupid ms access

It now works when I manually type in the date, and clears when I clear the control, but I still get nothing when I use the ajbcalendar control -z

here's my code: Private Sub EndDate_AfterUpdate() If Not Null Then Me.cboReason.Visible = False Else Me.cboReason.Visible = True End If End Sub Hmmmm the control doesnt seem to go back to invisible if the field is blanked either. Im stumped...

Im using the ajbcalendar button to populate a text box for dates. I have an afterupdate event that makes a control visible when the value is not null. It works fine if you type in the data manually, but not when I use the calendar button. What gives? -Z

Ok, I think that I am pretty set on how to lead users through the data entry and editting portion of my database. Start Page - A List of all cases that have "IsNull" for an EndDate. I have a listbox that runs off of a query that will display all of these records. So the user will first check...

Thanks for the help. I dont feel quite so lost now. I have a question, in the subform that displays all of the child records, the fields included are the ID numbers from the tblCase table and not the actual names from the other tables. I plan on the view for the subform being "single form"...

Hi there, I have a TON of queries in my database, and I'm not sure if I need them all, they seem to be slowing my DB down alot. The Db only has one table, which keeps tracks of incidents and all their details (location, date etc.). I want to report back to the managers of the locations...

Yea actually the file was made at work on MS 2003 I think. Im at home now using MS 2007. Is that a problem ? Enable what?

Im sorry Dcb, that new combo box doesnt seem to do anything. Do I need a button or something? was it just a hint ? I dont get it :( ....