Recent content by RyanB

Hi, My database has a option for attaching files to it which contain information about the specific record. The information about the files is stored in a table called 'tblFiles', the filenames that are used make reference the primary key from the main table where data is stored 'tblAR'. For...

Hi Wayne, I've looked through his example and can't find a way to print a document. I will keep trying, but if anyone has done this before please let me know. Thanks, Ryan

Worked like a charm. thanks

Hi, I've searched for this but can't find how to do it, When I open this form I want it to display the last record in its control source, This is probably a simple one but I just can't seem to make it happen... Thanks Ryan P.S. This is what i Have so far... DoCmd.OpenForm "frmAbout"

GRRR *pulls hair out* Ok, when I apply the same code structure to another form it doesn't work for me, it gives me the error that 'The OpenForm Action was cancelled'. here is my code: Private Sub butapprove_Click() On Error GoTo Err_butapprove_Click arnum = ARNo.Value stARfind =...

OMG that works, i am forever in your debt

Still problems Thanks, Still having problems when i try open a specific record with a button tho, my code is below: Secuser = ("[username]=" & fOSUserName()) DoCmd.OpenForm frmSecSettings, , , Secuser The error is 'the action or method requires a form name argument... Driving me up the...

Hi, I'm using the SHCOPY code for moving files into my database, only problem is I only want .PDF files to be displayed, i've searched google and all and can't find any reference on how to do it. Anyone know? Cheers, Code: Option Compare Database Option Explicit ' Shcopy sample from...

Never mind, I worked it out. for anyone interested here is the solution... Private Sub butAttach_Click() If IsNull(Me![ARNo]) Then MsgBox "Please enter an AR Number before adding a PDF document to the database", vbOKOnly, "Add A PDF Document" Exit Sub Else: arnum = ARNo.Value...

Hi all, Having this problem on a form when a button is clicked to launch another form and my code makes sure that the one of the fields on the form isn't empty/Null, I keep getting the error 'Invaild use of Null', but Access just doesn't seem to read it as a null in my code. See Below Private...

Hi, I have now changed it so the data on form 2 has its own table so basically all i need to do is take a refernence from form1 (the primary key from table 1) and use that reference to load a record on form2 the reference from form1 is also the primary key in table 2. sorry if this doesn't...

Thanks for the reply. Your assumptions are correct except that form2 does write to table 1 Ryan

Hi, I have a form(frmentry) where a user creates a record and it has a primary key that is entered manually the primary field is called "AR_Number". The user enters the details in this form and then click a button called "butapprove" and it launches another form called 'frmentryapproval'. When...

Hi, I can get the data when its in the form. The problem is getting the form to load the right record when its opened. I think this is probably a really basic question that I should know. So i'm gonna be kicking myself but for the life of me I can't work out how to do it. Basically i'm asking...

Sorry if this has been asked before but I have searched and couldn't find an answer I have a string that is set on startup (username) and have another form(hidden) that loads on startup this form contains information on what forms and options the user can access. Just having a little trouble...