Search results

I'll have to double check, is most likely what has happened. At present I don't have access to the database to check. Last day of work and it's a cleanup day. I'll follow up on this and reply back. It's always good to get coding clean and streamlined.

I need to clarify, due to so unavoidable circumstances, I'm writing the database in 2007, for a 2003 system. While this is quicker, for some reason it does not appear to work when database is loaded on the 2003 system. as this is for a government institution, there may be some specific quirks...

Worked it out in the end: "ID1" is the key field in the query "mastertable fortnight" is the query based on the table "Mastertable" In (SELECT [ID1] FROM [mastertable fortnight]) This filters all records in the query that match the numeric value of ID1.

Hi, Trying to apply a column in a query as the criteria in another query. is there an expression i can use such as: =[column]![query]

Thanks - have resorted to a subreport. it works, and will investigate dlookup shortly.

Hi, I'm trying to get a conglomorate report together that combines data from a number of queries, tables and crosstabs. currently all works except my attempt to programatically reference a field in a query. Said query has only one line as it is a summary query. my current code is this: The...

Thanks - owe you one. Drop me a line if you ever need assistance with circuit design, model rocketry, firearms, laser engraving or pretty much anything else that's dangerous and unusual.

Just reading a few visitor messages - Isn't just a joy when you know how to fix things? Everyone wants you to fix everything and for free. Incidentally I owe you one. Let me know if you need assistance with anything electronic (circuit design etc)

No, linking won't work. The database will be on a server. Files must stay with the database. For both location purposes and due to privacy regulations. I am making reference to parts of 3 different databases here, but the one that requires the OLE field if for a government institution. I am...

No not for images, for varied types of documents that must be associated with a job record. These could be anything from PDF to xls. There really isnt any other way to get around the requirement. In case I am unclear, i was referring to an OLE type column in a table.

Not a prob, Yeah I have difficulty finding time to design it myself. it's 23mb when compacted now, and there is just a few test records in there. could also be the bound OLE objects in there too.

Labels have advantages of their own, they also behave differently on reports. much of my code will be cut and pasted to a report at some stage, and I like to minimize my work in modifying procedures. It's difficult to explain everything I'm working, as it seems to have sparked your interest...

I will be doing other things with the variable further down the code. this is kind of mashing two steps together in preparation for some juggling further along. For instance I have a few labels that I want to add the string into, EG: label1.caption = staffname & " has taken " & tally & "...

I am aware, however for compatibility sake, and as this code was used in a 2003 database, it has some issues with the .value statement at times. The other factor behind this, as the client, who's database this was used in, likes to have control, and likes to see the focus change between boxes...

Just an addition, ran into an error when the subform had no records, so I added an error handler like so: Dim Tally As String If Me!leavetakenQuerysubform.Form.Recordset.RecordCount = 0 Then Else Tally = Me!leavetakenQuerysubform.Form!SumOfHours.Value leavedays.Value = Tally End If

Got it working: Dim message As String message = Me!leavetakenQuerysubform.Form!SumOfHours.Value MsgBox message This page was very useful: http://www.mvps.org/access/forms/frm0031.htm

I may need to clarify a little more. I have two tables. for the purposes of this we will call them "Maintable" and "SummaryTable" Maintable has a form - that has a subform (showing summarytable - one to many relationship) and also a subreport. The subreport is a summary query of summarytable...

So I have decided to contribute a few of the more useful snippets of code I have put together in some of the better databases I have written. I hope you guys find this useful: "Get Directions in google maps from address fields": You will need to change field names to suit. This can cope with...

Hi, currently working on a few databases at present. I have a conundrum I would like to resolve for all of them. My initial issues of trying to use a crosstab as a subquery have been solved by just using a simple query using the summary feature provided by the query wizard. So now, I have a...

Just figured out my problem - for anyone that finds this trough google like I did. Make a SIMPLE QUERY, using the wizard in access 2007, and choose the summary option. this will generate counted totals similar to a crosstab that can be used as a subform/subquery without the need to define...