Search results

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

Hi All, Thanks for looking at my question! I've had this error beofre but can't for the life of me remember how I fixed it or even find where I worked out how to fix it. The problem is occuring for a new client who has Windows 7. When he opens the database (frontend .accdr that connects to...

Thanks heaps Bob will give it a crack! Rachael

Hi Wiklendt, I'm in North East Victoria in the King Valley, my grapes go into Holly's Garden Pinot Gris, Holly's Graden Pinot Noir and Holly's Garden Ramato (Pinot blend). Wine by bike in NZ sounds like fun, atleast you would have to worry about doing your license for .05! Although the bikes...

Hi Wiklendt and Bob, Sorry I haven't replied earlier, I've got a vineyard here in Oz and we're right in the middle of harvest so have been picking grapes for the last week. Thanks for looking at this, I guess sometimes you just need to accept that somethings can't be done. I have tried the...

Thank you very much for looking at this, I'm sure I'm doing something really stupid!! Also I apologise for some of the names used, I've learnt alot over the years about naming conventions, I've been developing this database for almost 10 years now so unfortunately some of the early stuff still...