Search results

The easiest solution is to just not include that last column in the query at all. Then you need to set the GROUP BY on all of the other fields so for sets of records with the info all being the same, it only displays it once. Should do the trick, unless you need that last column in some way, in...

You might be able to use the SELECT DISTINCT SQL command here, which returns only unique values from a recordset. Check out: http://www.techonthenet.com/sql/distinct.php As for getting the last 10, you could either take them manually from the query results, or have some clever criteria in the...

I believe you can make the spreadsheet a linked table (via the external data tab), then use an Update query from that table to your old one to get the new values in (with 'is null' as the update condition if all the old ones were blank). If you want more info on how to do these things feel free...

I don't think you'll be able to do this, if you were still wondering. The way I would think to achieve this would be to use a VBA procedure that creates a shape based on the value of the currently selected cell, or something like that.

If they have Access 2013, I would have expected them to have the 15.0 references, as they are part of the program. I have no idea if it's possible to get the references in another way, sorry. You should probably google that one to see if anyone else has tried it. The alternative of course is to...

Those computers that only have the 12.0 objects available on them: are they running the same access version as you, with your 15.0 ones available? There are limitations to access that have been gradually lifted with each new version, so the newer versions are more likely to work, which may be...

What do you mean by 'reflecting on 4 pages'? Do you mean the report is repeating 4 times? And is it that you have installed 2013 AND 2010 on the new laptop? I've only had a tiny go on Access 2013, so I'm not sure what the problem would be, but I have no doubt that 2010 reports would work fine...

If you have any agriculture going on at your property, you can hang CDs/DVDs on string from trees. In my experience, the glinting of the light from them tends to prevent deer and the like from wanting to approach and start eating whatever it is you're growing. Probably works a little for birds too!

Do you mean having a subform with another subform on it? I recently did this. A client wanted to have a companies form, with an addresses subform to list the locations that company operated at, then a subform to the subform to list people they could contact at each address. Seemed to work just...

For me I get that when there was a problem saving the database. If you think it could be that, try the following: 1) take a copy of the database 2) Compact and Repair the original. It will tell you if it found corruptions. 3) Inspect the repaired version to make sure it repaired it all...

If you want to know the numbers of staff with each title at particular location you can experiment with the 'Count' fields. Add the totals to your query in design view (via totals button in the ribbon). You would need to first make a query listing all the different titles at each location with...

A possible alternative would be just have something like If Not Me.RecordsetClone.Recordcount = 0 Then 'STUFF Else 'Whatever should happen if nothing was returned End If So you'd have that if statement encompassing everything in your on open. Might be worth a go if the Cancel isn't...

Could be because strComputer is "." and so the "winmgmts\\.stuff" isn't a valid path (normally paths like that don't have dots in them)? Not really sure, have never used these functions myself, but that would be my guess.

I've never seen a built in way to do this. You would need to work out exactly what causes the errors (if its always the same thing), then test for something that indicates they are about to happen e.g. all the field names you expect to exist in a particular table actually do.

First, on the parts table have a field that stores what job a part is for. Second, create a parts form (tabular layout) to pick all the details EXCEPT the job. Third, add this as a subform in your jobs form, and when prompted by the wizard, say that you want to link the job on the jobs form to...

This would suggest that there aren't any corresponding records between the two tables, e.g. no transactions exist have have the inventory ID of any of your current inventory. So I guess you could check to make sure that the tables actually have some kind of shared information (called a 'Foreign...

If should append to whatever is chosen in the Append To box on the append query. The records also appear in the query table just to show you what records are going to be used for the append when you execute it (need to click the 'Run' button on query design view).

Indeed, it was only wishful thinking that they could solve the import problem by solving the export problem, rather than working around it. Although the OP does imply they won't be able to change the export, so perhaps this is not possible.

Should be fairly easy. Make a query with Transactions and Inventory as the tables. Have your 'price' field from transactions be one field, and the selling price from inventory be the other. Then activate 'totals' in the ribbon. New options for the query fields appear. You can then set the price...

Criteria:[TableOne].[isValid] = 1 I assume Isvalid is the Yes/no field you mentioned. If so, this could be the problem because a yes/no has values -1 for true, 0 for no. It will never = 1, hence why you got 0 records each time. So try -1 instead and see the situation changes! I made the same...