Recent content by allochthonous

This is all great info, but really what i was most curious about was whether SQL would correctly interpret the varchar (mm/dd/yyyy) MyDate against the true date fields of @StartDate and @EndDate. The actual range I am looking for does not really matter per se. PK

Other than issues with sorting and MAX, are there any potential issues with using something like CONVERT([varchar](10), datetimefield, 101) which yields a mm/dd/yyyy varchar value. That is, the WHERE > and < statement will still work properly as long as it is being compared to a true datetime...

Remou: Yes, I check for the usage of the Brand code before I allow deletion from the table. Yes, in theory, users could be entering transactions at the time the "maintenance" is going on, but since the CODE is written to the Transactions table, it should not matter what is going on editing...

Forgot to ask, could you explain a little more about the "lock table" idea? PK

Right now I am keeping the table, and just deleting records on close, and appending records when the form is opened. I could not recall which method resulted in bloat (can't this be combated with compact and repair on close of the db?) What is the code to check for existence of a table? If i...

Is there any way that I prevent more than one user of a FE/BE database accessing the same table at the same time? I tried using If SysCmd(acSysCmdGetObjectState, acTable, "tblBrandsEditTEMP") <> 0 Then MsgBox "To maintain data integrity, only one user may edit the Brands table at a time...

I am not sure how to attach a screenshot within the post. All i see is an option to include a link to a file storage site.

Maybe you were not working with a matrix?

I see no way to remove the row from the built in SubTotal box. It's just one big box. There are Properties settings, but i don't see any way to specify what rows to show. I think i figured out how to do this though. Because of how my data is set up, the WkTotOff.Value in the SubTotal section...

I have a dataset (see http://dl.dropbox.com/u/1868439/cdn%20report.xls Sheet1) that i need to report as a matrix. Within the dataset, i pull together the individual totals for CDNs within a week, along with the overall total for all CDNs within the week. I do this to make it easy to calculate...

This must be one of those "annoying limitations". This comment section via Properties is a but clumsy, but might suffice for now. I will try to start using Edit instead of Design.

Is this not the same functionality as when you use "Edit" through the Management Studio GUI? I can get comments to stick there. I was wondering if there was a way for them to display when you use the "Design" method. PK

Is there any way to get comments to "stick" in a view in SQL Server 2005 (Express)? I can comment when i use "Edit" of course, but I would love it if they would be visible in the view "Design" as well. PK

Yeah, I do not use relationships like that in this database. Now, should I have set them up anyway? Maybe. When building it, I saw no reason. I would have to really sit and think whether they would prove beneficial. OK, you have made a fairly good point in rearranging my tables, if not for...

OK. Perhaps I will do this when I get some time. Your method does not sound terribly difficult. The DB has been doing some odd things lately. Perhaps it is due to this "hybrid" design? Though I really do not understand what difference it would make. Not to sound like a complete noob, but...