Search results

Hi all I have a couple of linked tables and I'm trying to run a query to put data on a form. The tables are: Topic(ID, Subject, Detail, etc); Solution(ID, SolnNum, ShortDescrip) which both have 1-many joins with TopicSolution (ID, TopicID, SolutionID). A Topic can only have none, one or two...

way more information needed what happens - exactly - when you try to add an entry? does the form open? if so, can you click in a text widget and get a blinking cursor? does anyone else have permissions to edit your database/form/query?

Hi all I'm trying to put together a phone call logging system that has (amongst other things) a Call table (ID, SubjectOfCall, AdviceGiven, CallerID) and a Caller table (ID, Name, PhoneNum). I'm trying to form a query that will tell me, for a given subject, the number of calls, and the...

ahh, bummer. ok, thanks for that. I was hoping to get away with bog-std access, and only use the inbuilt parameter dialog. Didn't even want a form. Oh, well - looks like it's <Alt-F11> time again :rolleyes:

Hi MStef not quite. I want the year to be a parameterized query. Ie so the user can choose which years to run the query on.

Hi George The data type is Variant (Integer). I have a date field that I am extracting the year from with the Year() function to get the field in question. I have tried quotes. First I put quotes around each item without success. Then I tried surrounding the entire (quoted) list with...

hi all I'm trying to create a parameter query where the user supplies a list of years, and the query uses the IN operator with the supplied criteria. eg if the user wants data from last year, 2007 and 2001, they type the following in the parameter dialog: (2001, 2007, 2009) Access tells me...

Yes, you can, but first make a column in your query to match the ranges you want and use iif statements to populate this from the MaxLength field. This is your Column Heading field Then, create another column in the query which has the new column you calc'ed as its field. This is your Value...

hmmmmm ok, howsabout i create all the controls (ie 15 each of txtbox for name, 15 each of txtbox for votes, 15 each of togglebutton for elected), giving them names like name0, name1, ..., votes0, votes1, ..., elected0, elected1, .... and setting .visible to false at design time. Then at...

I'm working on a database of candidates for council elections, and I have a query that usually returns between 2 and 5 rows of data, (min = 0 max = 15). The data contains 4 fields (given & surname (strings), votes received (int), and is elected (boolean)). I want to display the query result...

Hi leeuwa I've been playing with continuous forms a bit recently (Access 2003, not 2007), and my understanding is that any control needs to be bound to the underlying table/query in order to show 'per record' data. So, if you can get your pictures in the database, and bind the pictureField to...

Hi all I have a continuous form and I want to make it so that it does not update the underlying table until I click the Save button at the bottom of the form. That is, if the user makes a bunch of changes and then hits the cancel button, I want the table to be at the state it was before the...

cheers, Dave, i think i get the idea of each 'form' being nothing more than the same view into different data, and understand why unbound controls behave counterintuitively (at least counterintuitive until you 'get' it). However, the bound toggle button seems to be clever enough to know about...

Hi John I've started on the solution path. Because I'm changing the button picture depending on whether it is on or off, it looks like the code in the AfterUpdate() event causes all buttons to change. When I don't explicitly set any changes {ie no code in _Click() or _AfterUpdate() events}...

ok, I've now worked out how get multiple records on one form with a continuous form, but I've now got the problem that when I click a toggle button on the form, all of the toggle buttons for that field change (ie every record's toggle button changes). The toggle button is bound to a Yes/No...

lol found continuous form option - thought you needed to have subforms set up to do that. don't worry about this one. apologies

hi all i want to make a continuous form but i don't know if i need a subform. I have a form set up with 1 record that I want to repeat for all the records in a query, so it becomes one long page with a line separating each record. There isn't a lot to each record, basically a couple of...

Hi Wazz, it's when i _don't_ put a value in that i get the problem. I think that if i DO insert a default value - as I thought you had suggested - then I won't get the problem.

Hi Wazz, Dave, the default value 'set' is 2013. Basically the field represents an expiry year which is either 4 years away or 2 years away. The column data type is number (Field Size is set to Long Integer which is overkill, but won't hurt, Decimal Places is Auto and Required is No). Going...

@dave If I get wrong data, I've got Validation Text that (i assume) will pop up as a message box. Any wrong (non-null) data will be an input error. But at the moment, I'm not putting any data in that field. I want my append query to only insert a foreign key, at this point. The rest of the data...