Search results

I work for a small company (25 employees) 10 of which are database users. We have an internal Access Database we've been using and developing for the last 10 or so years. Needless to say it's quite complex and there's a lot to it. Access front-end connected to a local MySQL server backend...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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