Search results for query: *

They took something reasonably simple and contorted it. Why would you not show all macro actions from the start. I am not a programmer, therefore maybe that it is why I cannot think of one legitimate reason not to show all macro actions, just a select few.

In previous versions, in a macro, there was a command of SetValue, argument "". I used that to clear password boxes on ONLOSTFOCUS or when using a command button to validate I tried the SETPROPERTY in Access 2007. Couldn't get it to work Any ideas

Thanks very much, I won't be able to try this for a couple days, but thanks again.

Here is the reference point: Forms![frmMainMenu]![List8] I wish to put in a condition in a macro to reference Column 7 in List8 Forms![frmMainMenu]![List8] (column7)="None" Any suggestions, it is easiest for me to macros as i do not know how to write code Thanks in advance

I tried the OnFormat and that did not work, I am at a loss. In case anyone has some time here are the exact field names, report name, etc Expr1 (this is the field in the macro that returns "True" or "False" depending on whether a check box has been checked or not oleSignature - this is the...

I am using Access 2007. To make a long story short, I have developed a database for my father, a mechanical engineer, and have duplicated a CERTIFICATION FORM for pressure vessels he inspects. I developed this with the intention of allowing other inspectors to get a copy and use it themselves...

Thank you very much!!!!!!!!!!!!!!!!!!!!!!! I work for government, more specifically, local law enforcement, and I am actually just a regular officer, who has a knack for picking up database design, especially with the help from people on this list. You know what they say, law enforcement is...

Response to last post. They are not upset I kick them out, We are approximately 20 years behind the times, and are getting automated now. Some of the databases in less than 3 years use have saved 125 (8)hr working days, they understand being kicked off. It was a necessity to do it this way...

Is it possible to use markup language like in this tek-tip board in the database? Quick example I have a list box with all active employees, I have done a concatenation with the employee's last name first, first name, and middle initial (the Employee Number is hidden in the first column) and...

THANK YOU!!!!!!!!!!!!!!! This is not the best way of doing it, but it works. I have a db password protected with one table and one field, that field has a drop down list, "Operational, Under Construction" All other databases are linked to this one. When I change the field to UNDER...

I meant to say Code that will make the STARTUP options window appear. I saw it and played with it on Friday, and cannot find it again If I remember, it was only two lines, I copied that code, put it into a command button, and voila, it came up, or if it was a macro, I cannot remember

Can someone give me code to make the StartupWindow Appear when a command button is pressed, that is what I need

I have seen a website (unknown this one or another) just 3 days ago where the poster had a simple 2 line code that disabled the shift key on startup (I have already done that through code) and then had code to view database window (got that one also), but I cannot find this same website to...

I was finally able to make this work using the AfterUpdate and then referencing the columns in the combo box, but I did it through code, and did not set the control source equal to the combobox.column(#)

not just viewed. I have been trying to read the faqs and searched posts, but I could not find anything that matched my scenario, and user level correctly QUICK BACKGROUND Employee table employee ID (primary key) name etc Overtime table otentryID(primary key) employeeID...

I read through the entire FAQ on tables and other, and I could not find anything like this, so I am sorry if this duplicates a previously written question I have a database that is controlled through a log-on screen I created, everyone has a unique User ID and password. On verification of...

I know : =[forms]![frmName]![fieldname] - active form =[sfrmName].[Form]![fieldame] - subform what is the correct criteria for a subform on a subform on a form? also, I need it to be a like statement as well, similar to an active form version of Like [forms]![frmName]![fieldname]&"*" Thanks...

I would like to thank everyone who responded to this post the below ended up working after all. Between Nz([Forms]![frmSearchMenu]![txtBeginAge],0) And Nz([Forms]![frmSearchMenu]![txtEndAge],999) I ended up having to change the criteria little to get it to finally work, I did have : Like...

I replaced it with that code and it doesn't return any values, I found a mistake I made in the code, but when I changed it I still don't get anything back, I also changed (([tblContact-SuspectRecord].strFirstName) Like "*" & [forms]![frmSearchMenu]![txtLast] & "*") to...

PH, not knowing much about code, where do I put that code you wrote just before opening the query, I built the query in design view and simply added the other like statementsin the criteria fields of design view Thanks