Search results

Got It I found this and it works like a charm Private Function set_my_link() Me![PDFButton].HyperlinkAddress = "S:\Ops\English - Home Savings\Credit Bureau\credit bureau\" & Me.AcctNumber & ".pdf" End Function Private Sub PDFButton_Click() Me![PDFButton].HyperlinkAddress = "S:\Ops\English -...

I am trying to open a PDF from an access form. That part is easy, the hard part is that the name of the pdf is the value of a field in the form. And it needs to automatically assign that value to the name of the file I am trying to open.. I have Private Sub Command52_Click() On Error GoTo...

That was the first thing I tried, and to no avail! Thanks for the suggestion though!

The form works fine, but when I try to open it in datasheet view it it says "Microsoft Access has encountered a problem and needs to close" and then I have to click close, at which point it closes the entire database. This is the only form it is doing that on. And the error message is...

I have a query that will pull records, and append them to the table. The only problem is that not only will it pull all the "new" records, but also all the "old" records. I just want to append the records that are not already in the table. Any ideas? I have tried using the primary key, but...

I should be getting 3 results. The results should be shown if the Field 'Is Null'. If the field has something in it, I dont want to see those Accounts on my query.

I would think it should be a numeric field! That is why I originally started the criteria to be Is Null, and not based on <1. No results if the query is left to be based on the fields being null. If I change it to the fields being based on <1, I get the desired results, even though it is a...

Nothing should have changed, this is a VERY static database, extremely locked down, information is pulled from linked SQL tables, access forms are basically just a front end for us. But that makes sense, just strange that out of 206000 records, only those 3 in that particular load wont pull in...

I have a query, and it has been working just fine, till today. I have it based on a field being null. This field shows null in the table, it is a text field but it is a 19 digit number if there is anything in there. The fields didnt come up in the query when it was based on Is Null. But if I...

I have 2 fields, Accounts, Accounts CMO. I need those two fields to show in the same table in a new field called Total Accounts. I am summing them, but getting irregular results, some are right, and some are 4 times more than they should be? How would you go about doing this, maybe I am...

Thanks!! Thanks Alot!!!!!! And here I was going to code in keystrokes...

Is there any way I can get the prompts from queries my macro is calling turned off. I have an append, 3 updates and a delete. It is ultimately pulling a report, I dont want the users to have to click through prompts to get the report to come up. Any ideas?

I am pulling some information, and I am needing a report to show the value "score" if the field is numeric, but if it is not numeric, retain it's original value. for instance if the field is 1234 it needs to show on the report as "score" but if it is MSP it needs to say MSP. Any help would be...

I have a form that displays records, But I want it to only pull records that are in the table as of now, any new records will be flagged by default as "false". So basically, I just want the fields marked as "True" on the RECEIVED field to be pulled in to the form. Have everything lined out...

nevermind, I read WAY to much into that D'oh!! I got it!! THANKS ALOT!

I got that, but dont know how to set it to autoexec. Which is why it isnt working I huh *haha*. So how do I set it to autoexec?? THANKS!!!

Is there a place I can insert a snippet of code to have all the forms come up full screen. Some users think it is annoying that they dont always come up maximized. Any help would be greatly appreciated!

thanks, that got me in the right direction. I got it eventually, the problem was that the values on the form were coming from different tables in the database. That was the tricky part. Thanks Again!!

This isnt exactly what it sounds like. I know I can control the input mask, and set it = to another field in a form, but the problem with that is then if you type over that field, it changes the other field in the form as well. I am wanting the 2 fields to be independant of each other, but IF...