Search results

Hi all, i have a report i am running with hundreds of text boxes in it with their sole purpose to calculate totals. i have all the formulas typed correctly and everything works great. the problem i have here is that when i am finished with the report and close out my DB, the next time i open it...

i have a unique one here. i would like to create a combo box on my main form that contains all of the tables and queries available in the DB so the user can change the recordsource. i have a particular form where the recordsource changes daily, and i would like to have this combo box so even...

I remember a thread from a while back where someone posted a code showing how to make a selection in an option group required if there is a selection made in another option groupd on the same form. but i cannot seem to find that thread... what i have is a form that has two option groups (each...

I have a dilemma that is really driving me crazy. i have a DB that the users will be inputing data into based on the a couple different results for each task. for example. if the user completes the task they will select an option within an option group (values 1, 2, & 3) and the user also makes...

I have an interesting one here. i am using the Tasks database template with MS Access 2007 and when a user selects a task to open, the Task Details forms pops up. the question i have is, would it be possible to auto populate the assigned uper box with the user's computer login? thoughts?

i have a table where i have a couple hundred records bound to a form. i have added a combobox to this form to show all of the calues in the primary ID in a dropdown. what i want is to have the user select the primary ID from the dropdown and then a bunch of text boxes on the form (each text box...

i am looking to create a form where the user can type in a city in one text box, and then a second city within another text box, click on a command button and calculate the distance in miles between these two locations. i am a bit lost as to where to get started on this, and any help would be...

i have a form with many text boxes and many labels positioned next to them. the text boxes and labels are postioned in a way that looks like a grid. if the end user types something into the first text box, the already in visible label next to it becomes visible Private Sub Text_AfterUpdate()...

i have a combobox on one of my forms and i would like to have a specific invisible text field become visible, only if a specific selection is made in this combobox. for example, i have text field labeled "tst1" on my form and on load it is set to visible=false. and within my combobox there are...

i have a table where a user will input data into one field and i would like another field on that same record to populate based upon what was typed in that first field. for example, if the user typed "Cat", "Animal" would populate in the other field. if the user typed "Baseball" in the first...

i understand this may be a bit off topic, but i have a page within access that the end user will type in the id of a coworker, and what i would like is when a specific id is typed, a disabled/locked text box nearby will populate with that coworker's supervisor. any help would be appreciated. thanks.

i have a command button on my form that i do not want to be enabled until 1 of 10 or so passwords are typed into a text box on the same form. i wish that i had more insight on this then the zero i have, but i am pretty lost on this one. is anyone able to assist?

i have a form that generates emails and the end user has the option to select upto 20 "lines" to display in their email. problem is, the user may not be utilizing all 20 options and possibly only 1 or 2. what i would like is if the user selects any less than 20, than the remaining "Employee...

i am about ready to give up on a project i am attempting to complete. i have a form that is going to be used for generating email and within this form is a subform. the subform is viewed as a continuous form. what i would like is to take the contents of this subform and send them as the body of...

i have some coding in my form as follows: DoCmd.SendObject objecttype:=acSendForm, _ ObjectName:=strDocName, outputformat:=acFormatHTML what this does is send one of my forms as an attachment in my email form. what i would like to doe is have this form (which is in continuous...

I have a form with 20 Combo Boxes in it organized vertically. my goal here is to have only 1 combo box appear on load and not have the second one appear until there is a value selected in the first one. and so on for the third, and fourth, and fifth, etc. these combo boxes are placed within a...

hi all. i am getting an error in my coding that i suspect may have a sinple resolution. the purpose of my form is to send emails and i have the To: and Cc: lines are predetermined. the problem that i am running into is in my subject line. below is a sample of my coding... Private Sub...

I have a form with two option groups in it. the results of the option button in these groups (three apiece) gets sent back to a table. my goal is to not allow a user to advance to the next page of the form unless a button is selected from both option groups. i have tried required fields in the...

I have a listbox on one of my forms what thats function is to search. theres tons of records loaded into this list box and there a text box nearby and when something is typed into it the list box dynamically search for matching values. very neat (got from a sample DB somewhere within these...

i have a form with many command buttons tied to list boxes. one of these list boxes allows the user to multi select email addresses and after pressing the corresponding command button places these email addresses into a different text box. another list box as multiple options in it where the...