Search results

I remember reading in an old Access manual that a recommended use of one-to-one tables was for things that are going to be temporary. The example they gave was something like having a ping-pong tournament details table that was one-to-one with your company's staff, since their ping-pong results...

Indeed it will, so probably more hassle than is needed in this case. But if you wanted to develop and test the old database, I think the hassle would be worth it for discovering the effects of version differences. But yes, OP you should just use 2010 for everything if you only plan to use the...

If you plan to have lots of tabs then that query will get complex and messy quickly. Unless the tabs are going to be all be displaying information from the same table, I would recommend setting up forms for all the different tab categories and then embedding them as subforms in the individual...

Here is my suggestion: You could start a new table called 'YearlyTraining', and at the beginning of each year you run an append query that adds all of your staff to this table, along with the year it's for e.g. a field called TrainingYear is set to the current year. The table could have the due...

As was said, rst is probably a recordset object, i.e. a thing holding the data from a table or query so you can do stuff to it. rst! is the preface to a reference to a particular field, so for example NameString = rst!PersonName would write the the entry from the field PersonName for the record...

My personal experience is that it is possible to run both as long as 2010 is installed after 2003 and you make sure not to overwrite 2003 during the install. However sometimes when you switch from using one to the other the system starts to reinstall the new version, presumable because it needs...

It depends on how you are doing the export, but most export functions have an argument to choose the spreadsheet file type, usually via some cryptic format arguments like 'acSpreadsheetTypeExcel9'. For example you can export via the line DoCmd.TransferSpreadsheet acExport...

If my memory serves me correctly then I think the name 'CurrentUser' is already a function: it returns the name of the user in the current workgroup if you have one setup, otherwise just returns 'Admin' or something similar. So best use a slightly different name just to be safe!

There is a way to get the windows username of the current user: Environ("Username")So you could include a check to only show the items where Environ("Username") = PersonToDoBusiness, or something like this.

The insert procedure bit is in the same place as the insert module. The insert menu should have Module, Procedure, or Class Module as the options. When you pick procedure it asks if you want it to be public or private, and if it should be a sub (just a set of code that runs) or a function (code...

I think you still need to change the Me calls to Forms![FormName]! calls. Because you've said 'Me' in a module that is set apart from the actual form, Access doesn't know what 'Me' is because public modules can interact with any form. So you need to be specific. OR just have the whole apply...

So that was the line causing the compile error? Such an innocent looking part! Well possibly replacing 'Me.' with 'Me!' will make a different. Apart from that you need to make sure that there is something called cboOPOwner for it to look at in the place the code the is run from. Ah perhaps that...

I think you want the office references version 14.0, not 8.0. There should be a MS Access 14.0 Object Library line in the references selection window somewhere that you can use.

Possibly of help is the line: DoCmd.ShowToolbar "Ribbon", acToolbarYes Perhaps have on in the 'On Open' event for the report. For me, opening using that line keeps the ribbon visible. It must be disabled as a result of the conversion, so perhaps running that enabling line just once will keep it...

I'm using 2010, and for me the tab with the currently active form is bright orange, while the inactive ones are grey. Quite a clear difference, similar to what you had in 2000. I haven't changed any colour schemes so I assume this is the default. Unfortunately I don't know any easy way to make...

So have you generally disabled the ribbon, but use code to have certain controls show when relevant? Answer might be to just enable the ribbon completely when previewing. Or if its the case the ribbon is just hidden rather than disabled, I think pressing Ctrl+F1 makes it appear and disappear...

Admirable honesty, but then again you are God, so I guess such virtues are to be expected! :D

I think these days the explanation for this that 'fiscal conservatism' in government just means spend less on actual outgoings, and more on background costs like repaying debts to other nations, which presumably helps increase general long-term economic stability. I don't think the people at the...

Ah okay, unfortunately I don't really know anything about the ObamaCare goings on. no doubt we whips out tactical lies all the time, for thus is the nature of politics! It seems strange to hear you say he is far left, as from the perspective of the UK, Obama would be considered right wing...

Does it show that, even if true? To be fair, it's not very far to go to recast Obama from 'US citizen with possibly foreign nationality' to 'US citizen with foreign heritage'. Not exactly the biggest cover up of all time. And another Democrat could have been chosen to run on the same policies...