Search results

You have to have the Oracle client loaded on the machine making the connection. Server name is a TNSname entry. DSN is a DSN, usually machine, setup to handle the connection, typically via OLE DB User ID and Password is the Oracle Database Userid and password with access to the table/view

CASH_: IIf([front]="QDV ","-" & Format([cash],"Fixed"),IIf([front]="PDF ","-" & Format([cash],"Fixed"),Format([Cash],"Currency")))

Hot Tea!?!? You can drink it HOT? Who would have known!

Yup, can find lots of that along side the road..... :rolleyes:

Try: Between DateADD("dd",-7,Date()) AND DateADD("dd",-3,Date()) OR DateDiff([YourDate],Date()) Between 3 and 7 Off the top of me head so may need slight tweaking

Depends on how it is setup. You may just need to requery that text box when an update is required.

Boy I am super bummed. I have to agree with Rich on this one. But I must admit, my Guzzi is a blast to drive, will out drive most Harley's, and parts don't fall off! It isn't the fastest. It doesn't have all the "bling" (thank god), it is a drivers MC, not a "look at me and my Harley" follower.

In the past, more for simplicity than anything, I have created a WORK table, and delete and populate it via queries and run certain reports against it, usually via a macro or a bunch DOCMD's. I like to use that approach when a few or more changes are required to the data, or denormalizing the...

You say Departments refs. locations, and Changes references Locations. So eah of those tables has a foreign key pointing to Locations am I right? So where does this table with two foreign keys into play then? Need more information.

First, I think you need it this way startdate2 = Me.start_date enddate2 = Me.end_date To assign the value in your form to your variables. This needs to be like this: SQL = "SELECT FROM project WHERE [Date] between #" & startdate2 & "# and #" & enddate2 & "#" because Access date literals need to...

Use DLOOKUP against your query (I think you to preceed it with an =)

Well you could try: Between cdate([Forms]![Search]![txtStartDate]) And cdate([Forms]![Search]![txtFinishDate]) this should stop any date conversion errors, as long as the field on in the table you are comparing to is a date data type. The other thing is if time is stored along with the date in...

On your two joins, make sure both are left joins (or right) the same way.

You basically need an AND condition in your left join to also state the proper policy # It would be something like EmployeeID = LodEmpID and Policy# = LogPolicy#

Scamed from the internet somewhere 1. Public Function xlForeCast() As Double 2. 3. Dim MyDate As Integer 'Will be the point for which you are forecasting, in this case 2007 4. Dim MyRange() As Variant 'Will be the independent element of the forecast function 5. Dim...

I would write a query that accepts some key value and sums the lines up. Then use that as the basis of your textbox. You may have to requery it depending on how your form/s work.

What you are calling option 2, would use the first also, but could be stand alone. I just it find it easier to identify the "stuff" with queries first (typically), than you can build on that. The Y and N was just to make it more readable. The NZ is to handle both NULLS and empty fields, hence my...

Save your export format as an export specification. If the filename is constant, you can use a Macro, otherwise you should use DoCMD.TransferText command in VBA (see help). You can feed that a filename either from an input or form, use your export specification in either command.

Oh yea, SOX here in the US has brought a totally new meaning to the phrase "Red Tape". Today a change that takes < 5 Minutes to make, takes 1 hour plus to get through all the documentation.

Been play'n with NetBeans (hence Java). Pretty impressive I must say. Plus there is a wealth of free stuff you can use to do it. Not to mention if can use your current Access DB's via JDBC. Or load a free DB like MySql or others. Plus you can create stand alone apps, web pages, what ever. You...