Recent content by twac1382

Ok, so I'm really just fishing for ideas on how to make this work. We have a shift log that includes both personnel actions during any given day as well as operational actions. (We recently switched from a word document to an Access Database to allow multiple users to input events while...

[SOLVED] Compare Username on Report to Table That was pretty much it. I re-worded my code to: If me.usernameID = Environ$("Username") or Environ$("Username") = "krausslj" then I appreciate your help...guess I just needed to step back a moment and get a second set of eyes to look at the code.

Hi, I'm working on creating an events log. In my table I've got a field that pulls the individual's username (that they use to log into the computer) and logs it against their log entry. As part of my query (for my daily events log report) I'm pulling up said username. I'd like to give...

Actually, I think I just overlooked a simple spelling error. I'm using: Between [Enter Start Date] and DateAdd(d,3,[Enter Start Date]) Seems to be working now that I re-spelled it. Thanks though.

Ok, so I'm sure this is a pretty simple criteria, but I just can't seem to get the syntax right. I'm trying to allow my user to select any start date and the query will return that date plus the next three days. I appreciate everyone's help.

I wanted to say a big thank you for pointing me in the right direction with the "IsNull" and "AND" syntax's. The end result code looks something like this: Private Sub UpdateMissionRemarks_Click() Dim rmk As String: rmk = "" If Me.CustomsOnly = True Then rmk = "CUSTOMS...

Awesome, I'm trying it out right now. The only thing now is that I'm getting a "Run-time error '94': Invalid use of Null" error on the line cgooff = Me.PalletTrainOff I think it is because it's already associating Me.PalletTrainOff is Null. I think that some of these might need to be...

I apologize up front, this will be a long post... I am working on creating a form for our office which tracks flights that are requesting to land on our parking apron. I am to a point where I want to compile all of the input data into shorthand for a Mission Remarks box so that I can simply...

Hello all from Baghdad. Currently I'm working out here at the airport trying to get a database set up for our office to track some of our incoming information. I am fairly new to the whole programming world, however, I feel that I'm getting the hang of it. In fact, once all of my paperwork is...