Search results

Thanks for your help Gemma. Your suggestion sorted it. :) I went with this in the end: Dim myArray As Variant Dim myVar0 as string, myVar1 as string, myVar2 as string If Not IsNull(Me.OpenArgs) Then myArray = Split(Me.OpenArgs, "|") End If If UBound(myArray) = 2 Then myVar2=...

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

OK so I've figured this out. For some reason Me.requery after either a deletion or save followed by closing the form caused the error. I replace Me.query with a recordsource update and this has solved the issue.

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

I'll see what I can do about that Bob, but I have a whole login layer to disable and 90plus other forms to delete in order to get the size down, so I'm not sure how practical a move that is. This behaviour is also exhibited on multiple other forms.

Bump. Still experiencing this issue and really need to get to the bottom of it for the sake of my sanity.

I applied some basic code to the on Error event to display the error message and error code and it came out as 0. I have seen both variants. The 3021 No Current Record error actually displays the 3021 code but the version I'm suffering from just says "No Current Record" and nothing more.

I have no code on the on Close, on Unload or After Update event for neither the main form or sub form. I do use plenty of VarChars but I always set a character limit - though not as high as 500. It's really frustrating because if I could figure out how to handle this specific error then I...

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

Sorry, I didn't mean hidden form I meant hidden control. So on the main form are two text boxes. One containing the credit limit, one containing the order total. But the order total takes 1-2 seconds to appear and kicks in long after the OnCurrent event has had time to fire.

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

Following on from the excellent responses to this post of mine some time ago, that all works perfectly apart from the entire report is PDFed when I need only the current record based on the primary key. How do I modify the acOutputReport function to only PDF a single record?

Thanks for your reply Jack. Examples of the custom functions I'm running are as follows: Check the current record's customers' VAT status to determine how much VAT to charge. Field validation. If mandatory fields are not filled in then set their border to be red an 2 pixels thick to draw...

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

Hello and thanks for your reply. I'm not checking to see if a new record has been saved, I'm checking to see if there is an actual record. Let me explain in a bit more depth. I have a table called tbl_orders which holds a basic summary of an order. There is a field called entry_complete that...

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