Recent content by Kafrin

Nope, there's nothing in the code to cause the problem. A couple of ideas, but no guarantees... 1) Check the query itself, make sure it hasn't been saved with a filter on it. I don't think this would cause your problems, but it might be worth checking. 2) Try a different Excel format in...

Your problem scrolling is because, as well as adding a filter, you're also getting frozen panes. This means that the top set of rows are all frozen and you can only scroll the rows below them. However once you remove the filter, the number of frozen rows is too big to fit on the screen, so you...

When you open up a query as a recordset in code, you need to feed in any parameters that are used in the query and that refer to controls on forms. I'm surprised you have any of these, so probably the most helpful thing is if you post up the SQL for the query. Please note that where I've used...

What I suggest is that you start by building a query. You base it on your Contacts table, include the name of the contact (+ any other info you want to show on the message) and set it with the criteria PromptDate <= Date(). This will then show you everyone whose prompt date is today or in the...

Gemma: unfortunately the requirement is that the dropdown is checked even if the user just views the record, they don't have to edit it. That's why the focus starts off on the dropdown. Although there may be something I can do there with setting the record to Dirty=True in the OnCurrent of the...

So I've got a form set up like this: ~ There's a dropdown box that gives you options from a table to choose from. ~ There's a 'Jump' button to click so that if the option you want isn't listed you can jump to the appropriate form, add a new record, and then come back. ~ The dropdown, which gets...

Hi, sorry I disappeared for a bit, life's been hectic! Attached is my recreation of your database, with the relationships in place. Have a look at this and see if the relationships make any sense to you. I'll get back to you about your original question in a couple of days - I haven't had...

OK, firstly some naming conventions. It's a really bad idea to give tables or fields the same names as recognised Access commands. From your picture I'd recommend changing the following names: Form Name Record Date (also avoid Group, Report, Table and Value) Then we need to sort out your...

Can students be in more than one group? Or can they change groups but you'll want to see historically what groups they've been in? If either of these is true then you should have one table for Students, one table for Groups and one table that links to both students and groups...

As jzwp says, it depends how your tables are set up. Starting from scratch, you'd set up a table for Students, a table for Classes and a 'mapping' table (which I'll call StudentClassMap) which links to both Students and Classes to show which students take which classes. You'd then base your...

One way is to write a function in code that looks at the check boxes and that you then call either in a control on the report or in the recordsource behind the report. The code should be in a stand-alone module. In this case I'd probably work on something like this: Public Function...

Firstly, try to simplify your individual functions, then see if you can put them together, eg: Public Function FirstQtrLFMth1to12(dThisMonth As Date, AKW() As Variant) Dim sDate As String, lYear As Long, lMonth As Long lMonth = Month(dThisMonth) lYear = Year(dThisMonth) sDate =...

Have you tried the AfterUpdate event of the calendar control?

Hi All, I have an Access 2007 database with a Front end/Back end setup. Whenever I open the Front end, the file size increases dramatically. I do not have to make any design changes for this to happen. I found a Hotfix on the Microsoft site, KB960307, which, among other things, address the...

If you have primary keys being copied across it should only be able to tak enew records as old ones can't be duplicated due to key violations. DCrake's suggestion is the most straightforward, so I'd recommend that first. Alternatively, you could put a Yes/No field on the tables and tick it...