Search results

Thanks for your help AjeTrumpet. In the end I used something similar which was strNum = Nz(DMax("ProjectCode", "TblProjectMain", strWhere), 0) And this worked. Thanks again.

Thanks for that, I'll give it a try:)

Hi everyone. I'm having a problem with my code. Hope someone can help. This concerns two tables. tblCountry and tblProjectMain. tblCountry is the parent table. I'm using a combo box to select a country which in turn I can allocate a Project to. when the country is selected I'll press the...

Hi there I know how to reference a subform and a subform within a subform with VBA. I'm just not sure how to reference a parent form within a Main form using the Parent forms subform event. So, if I had a subform within a subform, does anyone know the syntax within the Subforms event to...

thanks for replying Bob. I'm sure I've worked it out now. It was just a bit confusing because I've never worked with Junction tables before. the forms were a little tricky as well. I'm just testing at the moment and if I run in to any problems I'll let you know Regards

Hi folks I'm having a problem with linking forms within my main form. I have a Main table tblMain that is linked to tblAmountApproved that is linked to a junction table and then another table tblDonor is also linked to the junction table like so: tblMain - tblAmountArroved - tblJunction -...

Hi folks I've been looking for way to programmatically copy and paste the contents of one text field to another within a form. Generally the forms have two sets of details that usually have the same dates and so on. sometimes they don't and obviously these could be changed manually. To be...

Thanks Simon! this has all helped and now that I have far more info than before I can put this issue behind me.

Hey, thanks alot MStef! that worked.

Hi Folks In my Main form I have several combo boxes to search for records. I'm having a problem with one of the Combos and I think it's because it's a number rather than txt. I'm using a CountryID from the Main table (with the Country field from the lookup table visible) and when I...

Hello all First of all, I'd like to thank everyone who's a member and has helped someone at some point within the forums! I'm quite new to Access and have received a massive amount of help on one of my first databases.:) As the title points out, I'm not sure about the WIF. If I have two...

Thanks alot for the help folks... That clears alot of confusion Edit: Actually, I have two more questions If I use the ID keys so that the main table is using FKs rather than names, I take it that I set the Bound column on the form combo to the ID but hide this so that only the actul name is...

I don't understand what you mean Rich? Have I not explained it correctly?

Thanks Dennisk for your help, I'll have a look at DateAdd and see if that makes things easier!

Hi everybody I have been unsure about this topic and want to finally be sure. When I create a lookup table I don't include a PK; I just have the one field. Therefore I don't include an FK within the Main table; I include the same field name as the field name in the lookup. "sector Details" in...

Thanks Dennisk for the reply. I would like to ask a question. would I create the query and subtract 4 weeks from the date and put this field into a report? I guess this would be the easiest way to view the records. I'm unsure of how I would use criteria. thanks

thanks Pat. I put them into separate table.

Hi All I've been looking at a couple of things that can help me and can't find anything solid. I hope some of you can help or at least point me in the right direction. One of the forms I'm working on has dates that reports are due to sent in to the Organisation. the dates are usually worked...

Hi there. I just wanted to ask peoples opinion on something. In the database I'm working on I have to create two new tables that will be joined to the Main table. each of the new tables has only one field (as well as the FK) with a one to many relationship with the Main table as there will up...

Thanks for getting back to me Rich! The reason (I believe) a subreport wouldn't work is that I have to take dates from the many side ( the installments table) for criteria against the report. These are Schedule dates that the money would be disbursed. If I create a subreport with the...