Recent content by neepshed

I guess I want to know how do I check if the right hand side of the condition is not set?

Hi. I have a procedure that has a list of ids in a recordset. I compare each of these ids against an external database table. However if an id does not exist in the external table i get the error 91 object variable not set error. If rsWellList.Fields("IDWell").Value =...

How can I join 3 fields from a single table together. I intend putting the result into a temporary table. e.g. Table 1 Field1 Field2 Field3 Output Field1,Field2,Field3 Thanks in advance.

Hi. I want to open a form based on the result of an autonumber for a newly added record. The form I want to open will be a data sheet with no rows as the autonumber value will not be present in the table. I have tried DoCmd.OpenForm "frmAssignments", , , "LessonID = AutoNumber" But it doesnt...

Thanks XWB.

Hello, I have a script that compares data formatted as hh:mm. However the comparison never seems to work. FromTime is defined as a Long. If ToSheet.Cells(2, 3) = FromTime Then FoundTime = True Cells(YrRow, TimeCol).Interior.ColorIndex =3...

Hi. I am total newbie to this. I am trying to create a procedure that will show all records on a form that match the inputs of 3 separate fields on the same form. The procedure will run the On Click event on a button. Can anyone point me in the right direction. Thanks.

Stella you are a God. Thanks. I've spent about 3 hours trying to figure that out!

I have a cell K41 that contains a cell reference e.g. $B$23. This is obtained by by using =ADDRESS(L37,L35). How can I get the value of the contents of cell $B$23. Everytime I try and reference the value in a formula I get reference K41 and not the contents on $B$23. Thanks.

I have a cell with a reference in it e.g. $B$23. How can I read in this reference to obtain the value of cell $B$23. thanks

I need to search a cell for a particular value and based on whether the value is present I need to perform an action. What is the best way of searching a cell for a determined value. This search will be done row by row in the spreadsheet. So I dont want to specify the entire spreadsheet range...

I get a run time error 424. Object required. Yep. I'm not very good at this. So if you've got a solution I'd be very grateful.

Hello, I am trying to create a macro that will copy a selection from Excel and paste special into Word (unformatted text). Any thoughts on what I have so far. It fails when I do the paste special. Thanks in advance. Sub CreateText() ' ' ' ' COPY Data from Excel Cells.Select...

Does anyone know of a way to create a hyperlink that will run a batch file?

Problem solved. I had not setup the Forms correctly