Search results

I copied it in directly, and the "Dao" did not auto-capitalise. Try re-typing it, as it should be "DAO".

Right. But if I then query all records in that sequence, and add 1 to all values where the sequence position is >= n, will I end up incrementing my new entry, and if so, will this then be returned to n when I close the form (since I'm not updating the contents of the bound textbox)? Or has the...

If I've understood you correctly, I think you can do this with your unload event. If you have a global boolean that gets set to false when the main form loses focus, and true when the user clicks your save button, then you can invoke cancel if it's not true, and stop the form from unloading...

Couldn't decide if this belonged in here, or queries, or vba... I've got a form to add an item to a sequence. The user can pick the position in the sequence. However, if there is already an item at that point in the sequence, it needs to be shunted along. The data entry form has a bound...

Thanks all for the help. It dawned on me that it was much easier to choose the properties I wanted (in this case, largely the OnEvents), than to make a different case for each type. Then, exporting to csv is simple, and sorting by type will be trivial. Updated code below. If you use it, just...

Thanks jdraw. That should give me a significant head start. Just a sidenote to any that come after... a blank entry in a property.Value will throw an error, so beware if you're calling up all properties.

Temporary tables sounds like an excellent solution... I've not used them before, so it should be a good time to practice!

Thanks for this. I'll have a go and see how badly I can mangle it...

I had found that article already, but it's not helpful. The ControlTypes in that article have names. Access returns integers. Seems to be part of MS's constant effort to pretend that VBA = VB.net. I could build a case select for ControlType, but I first need to know all the integers.

I'm writing a sub to cycle through all the controls on all the forms in a project, and export their properties to csv. This has gone smoother than expected (hat-tip: http://vbcity.com/forums/p/142594/609960.aspx#609960) Now, I am going through and cycling all the properties, but each...

For the benefit of some other poor soul, it was simple. I hadn't realised that Access buries data type in design view. Clicking on the field then shows that it's defaulted to long integer (because who doesn't want that, right?). Changed to double, and now all is well with the world. I had...

Recordset.update is such a foundational function that I can only think I'm getting the basics embarrassingly wrong somewhere, though I just can't see it. I've got a table to which I just added a number field (let's call it fld1). I have a double (let's call it dbl) I wish to write to that...

Thank you so much for such a detailed reply. That is exactly what I was looking for.

No, it's definitely not the PC - we've tried these things, and it happens on all PCs, which all have somewhat different environments.

I've been taking over a sizeable Access/VBA project, and we've been integrating a third party dll based tool. Sometimes, when creating the objects to use the tool, something goes wrong. This is intermittent, and apparently impossible to consistently re-produce. Unfortunately, I've only found...

OnCurrent did it... OnFocus on the tabs means that it tries to update with the currently selected record (i.e. the item on the previous tab). Thanks guys... I shall now see if I can work out how to mark Solved!

For some reason that give an "invalid use of me" error (I know how it feels!). I've just been more explicit with it, and it works: Public Function Select_Doc() Forms!Main!Doc_No_Box = Forms!Main!NavigationSubform!Doc_Number.Value End Function

OK, I think I follow. So just to (hopefully!) reword what you're saying, I need to write a bit of VBA so that OnClick I send the text from the selected field and write it into a text box. (As an aside, I specified the tab names in case the solution involved querying which tab was selected to...

So, I have the current setup: Main form: Main Tabbed control: NavigationSubform Tabs: Reports, Calculations, Drawings, Datasheets Each tab holds a subform with the name Tab_<tab name> The subforms are all in datasheet view. I would like to have a control box on the main form which, when you...

*Pokes head through door* Hi... I was pointed in this direction by a member who's also on another forum I frequent... I'm still fairly new to Access, with middling VBA skills, trying to do advanced things. I'm sure it'll all go swimmingly. I'm also sure I'll be starting my share of "help me!"...