Search results

Thanks Dt... that is what I had heard as well. Will try to get hold of a copy of the book. Cheers, J.

Just bringing this back into view.. posted just as new posts were being cleared down.

Hi folks, I have a bit of experience using a combination of vb, sql, unix scripting, access, dos etc. As well as very basic use of HTML and some static webpage design through Dreamweaver. I am considering an attempt at creating my own dynamic website with a MySQL db behind it, and I will need...

Looks like you would like to specifically change the value of a report field to a specific value from your form - by just assigning the value... not sure that that will work. Believe that you could instead try to filter your recordsource (myGlobalSQLstring) so that it only selects records where...

I can't look at your db - I only have Access 97 at work. Ok. so you have the form bound to your table. 1. Create a query that selects all of the elements that you need from the table (obviously you have to keep the table to do this). 2. Go to the properties section of your form and change...

I'm not surprised it didn't work... all of your field names have changed from the jpeg that you posted... lol. I have to go... so will give you a quick and easy. Create Query 1. an aggregate query where you only select employee id and max of date. Create Query 2. A Select query where you...

You could try the following, the main reason that I use this approach is so that I can create a filter on the fly depending upon the choices made on a form. Set up a global module with a public variable. Global Module Public gstrReportRecordSource As String In the report set an "on open"...

Go to the query for the report and put forms!Formname!txtEmployee in the criteria section. Where Formname is the name of your form calling the report, and txtEmployee is the text control with the employee id.

Don't quite know what you are after... but maybe try putting the following formula as an extra field in your query... and tell me if it is what you want? test: IIf(IsNull([coaching1A] And [coachingdato2]<>""),[coachingdato2],[coaching1A]) Be sure to keep it as "group by" in the total field.

... do you really need a "quick lookup" for just 6 records?! Sounds like a little over-engineering.

Even easier... select combo control... add to form... the wizard should offer the opportunity to "find a record on my form based on a value I select in my combo box"... choose this option. J.

Firstly, listen to Neileg all of his comments will help you to code better in future. If you then want to experiment a little try the following. Set up your combo using the wizard (based on a query, not a table) Insert an unbound text box called txtControl On the "on Change" event of the combo...

That code should work as is, it will allow you to see it isn't as hard as it looks. Create a table called Tablename with 3 fields (field1, field2, field3) and populate some of the fields with any garbage... i.e. Field1Row1 Field2Row1 Field3Row1 Field1Row2 Field2Row2 Field3Row2 Field1Row3...

Sorry about the double-post... my browser said that it had timed-out?!

Dolano, Instead of trying to output a report, you could create a recordset of the query that you use for the report and output that instead. Below is a sample of the code that you could use, as well as some additional format helpers if you want to format the spreadsheet. You would put this...

Dolano, Instead of trying to output a report, you could create a recordset of the query that you use for the report and output that instead. Below is a sample of the code that you could use, as well as some additional format helpers if you want to format the spreadsheet. You would put this...

Because it is an aggregate function you may run into problems with a single query. It may be that the simplest solution is to keep the first query as a standalone query and reference the value of your first query in a 2nd query.

This might be what Rich is refering to. I had it in an old directory. I think there are some credits within the code and forms. Suspect it is the db originally posted by Pat. James.

If everyone planning to join the army played a few games of paintball first they would realise how easy it is to get shot... then perhaps no one would be so foolish... or maybe it would just encourage more ppl in the US to join?!

Instead of creating a temporary query definition you could just put DoCmd.RunSQL (strsql) J.