Search results

The transfer text macro can be based on a query, all you need to do is create a query to select the last record entered in the table and put the query name into the table name setting of the macro.

Does anybody know how I could achive the following. Example table would hold say employees with various job titles, what I would want are results listing 2 staff members for each job title.

still not sure why its doing it but I have changed the format for the field to fixed which gets the figures close to what I need.

I would say yes, they come from a linked table. I say they are the same because some results are fine and what I expect. It appears to happen when the figures are the same and the result should be zero.

Why am I getting strange query results of -1.77635683940025E-15 when I subtract one field from another and they both hold the same figure. So 8 minus 8?? I am expecting a zero.

I am a little confused but would something like this do? =IF(B2="","no data","data entered")

Yes, all the obvious ones had been set correctly. I have an answer for this now. Access options, current database, Document window options there is an option for tabbed documents or over lapping windows. Thanks for you input anyway.

I am looking at an access 2007 database and I cannot get the form min max buttons to enable. Border style is sizable, control box is set to yes and min/max is enabled. Has anybody got any ideas why?

You will have to do it with VB code. So go to your command button and display properties, select the event tab and then a suitable event, after update or something like that. select the box at the end and build code. The private sub part will already be created so enter something like the...

Had a look, hope this is kind of what you want. I created a crosstab query to sum the data, you will see what I mean.

perhaps you should post your db and I will have a look

I got that, what are you struggling with? which part of the report?

You should explain what you mean by formatting, what are you struggling with? With regards to totals you put unbound controls on the report with control source property set to e.g. =Sum([Stock on hand])

I am sorry no experts around!! You will have to do with me. As i said the problem is with your formula, you will not be able to perform a calculation on sizep1 + sizep2 *5. What you need to do is replace thr formula with something like =([valx]+[valy])*5 You then need to add a control and some...

May be its a joiners thing but what does size1p and the rest mean? What I am thinking is you need another text box on the form that would have something like =[valx]+[valy]*[Formula] in its control source. But that isnt going to work with text as your formula.

Have a look for the SendObject VBA method. DoCmd.SendObject You may be able to achieve what you want with just a macro, that has a sendobject.

Thought it was but obviously it was not. That is the answer thankyou.

Heres the sql SELECT data1.*, teams.* FROM teams INNER JOIN data1 ON teams.codeno = data1.codeno;

I have a query based on 2 pretty simple tables, I am doing nothing fancy with it just selecting the data. The query executes fine but will not allow me to update the data. Not sure what i am doing wrong here and have looked at all the reason MS give for this state and can find no reason why...

We are talking proper football, with a correct shaped ball :) The data is presented as just a total for each player on a web site, I can highlight and copy this data then import into access. The 3 tables would allow me to deduct the values from one another.