Search results

I just post this one because it took me more than an hour to find a comfortable solution for access 2003 http://support.microsoft.com/default.aspx?scid=kb;en-us;826765 To set the AllowBypassKey property to False, follow these steps: 1. Start Access. 2. Open an Access database project. 3. In...

Within one form everything with parameterized subqueries goes wrong. I think your hint might be right but i'm looking after the right reference currently.

I've converted a microsoft access 2000 into 2002-2003 filesystem because I want to build a mde. First I downloaderd the jet service pack 8. The problem after the conversion: reports in a form don't work anymore, the references to form values are popping up as parameters disrupting all the...

Ok today I will have a look I have small business server and will connect to it using a laptop via remote desktop client (terminal service). I will be editing records in same table direct via my user interface at the server and on the client and will see what results will happen.

Might be a stupid question as I know a lot of access but it's the first time I'm doing this: What's the easiest way to deploy an access database (mdb) on a domain network to clients?

You can do so in a form but not when the record is in tableview. If your records are shown in tableview forget it. So use the standard form options of flat fields and use the properties of the control box to add some color flavour.

I'm using two pop-up search forms to give my users search possibilities. The forms refer to a query with Like criteria. The odd thing, when I use the *-sign all values are returned except null values, in this way I'm missing a lot of records if one field is null. Does anybody know an...

Hi Pat, A similar thing I'm using but in one case there's a referential error without an error code. If there's no code nothing can be trapped. But this way i trap 95% of the referential errors so it's quite ok

McAbney, I tried but it only shows the original message. probably access doesn't see it as an error? The strange thing is one time it's 3200, other time it's 3396 and these error traps work well. But within one form access automatically responds with a message without error Id while my...

Thanks, I'll try immediately

and in another one without an error code and can't trap the stupid error

and in another with error code 3200

solved? Gee, in another form the help pops-up with error code 3396 end of topic

normally you should get the error code by clicking 'help' when the error message pop-ups but no help button is there

I've written a general error trap function within a module with several error codes. I call the funtion within several forms with different arguments specific for the form. I want to error trap referential integrity also, currently I have referential integrity enabled with only the update...

Hi there, it didn't work. It's a subform and I've put the code in the subforms on load event, but it doesn't help. The form still begins with the oldest record instead of a new record

FOund the code for the running total in here http://www.access-programmers.co.uk/forums/showthread.php?t=71569&highlight=running+count great query, only needed to add an extra condition (because I reset it for each changing order)

Hi pat, I will use an autonumber as my primary key. The rulenumber will be calculated by creating a running count, will look for the code

When I open my orderform I would like to have a new record to be shown instead of the oldest one. Each time adding an order for a customer I have to touch the new button first. I would like to autofocus on a new record automatically. I thought about adding code to the 'on open event' of the...

Thanks, I'll try the syntax