Search results

Cheers RG, And thanks for the link - very handy indeed! Is there any way for me to fix it so it will autofill all the fields in the subform?

*Slaps Forehead* Thanks very muchly Pat! You know the whole can't see forest from trees thing? lol

No worries Mik, I hope it helps you with the relationships. Once you see how they work then you can link all sorts of data together. You had the right idea in many ways already. Your rates table relationship was off - you need to make sure you have a field the will correspond exactly to the...

Ok, It's very rough - totally unformated and half of it is running from tables (I run off Queries), but it's very late and I've been working 14 hour days on my longweekend on Access. It works, and most importantly, it will show you about relationships and how you don't have to keep typing out...

P.S If you're around, could you explain to me what PLODS and HOLES are or how they relate? Also, do you have SET rates per client, or will they vary per job?

I'll help you Miki. Gimme a few hours, and I'll post ur db (though it would help if you were more specific, and your db HAD a table called "consumables"). I'm also going to have to make several assumptions because alot of it looks jibberish to me. But, you should be able to see sort of what I've...

Hello again, I'm having some problems calculating dates with VB on my subform. Here's the code I'm using (attached to the SubFrm) Private Sub Form_Current() If (Not IsNull(Me.LastTest)) Then If Me.txtTestPeriod = 1 Then Me.ReTest = DateAdd("yyyy", 1, Me.LastTest) End...

Hi, I have a command button on my form that (usually!) allows me to switch between current and archived records. I'll show you the basic code (first part). If cmdShowArchived.Caption = "Show Archived" Then Me.RecordSource = "SELECT QryTools.* FROM QryTools WHERE...

Thanks again Wayne - this is fantastic! It will take a little while to fully comprehend the things I can really do with conditional formatting, but I can see it's potential. Thanks for pointing it out to me - I never really knew of it before. Lucky I'm good at expressions already. This should...

Thanks Wayne! Worked a treat. If you're still about, I have a second question for you, relating to the same code. Say I wanted to flag the background of the 90DayService with a different colour (Cyan I think!), to indicate the dates that will be expiring in the next two weeks (to match my Nag...

Hi There, My form is set up to show all current records, and allow users to select a button and then view "archived" records (I archive by having a Yes/No box). I'll show you: Private Sub cmdShowArchived_Click() If cmdShowArchived.Caption = "Show Archived" Then Me.RecordSource =...

The Return of the dreaded mousewheel! I have used the fab Search option on this topic, but I feel I have some requirements that prohibit me using some of the options available. I need to allow its use for navigation of the mainform, but totally block it on the subforms, but with lots of...

I need command button(s) to switch between subforms on a mainform in only one subform window (one subform already set as default). So in other words, I don't want a command button to open up new forms (I know how to do that); I need to minimize the amount of subforms and forms I have open by...