Search results

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...

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...

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 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...

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...

Hi All, This is a bit hard to explain and I've searched for an answer to no avail. I think this might be a 2007 bug. I have a report with a chart on it. The report is based on a query with criteria derived from a form. The chart also has it's row source (obviously) set to a query but until now...

Hi All, My client is trying to sync replicas and is running into trouble for some reason. last week everything worked fine but now they started getting a MaxLocksPerFile msg so I put DAO.DBengine.SetOptions MaxLocksPerFile, 1000000 in front of the db.synchronize then...

Hi All, Have been using db.synchronize for a month or so now with a client and no probs 'til now when the client got the file locking message, which I think I've narrowed down to the client having entered heaps of data to a replica then tried to sync and the whole thing went pear-shaped because...

Hi All, I've searched far and wide for an answer, I thought it should be easy but am having some difficulty. I would like to add a smiley face or a sad face to a standard comments list so that when that comment is added to a record on a form and subsequently printed, the information can be...

Hi All, I'm about to embark on a project whereby my client needs to be able to create replicas for use with tablet PC's that can be taken out into the field then synch'ed back at the end of the days work. I understand that I need some careful planning so would like to put forward my thoughts...

Hi All, Does briefcase become corrupt? Probably a silly question but... My client has been happily using a front end / backend for sometime. He drags the backend to the briefcase causing the replication thing to happen then over a network drive, moves the briefcase to a Targatech(I think)...

Hi All, I'm having a strange problem with my 2007 database. I make changes and email a new frontend in .accdr format to my client quite regularly without any problems, the last time being last week. This week he is getting a message "This database is in an unrecognized format", "The database...

Hi All, This is probably a simple question but can't for the life of me work it out at the moment. I have a form with unbound fields on it which is used to create new records. This form is going to be used on a touch screen so I have made another form that is a popup keypad. The keypad will...

Hi All, Having written and distributed a A2K database about five years ago and now with over 300 clients, I am needing to update everyone to 2007 (and make some money). Given that all these clients have the full spectrum of OS and access versions or sometimes no access my questions are: Can I...

Hi All, Have just started using 2007 and it's not as bad as I had heard to use in terms of the new menus, ribbons etc. But, Converting up from 2000 to 2007 all my command buttons aren't working, they were created in 2000 with the wizard so have all the error handling etc but just don't do...

Could someone please have a look at this code and identify why it might not work in some situations. I have a client who doesn't have a C drive but has an N drive in a network situation. This code which is in my start up form isn't prompting for a relink......works fine for me..... On Error...

Hi All, I have a diary/job planner section in my database that has a field for date, blocks, diary entry and completed by. In the blocks field (text) you can list A, B, C or A, C, or A, depending on what blocks the job was completed on. (Hope I'm making sense). Anyway, what I want to be able to...

Hi All, I was wondering if someone could take the time to give me a few clues on the best way to go about this problem programatically. Attached is a text file that is exported from a soil moisture monitoring program. I want to get the soil moisture measurements in to my access 2000 database...

Hi All, I am desperate to find an alternative to the rotten, stinking MS Graph. I have an application I've written for vineyards and have about 200 clients. MS Graph is letting me down BIG TIME with some clients graphs showing the data I used when making the graphs not their own, some the...

Hi All, I would like to hear anyones experiences with charts/graphs. I find the Access charts not powerful enough and unreliable. I distribute my databases so need also something that is not complicated for the end user. I have looked into a couple so far and here is my feedback to date...