Search results

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

Thanks for your help Pat, good to see there are still some helpful ppl on this forum... I didn't know it was such a crime to not know the keywords to use for a search...

Sounds like just what I need. Thanks heaps! I'll start making up the table up now and see where I hit a brick wall. I'm pretty new to DLookup, so do you know of a document, website that can give me a crash course in the Dlookup function. Cheers, Ryan

HI Wayne, Thanks for the reply. But i'm not looking at using passwords as this database will be housed within our citrix enviroment so the user will already have logged in. I was thinking a field for each form with a yes/no to define access and maybe a field for each option that i want to...

No need to be rude mate, I searched and didn't find anything... Instead of being so rude why not post a link to one of the topics seeing as you know more than I do....

Hi, Someone told me that it would be wise to seperate my front end of my database (forms, etc) from the backend. before i get too far and it becomes hard to split just wondering how I can achieve this?? Thanks Ryan