Search results

The form wizard (to my knowledge) won't help you with combo boxes. You can either finish the form using the wizard, then go to the design view and right-click on the field you want to be made a combo box. Select change to, and then combo box. You can adjust the properties for the combo box...

What wizard are you using, the form wizard or the combo box wizard?

...or something like that. Here's what I have. )> A macro that essentially directs Form1 to >Save 1.OpenForm2 2.FindRecord based on matching ID field between the two forms (to see if individual exists in Form2) 3.GoToRecord New (if meets the condition that the ID doesn't exist in Form2)...

Another question for you moleary: Do you need to keep those entered into the intake table and those transfered to the "master" table separate, or do you keep the info in the intake table even if a potential client doesn't become an official client? If you hold onto all the information, why...

This method might work for you: First, to "eliminate" the "duplicates," create a query with all the fields you need in it. Click the Totals (Sigma) button and select "Group By" for all of them (it should do this automatically). Save it. Create another query using the first query as the...

Good luck...I've been trying to get some help on a very similar situation but never get much of a response (at least nothing's worked yet Hope someone comes to our rescue!

One method that I have used is including the name (first & Last) in the combo box with the ID, just for display purposes. Then when they click on the down arrow, they can select the ID based on the name right next to it. THe ID is stored and displayed in the field, and the name is not. If...

Wouldn't a query combining the tables your main form and subform (and thus the 6 fields you need) work?

Also, the group by function won't work if you include other fields and the data in them is unique. It only groups records where data in all fields is the same. To remove duplicates from a table, you need to use a Find Duplicates query (you can use a query wizard) to find them, and then, if...

I'm much better at these things visually. If you email me a copy, perhaps I can help.

Would the filter (by form or selection) help you better? The advantage of a query would be to save the results, but if you just need to view them in that instance, filter would probably better suit your needs, and then it would be displayed in the form you've already created.

You probably can solve this problem in the report you are creating. With the Sorting/Grouping options in the report design view select the location (or whatever field you want to sort by first) and then in the properties select Group Header=Yes. That will give you a group header on your form...

Why not just skip opening the form based on the parameter query? Just open the report based on the query to eliminate 2 steps.

Ahh...it's all becoming clearer... What you are looking at is not the subform's design view, but the main form's design view (when the subform is displayed as just a large blank (white) box). You must double click it to open it and modify it's design, or, as you said, you can just open the...

Not sure what you mean by "actual fields"? Are you displaying your subform in datasheet view? Because when you go into the design view, it will display in in what you call the "white block" form, with which, most design changes won't be reflected in the datasheet.

I know I (and others) have asked various forms of this question before, but I am still struggling with this. Please be patient, I want to explain myself well so that I get useful input (of course any input is better than none at all!) I have a form of "General Contacts" that will be the...

I didn't mean to belittle those of us (yes US) who come to this forum looking for help to seemingly basic questions. I still consider myself relatively new to the wide world of Access, and database operations in general, and have often found enlightening advice here (sometimes I have to search...

Instead of what?

I'm hoping that after the long weekend, somebody might have some more insight for me...I really need to get this code squared away and working so that I can get my db fully functional. Thanks a lot!!!

I'd have to side with j here, and feel that raskew is *somewhat* out of line...though I sometimes find it annoying that some of the posts here seemingly so basic, and could be answered just as quickly/effectively by MSAccess Help or Bible or whatever, many many people on this forum use it as a...