Search results

Thanks CJ! I will work on that. Seems this file is building up a lot of issues against me lately. Now I have just noticed another combobox is behaving oddly: if disable it and enables it becomes locked and won’t work unless I remove it’a events and recode again.... I will let you know once I...

Any idea on how to fix that?

Guys, I have a combobox that is locked and disabled along with the rest of the controls but I click on it and even open the drop-down list whilst I won´t be able to select anything inside it. The controls are disabled and locked from their property sheet, not in any event from the form, but...

AccessBlaster What is a complied code? How can I check it? I fixed the Options on that form, thanks!

I guess it returns a LONG... that´s is big! I decided to go back to the book I am using to make the fSubNavigation and I realized I made a terrible mistake on the Form_Current event. So I can remove the large part of that code from my main form_current event and move it to the fSubNavigation...

How many events do you think would be reasonable? Maybe I can spread that code trhoughout other things like constraints at table-level and conditional formatting?

Not sure what you mean by messy, but since it is my first project I am sure it would not be perfect. I see what you mean by "jumping here and there and back again", I am still trying to figure out where I should place the code inside the events, it is a long lerning curve... :D Any insight is...

Hi, Colin. I had no issues when opening it here and from another computer in my company. But I will run more tests on it and review. Thanks!

This solution of yours is very similar to the "Access 2002 Desktop Developer´s Handbook" by Litwin, Getz and Gunderloy... ;) In fact I decided to use their fSubNavigation form that can be used throughout the forms and takes less time to adapt. Once I finish this project I will post the code...

That´s is weird... before adding the cmdSave button those nav buttons were working perfectly fine. But the fix suggested worked and I will just add the boundaries to avoid the error raised when reached first/last record. Thanks!

Access Heavyweights, I was building the buttons, controls and events one by one in a form and all was good. When I came to the the last button (cmdSave) the form start returning the "Error 2105: You Can´t Go to the Specified Record" on a the navigation buttons:Next, Previous, First and Last...

I forgot to post the code after I finished the validation after turning the cboUser to txtUsername!:o During some texts I noticed my previous post had a MAJOR FLAW as it was not returning the username correctly BUT the first username saved on the table, so I had to change it, removing the...

After going through some studies on the events at form and control level I have tested this approach and it is working fine. The god thing is that I can allow the user to add the DUPE if he decides to do so and it will carry a txtDupe to that form everytime the user navigate trhough it. This...

That´s a good idea, I will modify my validation to flag it to the operator and then I will offer an exit to prevent it. Thanks for the explanation! :)

Thanks jdraw! To be more clear I have an example, let´s say I have already registered this - I will use code formatting just for visual cue. ID = 1084, FName = Diogo, MName = Cuba, LName = Moraes, Company = 1, Position = 104. Then I will go to another person´s record: ID = 1193, FName =...

Hey, guys. :) I have a question that is not exactly equal to thousands of threads on the forum - which I have already asked before! - on how to prevent duplicates while ADDING new records to a table/query via form. I have a form that EDITS the employee information, for instance, and if a...

Excuse me, CJ_London, but I am not sure why I feel a little sarcasm coming from you here... Pardon me if I am wrong. We are talking about a real business case that is in place for years and they are trying to have a small app in Access to handle that. They don´t require it to be fancy or...

Glad I could help, Colin! :)

I guess that´s would raise an error on my entire project: "Error 6: OVERFLOW". I totally agree with you and I had the pleasure of working in a major energy company in the global market and it was exactly like you described: took time and efforts to get there. Despite of being out of the scope...

Welcome! Enviado do meu iPad usando Tapatalk