Search results

I want my database start form to maximize on open, but the other forms to remain as I have set them. Right now I have in the onActivate event DoCmd.Maximize and it maximizes everything. Any suggestions?

thanks! my problem was that i wasn't using quotations around the , or blanks. what i wound up with was [last]+", "+[first]+" " +[int] and then just cut and paste as needed. I appreciate the help.

i need to import a list of names from another database. They are stored as 3 fields now: [last], [first] and [int], I want them all in one field that should show "last, first int". How do I go about doing that?

I forgot to alphabatize my reports when I made them. Is there a way to go back and do it, or do I have to remake the reports?

GOT IT!!!!!!!!! If Me![Male / Female] = "male" Then [MaxWeight] = [Height].Column(2) If Me![Male / Female] = "female" Then [MaxWeight] = [Height].Column(3) did what i needed in an afterupdate event for height. Thank you for your patience Dave.

? what is field4 for then? I select the sex (m/f), I select the height, and field4=maxweight? this would go as an afterupdate event for height, right? I need an english to Marine dictionary so I can understand. I did this: all the max weights are on one table now. the fields on that table...

so far so good Thank you for your concern, she's doing much better. I solved the color problem by inserting this If [Weight] > [MaxWeight] Then Me!Weight.BackColor = 65535 If [Weight] < [MaxWeight] Then Me!Weight.BackColor = -2147483643 If [Weight] > [MaxWeight] Then Me![bodyfat%].BackColor =...

how about this I'm sorry I haven't responded back until now, my wife was hospitalized last Monday, and I have been rather busy with my children. I can put all the maxweight's in one table and have 3 columns;[MarHeight],[MaleMax],[FemaleMax]. Would that make it easier? How would I make it...

no joy They male/female part is not working for me. This is how I'm going about getting the [maxweight] right now. For [height] under afterupdate the code is "[MaxWeight] = [Height].Column(2)" , it's rowsource=[tbl male ht/wt max]. How do I go about making it select from either the above or...

halfway there The backcolor coding works great, except it affects every record instead of just the one currently being worked on. How do i fix that? Now I'll try out the lookup on the male/female part.

and one other thing after the fields are filled appropriatly...I would like it to change the background color of [weight] if [weight]>[maxweight], but I'm not sure what statement to use. I'm so lost :(

I have a form with many fields, 3 of them are [male / female], [height], [maxweight]. The height/weight standards are differant for men and women (for the military), and I have them saved on 2 seperate tbls. Here's where it gets tricky (to me). I have a combobox on the form that lets you...

i actually want to affect each record individually, the only items changing will be checking/unchecking boxes. but thanks for the help.

You should be able to use a "find duplicate" query to do what you need. I haven't used one myself, so I don't know how to set it up, but it sounds like what you need.

to clear things up my main switchboard has a subform on it that shows me what crew (days or nights) all of the Marines that work for me are on. I would like to be able to update their info through the subform rather than opening up a second form that displays just that one persons information...

no go There isn't anything on my switchboard to link to the subfrm. I want to be able to update my subform and have it change the table that it's based on.

My switchboard has a subform on it that doesn't allow me to change the data (in this case check boxes). If I open the subform alone it allows me to, only when viewing it through the switchboard is it locked. Where do I change the property to allow updates?

Thanks for the help guys. I've decided to make the "shop selection" an item on the switchboard and put a note at the bottom in big red letters advising the user to select their shop first. I appreciate all the help.

i am going to distribute this db to my whole squadron (i'm in the Marine Corps), I will not have control of it, or access to their copies once I send it out. Basiclly I want to provide them with an easy (Marine proof :P) way of naming their own report. I think a combobox is what I want, and...

i don't get it? The report will be identicle in layout for everyone with the exception of the Title. I want to make them choose the "shop name" from a form 1 time only, and then have the db put that shop name in the header of the report from that point on. I don't want to make them do it over...