Search results

Well, this was used on both my input forms (The State and Research one that looked and acted identical). My "funds" field combo box (State/Research as choices), I had it defaulted to the corresponding Input form with this code behind the form. So that if someone choose to Input state, funds...

Private Sub Form_AfterUpdate() If Me.Funds = "Research" Then Me.frmUserAccts.Form.fkAcctID.InputMask = "00000-0-00000;;*" Else Me.frmUserAccts.Form.fkAcctID.InputMask = "000000;;*" End If End Sub How do I get this to work though?

That is realllllly coool!! Thank you again.

Also, what would I have to change with the exisitng set up so I can get this code to work?

The account number is not that serious in respect to who has rights to create it. I want to allow all users to be able to link an account number to their username at any time. This is code I would need for option 2?: Private Sub AcctNo___NotInList(NewData As String, Response As Integer)...

Well, this is going to be my input form I assume, so I changed the main form, with the subforms to Allow Data Entry. When I get to the first subform, I go to add an account and I get an Access Error message stating: "You cannot add or change a record because a related record is required in...

See, I'm missing something here because I used tblAccounts and tblVendors for my subforms ONLY because they included the actual fields I needed (for input) (for example "acctNo" and txtVendorName") I tried using tblUserAccts, tblUserVendors, but those tables include fields (keys) from other...

Here is a copy of what I have so far... Those two tables, UserAccount and UserVendors are not filling. Also, for my Vendor list, for some reason I couldn't get it to display, I finally messed around and got it, but it's not working right.

Am I suppose to make a query for each of my subforms on my Input form?

Thanks JZ, I'm going to set this up probably Monday, with the Input forms and what not. I may or may not need help on the Search Queries/Forms, if I do, I'll give you a holler. Again, thanks for everything so far.

OK that seems to work. Couple questions?? 1. I know what foreign keys are, but in terms of access, is there something I have to set up to make it a foreign key (for example, the primary key has that little key icon that you have to click to set it up as the PK), or by putting the same name in...

No, what it is is our Purchasing Agents (usernames) have access to certain accounts. Yes they will make orders with these accounts, but this database isn't capturing any orders. All it's capturing is the usernames, what accounts they have access to, and what vendors they have access to...

The account number is assigned by us to distinguish departments and/or grants from each other.

Thank you for the time you already have spent trying to fix my design..I knew there was probably a better way. Anyways, this database is fairly simple. I have many purchasing agents in my office who are incharge of ordering supplies from any of these 8-9 vendors (office max, fisher...ect)...

Hi All (Access 2003), I recently received help on the forum and was able to set up my first subform for a database I've been working on. I wasn't sure exactly how to do it, but worked my way through it with some help from other users on the site. I thought life would be easy after that, but...

Oh I see what that does..

Does that go in the main form or the subform's after insert?

Perfect and yes I like that it directs the cursor to that field...thanks so much!

Let me clarify to...if the user selects YES to approver, THEY MUST ENTER into the approver field

Thanks! Its the State Input Form