Search results

Thanks GinaWhipp, daunting name. Forgot about the trusted location thing. If its on your site I will find it, otherwise could you point me in the right direction.

We have a situation where we need to deliver a compiled front end in .accde format to a client hundreds of miles away. The location of the back end data will be an Access database on their server. The problem arises because I cannot duplicate the path to their server in my office. I know there...

this will add 13 months to the issue date me.expirationdate.value = dateadd("m",13,me.issuedate.value)

While I don't doubt plog's solution, the count feature will put a zero in there as long as the tables are linked with a left join. You are saying, give me all the kids and count any that match. So where there is no match, count evaluates to a zero. Try this, it's basically the same thing, but...

Try this: Age: Round(DateDiff("d",[Birthday],Date())/365.25,2) This takes the difference in days then divides by the days per year to get answers like 64.7 or 64.9 then put >=65 in your criteria.

Yeah, you need a sub query working off the ID of the person and the date of the abscenses. Check out Allen's site it explains everything. http://allenbrowne.com/subquery-01.html Basically it allows you to run a query inside a query on the same table and find the last event related to that...

When you use a wild card, it means you have part of the postal code. Your criteria looks like you are asking for 06902*, which will get you my zip code in Stamford, CT. But if you put 06* you will get all the zip codes in Connecticut. To solve this you might want to change your criteria to Not...

How are the users accessing the records, via a form? Is the record locking on the form set to edited record? or is it on All, which could be the problem. Clicking on OK, what is that, a command button you built or are they editing the tables directly? The way I understand it, the first person to...

I think the commands inside the form override the open options. When you have the form in design mode, and you are viewing the form options, not detail or pageheader, but the form, you will see on the Data tab a bunch of options for editing. These options take precedence. To do that I would...

I don't have a working answer for you but I think you need two things to get you started. You need the latitude and longitude for each address and you need the formula to calculate the great circle route distance. That is assuming you don't mean driving distance. I downloaded the formula in a...

Bob's right, databases don't usually store calculated numbers, you calc them when and where you need them. In your case, if the main form and sub form are in two seperate tables with the related records linked together, you can just run a sum query on the sub table. However, if you still want to...

Its tough to give you a good answer because I don't know what the end game is, which is Pat's point; but I will give you my best ideas based on what we have so far. I would create the new table with only the user entry fields. Link the two with a left join in a query attached to the form and...

Never mind, I figured it out. The main report has 21 records and the pie has 135. I was using the pie table as the record source for the form, meaning 135 charts. When I changed the record source for the sub form/report to the main report table, I got 21 charts. So the form uses the master table...

I created a pie chart in a form and did all the formatting there. Then I added it to a report and slid that report onto the main report. This whole process has worked fine with other sub reports, but his pie chart is doing something interesting. It there are four slices in the pie, I am getting...

Its not a big deal, but I have an entire application with one strSQL variable. You could also do strSQL: = "Select ..." CurrentDb.Execute strSQL, dbFailOnError strSQL: = "Select ..." CurrentDb.Execute strSQL, dbFailOnError strSQL: = "Select ..." CurrentDb.Execute strSQL, dbFailOnError strSQL: =...

The chart can have a module behind it. You could check for a title and push the results to the chart. In the OnCurrent event of the chart Select Case ProductTypeID Case 1 me.Chart.ChartTitle.value = "Product One" Case 2 me.Chart.ChartTitle.value = "Product Two" Case 3...

You can grab that value, the total tax and divide it by four. Edit each of the quarterly boxes and in the control source line, type in =TotalTax/4 Better: =Round(TotalTax/4,2) The word TotalTax should be the name of the box where your DSum is located.

There are a few ways to do what you are asking. But let me start with the easiest. Create the new table with all the appropriate fields and the same field as the primary in the source table. Then open the form using a query where some fields are linked to the source table and some are linked to...

You might have a problem with the way the tables are built. You have a one to many relationship between the vendor and the parts with a linker table in the middle. You might want to rename the fields so you can follow the logic easier. In the vendor's table the primary key, (VendorID) and in the...

It might be easier to put the if statement in a query and make the query the recordsource for the form. Try this, create a query off the table with all the fields. Then create a new field in the query by entering InStock: iif(isnull(StockField)=True,True,False) in a blank "column" Then on your...