Search results

I think I stole it off of RuralGuy a long time ago and put it in my list of favorites. Funny though, sometimes when I am struggling with dates and times I have found myself googling up brian's name since his understanding is much envied. -dK

In the form properties for the KeyDown event, you can try ... If (Shift and acCtrlMask) > 0 And KeyCode = 80 Then KeyCode = 0 Then set the Key Preview property of the form to 'Yes'. -dK

Here is a good resource. Skip down to the 'Time, adding and subtracting ...' -dK

Awesome .... glad it is working for you! Good luck! -dK

Are you using the arguments supplied by vbaINet? That is, if you have DCount on a code line and nothing else, you will get that error. You have to provide an argument for it .... If DCount(allofyourstuff) <> 0 Then ... the record exists else ... it doesn't exist end if -dK

Hehe .. I like her sister, too. :cool: I wasn't sure if you (or someone) wanted the full zip (in the future) and was going to actually fix them or not. If you want to clean it up permanently, use the same syntax in the "Update" row on an update query. -dK

Ah .... here is something when dealing with apostrophes and quotes and such with strings. It also has another link (on DLookup) on it and both pages may provide some insight now and when moving forward with your project...

You betcha. Good luck on your projects! -dK

I would suggest just trying one. Let that one work error free. Then add another and debug it, and then add another condition, etc. etc. I would point you to this article. Scroll down to the 'multiple criteria' section. HTH, -dK

Aye ... I think that bit is called 'Layout'. I would guess that yours is set on 'Tabular'. The form wizard will normally used 'Stacked'. The layout can be found under the same pop-up menu when you right-click the control. I assume that these all have their purposes. :confused: The only one...

I wouldn't jack with the original fields but use a variant to retrieve what you want. For instance, in the QBE go to the last column and put in something like .... ShortZip: Left([ZipCodeFieldName], 5) Change the ZipCodeFieldName to whatever the field name you have that holds the zip...

You betcha. I probably would have referred that initially but thought you were only dealing with two criteria. Once you mentioned the complexity bit, that one sprung to mind. Apologies, but glad you got it working straightaway! -dK

Here is an idea for (1). Supposing multiple assignments for states and such I further suppose each user is unique by some field (name, ID, etc). You could use a subreport based on your user name (or ID or whatever method you use) and the state's assigned to you (or that ID). Then set the...

My guess would be because of the anchoring you have on those controls. If you right click in design view, you will see the anchoring on the pop up menu. If you have selected some point on the form, the control will automatically stretch per the selection when you maximize the form. You can...

Almost there .... you are missing some quotes where you are trying to refer to the form ... ","[Item Type]= " & ([Forms]![frmAssests]![Item_Type]) & " AND These will break up the string to pull in the value you are referring to. You will need to do the same wherever you try this at. Also...

There shouldn't be a limit (except for memory). Now, I've always understood that different interfaces might put a restriction on a string's length (i.e., MsgBox and some Import methods). For memo fields, I've always loaded those into strings without issues. -dK

Unfortunately, the office of the Presidency (US) has changed over time. The President shouldn't have 'programs' or 'agendas' when they assume office. This wasn't the original intent of the President. States interest are served by the other delegates in Washington (Senators, Representatives)...

Not sure what you mean. If you could provide the scenario, a set-up example and the objective it might be helpful for a good response. -dK

Ah ... aye, see what you mean. I've abused and have had a lot of success with Allen Browne's method? Here is a link to it (I couldn't find it on his site). Most of it could probably be deleted but calling your attention to the last 30 lines. If you could understand this, then it would be...

Gotcha. I would assume that you would validate against a unique field such as a serial number? This link can provide some insight. Also, I forgot to add a Cancel = True in each If event for the form validation. This will cancel the save action on the event. On the evaluation of the...