Search results

!! Am I not on your side!! I agree that there is no positive genetic evidence (The UK College of Psychiatrist had to retract their statement that "people are born gay") My evidence, if anybody ever bothered to collect it, would confirm that being gay is a learned experience which becomes a...

Whether children are more likely to be gay or bisexual may be due to nature or nurture or a combination of both. If "70%" of children ADOPTED by gay couples chose a gay/bisexual lifestyle, it would be almost overwhelming evidence for nurture ie environment as against genetic factors. Your...

The error appears when runtime only with no full access is installed.

No! The error does not come up on his PC's with full access - the problem only occurs with those that have run-time. Perhaps there is a (well) hidden, now redundant, control on the relevant form that still calls the Activex 'successfully' in full Access but Run time is unable to call it??

Access 2010 on both Windows XP and Windows 7 I have an application which USED to use a postcode address utility that created an Activex. I have removed all references in vba to the utility but Access runtime gives an error 'cannot create Activex' on my clients PC's (both with Windows XP...

I have an Access 2010 database that uses an Address Utility that requires a reference to pdf.ocx. Things work fine on Windows7 but I need it to run with Access Runtime on XP. The database runs OK but can't pick up the Address Utility - 'unable to create object' - I suspect that the...

Many thanks to you both - I had already thought to use 'auto exec' when I read your answer Frothingslosh(!) TJPoorman, you asked Why? - my client wants to be able to create individual customised databases from within the basic database - so I was setting properties for a new database. What I...

Hi, Access 2010, Windows 7 I presume the specification of the start-up form is a property of a database. How can I use vba to set this property?

Yes - I see the point that it may be possible to avoid Exit Sub. I just find that sometimes my flow of logic seems more transparent with (sparing?) use of Exit Sub notwithstanding lots of comments. Why make things more complicated than they need to be? ((Exit Sub is there, so why not use...

Many thanks, my misconception cleared :o - as you might guess I am only just getting into 'deploying' (after a an abortive attempt long ago with Access2000!) My front-end starts up by looking for its back-end and if it can't find it allows the used to locate it and it then unlinks/relinks the...

I am a self-taught Access VBA person. Sometimes I find the 'need' to exit a subroutine from within a control 'loop' e.g. if.. then..else with... while... et al. I suspect this is 'bad form' but is there any 'cost' in doing this? There presumably will be if objects have been set and...

Access 2013 Is it possible to compact a database to a new name? (In previous incarnations of Access I regularly 'compacted and repaired' databases to USB sticks rather than simply copy the file in the (mistaken??) belief that this was a more reliable approach) I can't see where to do this in...

I am attempting to deploy a split Access 2010 database to an XP PC with service pack 3.(NOT by choice!) There is no Access on the XP machine so this would be a Run-Only version. MS claim this will work. I was hoping to deploy both the front-end and back-end with a single package. Is this...

Hi, I am using Access 2010, Windows 7 I have an unbound form with a combo box and a bound subform on it. I am using the combo box to get a value to filter (and display) records in the subform. My code is: Private Sub cboSessions_AfterUpdate() On Error GoTo...

I have a split database.(Access 2010) Three of the linked tables are Appointments, Appointments_OLD, Appointments_NEW I want to use vba to rename Appointments as Appointments_OLD (replacing the current one) and to rename Appointments_NEW as Appointments (replacing the current one) I have used...

Access 2010 I have created a custom shortcut menu for reports using VBA in the Open Event of my Startup Form. It works fine but: 1. I have to let the code run every time I open the database for it to be available to reports, otherwise I get a message that my menu cannot be found. I...

Never thought of that!! Many thanks.

Is it possible to set the Date Picker in Access 2010 to start the week on Sunday rather than Monday? (Which I believe it did in Access 2007)

OOPs! You CAN make a copy of the Back-end database using vba in the Front-end - I made a stupid mistake with the name BUT. . . UNLINKING TABLES Can anyone explain why version 1 does not work (It stops halfway through because it can't find a table it has already deleted!) but version2...

I am trying to use VBA to backup the BACK-END of a split database (so I can automatically archive selected data). If I use FileCopy I get a message that the BACK-END database has not been found. Obviously I could 'unlink' the BACK-END, copy it and 're-link' it, but I was hoping for a...