Recent content by jlm722

Mr. Alan, thanks for responding, I have read that post and it's all Greek to me. It makes no sense. They are all over the place with code. :(

Hello friends, I have searched and searched and can't seem to find a simple answer for my question. I have a form in which i want to place a command button that will simply print a pdf stored on my computer. I want it to simply print it without leaving acrobat reader open etc. I don't want to...

I don't know why this has to be so difficult. If you read my original post, it explains i already have a table with both fields. Please please please consider what i'm asking. I need to be able to add data into field 1 (account number) and field 2 (account name). My combo box ONLY needs to have...

sorry, you have to pardon my explanations sometimes. My table has two fields. one is for an account number, the other is for the name associated with the account number. This is an application I am using to cash customers payroll checks. There is a field on my form to enter the payor of a check...

The code I'm using works fine to add a new number to my list. The problem is, I need to add to two fields with one "not in list" event.

vbaInet, You folks are wonderful, and I know JUST enough about vba and access to be dangerous :o) But I am completely confused. What exactly is the response you just sent? combo187.value = newValue_Variable? what does that do? I think maybe I haven't explained what exactly I'm trying to...

Private Sub Combo187_NotInList(NewData As String, Response As Integer) On Error GoTo Combo187_NotInList_Err Dim intAnswer As Integer Dim strSQL As String intAnswer = MsgBox("The Account Number " & Chr(34) & NewData & _ Chr(34) & " is not currently listed." & vbCrLf & _...

? huh? ya lost me. never heard of code tags.

Private Sub Combo187_NotInList(NewData As String, Response As Integer) On Error GoTo Combo187_NotInList_Err Dim intAnswer As Integer Dim strSQL As String intAnswer = MsgBox("The Account Number " & Chr(34) & NewData & _ Chr(34) & " is not currently listed." & vbCrLf & _...

actually, the only thing it is currently doing, is letting me add a number. The problem is, I don't know how to add to two different fields. And by the way, I'm using Access 2000, but i'll post the code if you want it, hold a sec

Hey there forum friends, I have a dilemma. I have a table (let’s call it tblAcctNum). It has two fields, AcctNumber and AcctName. On one of my forms, I have a combo box that looks up numbers in the “AcctNumber” field. The main reason for this is many of the “AcctNumber”s are used quite...

No one has replied with a solution to this. I think, sometimes I explain my problems incorrectly. I simply want to be able to store a pdf file and have an access report print it. Instead of creating a report that places the info in the correct place and having the user insert a blank form...

No problem with the copyright, they're accepting what I'm doing now with the horrible resolution, but occasionally are kicking them back due to the quality of the print. It's a public form, ditributed for free, and trust me, they'd rather us print them and save their paper! :0) I need to store...

:confused: The state I live in, Tennessee, has a pdf of a "noting of lein" for a vehicle. The pdf is not fillable. Currently, I printed the pdf, scanned it, and saved it as an image on a report, so my db would place the necessary info on the image, so it appears that it's been typed in. However...

well, i'm sorry, i need to explain farther. The problem I'm having is, I made a database to use as a master db that will access 4 other databases. at the currect time, there is 4 individual shortcuts on my desktop to open each db. I am creating 1 db that can be opened, with a form that has 4...