Search results for query: *

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

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

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

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

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.

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

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

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

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

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.

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

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

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

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

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.

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.

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

Thanks for the input. This one is solved.

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

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.