Recent content by travismp

I have a simple data entry form with 2 fields, one is bound to a backend table and the other is an ubound box. I want to save anything typed into the unbound box into a field called [Company] in the backend table. Also I do not want the unbound box to clear itself out each time a new record is...

Great. I will give it a go. Thanks.

Are there any really good Access Database Data Integrity Tools available? I do not mind paying for one. I have a couple DBs that I would like to run a tool against and see if there are any issues with: ~Data in the tables ~Possible Query, Form, Report, Macros, ect. ~VBA Code Something check...

Great Thank you Bill. I will spend the evening doing BOTH and trying to get each one to work. It will be a good learning tool. Thank you again, I may have questions but I will see how far I can get with the info you have provided. THANK YOU SIR!

OK, so option 2 could be down with information in a drop down field too?

tbl_COMPANY (lists all of my company information per client) [CompanyName] is the name of the field which lists the company name. [Active] is a Yes/No field which will be checked if a company is currently active. qry_COMPANY_ALL will show all companies and if they are active...

I need help writting a math based query. Here is my data in the table: COMPANY PAID COLOR ALCO -1 BLUE ALCO 0 RED ALCO -1 BLUE ALCO 0 BLUE ALCO -1 BLUE ALCO 0 RED ALCO -1 RED ALCO 0 BLUE KMART -1 GREEN KMART -1 BLUE KMART -1 RED KMART -1 RED KMART -1 GREEN KMART -1 BLUE KMART -1 RED KMART -1...

I did try that and it gave me an error. Is my syntax incorrect.

I need a quick fix help. I need help with a format issue at the query level. I have data that looks like this in a column Red - Policy Blue - Paperwork Red - Forms Green - Prototype Yellow - Files ect. I need to show everything AFTER the " - " so everything after the space hyphen space needs...

That did it. THANK YOU SIR.

A quick follow up. I need to change this just a little bit. Here is my exact script so far that launches on "On Got Focus" of my field inside the form I need to add something to check to make sure there is even data listed before it tries to go to the end. Right now if I pull up a company...

that did it. Thank you so much my friend. You are the man.

I have a memo field that holds a lot of data for almost every client. When I open my main form the first field that is active is my memo field however it highlights all of the current data. I would rather it go to the end of the memo field on SetFocus. So can I write some VB or change some...

thank you Bob. I was able to use what you gave me at the query level to make this work. THANKS again, I have my report working perfectly! Your help is always a big help. keep up the good work! T~

If Me!Color = "RED" And Me!State= "NY" Then Me!Color = "STOP" End If This is on a report, on format. I am trying to update a field based of off information from 2 different fields. This of course breaks. The top code is correct, but I am not sure how to update the field while the report...