Search results

Nevermind i got it thank you.

Accually now it just goes back to the way it was when i click off a record i also did it in design view and it does the same thing any ideas.

Thank you very much!

Never used charts before hopfully this is easy. I have a form that tracks billing and date billed and i used the chart icon and wizard to visually show the trends. The chart works fine only problem is all my data on the billing charge is in currency but on the chart it doesent show currency...

I use something like this but it only emails the person the .TO specifies not sure of your requirements but it works with out outlook being open however access must be open. make sure to reference Microsoft outlook 12.0 object library also the .display doesent send the e-mail it allows the...

Does any one have a working example (links) of the SendMessage function they could share cant seem to find anything simple on the web I found the declare im just confused on how to use it Declare Function SendMessage Lib "user32" Alias "SendMessageA" (ByVal hwnd As Long, ByVal wMsg As Long...

Private Sub Frame19_AfterUpdate() If Me.Frame19 = 1 Then 'frame 19 is your option group 1 would be yes' Me.Frame4.SetFocus 'frame 4 is the how satisfied are you option' Me.Frame4.Locked = False 'need to unlock it incase they select no first' Else Me.somethingelse.SetFocus 'Set focus...

Need some info is v4 an option group or a field options are either true or false so you wouldn't use isnull if me.v4 = false then ..... and you should use the after update if you want them to enter some thing or select something first before running the code sorry if im way off hard for me to...

you could have a submit button click or you could do this on lost focus event something like if isnull(me.yourfield) then msgbox "please enter a valid whatever",vbokonly,"title here" me.yourfield.setfocus end if the lost focus will check if there is anything in the field when the person tabs...

Are you using a save button you could do something like this Private Sub Command37_Click() If Me.List35 = "select" Then MsgBox "Please select somthing", vbOKOnly, "Blah Blah" Me.List35.SetFocus Else DoCmd.GoToRecord , , acNewRec End If End Sub

Sorry i was using q's and forgot to change a couple just use v or whatever your using

Why if v2 = 1 then your setting focus on v3 then evaluating v2 again It looks like your evaluating v2 on both why not combine them This is just randomness change your fields around for your need Private Sub q2_AfterUpdate() Select Case Me.q2 Case 1 Me.v3.SetFocus Me.v4.Locked = True...

You can use an after update event and an if....then.....else statement like Private Sub Combo28_AfterUpdate() If Me.Combo28 = "male" Then Me.Q1.SetFocus Else Me.Q2.SetFocus End If End Sub Your could also use select case statement if you need to evaluate more than one value. for your next...

Sorry didnt know about the demos i think i have a few ideas how this can be done graphically just dont want to slow down the loop too much ill take a stab at it thanks for the replys and info

Has any one ever tried running a loop until another one is done or is this even possible Just want to know if it can be done or if anyone has any examples Thanks in advance:D Goal is to have a loding bar that shows the user that something is happining and not doing nothing.

This sounds complicated if youve tried any code post it here someone can help im sure sounds like you need to try a loop..that will add or skip ie. select case or if statements but dont quote me on that one seeing is believing

Does this info have to be in 4 tables? Why not use one and use queries to display the info you want on a form? i.e build form from query.

In Access 2007 you can go to the properties on the text box got to format-show date picker- select for dates when focus is on the field a little calender shows up this is usually default if the field is set to date\time not sure on previous versions of access hope this helps

U could just use the totals button at the top of the query design looks like an E change the totals row above criteria to AVG sorry if im way off of what your trying to do may need more info like where your putting this expression what are the field names etc.....

1. Did you store the value from your month combo box into a field in the table? 2. Is your report from the main table or a query showing the most current record? 3. Im sure theres a way to do this do some reserch never done it my self though.