Search results

I would say self-determination. The chance to be represented since the representation offered now is representation almost in name alone. Certainly there are regions around the world within countries - Friesland, Flanders, Basque Country, etc. - that would see themselves take steps onto the...

Er, there are no images. See this example for what I mean about table structure.

See what you mean, Brian. I wonder if I would personally do that or whether, as a manic data controller, I would envision a debit/credit system for points so as to always have a complete history/audit trail. (Me and bigger thinking. :D )

Go back to your table design, by the sounds of it. When I see Sun1, Sun2, Sun3, etc then it's indicative of a design flaw in your tables. Ditto the idea of having 34 queries. I have this horrible mental image of you having created some sort of matrix (days v classes) in an Excel style out of a...

With only three weeks to go until the people of Scotland vote in a referendum to decide if they want to be independent from the United Kingdom, perhaps it's time to see if AWF wants a discussion. After all, there's enough voices from around the world on this forum to offer up some new...

How are you exporting the query: the TransferSpreadsheet method or by copying and pasting?

Any questions on how it actually works, let us know.

Re: delete a databese Why would you want to do this?

I would infer from the question 'lock' means to protect a database object (perhaps with password) from certain users. If this is the case I would suggest the thinking behind doing so is wrong, as it may infer the database is not form-driven, leaving users to happily use tables directly.

No, it can't be done in a table. Stop looking at the table and thinking it looks like Excel and so must to things like Excel. It's not Excel. If it acted like Excel, we would just use Excel and Access would be redundant. Access is a database. At table is for storing data. You can do...

The term for what namlian describes is import specification.

I'd add to be consistent with naming conventions. Why have some tables prefixed 'tbl' and not others? Prefix them all.

Not in a table. You do it in a query. Just create a new field in the query. Something like: Tally: [Points Earned] - [Points Used] Database design expects that you calculate values at run time rather than store values in a table.

More information required...or, at least, this is my understanding. You have a form you are using for data entry. The data entered obviously goes to an underlying table. On that data entry form you have a textbox where you enter a person's name and, on entering the next record you want to...

The Not applies only to the first check. If Me.ComboBillable <> "Yes" And Me.ComboBillable <> "No" Then Or: If IsNull(Me.ComboBillable) Then

The module that comes with a form is called a Class Module. It's an enclosed world in there and one does not simply call the function within it as you would a function in a regular Module. Calling the function from a query - form open or not - does not give the query access to the form's...

Trying to understand this...you're trying to insert blank rows into a database table? If so, it goes against the idea of a database. coded so that after certain labels are printed the database will print a blank label. Is there any logic to these 'certain labels'?

I suppose that rather than command boxes in my attachment, you could use 42 listboxes. In the attached - which will throw up an error if month or year is blank - there is some data in for August 2014. It's not your answer, but may give a suggestion of the complexity involved. May even be a...

You could, in effect, create one but it would require 42 command buttons for the calendar dates alone, then code to calculate and caption which ones would be available based on the year and month. Plus what you want each command button to do (though a class module could be employed to deal with...

One thing not mentioned yet is the ability to dimension a static variable inside a subroutine or function. This will retain the value after the routine or function has ended. It is still only usable within that subroutine or function's scope. Static MyVar As Long