Search results

Hi all, Can anyone explain to me how the Input Mask's work (field property within a table)? I'm trying to setup a table with Fields for a Username(txtUser) and Password (txtPwd), the latter of which I've setup with 'password' in it's Input Mask property. So all I see is a string of asterisks...

Well I may never know why exactly it was doing this (some deep imbedded bug born of niche circumstance perhaps) but I deleted the linked table from the fe and connected to it like new, and somehow, that solved the display issue with my combo box :ROFLMAO: Utterly bizarre. Thanks for all the...

Bound Column is 1

Hi All, I'm hoping someone can help me to understand some odd behaviour I've observed (Access 2010). I wanted a combo box with options: Basic, Intermediate, and Full, but I want to return 1,2 and 3 to the control source. Should be easy, I set these properties: Control Source: {Blank} Row...

Thanks arnelgp I went with your method in the end. Was trying to avoid it as it required me to lift a complicated query from the combo box and put it into the source for the form (evidently, 'animals' was a simplification) but with some fiddling it works no problem and no noticeable affect on...

Hi All, This is probably simpler than I realise but hard to explain (please bear with me). I have some code setup which sorts records of a continuous form alphabetically. The user clicks on a header label and it adds to the OrderBy property. See code below, it works fine, with one exception...

Thanks for the reply Arnelgp, I'm not entirely sure what you mean tbh as far as I'm aware there's no ASCII for shift. However you put me on the right train of thought and I've substituted the code for SendKeys "+[tab]". It may be less efficient in terms of processing power (I'm guessing) but...

Hello all, I'm having an issue with some code designed to navigate a continuous form - it's your typical arrow key navvi, up goes up a record, right key tabs across, etc. All was working fine, when, inexplicably, the keycode for left stopped working. Here's the code: If KeyCode = 37 Then...

Thanks for the replies all, I considered adding more controls inside Access but figured it should be doable within Outlook, and turns out it is! How did I not know about this!? :whistle: Note to future self: I did observe this method only deletes the oldest email with the specified subtitle...

VBA Scripted Outlook Email with sent/cancelled checker, how do I stop Users Saving as a draft? Hi all, been a while since i logged in! I have some code that writes an email in Outlook, and returns true or false depending on whether the user sent the email (or clicked cancel). This is working...

In case anyone else is struggling and happens upon this thread, here's what solved my problem... All the advice and code I've found online (including that helpfully provided by the above) online only applies to Word's LEGACY controls. It would seem that at some point in the last however-many...

Awesome thanks a bunch, I would have never figured that out alone. This should be enough to get me going now, wish me luck! :)

Sorry, I meant how do you check the name of the control in Word?

Ah ok... then this will be a really dumb question... how do I know what the controls are called? Thanks again for your help :D

Thanks Ridders this is just the sort of help I need. I've added a checkbox and tested the code, it's getting stuck at this line: oApp.ActiveDocument.FormFields("MyWordCheckBox").CheckBox.Value Returning the same error (5941, The Requested Member of the collection does not exist) Do you know...

Hi All, I am trying to create a form for users in MS Word (although any commonly accessible software would be fine) with the plan to import the data into my Access database. However I am not sure how to setup the Word Document or identify the correct controls from which to extract the data...

Thanks Static this is just what I needed, I didn't realise you could flip Select Case and use True on the top like that. This is actually the other reason why I wanted to use a select query in the first place. I wasn't going to bore people with the convoluted reasoning, but basically...

Ok yes I see why that part was dumb, so assuming I change the code to something like: With Me!Forms select case blah blah blah end select end with How would I go about testing the control source of the individual subforms? Thanks :)

Hi All, Sorry if this is a dumb question, is it possible to use a select case statement in conjunction with a with statement? Specifically I am trying to test if the control sources of different subforms are null. I could do this easily with nested Ifs, but would prefer to use select...

Hiya, I've tweaked the code above to show where you need to change names for your database. It might be easier if you could attach a stripped back version of your database. Nothing sensitive just the basics so I can see exactly what we're dealing with :) Command0 is your button - but...