Recent content by Ethereal

Danny, Below is a outline of the new application that I would like you to write. In a nutshell, this application will test the connectivity to specific network dirves/directory and display whether the connectivity test passed or failed. I see this as something that automatically runs once...

Post a sample of your problem.... I am having trouble invisioning it

Is there a way to find out which user is using the form ? Not the access account, but the actual windows account

Glad I could help, These forums have been a lifesaver for me... Thought i'd pass it on

I implemented what i said should work, It did :P Check it out and see what you're missing .. My instructions weren't 100% codeworthy, but this example demonstrates what i wanted to say... I also added a calander feature you may be interested in using and put a big button with a pic of a calander...

forgot to take off the separate delete button lol, i originally had a separate form, and that one justdisplayed them. But i thought it might be easier to put the delete right in there. Edit: Just implemented the changes to my application, Works perfect! THANKS!

does all the information have a controll source ? also the "on change" event occurs after every single character you type, so it might not be a good idea to requery there

Err.number = 2456 Err.Description = DBname Can't find the field 'Forms' referred to in your expression. I made a Sample DB emulating what i'm trying to do ... however, now i get a different error... If you could take a peek that'd be great :D

If you want to do anything complex with the body i suggest you work with an outlook object and use HTML body, you will need to check off the outlook object in referances. www.outlookcode.com, there are some samples there that might aid you, Other than that you have to write out the body...

just go something like this ... txtDate = Me.cboYear & "-" & Me.cboMonth & "-" & Me.cboDay... this assumes you have a number in the month box... if not .. . populate the combo box with 2 column IE 1 | Jan, 2 | Feb, etc then instead of Me.cboMonth make it Me.cboMonth.column(0)

I need to have a button on my continuous form that deletes the corresponding record... I used the wizard to create the button, but it doesn't seem to work... Any Ideas?

yes, just set the control source of the check to your table, but change the fields to yes/no fields

i didn't change the label on "yes" but that checkbox corresponds to three values.... True, False, and Null... As i left it there it doesn't save info to the tables, you have to set the control source of that box to the correct field in your table

for a search form perhaps you would want to make it similar to the form in that screen shot but instead of text boxes you would have combo boxes... Their rowsources would contain the values from the corresponding fields using the query builder. However you do not want to make such search...

Ok, I have altered the format of your table... The fields are now yes/no fields... If you click a box it's yes.. If you click again its NO and if you never click at all it is Null or (N/A) Now you have to set all the control sources of the "yes" buttons on your form to the corresponding fields...