Search results

I knew it had to be simple. One day I will find a VB programming book and answer the silly questions for myself. In the meantime, this forum keeps me at least partially sane.

I have a form that shows personnel - first name, last name, affliated company. I would like to put a command button on the form to enable users to sort the list by any of those fields (even if it means three buttons - I don't mind). I found "me.orderby" but then I don't know what happens next...

Table structure (the basics): Eg: table 1 (projectid, project number, project name) 1...32...Smith Smith Road Centre 2...54...Alpha Alpha Centre Eg: table 2 (issue id, projectid, issue, report yes/no) 1...1...Roof leaking...............yes 2...1...Floors need polishing....no...

Okay, found a work around, and possibly an answer as to why the field in the heading changes. The current box in the header of most of my forms is bound to a field in the table; so when you go to a new record - there's no data for it to pick up. First - in the open form command button I've...

Okay; thought it might be clear as mud. I have a table with say 4 projects (field: ProjectID - 1, 2, 3, 4). I have a 2nd table "issues" that shows that ProjectID 1 has 6 issues (issue 1, 2, etc); Project ID 2 has 3 issues; etc etc. In the issues table there is field (yes/no) that the user...

I worked around it. The two layers of buttons wasn't working, 'cause once you made a selection you couldn't change it. I thought about making them Option 1 through 6, and just having repeating value in my table (ie Option 1 and 4 are both "green"), but it basically was getting too hard...

We have a table with fields (eg) "project id" and "issue" and "report". The table has several dozen projects, all with a number of issues. The reporting rules are that the top three issues are reported each month, but there needs to be flexibility to allow more issues to be reported if...

Hit the first snag - no "on click" option for the toggle buttons. I tried "on focus" but I get an error message telling I can't hide a button that has the focus.

So, if all my buttons are defaulted to the dims, because they're in front. All I need is a code on each dim button that says "on click, make invisible". Ah, but I would also need it to make the other two visible, in case the choice changes. If someone chooses green today, I need to "reset"...

Is it possible to create a toolbar that will open with each report, even if the database is opened on a different machine? I want some pretty simple buttons - close report, print report. Sitting with users in a one-on-one work through I noticed that they often go to click the "X" that closes...

I have a form with a series of "traffic lights". These are indivdiual toggle buttons, with an option value that corresponds to a table "Status Options", and feeds another Table "Project Status". So - if the green light is clicked the option value is 1, the status options table says that's...

Would love to, but its nearly 40MB and full of confidential information <sigh>. I'll keep trying to muddle through with the hints you've given me. I'll check other forms and see if they drop the filtered box as well. Maybe I'll hit one that doesn't and go from there :)

I have a database with about 80 projects in it. Huge thing with twenty-eleven different aspects of each project being reported. The prime purpose of the database, other than to collate information, is to enable project managers to produce a monthly report easily. I have two anomolies. One I...

I think I know why it's not working for me, but I don't know why it's not working :-) When I click in a new record (it's a continuous form), the combobox in the header (the one showing the filtered project #) goes blank. SO: On "Form 01" I have a command button that opens "frmKeyActivities"...

I don't follow. Sorry to be dense. It's Monday am. In the header of my form I have a combo box called "ProjectID", which is filtered to the selected project. The filter is code attached to the command button that opens the form. I then have a 2nd combo box in my details that section; and...

Our database has been updated to include links/programming (I didn't do it, I don't understand it) to MS Project. Every since then I've been getting an error message telling me that I'm missing a reference to the "MS Project 11.0 Object Library". I have to turn off the reference in VB before I...

At the beginning of my database the user chooses a project to work on. Everything (forms/reports) they open from then on filters against that project. (The common field in all the relevant tables is "ProjectID") If they create new record; however, they have to enter the project number into the...

I have a form with various "options". These have been designed on the principle of "if you tick this - then this shows, but if you tick that - then that shows". Works beautifully. EXCEPT - when you navigate away from the current record, the boxes that are visible are visible on all records...

Wohoo. Thank you. Worked like a charm. Just had to borrow some code from another form that was filtering against the specific record (the default seems to be to ask for criteria - and I didn't want that). Thank you! This forum is a boon to my health and sanity :-)

I have a form showing in continuous form mode, with a list of personnel and details. To protect it against accidental change I've set it to not allow edits or deletions. I'd like to put a button on it that allows people to edit the current record. What's the best way of going about it...