Search results

Here is a snippet of code I'm going to use for archiving old data strSQL = "INSERT INTO tblMatters " & - "IN ""C:\Archive\DataArchive.mdb"" " & - "SELECT * FROM tblMatters WHERE [rec_date] < #1 January 2009#;" The code appends certain records from a local table into an identical table in an...

Doh. Self-solved. Just use asterisk to select all fields.

I'm trying to create an archiving routine as my database is becoming very large. For about 10 tables I want to shift certain records to an external database which would have the required 10 tables with the same table names and structure. So far so good. I now want to automate everything using...

Sorry - but didn't work. It just hung the A2010 run time machine

I have an application created in A2003, but my client's machines nearly all use A2010 runtime. Does anyone know how I can disable the Date Picker completely on all forms as I have no need for it. Obviously I can't access the 2010 property sheets to disable it that way. Thanks Dave

I like what you're saying, but after having altered the shift key behaviour I have to close the app, then re-open it while holding down the shift key, and in that case no forms open, not even the one I've designated as the first one to open. If I could find a way of opening a hidden form right...

David - I see where you're coming from but there remains the loophole of the shift key. And that's where I got to as well, although by a slightly different route. So I'm beginning to think I'm stuck with what I've got, which is almost there but not quite. Currently, after doing my work behind...

But what if there are no open/hidden forms?

Has anyone managed to crack this? I want to run a function when my application closes. But it must run in all cases, so running it on the last form, or in a hidden form, is not good enough. Even if I'm in design mode with no forms loaded, I want it to run. For background info - my app is...

A bit more info:- In full version of A2010 my app, which is still an .mdb, runs without errors but there are issues mainly around menus/toolbars/ribbons. The locking down that I do in A2003 doesn't work right and menus and ribbons are exposed for all to see. In A2010 Runtime it works...

I have a large application originally written in Access 2003 running on XP. My development machine has been upgraded to Windows 7 but still keeping Office 2003 Pro. At the same time our client has also been upgraded to W7 with Office 2010 standard and Access 2010 runtime. This is all working...

Thanks JHB - it worked !!!

On a form I have 2 list boxes and a subform in a cascading arrangement. When the form is opened the first list box is populated with data from a query. When an item is selected in List Box 1 then entries appear in List Box 2 from another query. When an entry in List Box 2 is selected then...

Thanks Pat After 2 days of fiddling around I think I've reached the same conclusion. The user will select a section, then see a list of sub-sections. On selecting a sub-section they will see a continuous form with the budget line detail. It will look perfect with no compromises or short cuts...

Thanks for your input Linq. This is part of an existing program that has already been in use for 4 years so cannot be changed now. I'm stuck with Access for the time being. This module is a budgeting system. The budget consists of 14 main sections, each section has a number of sub-sections...

Very interesting post Linq. So have you any suggestions about how I might approach this problem. I can think of a horribly long winded way putting all the data into an array and then writing it to rows of text boxes and buttons, and then arranging for a complex way of scrolling up and down the...

You're right of course, I know what I meant, I just used the wrong word. I don't think your idea would work on a continuous form. Just to be clear each row of my form contains 4 text boxes and a command button. One of the text boxes contains a numerical value. If that value is -999999 then I...

Oops, should have said - Continuous

In Access 2003, if a condition is met I want 3 fields to "disappear". Seems easy, just change the back colour and text colour. But, the various grey colours offered do not match the default form background colour. This is very annoying as I don't want to change the forms background colour, it...

Access 2003, in a continuous form I have a number of fields and a command button. I would like to hide the button if a condition is met on one of the fields. Anyone know if this is possible? Thanks Dave