Search results

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...

I did not mean to post the first thread. It posted before I was even finished typing. I deleted it. Sorry for that. OK I will check out "FollowHyperlink" first and see what happens. Thanks.

I am sure this should be fairly easy, but I have never done it so I am not sure what the best way is. I have a column in my DB called [INVOICEID] I have a folder on my computer located at "C:/INVOICES/" this folder is full of tiff files named the invoice number. In my database when I am...

That last code worked PERFECT! Thank you very much.

I can easily make a sample. However I have to pick up my dogs in 10 minutes. I can build a sample tonight and upload first thing in the morning when I return.

OK, just tried it. I named this query Z for test reasons. Created a new query ZZ with only the KITS2 column. Executed, everything looks great, right click one column and chose filter. Same error. "Data type mismatch in criteria expression"