Search results

Hi Minty, thanks for the prompt response again. It's because of the need to have cascading cbo boxes that a subform is needed. There will be MANY facs > schools > subjects > specialisms when the data goes in, so having them as standalone cbos would be horrible. But I found when I had a...

Getting an error when entering a new item. When I select a building I get: You can't assign a value to this object. But then I click OK, and I can...?

It's like submitting an assignment - arrrghhh! ;) EDIT: One of the cboboxes is broken in the subform, it needs to be changed to: Me.cboFIDSpecialism.RowSource = "SELECT tSpecialism.[IDSpecialism], tSpecialism.[SpecialismName] " & _ "FROM tSpecialism " & _...

That sounds like bad news :( I've attached a stripped back, RL data removed. The forms are now fLocationV2 and fLocationV2Subform (rebuilt today to make sure I hadn't done something stupid - entirely possible :D). EDIT: the continuous form fLocationV2 should have the fields that would...

Hi Sneuberg, thank you for the quick response. I've tried de-linking the forms already and it didn't work. I'll try to do some more testing now and report back, see if I can get any more useful info to help pinpoint the problem. I've also run the compact and repair to no joy.

It has to be something on the form that's causing this. I went into the table (tLocation) and tried to add a new record and it did the same thing, used a already used ID. I recreated the table and imported the data. Table worked fine, until it'd been used by the forms? fLocations Record...

Further to a previous thread... and valuble advice from Minty about being able to have a subform of a continuous form (in the footer)... I have a continuous form (fLocation) based off a query (Record Source: SELECT * FROM qLocation) which in turn is based off a table (tLocation, which has...

Ok, sorted out the filter. Found this VERY useful comment elsewhere So my filter for the form (when not in the navigation subform) was this: [Forms]![fLocation]![cboFilterFIDBuilding] Dropping it inside the Navigation Subform, it becomes...

Hi Minty, I thought I'd tried that and had it fail, but clearly not. I've just switched from a popup to putting it in the footer. Thanks for that. Quick question, before I close the thread, related to this form, I've just put it into the Navigation Subform and the filter I have has broken.This...

I think I'm going to have to revisit how I do this form if no one has a solution. I found this suggestion below a week or so ago when I was looking if you can have a subform in a continuous form (no). I did try to place a subform in the footer of my current fLocation, as per the quote above...

As mentioned above, I've changed the filter. Here's the code if anyone finds it useful. Private Sub cmdFilter_Click() Dim strFilterStart As String Dim strFilterEnd As String Dim strFilterBuilding As String Dim strFilterRoom As String Dim strFilterUsage As String Dim strFitlerFaculty As String...

Ok, I've removed the filter fields entirely for now, but it doesn't effect the problems on the body of the form. For the Header filter I'm going to not bother with an after update event on them because it was getting so messy, but do it from a button that checks the contents of the filter...

I hope some people will be so kind to help me with a form I'm having huge trouble with. I've attached a stripped back database (removed non-related tables and other forms and filled with test data that doesn't represent RL). There are two forms here, both continuous: fStaff fLocation Both...

Ok, I've sorted this. The textbox (txtFIDUsage) control source: =[cboFIDUsage].[Column](1) Sorry for people's time!

I needing a continuous form (fLocation, based off tLocation) which users add records directly on. Fields are: IDLocation FIDBuilding (FK, to tBuilding.IDBuilding) --- cboFIDBuilding / txtFIDBuilding Room FIDUsage (FK, to tUsage.IDUSage) --- cboFIDUsage / txtFIDUsage FIDFaculty (FK, to...

Perfect, that works! Thank you (for both suggestions!), I knew it would be something simple.

I have a continious form (fStaff, based off tStaff) that has the following fields: IDStaff (autonumber) Firstname Surname FIDRole (FK to tRole.IDRole), cboFIDRole Ex (Yes/No), CheckEx In the header of this form (fStaff) I have a checkbox (called CheckExFilter) If it's checked I want it...

This monster form is working, and now with error checking and everything also added in (and still working!). It's somewhat annoying that it looks like a fairly small form, which doesn't at all illustrate the effort involved getting it working and how much it's doing. I've learnt a LOT from...

Ok, ignore me, done this: '---------FUNCTION-------- 'equal to the number of locations in lstLocation, add a new record in tRequestDetail '(including the returned ID above from tConfigInfo) If MsgBox("Are you sure you want to append " & Me.[lstLocation].ListCount & " records.", vbYesNo +...

Code so far: Private Sub cmdBulkUpdate_Click() '---------FUNCTION-------- 'adds a record to tConfigInfo and returns it's ID. Const NewCIItem As String = _ "INSERT INTO tConfigInfo ( Configuration ) " & _ "VALUES ( txtCIfromBIForm )" Dim newID As Long With CurrentDb 'insert data...