Search results

Hi Doran-Doran, Try the following on the Open Event of your form:- If User.AccessID = 1 Then Me.cboAdmin.Enabled = True Me.cboAdmin = Me.cboAdmin2 Me.cboAdmin.Locked = False Else 'ElseIf User.AccessID = Int(4) Then Me.cboAdmin =...

Hi CBragg, Thanks for the speedy reply. Unfortunately I can't do that as the database that the information is exported to cannot except it. However that was one of the ways I thought about importing it back in. Split the dd part of the date into one row, mm another and yyyy into the last and...

Has anyone come across the following? I have a table with several date fields. Next I have a query where I format the date fields so they can be exported in the correct format. I do this in my query as follows:- Date1: Format ([DATEBRTH],"ddmmyyyy") Date2: Format ([DATESTRT],"ddmmyyyy") When...

Hi maxmangion, Sorry I explained the situation wrong. I have two tables in my Query - tblLearners and tblActivities. One Learner can have many activities. What I would like to do is show the Learner and only the one activity that has the greatest date. Regards, Ant.

Hi all, I have a table with several records and I am trying only to show the one with the most recent date. Thanks Ant.

That's correct Sammylou. Ant.

Hi GUIDO22, Ignore the bit about opening a form. If I have 10 records in ListProgrammes and I requery the list using:- Me.ListProgrammes.Requery The first row of the listbox is selected and I would like it to return to the row originally selected listbox. Ant.

Thanks again for your replies, will have a look into it. Ant.

Hi all, I have a a form with a listbox on. When I click a command button it opens a form depending on what I have selected in my listbox. When the listbox is requeried it automatically selects the top record from my listbox. It is possible to requery the listbox but keep the record I...

Hi Col, I originally had the fields filled in by default values but apparently this is confusing for the user when adding a new record? :rolleyes: Unfortunately certain fields are required for some records but not others. Ant.

Thanks for the reply SQL_Hell, Unfortunately when a user clicks a command button to close the form, if certain fields are null, it automatically inserts the required information. So even with pessimistic locking it does not seem to be stopping the user from editing the data. Ant.

Hi all, I have a database shared across a network and the problem I am having is when one of my forms is closed, if data is missing it will fill them in. If someone already has the record open is it possible to prevent opening of the form with that corresponding record? Thanks for any help...

Hi All, I have a form with several fields on which can not be null. What I am trying to do is when the user clicks a Cmdbutton to exit the form a Message box to pop up saying "Field A can not be null". When the user clicks the Cmdbutton again if the next field along is null the same thing...

Hi Cable, It is on line:- Dim prn as printer Ant.

Does anyone know if the code from post 2 can be used in Access 2000 as I am getting the error:- User Defined Type not Defined Thanks Anthony

Check out http://support.microsoft.com/default.aspx?kbid=304548 HTH Ant

Hi All, I have searched about but not with much lick unfortunately. I have a form with a command button on. When I click the command button I print the report without actually viewing it. What I would like to happen is when I click the command button it prints a copy of the report to all...

Hi all, I have a form with a listbox which displays table names with the following as the rowsource:- SELECT [msysobjects].[Name], * FROM msysobjects WHERE ((([msysobjects].[Name]) Like "Codes_LP*")); I was wondering if it is possible to have a command button that opens the table that I have...

Thanks Mile-O-Phile, Works Great. Ant.

Hi All, I have a form with a ListBox and command button on. When I click the command button it deletes the record from the ListBox with the following on the OnClick Event:- Const strSQLDelete = "DELETE * FROM [tblClaim] " Dim strCriteria As String Dim strPrompt As String...