Reverse Engineering!!!
Sep 21, 2005
Hi
Im working on an Access Database at work. It records the training undertaken by NHS clinical, managerial and admin staff in Brighton. It is used also to generate invoices etc.
I have a better knowledge of access than anyone else here (outside of IT department obviously) so I have been asked to get rid of some glitches and add some functions.
A big hurdle I have found is this:
I can very easily for example, add a command button to open a form, run a query etc, using the wizard.
However I am trying to ascertain what some particular command buttons actually DO. Am I right in thinking there is no way of "reverse engineering" using the Wizard or similar? Because the only thing I can find is Properties > Event > Onclick [eventprocedure] and if you click on build you just get visual basic which I sadly dont understand.
Im not sure if ive made any sense at all. In essence, im saying that making stuff seems easy, but working backwards and dissecting it seems to only result in VB code.
Is there a way around this?
Gazz
View Replies
Mar 22, 2006
Hi everyone,
I have learnt so much here and I could do with some advise from all of you.
Recently I have developed a software using MS Access and I am in the process of getting Copyrights, Trademark rights for my software.
The software is to be distributed via the internet for personal use. However, I have been having serious concerns about people trying to reverse engineer the code and selling it under another name.
The last thing I would want is someone else making money off pawning this. Not only does it bring bad credibility but can really dent the business end for me.
Can anyone please suggest any way that I can block anybody from reverse engineering the code.
Also how can I make my program user specific and tamper proof??
Thanks and appreciate your help.
View 6 Replies
View Related
Oct 14, 2005
I have a one-to-many-relationship set up. Now I need to jam each related many into one field in a new table to make it like a list. Is there an easy way to do this?
View 4 Replies
View Related
Jul 15, 2006
Is there a way to reformat so that the line that is the next line to be entered is at the top instead of the bottom >> I hope that is clear
Also when i use the scroll bar at the bottom at the very end to the right it show grey in the background is there a way to limit it so only what is used is showing
Thx STeve
View 5 Replies
View Related
Sep 14, 2005
I split a database and created a backend but now I dont need it and I accidentally deleted the backend while I was updating the file folder and it was on the network so it's gone for good.
Is there a way to reverse splitting a database so it no longer requires the back end?
View 1 Replies
View Related
Nov 8, 2005
i have a lists of emails+domain names eg camae@yahoo.com. im trying to sort them in reverse order but "reverse" seems not working in access. anyone knows how to do them or i was thinking of sorting the list begin with the domain names (which is after the '@') but i dont know how. ive tried using "like "*@[a-d]" but the result displayed is not sorted in alphabetic order. sorry im a beginner. thanks in advance
View 8 Replies
View Related
Feb 8, 2006
Hi.
I've downloaded Stephen Leban's nifty calendar and have it working beautifully to enter in dates and ranges of dates to a fishing schedule table (this is a fishing regulations database). (thanks to RuralGuy for posting the link to this, and other calendars, on another thread)
I have a form for entering some parameters to narrow the results of a select query that shows the start and end dates for individual blocks of consecutive time for each scheduled fishery. (Some fisheries might be scheduled to occur every thursday and friday for a couple of months, or other hard-to-predict ranges of time.)
What I would like to do next is to click a button on the form to make the calendar appear with all the dates where fishing is scheduled to occur (from the query results) be highlighted, or circled (or something equivalent).
My vba 'skills' are not up to tinkering with his class module without some serious assistance. Has anyone tried something similar to this with his calendar? Is it even possible?
I have seen other calendars that do something similar (though I'm still in over my head trying to figure out the modules) but I'd really like to keep with Stephen Leban's calendar since it allows much more felxibility in displaying over various time intervals.
I would greatly appreciate any assistance. Thanks.
View 1 Replies
View Related
Jun 9, 2006
I have two tables A and B. There is a 1 to many relationship between A and B. Table A's data is controlled by FormA, Table B's data is controlled by FormB which is a subform on FormA. I already have a combo box for navigation on FormA, however I would also like to be able to have a combo box on FormB (FormA's subform) for navigation, so that when I choose an record from the subforms (FormB) combo box, FormA then jumps to the 1 record from FormA that contains the related record choosen in the SubFormB's combo box (along with the subforms choosen record on the subform) .
Kindalike the combo box on FormA, except it's a 'reverse lookup' if that makes sense. Is this at all possible, does this even make sense? :confused:
_______________
HOLY CRAP BATMAN!!!
View 2 Replies
View Related
Aug 21, 2014
I have a table with data that is imported from another application. The employee name is showing up as LName, FName. What function can I use to make these FName LName with no comma? I know I may have to do a two step to separate the two then concatanate but not sure how to do it.
UTA: I figured out LName: Trim(Left([ApprovedByFullName],InStr([ApprovedByFullName],",")-1)) to pull the last name minus the comma. How do I pull the first name?
View 7 Replies
View Related
Aug 3, 2015
I'm using I have a secondary control being populated by an entry from another control. I was able to find the code I needed to do this using a combo box here in this forum.
me.txtDependent=me.cboPrimary.column(#)
(specifics changed to protect my company's paranoid view of privacy)
the code itself was showing up in the secondary control instead of any value. I found though that moving the code from the On Change event for the primary control to the On Current event for the form itself everything is working beautifully.
However, I have a different task now that I need to be able to accomplish with the same two tables but in the opposite direction. I suspect that I'm going to need to create a second set of controls and maybe even a second relationship or table to do this. To use a set of specifics that I think will get this point across, if I had a master table which includes a field for "City" and a secondary table, CityState, which contains both "City" and "State", and two controls, a combo box cboCityState to look up the specific City and a text box, txtState to display the State, putting the following code in the City combo box's On Change event populates a text box with the State when the specific City is selected, or putting it in the form's On Current event will be sure that State shows up in all the copies of a form when the form is used in a search and the City is not changed :
me.txtState=me.cboCityState.column(2)
What I need to do now is to set up a control which allows me to type in the State and have the results show all records that include that State.
I'm using this in a Filter by Form environment. I know the objections to this method and the benefits to creating a dedicated search form, but this method appears to be working well in all other ways for us for now. I have several situations within this form where I have one control showing up at the initial load of the form and at the beginning of the filtering process, allowing selection of multiple values from a long list of values in a list box, for instance, (using the On Filter event) and other controls showing up as a result of the filtering process, to display the selected criteria only, for instance (using the On Apply Filter event), so I'm aware of how to make this work if that's required. I'm thinking I may need to create a second control, something like txtStateInput, to accept the State search criteria and another, something like txtCityResults, to show the cities that are part of the resultant records.
View 5 Replies
View Related
Jun 13, 2013
One of my clients has asked me to look at building a way to check if the email addresses they are capturing in my CRM are valid. He want's to go beyond checking for no "@" etc.
From what I've seen, it looks like a reverse DNS check (might be totally wrong) is the way to go. IE: check if the email is valid. I've see a few tools online that can do it one by one (which I could parse to if I had to) - but ideally I'd like to be able to run this from a VBA script.
View 9 Replies
View Related
