Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. nwprog

    How to set focus on a field list

    Use the Before Update Event for the Form. If IsNull(Me.yourselection) Then MsgBox "Please Make a Valid Selection" Me.Selection.GotFocus. End If
  2. nwprog

    Make textbox not visible depending on other textbox

    Crisis, I feel your pain as was in your shoe's not to long ago. If I have understood you correctly, you only want txt2 to show visible if your data from txt1 and txt2 do not match. If this is correct then on the properties sheet for txt2, set the Visible Property to false. This gives it the...
  3. nwprog

    Multiple Instances of form

    Rfoye, just a question, why so many instances of the same form. I've seen this before and I can assure you that depending on your circumstances, you may be barking up the wrong tree. I actually tried to do this myself not too long ago and it turned out to be a disaster. Multiple forms as...
  4. nwprog

    No-edit on form doesn't work for sub-form objects

    I guess my question is are the sub forms returning information related to anything in the parent from, or are these used to also enter data. Without knowing more about your specific needs its hard to place a solution. The sub forms are objects just as much as the parent form. This means that...
  5. nwprog

    a continuous popup form

    I have this same sort of thing based on a query. It works just fine for me. On the Properties sheet set your pop up to yes, and make sure that your form view is continous.
  6. nwprog

    Keep table accrate using Query

    Ginger, (I am assuming your a woman) If I could see you I would kiss you. You are a genuis. Thanks a million.
  7. nwprog

    Keep table accrate using Query

    Yes Ginger, the Data Entry Property is set to yes.
  8. nwprog

    Keep table accrate using Query

    You know its funny you should say that because I actually figured that out this afternoon. But since you were kind enough to respond, please allow me to pose the second half of my question with regard to this same form. The query is working just fine, but now I need to reopen the records in...
  9. nwprog

    Keep table accrate using Query

    Here is a intresting hicup that someone might be able to help with. As I am still learning, I'm not exactly sure how to approach this problem. I have a table that is based on a Create Table Query titled "Open Jobs". The Query retrieves data from one of my main tables called "Tower Calls"...
  10. nwprog

    Create a running list Using SQL

    Well your on the right track Remou, but you bring up a point that I hadn't thought of before, and thats using a continuous form. Thanks for the tip.
  11. nwprog

    Locking field after data input

    I agree with Remou. Personally my problem is that I'm still learning. I've done a little study on ASP but am focusing on VB2005 at the moment. The syntax is similar to VBA but the algarythms are slightly different. The advantage to that is you can build your own custom database in VB. So I'm...
  12. nwprog

    Enable/disable or start/stop timer on form ?

    Hmm, Well it might help if I knew why they were hidden to begin with, but try something like this. Private Sub formname_Load() Me.Form.Visible = False End Sub Private Sub formname_Timer() Dim cntdwn As Date Dim cntdur As Date Dim iCount As Integer If Me.Form.Visible = False Then...
  13. nwprog

    Locking field after data input

    Jack I've actually run into this problem once or twice, and as yet have not been able to come up with a solution. You might try creating them in XML and importing that into the .htm page. If your trying to create an DAP from within an mdb, hang it up, I've tried and it just doesn't work. To...
  14. nwprog

    Create a running list Using SQL

    I've been trying different ways to create a list using a form from the SQL Query. The table that the query is based on has several columns that are a combo box look up. I'm guessing that the Query is loading them by default. For the Requery I used DoCmd.RunCommand (acCmdRunQuery) I also...
  15. nwprog

    Load search from Form into Query

    Holy what a great resource! This is fantastic, Thanks for the tip, it has solved two of my problems. BTW, does anyone know how to make those great videos with the naration, those would be great for delivering my updates.
  16. nwprog

    Locking field after data input

    On your properties sheet for the control, set the Default Value to =Date(), and format your date style. Then change the Enabled property to No, and set your Locked property to Yes. I would also suggest setting your Tab stop property to No. That should keep anyone from altering your data.
  17. nwprog

    Create a running list Using SQL

    I've really come to rely on this place for help, your insight and inputs have been an immesurable help. Thank you. I'm strugling with an SQL problem, I want to create a list of open jobs when a particualar column is Null. The parameters I'm trying to display are tailnum, date, flt, and gate...
  18. nwprog

    Replacing One Time with another.

    Thanks for the input. This one is solved.
  19. nwprog

    Replacing One Time with another.

    Ok here is a tough one. I have a form that contains a timer. Two actually. The problem is that the second timer, won't always function. I've tried using If conditions to keep it from firing if the variable advtime is Null, but for some reason, this doesn't work. The idea is to replace...
  20. nwprog

    Enable/disable or start/stop timer on form ?

    Well you Question is a little bit vague if I've understood you correctly you are trying to open one form, start a timer that goes to 10 sec or 10sec to 0. I've worked alot with timers and countdowns and it would help if you were a little more specific on what you are attempting to do.

Part and Inventory Search

Back
Top