Search results

Thanks for your help everyone.

Thanks Rural guy. I'm not trying to take a short cut here but, could you point me in the right direction of how I would do that? Thanks

hey, it's ok, I worked it out SELECT Left([codes],7) AS codes FROM Project Only problem is, some of the codes have spaces oft, CMB - 001 DRC-001 ah well, thanks for the help folks.

Thanks Rabbie, I didn't notice the Left function until now. Do you know if I can use it in a query? I can't find any info on it. thanks

Hi there I saw my question in an online tutorial once but can't find it. I have about a thousand records and I'm just concerned about one field. I have to strip away part of the text. Heres an example: AFG-006/2/E AFG-006/E AFG-008/1 AFG-008/1/E I have to strip away all of the left part...

As far as I'm aware, each field from left to right takes precedence in the aggregate. So, if you have several fields within your query, set them up like this: Manufacturer ID(GroupBy) SN(GroupBy) Current Location(GroupBy) Status Date(Max) Time(Max) In that order within...

Hey, I'm unsure of how to do this one, any help would be appreciated. The database I'm working on has around 2000 records within the parent table. These reflect projects around the world. the child table has records on how much these projects cost. I would like to calculate the % of...

If you want the lastest date for that set of records you could use the MAX function. Change your Select query to an aggregate using the totals option within the view menu and where it says Total, change it to MAX under your date field. Hope that's what you were looking for.

Could you give a little more info as to what you want? do you want to extract records with whatever date you specify?

thanks Neil for getting back. I've been thinking of using a Pivot table within Excel. Probably better that way than to have a pivot in Access. I'm going to set up a cross tab query to see if that will work. cheers

Thanks folks for your help. neileg, No, this is not course work, I'm simply looking for a way to do this query so that I can use it as the record source of a report. Perhaps what I propose is "bad design". however, I'm looking for ways to produce the report so that it can be analysed within...

Hi folks. I've been looking for an easy way to have 12 columns in my query which are each of the 12 months and are all using the same date field "dateSent". So i'd want to just use the month part. within the actual columns there will be a disbursal field which will tell a user how much...

Thanks Jurjen! you've obviously took some thought in this. I ended up making a new field (archive Yes/no) within the parnet table on the other side of the junction table. and created code so that when a user ticked the archive check box a dialog box would popup asking the user if this was a...

Hi there. I'm trying to archive records by using append and delete queries that span accross 12 tables. the VBA will execute them all. However, I have a junction table near the end; It will be the Junction table, then a parent then a child table. I can get the junction table keys deleted...

Hi folks. I'm having a bit of bother with the MSCAL.Calendar.7. If you know what the calandar perhaps you know the problem. I'm using the calandar to get the dates for an input form which will open a report. I have code within the command button to open the report which is: If Not...

I'm not 100% sure I follow the last paragraph. However, If you want to double click an ID field within one form and open another form that relates to the same record ID, perhaps this might be of use: http://office.microsoft.com/en-us/templates/TC010184611033.aspx?pid=CT101426031033 Download...

Hey everyone! I had a look at some threads that were concerned over Boolean fileds (yes/no option/tick boxes or whatever? and thought i'd hopefully add something if it hasn't already been added. there is an option where you could have three states if you select a tick box as your Boolean and...

thanks Maurice. You had the same code that I tried and yours did work and mine did not. So, I had a look at your properties and saw that the 'Key Preview' was set to yes and when I did that it worked fine. Thanks again.

HI everyone. I was looking for some code to disable the Pageup/down keys within a form and the code I got is not working. first of all, I used the 'Cycle' property of the form to 'Current record' I also added this code: Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer) Select...

Hi folks I borrowed some code to use with reports which is: If Not IsNull(Me.cboProjectCode) Then strWhere = strWhere & "[ProjectID]=" & Me.cboProjectCode & " And " blnTrim = True Before that I used a technique using a dynamic query by code but this is a lot easier. My...