Search results

Hello, I am building a sort of property management database, and I have run into a bit of a problem. The database will store information about buildings, leases, maintenance etc.. My problem has to do with units in buildings. The tracking of units was requested near completion of the...

Well, it's official, I am a moron lol Ok, I got it working. I did end up using it in the criteria field for LeaseId, however this time I got the name of my Form right lol So in the LeaseId criteria, I simply entered: [forms]![Lease Offer]![buildingCombo] and it works perfectly. (Notice the...

Thanks Ken, In the mean time, I'll keep working on it :)

When I place it in the top row (ie Field), I still get a prompt. :confused: I'm not sure if it's even possible to filter an append query without user input. Maybe if I make a temp table, that will only store one field and have the form populate that field, then run the query and use the...

I was doing the Forms!LeaseOffer!buildngCombo.column(0) because the combo box has two columns, Column(0)= LeaseId, Column(1)= buildingName unit #.... (Column(1) was a work around I had to do and talked about in this thread: http://www.access-programmers.co.uk/forums/showthread.php?t=86584 )...

Do you mean in Design View? I tried it, but I don't know what to put in for the criteria. When I put in under the Field: LeaseId Criteria: Forms!LeaseOffer!buildingCombo.column(0) I still get my undefined function error. (Undefined function Forms!LeaseOffer!buildingCombo.column(0)) So...

Thanks for the quick response. It makes sense to me to include the condition right in the Query (since I'm only going to be running it from a single form, with a single record option). However, first of all, I didn't even know that I could use SQL for the query (although it is pretty obvious...

Hi, I am trying to run an append query, but instead of appending the whole table, I would like to only append a single record. I have an append query, and it works like a charm. I can also get it to work with prompting the user for a parameter (in my case LeaseId which is a primary key)...

Ok I solved my own problem. It was mostly just a work around, but for a good reason. You see I realized, that when there is going to be multiple instances of leases for the same tenant in the same building but different unit, my building combobox will simply display the building name multiple...

Hello, I have set up a form which will be used for filtering reports. I would like to be able to generate a single report and in order to do that I will have to filter three fields. I am using three combo boxes to achieve this. The three fields I am filtering are as follows: Tenant Name...

Hello, Although, I have seen many threads in regards to displaying images in forms, I have not been able to find exactly what I'm looking for. The solution I am looking for is to give the user the ability to browse for an image, select it and insert it into the form. From reading these...