Search results

I'm trying to create cascading combo boxes but can't get it to work correctly. I've followed the video by Richard Rost where the second combo box only lists the cities based on the state selected in the first combo box. It fails to filter the second combo box list but works in his demo. I...

I'm not ignoring it, some of it I've already tried or have thought about but they don't work for me. I'm in other forums or FB groups for some of my other interests and on some it's me that help out with (hopefully the best) advice the most as I have had a lot of training & experience in that...

You're not bothering me, I welcome all suggestions. :)

TBH turning allow edits on and off every time would be a pain, stopping the navigation buttons taking me to a new record at EOF and making exiting the last field in the tab order taking me back to the first field is a better solution for me. I have maximised the screen area for the main form...

Anyone who uses it would need to add or edit records.

I don't know exactly why the blank entries occurred but I had moved beyond the last valid entry accidentally, perhaps I exited from the form the wrong way. All I know is that, if for example I had records 1 to 10 entered correctly, moved to the new record by mistake and exited it without adding...

It's the main data entry and view form. It would mean duplicating the form exactly and use one to view and one to edit and/or enter records. I didn't what that although it's an option to consider in the future.

Pat Hartman. I have been building this database for a while now and where data must be entered in a valid format I have used the built in Access rules to do that, input masks etc. For the majority of fields the data can be just about anything so no validation is needed for it. It's up and...

I'm just getting used to writing code in modules, not looked in to class modules yet. I'm starting to figure out some of the code but the syntax is way beyond me at the moment. I can do limited stuff but at first I couldn't get even the simplest one line command to work as I had no idea where...

My next question is, in my database I've taken various steps to prevent accidentally adding a new record. Up to now if I did I added the record giving the 1st field the description of blank and then edited later when a new record was entered. This is because it's better for me to maintain...

As I said the function Arnelgp worked perfectly with the correct function call provided by Bob Fitz. Having just spent the last few hours writing & re-writing all the 'On Click' events and tidying up the work adding comments & indents in both the modules etc. everything is working as it should...

No problem The_Doc_Man, I used yellow as that was the highlight colour used by Access Debug and I was trying to stick with their method. I normally use red so next time ..........................

Bob Fitz That worked perfect. The function was spot on (I had already changed the end sub with end function) as soon as it was invoked correctly. I am trying to find out what the ME stands for/does. Can you explain (simply lol)? I am learning slowly hence why I am now playing with MODULES...

Everything I tried failed. I must be doing it all wrong.

Thanks for your reply Arnelgp I've tried that code but can't test it as I'm just a beginner and not sure what you mean by a form parameter, exactly where to put the function or how to call it from an 'OnClick' event assigned to a button. could you explain to me how to do those things.

Hi, I'm using code to go to the next record and warn that i'm on the last record so it doesn't proceed to a new record. The code I'm using works if I put it in the 'OnClick' event but if I try to use the same code in a module it fails. The code is. Private Sub Next_Click() With Recordset...

I found it difficult to explain the problem & solution in post 21. Not actually flitting from one thing to another. I have spend days trying (and failing) to do the things I've asked about. Joining this forum was a last resort before giving up and doing without some of the functionality I wanted.

All the info said it needed so many settings changed to hide things but none were secure in 2007.

You probably know it already https://accessworld-accessworld.netdna-ssl.com/forums/images/smilies/smile.gif but what I was trying to do was display 2 of more fields (using a 'lookup box' from a relational table on the same form as all the data from the main table. It would only pick one field. I...

Thanks Isladogs. That looks good but for now I wouldn't be able to use it, I need all the data from only one record on the screen and would move to the next record as required although things may evolve as the database grows. I have 48 records in at the moment and each time I add more I come...