Search results

Is there anyone that can help on this? I'm still struggling to figure out why this subform will not work for data entry only. Anyone?

Any luck finding where this thing got broken pbaldy? I'm not sure what the heck I'm doing wrong!

I appreciate the help. Yeah,I haven't the foggiest why it is failing either (obviously). I've got my fingers crossed

Ok, it is attached. In particular, look at the consumers form under the Authorizations tab/page. I have 2 subforms there, the top one should be blank and used only for data entry. The data should look like shit since I did about 10 find/replace to randomize what was in there. There is also a...

Relevant. The data entry form fields are bound. Should they be unbound?

With any luck this should have a simple solution, but I can't figure it out. I have a form (Consumers) that displays consumer information. On the lower half of the form are two subforms. The bottom subform (Authorizations) shows records from the many side of a one to many relationship, linked...

Ok, these posts have code with AddNew being used, any particular one I should focus on? I'm absolutely new at code, so I'm basically learning a new language (am literally? - whatever). Adding Multiple Records Populate Subform Record Insert New Records with Range of Values Multiselect Listbox...

Excellent! Direction! Ok, I'll take a look at what you've posted.

Ah, no hits. Understandable. Even if someone can't actually help me (or doesn't want to), any direction with which to help me focus my search? I've looked around for things about adding multiple records from one form and things, but so far I haven't found anything that I can use - or at least I...

I have a form with StartDate, 3 Comboboxes (Employee, Consumer, Service), and a button. What I'm struggling with is code to do the following: User enters a start date (mandatory), and values in all of the comboboxes (mandatory), then hits the button. The subform then creates 7 records with those...

Ok, so here is my database with rubbish data. I'm satisfied enough with the authorizations subform on Consumers, but I've hit a version of the same snag in regard to the timesheet subform on Employees. It's another combobox issue. If you look on the timesheet subform on frmEmployees, there is a...

I'd love to post my database but the data is confidential, HIPPA stuff. Is there a way to randomize the data? If not, should I just save a duplicate and clear all of the data?

I've given up on having a seperate form to enter in auth #s, and instead will just set up a msgbox to pop up when a user types in a unique auth # (If I can figure that out). So I killed the Auth Numbers table, added an AuthNumber field on tblAuthorizations. The problem is the auth numbers...

Ok, so the problem I am having with the structure you suggested is that unless a particular authorization number has been used, it is not related to a ConsumerID. This means that I cannot add new auth #s without their Auth data. I'm trying to set this up so that new Auth #s have to be entered...

So I switched the tables around as you suggested lagbolt, but the problem I'm having now is that my Authorizations subform (in Consumers main form), doesn't have a way to select which authorization to use when adding a new record. Attached is what the form looks like. Only date sorting is...

Ok, so my company does mental health work with our consumers. Before we start working with a consumer we need to get an authorization number for them. Following this, we use this auth # to request services for the consumer that covers a given period (usually 8 weeks, but it varies). At the...

So attached is what my Consumers table looks like with AuthNumbers and Authorizations expanded. (ConsumerID is hidden in tblAuthNumber; AuthNumberID in tblAuthorizations) And I really don't want to have a query that is drawing from multiple tables, because clearly it doesn't work (or at least...

Regarding putting data in manually, that's easy. Because linked tables behave like pivot tables, expanding a record in tblConsumers lets me see tblAuthNumbers, and expanding tblAuthNumbers from there lets me see (and add records to) tblAuthorizations, all linked back to the record on ConsumerID...

Actually... It looks like I've been thinking about this all wrong, my issue is one of many to many to many, I think. Each consumer can have many authorization numbers, and each authorization number can have many authorization instances (we reauthorize the same number multiple times for new...

I am using a Main form bound to quConsumersByActive-Inactive (which is is just tblConsumers filtered by unbound buttons on the form), and a subform bound to quAuthorizations. I am trying to enter authorization data for the consumer on the main form, but a sticking point seems to be that...