Search results

Suspect it is a problem with the forum presentation - It looked fine when I copy/pasted from the browser. I'm not prepared to spend more time on this. Suggest do what I did - copy paste the OP's questions to your browser.

a further google on the question 'Suppose Access is the only application running on a computer, what hardware, operating system, and configuration is recommended to maximize the performance of the running application?' produces this result: To maximize the performance of Microsoft Access, it is...

googling the question 'What PC hardware/software is needed to run Microsoft Access quickly?' produced this response: To run Microsoft Access quickly, your PC should have at least a 1.6 GHz dual-core processor, 4 GB of RAM for 64-bit systems (or 2 GB for 32-bit), and 4 GB of available hard disk...

Been asked - yes, pursuaded - no Last one a couple of years ago was for a theatre company - an employee had built it using only macros and no documentation. And data wasn’t properly normalised. It handled show bookings and some elements of production and staffing rotas. They wanted to license...

about 20 years ago I was involved in migrating an access system for calculation of sales commission for around 600 sales people. It used to take about 1 1/2 hours to create 600 reports and email them to each person with copies to managers. The new boy on the block decided that access was not a...

The problem i have with the new browser control is that when using it to display local files. updating the control source doesn’t always refresh what is displayed

can't say I agree with all those comments Why "1" is better: Faster - Access doesn't need to resolve field names No field name conflicts - Won't break if you rename/delete fields Clearer intent - You're just counting records, not referencing actual data Performance comparison: you don't do...

So usual reasons for moving to sql server BE, nothing new. Now if only IT could actually support the typical rapid changes required to meet strategic initiatives, particularly when only 5 or 6 users out of say 500 users require the functionality. As it is with companies that have low data...

Can you provide some links to support your statement

dcount will return the number of lines in the query. If the query already has the criteria '"received" = False' then you just need DCount("*", "TotalOpenPOQuery")

What I have done in the past when migrating data from one system to another is to create a migration document. This lists all the tables and fields in the new system together with all datatypes and constraints. Sometimes with performance criteria as well. The old system tables and fields are...

usually means you have a spelling issue so first check names - TotalOpenPOQuery and OrderID - and is orderID on your main form? try using Me.OrderID to verify and try using "*" rather than "1" in the dcount function

doesn't matter - a form does not have to have a recordsource. It can have unbound controls or controls bound to a calculation/function such as dcount. And as Arnel shows, you can assign a value to a label or button by assigning the value to the caption. The potential problem with having...

Given this has come about as a result of UK law, I was going to suggest ‘the speaker’ as in the speaker of the House of Commons- the person who slaps down inappropriate behaviour of MP’s

Perhaps you should also clarify what you mean by access procedure - a specific sub or function? Doing what? Is access split? If so where and what is the back end?

Why use a subform in the first place? Is the idea that it expands if the user clicks on it? Why not use a label or button? - I do something similar to show certain data and use color to indicate current status. Eg red might mean invoices to be raised or paid - user clicks on the label/button to...

Good point

An alternate to majp’s suggestion Select qryActiveUsers.* from qryActiveUsers left join TblAssignedExaminers on on qryActiveUsers.userid= TblAssignedExaminers.userid where TblAssignedExaminers.UserID is null

What if you have more than 32 pictures? And is the table one with 32 columns or so, one for each picture. Or more normalised with 32 rows ( however many actually required) of one picture each? Given you appear to have a denormalised setup as an alternative to the transparent button suggested...