Recent content by StuartDwight

Thanks guys, it was the offset command that was my missing link, you have saved me a lot of time. I can get on and finish my coding now.

I have some code below which opens a file in excel and gets a cell value. What has happened is the file I am looking in changed and can contain a varying no of rows before the row I want. What I need to do now is find the cell reference that contains a text string "Total Net Pay:", then I know...

Can anyone tell me how to count the number of columns in a recordset. The datasource for this recordset is a crosstab query and the columns will vary in number each time it is run. Many Thanks.

I was having a problem with whole numbers like 1.0, it seemed to strip of the .0 and was coming back as 1 which is allowed, and was failing my check. The * 100 MOD 50 worked a treat, add the "undo" and "cancel" and the validation worksperfetly. Thanks Guys.

It's the code bit to work if it complies with my criteria I'm struggling with.

Sorry I don't think i have explained it very well. The first combo box contains a list of Agencies and the second combo contains a list of people working for the Agencys, the citeria of the second combo (or people) is based upon the agency picked from the agency combo (first). What i wanted to...

I have a field on my table set to Double with 1 Decimal place. I want to limit the input on this field so that the user can only enter either .0 or .5 after the decimal point. Has anyone any ideas. Regards, Stuart.

I want the 2nd Combo to lookup all the records it would if you clicked it and goto the first one.

I have two ComboBoxes on a form, the second Combobox's citeria is based upon the record chosen in the first ComboBox. What I am Trying to do is on the AfterUpdate Event on the first ComboBox, to automaticaly show the first value in the second ComboBox. Many Thanks, Stu.

Dear all, Can anyone shead any light on this. I have a Listbox with multiselect set to Extended. It is used to select multiple records for a delete job. It is also used to select a record for opening. It opens the last if more than one is selected (not ideal but it works). The problem i'm having...

Dear all, I am having some problems with an Insert Into command. I am trying to insert data into a SQL Server 2000 database using a Access 2002 front end, over a WAN. My code is as follows: DoCmd.RunSQL "INSERT INTO CORS_records_notes(ID,author,title,note_date,note) VALUES(" & strID & "," &...

Does any one know how to change the background of a checkbox to a diferent colour. It seems the usual properties box is not available. Thanks Stuart.