Search results

  1. H

    Combining multiple sub-records against each row in a report

    I've built a system to log faults against products. Each product can have 5 types of fault. Fault1, Fault2, Fault3, Fault4, Fault5. Each product can have multiple instances of each fault type and for each fault logged, the metrage is also logged. For instance: Product 1 can have a Fault1 at...
  2. H

    Using SelStart with a ComboBox

    I have a combo box formatted with an input mask of: ####\-##\-###\-####;0; When the user clicks in the combo box, usually the cursor ends up in the middle of the string and they have to backspace or press the Home key to return to the start of the field. I know that for a text field you can...
  3. H

    Continuous Forms - Different Properties For Each Row

    I have a form containing a sub form. The main form is for orders, the sub-form contains items against the order and is set to continuous form view. We have a price field set to a double in the DB back-end that is generally displayed to 2 decimal places on the sub form. Very occasionally I'd...
  4. H

    255 character limit on query fields

    I have a query, the results of which are pasted into a spreadsheet template for a monthly KPI report that goes to one of our biggest customers. The problem is (and I know that this is old news) Access's 255 character limit on fields in a query. Even fields set to longtext or blob get cut off at...
  5. H

    255 Character Limit on Query Fields

    Hello guys. I am having a problem with a query in that it truncates longtext fields to 255 characters. Having read up on this, it seems this is a restriction enforced by Access, for whatever reason. Does anyone know of a way around this? I have to use a query as opposed to a report as the...
  6. H

    Detecting when Access, and not a specific form, has lost focus

    Hello, I am using a Microsoft Access .mdb front end and a MySQL back end. I have a bound form containing a sub form. For one of my users, sometimes when she switches from Access to Excel and then back to Access a minute or two later, she gets a #DELETED error in the subform and one or more of...
  7. H

    Long Query Being Broken by Line Breaks

    Hello, I'm trying to run a long query through VBA code. The query itself works just fine, but when run through VBA is being broken because Access is adding line breaks in the middle of words and thus breaking the query. For example, it's trying to run: SELECT * FROM MY_TA BLE WHERE id = 1 AND...
  8. H

    Use two decimal places only when required

    Is it possible to modify a control on a form so that it shows to 2 decimal places only when required and show to 0 decimal places the rest of the time. I'm working on our invoicing system and the field quantity. 99% of the time we are dealing with whole numbers and 2 decimal places is not...
  9. H

    Sorting on a calculated field producing unexpected results

    I have a relatively complex query that shows delivered orders and calculates the number of days they were late. I want to sort the results of the query by the field days_late which is [delivery_date]-[despatch_date] but as you can see by the screenshot below, It partially sorts the results but...
  10. H

    Checking if myArray(x) is actually set

    Hello, I'm working on a form which has multiple variables passed to it via OpenArgs with a pipe (|) separating each variable. My code captures the string and creates an array containing each element and this works just fine. However. This particular form can be opened from multiple different...
  11. H

    Sudden graphical glitches when displaying reports

    Hey guys. Just encountered a new issue in my Access database whereby reports and forms often appear transparent and graphically glitch all over the place. Hard to describe but the following screenshot will demonstrate: http://snag.gy/tSVJZ.jpg If I zoom into a report then it renders properly...
  12. H

    Creating a hyperlink that incorporates the cmd function in an HTML email

    Hi guys. Using the /cmd switch when opening Access, I've managed to make it so a user can open a specific record on a specific form automatically when they open my database. Emails are automatically generated that notify the user that they have a new record to view and the idea is that the...
  13. H

    No Current Record Error - Not the 3021 variety

    So for years now I've had a minor but annoying problem with my database. I've tried on numerous occasions to get to the bottom of it but always failed. I've read through hundreds of forum posts but still not figured it out. Today I'm absolutely determined to solve it. I have an Access 2010...
  14. H

    No Current Record Error on Form Close but not 3021

    So I have a problem with my database that's been bugging me for some time now. I've read countless forum threads but to no avail and am pretty much at the end of my tether with it. I'm using Windows 7 and Microsoft Access 2010. I use a MySQL back end and Microsoft Access front end. This problem...
  15. H

    References order not being saved

    Hey guys, I have an issue with my database in that if the 'Microsoft Active X Data Objects 2.1 Library' is higher up the references list than 'Microsoft DAO 3.6 Object Library' I get a mismatch error on my database connection script. Correcting the sort order resolves this, however, there are...
  16. H

    Calculation in footer of sub form lag.

    Hi guys. I have an orders form with a subform containing each item on the order. An item has a price and a quantity. On the footer of the subform is a field called txt_order_total which calculates sum([quantity]*[price]). On the main form is a unbound text control that displays the order...
  17. H

    Write Conflict Error - MySQL Back End

    So I have a database front end that's an MDB run in Access 2011 and a MySQL back end run by XAMPP. I'm encountering this weird error where on almost all of my forms, if I change a field from one value to another, but then change it back to the original value I receive a Write Conflict Error...
  18. H

    Check for current record

    On various forms on my database I occasionally receive the message "No Current Record". This is to be expected at certain times as there are indeed no current records. Now I know it can be suppressed but that's not a course of action I want to take, but is there a way to check for a current...
  19. H

    Access 2010 PDF and Email a Report Using VBA Code

    Hello, I'm using Access 2010 and found the Send to Email as PDF command indispensible. However, I have a problem in that I've hidden the main ribbon from my users which means they can't actually click that button. Can anyone tell me the VBA code that will let me PDF and email an indiviual...
  20. H

    Write conflict error when changing a value to something else then back again

    I'm developing a database and at the moment I'm the only person using it. I have a bound form with various text boxes on it. If I change the value of any of the text boxes and close the form the updated values are saved. If I change the value of any of the text boxes, but then change it back...
Top Bottom