Search results

In your code editor click "Tools"... "References" see if anything says "missing"

First, unless you are saving the results for historical purposes...you do not save results of a calculation. There is no need. That being said, and if you really have the need to... a few ways to do it... As you will find using this forum there are usually many ways to accomplish a task.... just...

Sounds like replication was an after thought....... your first question was on only sending new records........ I do this with a few DB's on "orders" a simple Yes/No field in the table... "Sent" perhaps. In the onclick event of the sendobject button run code to mark "Sent = True". Then with your...

Basically...... I use a function. Function GetUserName() GetUserName = Environ("UserName") End Function You can also add GetComputerName = Environ("ComputerName")

The whole point is that the code needs to run on both events, the Domain AfterUpdate AND the OnCurrent event of the form. So, Yes, you can put the code again in the OnCurrent event of the form. As a side note.... I don't think I have ever seen one event called from another... Being the...

Have a look at this one....... Function EmailList() As String '-- Return all of the email addresses in the EmailAddress table '-- as one string separated with a comma "," On Error GoTo Err_EmailList Dim MyRs As DAO.Recordset Set MyRs = CurrentDb().OpenRecordset("tblEmailList"...

Well, I learned the hard way to do it like this......Our server drive was "F"... Someone added a PC with a mutli media reader..... occupied a lot of drive letters...."F" being one of them.... Take the pick of which you want to change... I also remember when this came up searching through...

Didn't get much on a search of this but...Trying to stop the warnings for trusted locations.... They are sometimes simply a hassle.... I was working on a DB....put a copy on a thumbdrive to take to work...... Now I had to establish a trusted location for a folder on the "E" drive.... The hassle...

Agreed, wanted to add one thing I have found helpful. Remember not to use an absolute path to the backend....ie drive letter on server.... One stations server drive might be "F" anothers might be "Z"..... Use a path thru "Network places" this assures the frontend will work on any station.

Well, tried something that worked...Don't know why...but... Created a new blank DB in 2007 and imported all objects into it. Now when I change it to accdr it opens and runs.....Unsure of why this worked....but it does. Access.....go figure.......:rolleyes:

OK......Tried it.. Changed the accde to accdr.... same thing.

OK.... I see you answered the question about accdr....And Yes, I am trying to emulate runtime on the other machine. Error handling...Well, there were some places in the code with no error handling...loaded the mz tools to make fixing quick...Added to all code... still the same results. No error...

Having an odd problem with 2007 runtime. I developed an app some years back, did it in Access 2002. An early one I can tell because I used the "Switchboard" Well, I loaded this on a computer with only Runtime 2007. Crashes everytime I try to start it. Thought it might be the switchboard so...

Try this........ Nz([Field1]) + Nz([Field2])

If the runtime is installed you do not need to install it again. It is not unique to the database. I think there is an option when compiling the DB and runtime for that. Leave off the runtime.

In the query all fields are set to currency at 2 decimal places. It is not totaling correctly. I am assuming it may be a rounding problem, but don't see where the culprit is.

Theres all kinds of companies that make blank check stock. One per sheet...or three per sheet... I'd go with one per on a business. Would then simply be a matter of getting your text lined up to print correctly. A Report becomes a check. If the stock Does NOT contain the routing number and the...

K....... first the questions......... "Couldn't the commission be simplified to Commission:IIf([JobInvoicePaid]=True And tblJobs.ServiceTypeID=2,(([ContractPrice])-Nz([JobSubAmount]))*0.05,(([ContractPrice])-Nz([JobSubAmount]))*0.03)" No, there are other type ID's besides listed that...

Have a little problem I can't locate... Have a field on a report, all fields are unbound, for the sum of commisions... control is =Sum([CommissionPayable]) CommissionPayable is set to currency and decimal 2.... CommissionPayable source is rather lengthy.... CommissionPayable...

Any nulls involved? try this........Nz([Field1]) + Nz([Field2])