Search results

I'm not sure what you mean, Brian.

I've never used the switchboard feature. Now, I've inherited a database with three levels of cascading on the switchboard. I've been asked to rebuild the switchboards to make them similar to another database commonly used here. There's one major thing I just don't understand and need some...

Hi all. We're looking to start sending auto-generated emails that will act as notifications when certain updates are made in a multi-layer approval process. In other words, a submitter makes a requisition request, his manager must approve or deny, then the VP, then the budget team. On each...

Click and drag across your formulae, right click on the edge of the selection and hold down your right button. Drag it away and right back to the same place, then select paste as values.

In conditional formatting, enter a formula that indicates if the cell's value is =min(range), apply a format. "Help" on the conditional formatting actually has an exact example of what you're trying to do. I've used it many times myself. Another way of doing it is picking a cell on the row...

Alc: Be sure to check out the F4 key for cycling through the possibilities of locking the cell addresses. Type a cell reference into a formula... click on that cell reference... hit the F4 key a few times and watch what happens. It works for ranges as well... e.g. A1:Z26 . Click on one or...

Hmmm... well, I can speak only for myself, but I'm sure many others feel the same way. Being called "dumb" doesn't exactly give me a warm feeling about even beginning to try to help out... especially considering that this is an MS Access forum and this is your first posting... about something...

Hello. I am trying to open a query using DoCmd.OpenQuery strCurr_Query, acViewNormal, acReadOnly but I need to add a filter string called strCRITERIA and I just don't know the way to get it done. Any help is greatly appreciated!!!

Bob: Thanks! The Auto Expand property did exactly what I wanted.

I have a number of long-list combo boxes. What I would like to have happen is that if I make a selection in combo A, that selection comes to the top of the drop down if begin to make another selection. For example, if I have a list of states... when I choose Texas, I want Texas to be at the...

Hello all. Is it possible to create the capability that, while in report preview, will allow scrolling using the mouse roller? I am extremely tired of having to move to the bottom of the page and select the page buttons on the Access navigation bar. Any help is GREATLY appreciated.

Hello all. Is it possible to disable the print option when in print preview? Some of the reports we generate are hundreds of pages long. I'd like to make it so users would have to save the report and print in another application if they really want it that bad. The normal print preview...

Tried searching here before posting, but didn't find anything. Did a google and was brought back here to an old thread... DoCmd.RunCommand acCmdFitToWindow

Hello all. I've searched for this and simply cannot find it. I want the default for report previews to be set to "fit" instead of 100%, so that all my reports (many) show in full-page fit view every time... simply to make it easier on the eyes. Any help is greatly appreciated!!! Tom

I'm working on a database in which opening the db requires entry into a LogOn window. Some report code runs various queries and then uses the CurrentUser value as part of the report name when created: sTemp_QryName = "qry tmp " & CurrentUser & " - adhoc" This works fine. What I need to...

James: Nice idea. I'll look into that. karl: Thanks. I'll definitely go through that tutorial this weekend.

Hi all. I've been asked to add this feature and need some help. In the form in question, a series of approvals are required regarding personnel adds/edit/reduction submission. The approval levels are, in order: Director, VP, HR. What I've been asked to do is make it so that when then a...

Thanks! I'll try that.

Figured it out... RemainingQuantity: [QuantityonHand]-IIf([sumofquantity] Is Null,0,[sumofquantity]) So, if my [sumofquantity] field (the field that sums the sales) is NULL, this equation enters zero in this new field... otherwise it grabs my original amount. I then subtract the calculated...

Simon: That's my question... how do I calculate zero??