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, 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"

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

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

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

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

Hi, I want to be able to program some sort of security for a database I have created. There is allready code in the database that detects the domain username, so I was thinking of creating a table that holds info on each user and what forms they can access and certain options that they can do...

Hi All, Trying to open another form from a list box and have it carry the value over to select the correct record. But i keep getting 'The operform action was cancelled' error. My Code: Option Compare Database Private Sub lstAR_DblClick(Cancel As Integer) DoCmd.OpenForm "frmMaint"...

Hi All, Having a little problem with my combo box setup. I have 3 combo boxes, 1st is division, 2nd is branch, 3rd is department. They all refer to a table which has 4 fields... they are the 3 I just mentioned and a 4th which is the department code. The 3rd combo box contains the last to...

Hi All, I have a form that will sometime contain no records for different users and I want a mesage to appear when there are no records waiting for them. I have code in place to close the form when they run out of records to approve, so I copied that code thinking it would work on the form...

Is it possible to save data to a field which isn't on the form Say i have an inputbox and want to data to be stored in a field that isn't present on the form but the table the field is on is part of the control source. At the moment I just have the field on the form but hidden, this is not...

Hi All, I have a form where a user reviews a request or declines it, they have a approve and decline button to choose from. The results that are shown to them are from a query which breaks it up into requests that come under there control. What I want is for when they click approve or decline...

Hi All, I'm just wondering weather the 'Switchboard' is a feature in access 2k? I'm making a db that will be running on runtime 2k and I'm using 2003 for the development (2000 file format) and want to know if I can use the switchboard feature still. Cheers, Ryan

Hi All, I have a form where users fill out information and then press a submit button when completed, my problem is that the form is saving the data as it goes so when someone stops filing in a form halfway through the half filled form is saving in the database and its making it a mess. so my...

Hi, I have a data access page, aswell as a form where I want users to be able to put in a reference number into a field (this field is the primary key) and for it to either when a button is clicked or 'afterupdate' to load that record and have all the below fields bring up there information...

Hi all, Looking for some help with some code. I have a data access page where users input details of a purchase request form they have filled out and then I want them to be able to attach the scanned version of the form. I allready have a field where they can input the location of the file...

Hey All, Just started toying with these today, but a little stuck. It seems to use script editor instead of normal visual basic & i'm having trouble understanding what it is and how I should go about coding it. I have all the fields and everything set and thats sweet. I got rid of all the...

Hi all, On my form when you fill in the fields and close the form down it saves the record, should this be? This will create problems for my database as user's will only half fill in information, how can I make it so that the data is only saved to the table when a button is pressed? Thanks...

Hi all, I'm new here and currently creating a database. In one of my forms I want for users to be able to attach a file to the database, well save there local file to a network drive. So I want there to be a field with the path, a browse button to select the location and a attach button, also...