Search results

What you are asking for is pretty complex ... but could probably be done if you wanted to grind it out. I've attached a sample that I had gotten a hold of a long time ago. I apologize to whomever so can't give proper credit. It does a month view at a time .... However, you might look at this...

Woot! Finally won something! I'd like to thank the academy and am glad to see public education is working! ;) How very .... Douglas Adams-esque. :D But what do those pieces of paper mean? Where does those pieces of paper come from? I would defer to the Franciso d'Anconia character's speech...

Agreed with beginning and end. However, it is the 'popular culture' that has twisted the story that went with it. If you note the 'pop culture' at the time the story manifested he stole from the king and most notably the king's merchants. This story, along with many others such as the Little Red...

An idea is to 'flag' those where you just had the age and not the exact birthdate. That is, a yes/no field next to the birthdate control that, if checked, indicated the birthdate was estimated. Then when you run reports, you can use an IIF statement (if checked then birthdate = birthdate & "...

Here ya go ... If Len(Nz(Me.txtUniqueIDFieldName, "")) = 0 MsgBox "Please enter Unique ID" Me.txtUniqueIDFieldName.SetFocus ElseIf Len(Nz(Me.txtDateFieldName, "")) = 0 MsgBox "Please enter Date" Me.txtDateFieldName.SetFocus Else 'what you want to do End if Note, you are...

I agree with pretty much the entire post save this remark. Shouldn't the viewpoint be that the more I save, the more I guarentee I will not be a burden on you or anyone else? Who can foretell my future medical conditions that I may want to care for? By what right does anyone have to say who...

Re: Characterize Republicans/Democrates Sorry, Adam - I take a bit of offense to the simplicity of that statement which has been drilled into our collective conciousness. Robin Hood did NOT steal from the rich and give to the poor ... has everyone forgotten that there was royalty involved...

Here is my .02. Normalize only when it makes sense. My chief reason is to serve data-integrity purposes, for db flexibility and hopefully to create an optimal ... For database size, it is my understanding that Access a long integer type is 4 bytes and a date field size is 8 bytes. So strict...

Hear! Hear! :)

Ah ... vbaInet posted prior to me and thus I answered unknowingly and held my tongue. I have '03 on an old machine which I hardly boot up hence I am not much help because my memory is not that reliable. You should be able to do a search such as vbaInet suggested and find exactly what you are...

I am not sure what version you are using. If you are using 2003, I am not the best to offer advice if you are using the built-in security for the users and groups (all I know how to do is grab the windows login name). If you are using 2003 or 2007 and built your own log-in functions, then I...

Me.Name is the form name. For instance, use MsgBox Me.Name. -dK

You will need to set up the logic behind a 'Go' button through VBA that would either need to be of the If-Then or Select Case (or combination therof) that would then allow you to set the recordsource property of the subform. For instance ... If cboCombo ="1" Then Me.SubFormName.SourceObject =...

A different form depending on the inputs or a specific record from the same subform? If a specific record, then you can just use the Filter property of the subform based on the inputs from the combo boxes. -dK

I think your easiest option would be to put together something like you described and then in VBA ... 1. Copy the master file. 2. Delete the slides that are not 'ticked'. You can copy and past slides, but in my past experience messing with PowerPoint the aforementioned would probably be the...

Reread my posts and look at where I was referencing the form verses control as vbaInet pointed out ... This link might help you when it comes to VBA. -dK

In the BeforeUpdate of the form you can use .... If Me.cboComboName.Column(x) = "TDY" Then If Len(Nz(Me.arrival_data, "")) = 0 Then Msgbox 'something about what the deal is Cancel = True End If End If I was erroneous earlier, the control event does not have...

Glad I could assist and we got it working for you right. Good luck! -dK

Okay ... this isn't it because I am sort of lost from not understanding the process (we used ECR cards). But I did do some stuff .. maybe it will get you started. I attempted to normalize your data somewhat, but got lost around the M4 form. The table names I used begin with a t, the queries a...

My best guesses are to (a) run each sub seperately to see if you get it, (b) use something meaningful instead of exp1, exp2, etc., to help identify, (c) if you copied and pasted a query and used a parameter (click parameter when the query is in design mode, it might be showing up somewhere. -dK