Search results

I have a little bit of code to extract the name and description of each variable in the table I name and results are written into a temporary table (tblTemp). I would also like to extract the data type of each variable, but am stuck as to the VBA designation of this property. Can anyone help...

Thanks for the tips!

Thanks for the reply. That was one of the things I tried first. It doesn't work for some reason.

I have a form with a list box. The rowsource of this listbox is set to a bit of sql that is run when the form is opened: SELECT BatchDate, Count(BatchDate) AS [No Of Deaths] FROM tblMR515Deaths WHERE StudyCauseOfDeath Is Null AND SCDinICD10 Is Null GROUP BY BatchDate The data in...

Thanks very much for the response. I'll give it a try.

I'm developing a Windows Forms app using VS 2008 with a SQL Server 2005 database. I've developed a search where users can search for data by entering one or two criteria. One of these is a date which corresponds to a date field in my database. The user clicks on a button, which feed the...

Thanks very much for the response David. Your explanation really cleared things up in my head!

I need to extract data from a string into two new variables (called 'NHSNew' and 'NHSOld'). The string is mostly separated by a '/'. Data to the left of the string goes into 'NHSNew' and data to the right into 'NHSOld'. I can do this first part OK as shown below. Data to the left of the '/'...

To answer my own question: I've found a method called 'The Rozenshtein Method' which does exactly what I want. It's documented here: http://www.stephenforte.net/PermaLink.aspx?guid=2b0532fc-4318-4ac0-a405-15d6d813eeb8

Hello, I'm trying various things in T-SQL and one of them is the 'pivot' function. What I'm trying to get is data which has the Year as a row in a query, the months as columns and the quantity as a value, in much the same way that you'd be able to do with Access' crosstab query, so...

Thanks again to Banana and SQL_Hell for the suggestions. Much appreciated.

Thanks very much for your reply Banana. Why encrypt? It's a legal requirement (or will become a legal requirement in the future). The data contains personal information/medical records etc. Threats? We're mostly worried about external threats - i.e. keeping out undesirables. The rogue employee...

My boss today raised the thorny issue of data encryption. Normally I develop in Access and am aware that I could use workgroup security. But I've had some bad experiences with this in the past. I've recently been investigating switching to Access ADP with SQL server back-end databases. So my...

Thanks for the reply. What I don't understand here is why does 'DoCmd.RunCommand acCmdSaveRecord' (or any of the other options I've tried) fail when I'm stepping through? If I wasn't stepping through there's no error generated, so does that mean the code has run properly? For example...

Yup. I'll do that later if you want to have a look at it. Thanks very much.

OK, I've something which appears to work and which I found a reference [to] to via google: If Me.Dirty = True Then Me.Dirty = FalseQuestion is, why does this work and not the others? BTW, creating a new db and importing all the db objects made no difference.....

OK. Db is compact and repaired by default on exit. Code has been compiled a gazillion times! I'll try the new db approach. Using 2003 SP3 and as far as I'm aware, all updates have been installed. It is a networked db. Is that an issue?

Yes, those properties are set to 'Yes'. Yes, I've tried using the dirty property and I get the same error. Thanks for any help you can provide.

Yes, I tried using 'DoCmd.RunCommand acCmdSaveRecord' and I get the same error message ('runtime error 2046'). Perhaps I didn't explain that in the OP. All of the three methods I use raise the error.

I'm hoping someone can clear something up for me. I've only now been made aware of it, which is a bit of an embarrassment as I've been using it this way for years! I've just discovered that when you use it on, say, the click event of a button that's intended to save the current record and close...