Recent content by gizzu

I have the Swedish version of Access. When I write =expresions in the controlsource of control in a form/report, I cannot use the english function names as in VBA, but must use the swedish substitute for the name, which access then translates into english, but still view it as swedish in form...

Hello! I was running the code from the sub form, so I couldn´t use Me..., but after tweaking the code to fit my needs, it brings the functionality I was looking for. I also wanted the subform to be fully visible, so I inserted Form_themainformname.recordset.movelast before going to the original...

I have a form in spreadsheet view. Basically all I want is to update the information which is viewed, but Form.ReCalc doesn't requery the database. So I tried Form.Requery. But after doing Form.Requery, the first record of the form becomes the active record, and in some cases I have to scroll to...

I use Microsoft Treeview Control 6.0 (SP6) in both Excel and Access. In Excel I can see the properties/methods in the VBA using Ctrl+J (or Ctrl+Space) but in Access I get the wrong list of methods/properties, e.g. properties is missing, and those viewed in the list doesn't exist. Why, and how...

I have serious problems when viewing forms in Datasheet View. I have forms named Form1, Form2 and Form3. All forms is viewed in datasheet view. Form3 is subform to Form2, and Form2 is subform to Form1. When I click the + sign next to a record (say, record #3) in Form1, the related records in...

Yes, probably you have to redesign the database. To get around the problem with changing team names, add a column named ID to the team table being of type Counter, then have the team field in the employee table of type Number, Long Integer. then each team will have a number that makes no sense...

I was able to solve the problem in the On_Change Event for the tab control in Form2. Sorry for posting, and thank you!

Form1 has a sub form, Form2, which have a tab control with a number of tabs. One of them, Tab4, includes a sub form, Form3. I have an SQL statement that I want to run (using DoCmd.RunSQL) when Form3 is shown on screen the first time, e.g. when Tab4 activates. I've tried OnClick for Tab4...