Recent content by Rachael

PS this only seems to happen randomly not all the time and some users it never happens hence one guy is sick of being the invoice enterer lol

is it possible that the offending record which is added by an append query is kinda not saved? So when an invoice is created an append query adds the invoice number and details to a table, it then adds a standard category heading via vba using the 'LastIdentity' thingy to get the primary key to...

Yeah, was thinking that might be a thought, just seems weird that it happens to only some people and that all the data is there for the calc to happen but it just doesnt calculate until either I trigger something like go into and out of the table or I've since noted that if i simple overtype a...

Hi all, am having a strange problem!! Access 2010 - split into a front and back end In an invoicing form that calcs wine sales and therefore GST and WET tax it seems that some users are adding a record and all the correct percentages etc for the calcs are being added correctly to the backend...

Update - changing the queries to use month and year function made all the difference....plenty of ways to skin a cat but some work and some don't lol Thanks

Thanks Galaxiom for taking the time to reply, I appreciate it (and sorry for taking so long to reply - mid winter and the vineyard needs pruning!!!!) Will take on all your suggestions and have another go - you learn new stuff everyday :)

Hi Glaxiom, thanks for your reply! Here are the two queries: Report that will only link on either EmpID or Vint but not both at same time based on this query: SELECT CoNotes.EmpID, CoSubCategory.WineItem, Count(Format([NoteDate],"mm")) AS Mnth...

Hi All, Totally stumped on this - had the report working but now.....don't know what's changed......... So a fairly simple report with two subreports - both subreports have their own queries not relating/using anything from the mainreport. One sub report links fine on two master/child fields...

Thanks Orion for responding :)

Ok so light bulb moment!! Me.txtCoID = LstCo1.Column(0) should have been Me.txtCoID = LstCo1.Column(0, varItem1) ddeeerrrrrrrrrrr what a dick....

Hi All, Can't figure out what the hell I'm doing wrong here!!! :banghead: I have 2 multi-select listboxes set to simple The first is use to select a vineyard and the second to display the blocks associated with that vineyard - can get this to work fine - no probs. What I want to do however is...

Hi and thanks for your replies, Here's where I'm up to, can get it to run but the Unicode value will not changed Dim db As DAO.Database, td As TableDef, fld As Field, prp As Property Set db = CurrentDb() For Each td In db.TableDefs If Not (td.Name Like "Msys*") Then...

Ah thanks for that! I'd glazed over that- you're absolutely correct - I atleast now get an error 'property not found' Do you or anyone else know how to properly refer to the Unicode property - my internet research indicated that what I've done was correct but it doesn't appear to be. thank you

Hi All and thanks for taking a look at my problem, Im trying to programmatically change the Unicode compression setting in my tables but can't seem to get it to work. Here's what I'm doing: Dim I As Integer, J As Integer Dim db As DAO.Database, td As TableDef, fld As Field Set db...

I just had a memory flashback, I think it may be the service pack version of the access 2007 runtime! Has anyone had any experience with this? Rachael