Search results

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

Resolved All done, On the "frmJobReadOnly" form save button I used the following. Work fine. Private Sub Command17_Click() On Error GoTo Err_Command17_Click DoCmd.Save DoCmd.Close Forms!frmMainClient![frmJobReadOnly].Form.Requery Exit_Command17_Click: Exit Sub...

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 have sorted out my problem. My error, the "aacount_no" filed was not bound to the table field. Sorry, I'm a plank Many thanks

Hi and thanks for the reply. I currently have the following code on the "Click" event. Private Sub Command40_Click() On Error GoTo Err_Command40_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmJobNew" DoCmd.OpenForm stDocName, , , , acFormAdd...

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 Le. Yes thats what I want dto do but how do I code it. I have been playing around with this for hours. Can you help, please.

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

Him##Thanks for your reply, it works fine. from here I can now workout my other errors and problems. Many thank again, keep safe and well. Dereck

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 Malcy I should have known, yes your reply works OK. I have my event set to preview the form and there is no reason why the user should see a preview. Many thanks Dereck

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 Andy, Thanks for your reply. I have looked at the other post and completed the first part and produced a table with the house numbers. What I don't understand is the query I am useing, see below: What do I need to change to get the secoend part of the address and so on. OK here’s how you...

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, I have solved the problem (Quick Fix) by removing the linked tables and exporting the tables from the BE to the FE. With the tables sitting side by side with the other objects the database work with no errors. This is not ideal but it works. I have search the web and my manuals and hve...

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