Search results

Nope I spoke to soon...

Strangely enough I seem to have fixed it. I saved the database in the old mdb format, opened it and then open the new format file again and the problem seems to have gone away...for now

Yeah it is very weird. I've tried compacting but didn't really help. The code is very simple and there is only one table in it. I know it is the library because when I remove it then the problem goes away.

I am having a really annoying problem at the moment. I have VBA code that makes use of the Microsoft Office 14.0 Object Library, but if I have this selected whenever I try to do anything in the Form Design view it is constantly freezing. It will literally say not responding" for a minute or so...

but what about if I want to confirm with the user whether they defintiely want to tick/untick it?

I have a checkbox on my form that basically deletes a record when the user ticks the checkbox. What I want to know is how do i check whether the person is "ticking" or "unticking" a checkbox before any action is carried out?

I know... :( But there must be a way of doing it.

I've been wreaking my brain trying to figure this out and I have a feeling i am looking at it the wrong way. Basically I have a continuous form with each record having a textbox and a checkbox. There can only be one checkbox ticked per record but what I want to do is to stop the other...

Thanks for the reply. The Doc Man: I completely agree about the data not being normalised. It is unfortunately a limitation in the way the dataset is exported from the original database and what I am doing now is simply trying to carry out some cleaning but in an automised way...

I would like to compare the values of several columns in the same record and remove any duplicates. So... ID | Col1 | Col2 | Col3 | Col4 | Col5 ------------------------------------------- 1 | A | B | C | D | C 2 | C | C | C | D | D 3 | A...

Thank you very much everyone it has just gotten a lot clearer. The "error" that I get is: #Func! So I guess that by not putting in +1, it is asking it to return the space which isn't a string.

Hi everyone, Sorry if this is a bit of a simple question but I just want to understand exactly how the "Instr" function works. So in my scenario I want to extra the first letter of someone's surname and I actually manage to get it to work using the code below. initial2...

I am having a very peculiar problem with my form. I basically want to open a form as a pop up window but when I selected this option in properties the form opens up really small. Does anyone know what might be causing this? Thanks.

Hi everyone, I am having a of trouble doing something which you would probably find really simple but I am pulling my hair out and I am not really having much luck finding and solutions either. Here is my problem, bear with me... So I basically have a form which the record source is either...

That's great. It's working now thanks very much!

Also I manage to get it to work when I specifically specify a column.

Same thing...

Thanks but that doesn't work either. The error it is giving me is on the line !fld.Value = "-1" And the error is "Item not found in this collection". So I am guessing I have incomplete code somewhere but I can't work out where.

Hi, I am trying to do something which should be quite simple but I can't get it to work. Basically I just written a code that scrolls through a dataset and when it finds a null field it will change it to "-1" but my code isn't working. Any help would be appreciated. Function FldTest() Dim...

I don't have much experience with creating pivot charts so please bear with me. I basically have a table like this: | EmployeeID | Day | HoursWorked | | 1 | 1/11/12 | 5 | | 1 | 2/11/12 | 6 | |...