Recent content by KCcasey

Hi All, Sorted my issues out. Firstly, the recordsource of my subform had mysteriously changed - the field I wanted wasn't being return.... bizarre. With that fixed, made some minor corrections (in red) to Pwise's suggestion, to end with this: Function OpenRecordForEditing() On Error GoTo...

Thanks for your reply Pwise. I slapped your code into the function, and which generated the error: 'Error -2147...: The expression you enteredhas a field, control, or property name that MS Office Access can't find'. Hmm. So then I tried to simply return the fields value using MsgBox...

Firstly, thanks for time to look at this. I'm painfully aware of my VBA noobness right now so its much appreciated. Now for some context. I have a main form with multiple pages. The first page has search functionality, the search results are displayed in a subform. The functionality I am...

Hi All, I've got a strange problem (at least i think so). I'm importing the contents of a text file to a dataset, and the datatype of the destination column is changing from string to decimal for no reason that I can determine... When I pass a text file with 13 rows, the datatype of the first...

Hi All, First off, thanks for taking the time to educate me. This is my first foray into VB.NET, so I really appreciate your constructive feedback. I have a test file that I want to parse, segregating the first 13(ish) chars of each line from the remaining text in the line. eg...

I've found this reference really helpful when dealing with complex data/calendar problems in the past... Completely different approach to Lamprey13's post. http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-calendar-table.html Good Luck! Casey.

Hi Folks, I've got a query that I'd like to create as a view... its necessary for it to perform some aggregations in some temp tables - - how can I go about this?? I've tried create tables, temp tables and table vars with no joy; I guess I want to know ifs its possible, and if so how? :)...

Beautiful, works like a charm. Thanks for helping out a VBA noob. Kind Regards, Casey.

Hi PHV, Yes the toggle buttons are grouped in a frame - - what is the property of the frame that controls the currently selected option? I'm currently use ADO to return a value, based on which I want to select a specific toggle. Bear with me here - - as my frame isn't based on an underlying...

Hi Guys, thanks for your prompt feedback! I tried Alex's fix first - - that ran without raising an error. However the option button on the form doesn't depress, which is kinda what I was really after... extra star anyone??? :) Regards, Casey.

Hi Everyone! First of all, thanks in advance for the help! This should be an easy one, but I'm at a loss. I want to 'toggle' a toggle button based on results from a recordset. Heres the code I've been attempting to use: Select Case objRecordSet("PSsentBy") Case "Neil Watts"...

Thanks guys! Its been one of those irritating questions at the back of my mind for ages :) Casey

Hi Everyone, Just a quick 'n easy question today... What does placing " N " in statement do? eg. INSERT INTO Northwind.dbo.Shippers (CompanyName, Phone) VALUES (N'Snowflake Shipping', N'(503)555-7233') Thanks! Casey.

Hi, The view is comprised of 4 underlying table, a couple small, a couple (relatively) large. Does this change my options? Regards, Casey.

Hi, I’m hoping that I can get some guidance :) I have a table that I want to be in sync with a view in a separate (SQL2K) DB. I’ve never played with triggers, or had much to do with implementing referential integrity in SQL2K - - I’m pretty much ignorant! There seems to be several options that...