Search results

For the sake of completeness, I thought I'd post how I finally solved this problem. It isn't elegant and probably isn't even best practice but it does work, and is far simpler than retrospectively applying any of the suggestions made above. That isn't to detract from the suggestors in any way...

I'm coming back to this thread late, having just read that you've all been suggesting and investigating the very same solution that I discovered by accident. I had assumed, and I know what 'assume' does, that Autonumber was solely system-generated. Of course, it isn't and you can import data...

I was searching for the solution to this same problem and, though Bob Larson's suggestion was not true in my case, I found that changing my query from two joined tables to embedded select queries, I got around the problem. It is however slower. My queries changed from:DELETE tblLeavers.*...

I'm reading threads on dismissing duplicate entries with interest, because I have an issue. Now there's a shock! I have a table which successfully blocks duplicate entries using a unique key on more than one field. In fact, it's a training records database and each person can only request a...

Okay, I've solved the problem, but I think it's ugly. I've built a form in datasheet view but the only field the user can entry is the first one, which the unique identifier. An After_Update event fires some VBA code that runs a query and populates the remaining fields with the details current...

I'm looking for a bit of clue really. I know what I want to achieve but not the best method of doing so. I'm working on a customer database and they've asked for a method of automatically updating fifty records, chosen by them, through a process, as follows: Identify bank of records, manually...

I'm designing a database into which a lot of Excel data will be imported. The tables I've created in Access have Autonumber primary key fields. I've normalised the data in Excel, using ID numbers to tie the tables together. I know that I can't turn Autonumbering on and off. Can I change the ID...

DateAdd("YYYY",-3,Date())

DateAdd("Y",3,Date)

Interesting alternative method. I'm happy to proceed on the assumption that adding the very simplest of table, query or form to the database will change the size from the default though.

namliam I agree your point but I'm looking at a list of 2,751 databases already and the search isn't finished. Armed with the information that a Version 10 database is 98Kb when first created, every Version 10 database that is 98Kb can be culled without worrying.

Does anybody know (where I can find) the sizes of empty database files for the various versions of MS Access? I'm doing an audit of databases for a client, to reduce network storage, and obviously empty databases are worthless, so can be deleted. Thanks in advance

I totally agree with that advice but felt that it might be a step too far right now, which is why I suggested the book. I don't have it here with me so can't say whether it makes that suggestion or not. As the majority of queries will be built using the design interface, these problems should...

Okay, I'm not promising that this is going to deliver what you're after but I've corrected your syntax. This should make the Query function, even if it doesn't deliver what you think you're asking it to!SELECT [Complaints].[Date of investigation] FROM [Complaints] WHERE (((Date() -...

Then can I suggest that you invest in a book? If your company is serious about assisting you, they should allow you to purchase it on expenses. I'd strongly recommend the Microsoft Press Step By Step book, which I've linked to on Amazon for the 2003 version. I have a copy myself and refer to it...

David raises a very valid question. If you're not sure what you're doing and this is a production system, you should say so. However, on the help front, if you do the following, I'll try to correct/recreate your query: Take yourself back to the point at which you took the above screen shot...

Yes, definitely. Write yourself a basic application that uses a web front-end written in ASP instead of Forms in MS Access. That the tables are in MS Access makes it easier to do at home. Changing it all to MS SQL is simply using a different ODBC connection, providing of course that the database...

If you're a Microsoft fan, then follow the developer's suggestion of ASP, etc. If you want to be able to do it all, you'll need to understand how to administer IIS on a server, administer MS SQL on a server and set up databases in MS SQL. The language behind ASP is (usually) Visual Basic, so...

Daz Per the previous answer, you really need to decide what you want to achieve before you start asking these questions. Developers will always tell you that you need all of those things because the majority of application development is web oriented. If you want to stick with databases, you...

First, a question: Does your Form, which has the button on it to open the Report, have a Field (hidden or visible) which contains the unique identifier for that record? If not, you need to add one. Then, with the Form open in Design view, open the Query that sits the Report is bound to, also in...