Search results

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...

either/or would work

i appreciate it, but this does not seem to be doing the trick for me. If i made a copy of the Tasks form that i use on a daily basis (which pulls its data from a query that pulls from a table and filters many many many records so that only the current date's tasks are presented) and removed the...

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?

hey, in reference to you post on 6/21/08, the sample main menu DB, i find this to be a really great starting point to a database i am currently working on. the only question i have is, it would seem your set up of the menu limits the user to adding upto 6 options per group and any amount after...

this example worked like a charm form me when i opened it in Access2003. i am now trying it out in Access2007 and the "Method" or "Data Member" (?) of Column doesn't seem to exist in VBA. very odd...

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 appreciate all of the input. but let's say i choose to simplify things... say the applicable cities are Boston, New York, Chicago, Seattle, and Los Angeles. in combobox # 1 the user selects Boston. and then combobox #2 only give you NY, Chi, Seattle, and LA for options (excluding Bos. as it...

very truw. just trying to provide an offline alternative to the users

that may be a bit too complex for my liking. what i was shooting for was either: A. i have a tables with City1 as a field and City2 as a field. then in field 3 i have the miles between City1 and City2. then if in the form, whatever selection is made in the City1 ComboBox, the City2 ComboBox...

you think latitude and logitude may work?

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.

perfect. that worked! thanks!

when i have the varArray up top set to 1 to 9 or 0 to 9 it will only acknowledge the password in the record #9 on my assigned table

do you have any idea why/how these fields may not be loading into the array?