Search results

Hi all, I have the following code: - Private Sub Command58_Click() ' COMMENT If the "completion_date" is null open form "frmCompletion_date' If IsNull(completion_date) Then DoCmd.OpenForm "frmCompletedDate" 'COMMENT if the "completion_date" has date then check if "Combo54 is set to "yes"...

Hi All. I have look through the forum but can not find a solution to my problem. I have a popup form set to "popup" and "modal" "frmJobBookOut" which passes data to a query "qryJobBookOut". In the query there is a field called "job_no" and I have set the criteria to reference the...

Hi All, I have the following code behind a command button on a form. When the button is clicked it calls a query "qrtJobBookout" and should display all the record that match the job number in form "frmJobBook". But it displays a error of "type mismatch". form name = frmJobBook, Button name =...

Hi all, Is it possible to have a Continuous form that is a pop up. Any ideas. Many thanks

Hi all. I have a Combobox on a form, What I am trying to do is before the record is saved check that a selection has been made. What I have so far is:- Private Sub Command17_Click() On Error GoTo Err_Command17_Click DoCmd.Save If IsNull(Combo2) Then MsgBox "You must select a supplier, If...

Hi all, I have 2 tables, "tblJob" and "tblSupplers" "tblJob" fields: job_no, suppler_no1, supplier_no2, supplier_no3. "tblSuppers" fields: supplier_id, company_name. Each job can have more than one suppler. I am trying to write a query that will do the following. If job_no 1 has one supplier...

Hi All, I am trying to assign function keys to perform actions on a form and sub form. On the "frmMainClient" form I have an OnLoad event: Private Sub Form_Load() Me.KeyPreview = True End Sub and a OnKeyDown event: Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer) Select Case...

Hi all, Is there a way we can have a RESOLVED option so when posts have been resolved they can be marked RESOLVED Many thanks

Hi All. I have been reading a earlier post regarding requerying forms How do you find out the name of the SubFormControl. I am trying to refresh sub forms and I am trying to use the following code. Private Sub Form_AfterUpdate() Forms!MainFormName!SubFormControl.Form!SubSubFormC...

Hi All, I should know how to do this but my brain has gone blank. I have a form "frmMainClient" which has a field "account_no". On the main form "frmMainClient" I have a command button which opens a pop up form ""frmJobNew" where I can enter a new job record. The "frmJobNew" form has a field...

Hi All. I have a from "frmMainClient" which has a subform "frmJob". They are linked using a field "accoint_no". when run the output show me the content of the "frmMainClient" and all the related jobs in the "frmJob" subform. That fine. I now want to add another subform "frmSuppliers". I want...

Hi All, I have a form "frmMainClient" which has a field named [account_no]. I also have another form "frmJobNew" which also has a field named [account_no] When a record is displayed on the "frmMainClient" form I want to be able to open the "frmJobNew" form "via a button" and have the...

Hi All, Point No1, I am not a VBA programmer, but I am trying to learn. My Question is: Environment: Access 2000 on MS 2000 Pro with a split database. If I have a button on a form with the following code on the OnClick event should it work: Private Sub Command204_Click() Dim cnnl As...

Hi all. This is driving me mad, can you help. I have a form which has a subform. The OnOpen event has the following code: Private Sub Form_Open() If User.lngUsrId = 1 Then Me.Form.AllowAdditions = True Me.Form.AllowDeletions = True Me.Form.AllowEdits = True...

Hi All, I am trying to set up permissions on forms useing code I have found in some posts here. What I have so far works up to a point. I can login useing the correct login name and password. When I get to the "ReferralsMainReferralForm" the welcome controls shows the login users name but it...

Hi all. Is it possible to give users read only permissions to selected forms useing the security facilities provided in Access 2000. I have have a look but if I select a user and than try and set the permissions for a form the GUI has the Read Data, Update Date ect greyed out. Can anyone...

Hi all, I have a popup form which accepts input from the use, dates. There are two fields of the form, comba28 = From Date and combo30 = To Date The user enters the the From Date and To Date and then click on a command button which loads a Report. The Report loads a few Sub-Reports and all...

Hi All. I am developing a new database for my employer. The database is near completion. One of the problems I now have is to get the current data into the new tables. The curren t database was designed (NOT) by someone who had never NOT designed a system before, and should never try again...

Hi All, Major Problem. I have been building my database over the last few weeks (with a lot of help from this Forum, thank you) and I am just about to go from developmentg to production and I am getting an error. I have my main form with 16 subform in Tab format at the bottom of the main...

Hi All. I have a form with a Combo Box that the user can use to select a record. What I would like is, if the user types in a search that is not in the Combo Box list, I want a message box to popup that informs the user that the record does not exist. Can anyone point me in the right...