Search results

Thank you! That worked perfectly! Carrie

Hi I've created a listbox and am using the following code stWhat1 = "": stCriteria1 = "," For Each vItm1 In Me!LstArchive.ItemsSelected stWhat1 = stWhat1 & Me![LstArchive].Column(0, vItm1) stWhat1 = stWhat1 & stCriteria1 Next vItm1 Me!txtCriteria1 =...

I've got Access 97! The code I posted earlier still didn't work!! But I had a think and tried this code instead If IsNull(Me.cboInt) Or (Me.cboInt.[Column](1)) = "" Then MsgBox "You need to choose an interviewer first!", vbCritical Me.cboInt.SetFocus End If Leading me to think that it was...

Hi Thanks JrJr - your comments did help. Meant I knew it was something within my code! Had another quick play and it works if I change the code from below If IsNull(Me.cboInt) Or [cboInt] = "" Then MsgBox "You need to choose an interviewer first!", vbCritical Me.cboInt.SetFocus End If To...

Hi Thanks for your response. No I'm not using the before update event. I'm using it on the On Got Focus of a command button. I'm basically trying to make the user enter a name before they run a report (the report is based on whatever name they type in in the combo box cboInt.) I have just...

Hi I've been looking on the forum to try and find my answer but am struggling to find anything! I have a combo box which I am validating by using IsNull. This works fine untill someone fills the combo box and then decides to delete it leaving the combo box empty again. My IsNull then does...

Hi thanks for your reply I've already tried creating a new front end and it didn't work. Have just tried again and it still doesn't work!! Everyone does have their own log in and password. The only issue may be the service packs. I use Access 97 and I know that I am on SR1. I also know that...

Hello Thanks for your reply! Yes I've compacted and repaired but it makes no difference. It is a split database. The table are on the network and eveyone has a copy on their C drive of the front end. I was wondering if it was a server problem but I don't seem to have this problem on other...

Hello I have just created a database which is now in use. However there is one issue that keeps arising. I have set up a startup form and from this the user chooses an area of the database they wish to go to. For example if they wish to setup a job they go to the form Setup Job. Once...

Stephen81 and Gudson Thanks for your replies and help. From what you say Ghudson I think I have overused the code you posted by putting it everywhere and I think this has caused the problem! Time to remove the code from all my reports I think!!!! Thanks for the help Carrie

Hi ya Yes I have a form where the people have to put in ther password. On the on open form I've put in the code Dim I As Integer For I = 1 To CommandBars.Count CommandBars(I).Enabled = False Next I I'm also using the code within reports with a customised toolbar. I basically do: On the...

Hi Thanks for having a look at this for me. The code I'm using is Dim I As Integer For I = 1 To CommandBars.Count CommandBars(I).Enabled = False Next I and Dim I As Integer For I = 1 To CommandBars.Count CommandBars(I).Enabled = True Next I Carrie

Hi I've got a database application where I have disabled my menus/toolbars using code from the forum. It works fine. However when anyone else goes into a separate database/new database they find they have also lost all their menus/toolbars in these databases. Is there anyway to get round...

Hello I was wondering if anyone could enlighten me a bit. I experienced a corruption in my database today. Fortunately I managed to sort it out but decided to look on the forum for any clues to why it happened. I came across the Jetcomp.exec compact utility. My problem is that I need to...

Thanks Mile-O-Phile I was having a bit of a mind block. I think an update query is the answer!!! Carrie

Hi thanks for your reply. I went to the field and put in the format but it appears not to work on a text field (works on a number field!). I don't suppose you have any other suggestions?? Carrie

Hello I wonder if anyone could help. I have converted my jobno field from a number field to a text field. Unfortunately while doing this process any jobs that have a zero at the front have had the 0 wiped out! i.e Jobno 00679 is now 679. Is there any code I can use to put back in the...

Hi Thanks for replying. I will give that code a go. Can I just clarify what I think I do. The code provided will mean the users will be able to compact their personal front ends whenever? Regarding the backend I will just compact that when nobody is using the database. Is my line of...

Hello I was wondering if anyone could give me any tips on compacting databases. I've just completed my database and I plan to split it and put the backend on the server and the front end on everyones computer on their c drive. Originally I thought all I'd have to do is compact the backend as...

Hi I'm currently setting up a form which has a main form and two subforms. At first I could get it all to work and scyncronise fine. I then decided to help make data entry easier by breaking down the two subforms into tabbed controls. i.e. The first subform is split into three forms...