Search results

Does this example work for you?

Works in 2007 - I have many forms with this type of setup

No problem - Can you describe the problem in more detail? What is preventing the header & footer on the subform?

Can you post your database?

Import all objects into a new database, then compact & repair. Don't know the cause of the problem, but I have have had this before and this is a solution

Established Trust Location, user has full permissions, but still On Load and After Update events only partially working, seems to be related to the * wildcard

Well, it's obvious to some, but not necissarily me! Will check this out, although I would have thought we would have a few other 'bugs' besides this one if it were this

Working with a fellow member on a project and have come across a strange problem. I have built several forms that have a simple On Load event (sets a few variables to "*" so all records will be shown on start up) that can be filtered by various combo boxes. All works well my end, but when...

As this is a calculated field, there needs to be a reason to store it (need more information on the purpose of the data) As long as you have the data needed to do this calculation in tables, you can run a query to do the calculation, so there is no need to store the calculated value

Now that raises an interesting (but entirely off topic) subject: How many countries Health funding is declining because the tax raised by us loyal smokers & drinkers declines due to the do-gooders who decide how I should lead my life?

Is there any reason why you need to store the count value? If it can be calculated by a query, you can call up the result as required

Double check the format of the excel columns & make sure they match the access fields. Often, the columns are 'autoformatted' into what Office thinks they should be ans a mismatch oocurs, ie trying to load tect into a numeric field

It may be clouding my judgement, but currently reading a large tome regarding the Kennedy's, invading Cuba, links with the mafia in Castro assasination plots: Current standing: = George W Bush ie the truth is irrelevent as long as my family stays in power Ted, specifically: Chapaquidick...

Any takers? I'm going round in circles with this

Of course, what is the first thing ones does when something works perfectly? Yes, tamper with it accdb (2007) attached. Now want to use combination of filter combo boxes (blank = *) and sort functions. Works mostly, but depends what order you do things. Use combo boxes first and then sort...

I have been having similar issues with complex queries (ie multiple wildcards) and seem to have resolved by running a series of sequential queries. It seems to cope with 1 Like per query, but starts to fall over if I have 2 or more per query

Thanks kindly, works perfectly!

Code is Dim SQLtext As String SQLtext = "SELECT [2tblSighting].SightingID, [2tblSighting].AnimalGroup, [2tblSighting].Species, [2tblSighting].Depth, [2tblSighting].Sighted, [2tblSighting].Method, [2tblSighting].Explorer, [2tblSighting].SightDate, [2tblSighting].Extinct, [2tblSighting].Notes...

I get message - Can't find the form specified in the sql statement? The only mention of form is Me!Form.RecordSource = SQLtext

VBA not my strong suit, can you give me some pointers?