Search results

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

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

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

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!

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