Search results

That's exactly what I did. I referred to the subform, and used the above methodology. I found some strange behavior, though. Which made it "work". Behavior as follows. Whenever the subform opened, it opened to a new record, even when using.. DoCmd.OpenForm "Votetbl subform", , , "[ID]=" &...

The Dcount works perfectly! Thank you pbaldy! but.... The plot thickens. When clicking the button now, it asks for a PersonID parameter. The ID field is being brought up properly, however the form being opened has a subform for the PersonID table. Any thoughts?

Thanks pbaldy for the quick reply. The RequestID field is numeric, however text33 and Person are text. Additionally, I'm looking for the Condition statement (in red below) as well. Basically, if that record exists, then go to it, if not, else create a new record based on ID. I have the...

Back again with another good one. I need to open a form based on multiple fields in a single record. I was thinking maybe Dcount could do this, but am unsure how to write it... For instance. If the value of field "ID" AND "text33" is in table [tblVote] Then Goto that record in a Form...

Cronk, THANK YOU! Creating the multiple field index was exactly what I needed to do. I had a problem displaying all that information on one form as well, until I read about the subform feature. You rock!

Hi Cronk. The two tables are set up in this fashion. tblRequests ID (PK) - Autonumber Requestor - Text Start Date - Date/Time Request - Text tblVote VoteID (PK) - Autonumber RequestID - Number PersonID - Text (Pulled from active directory using a Module) Vote - Number (depending on option...

I have multiple users that will be voting on one particular record in separate table. I'm having a couple issues here. 1. Linking the one request table record to multiple records in the voting table. 2. Ensuring a unique UserID can only vote once per request record. I'm positive there...

OK, this has been stumping me for quite some time. What I would like to do is have about 10 users fill out an Options Group in another table (tblVote, [field Vote]) while referencing specific records in another table (tblRequests, [field ID]). The part I can't wrap my head around, which...

I've had to relink my backend tables to the frontend when I moved from one server to another. Not sure if that will solve your problem, as I received a different error message after moving it.

Hi All, I have a Frontend DB in accde format residing on a SharePoint site. For some reason, the attachment buttons are greyed out when accessing it. Additionally, that same Frontend DB resides on my local desktop, and the attachment buttons work fine. The attachments field is stored...

Hi All, I'm back again with yet another awesome question! I'm looking for a way to look up all the members of a DG and place those names/network IDs into a table. I've read some through some things in the forums and thinking LDAP may be able to do this. Or perhaps I'm going about this...

I should have also stated that the combobox on which I'm trying to sort by is alphanumeric. The first two characters of each value is numbers, but the rest is not. Additionally, sorry still a bit new to access, what do you mean by join in that table to include the sort field? Wouldn't I...

I'm full of questions today... I have a report that has a link on it to a form. When I update this form when I'm in my .mdb, it autorefreshes the report when it regains focus. Now I have pushed this to a .accde format, that no longer happens. Pressing F5 seems to refresh the report...

Hi again, all! I was wondering is this was possible in access. I've read material on grouping and sorting, but haven't been able to pin down what I need. I have a combobox field that has 14 entries, beginning with 01 as the first two characters. What I'd like to do is change the order in...

Ok, I jumped the gun a little bit! Turns out I was missing a ' the whole time after the field was identified in the criteria. This works perfectly when the syntax is correct! If DCount("[ID]", "Employee", "[ID]='" & Me.Text33 & "'") > 0 Then Thanks!

I'm having trouble getting this to work properly. I'm failry new to access and I'm sure don't have all the concepts down. The table name is Employee, and ID being the field I'm trying to compare LoginID (a textbox on the form that is pulling the ID) with. I've attempted using the...

[SOLVED] Enable Button with Validation Rule Hi All, Got another for you elite coders... tell me if you think I'm going about this the wrong way or if I'm making this WAY too complicated. I have a button on a form that when I press it, I want it to validate a user's Windows Login ID in a text...

Starting a new thread on this as it's slightly different. I'm pulling in the manager field from AD hoping it would display just the manager name, but am getting a bunch of extra fields. I think this is what Galaxiom was speaking of when referring to a multivalue field. Is there any way to pull...

Hate to revive an old thread, but this post provided me with a solution to a question, so thank you! Now I'm pulling in the manager field from AD hoping it would display just the manager name, but am getting a bunch of extra fields. I think this is what you were speaking of when referring to a...

My name says it all. I am COMPLETELY new to Access; However I do dabble in SharePoint design and jquery. Hope everyone is ready for some off the wall questions!