Recent content by IndigoStickman

I believe simply adding a line below the first, but like this: Me.SubFormControlName.Refresh Should do it? May even be better to put that line above, so it refreshes the form prior to popping it up. Someone will no doubt correct me if I've made a schoolboy error as I'm still green with VB...

Thanks David, I'll use that as I'm the only one to be the admin user. And thanks Galaxiom, I did mean DSN, doh.

I'm also racking my brains to find an alternative method to get that field to populate for you using my working knowledge.

I've done a quick sweep of the forums and it seems your runtime error: run_time error -214352567 (80020009) Is that the recordset is not updateable. I'm sure that means that you have locks in place to prevent additions etc in the source of the form. I'd look at the controls if it was me to...

Hmm, Will a simple Me.refresh on something like the "got focus" or "on activate" event not fix it? Or am I looking around the issue.

Is the customer order form that is still open visible or not? It's just that I have a similar thing running in a database of mine, but wouldn't want to misadvise you as I'm still a relative beginner when it comes to Access programming.

I trust that you've already tried opening the table that contains the offending record in datasheet view and simply tried to delete the row altogether? Its a rather primitive and slightly raw way of doing it (I'd prefer to do it through the front end via a process but when needs must...), but...

Hi all (not sure if I'm in the right place), I'm putting the finishing touches to an Access database, and part of the design relies on linking to a number of tables within an external SQL database. We've set up the DNS and entered the password etc, and have even checked the "remember password"...

Hi all, I've got in place a Modal search form that produces a list of results based on a number of keywords in the relevant text fields. for the on_Click VB I have the following code: Private Sub btnopen_Click() If (Me.CurrentRecord = 0) Then MsgBox "Please Select a Record"...

Hi all, I'm a relative newcomer to Access through work having previously working with a stripped down version of J2EE, and am in the process of learning Access programming as a "baptism of fire" - Very enjoyable but there will be a lot of questions on here from me :D I hail from the East...