Search results

I took another look at your SQL and I've made a few ammends, I'm not sure if it'll be right though. strSQL = "INSERT INTO [" & TableName & "] SELECT * FROM AddChangeName WHERE [AddChangeName]![term] = 200301" NB. I changed capitals for my own personal preference. I don't think you need any...

All your doing is setting a string to a variable, your not telling VBA to execute a command. Just like strSQL = "hello" It doesn't do anything after that A compile error is good, it should tell you what the problem in the SQL is?? maybe try adding a space "] SELECT I have to go now but post...

I think you might just need to execute the SQL exec strSQL

Dim Text1 as Integer Text1 = Me.Text67 (Where text67 is the total number of days) Me.Text131 = (Text1/30) 'Text131 needs to be a text box, data type double. This is very bad way to go about it. the number of days in a month varies, so using 30 just isn't right. If you enter two date values...

Sorry, like I said, I don't really know much about it.

Sorry, like I said, I don't really know much about it.

Here's a bit of script I run from the macro's in Outlook, I don't know much about it really but it might point you in the right direction. Sub Napolina() Dim olApplication As Outlook.Application Dim olns As Outlook.NameSpace Dim myItem As Outlook.MailItem Set olApplication =...

If you have a2k or above you can create a data access page. Otherwise (but better) you can use ASP. Some usefull links on this page. http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=36188

Thanks for replying but I got IT to install Office XP. Eveything seems to work fine. For now.

Yeah but your users will still need a front end unless they can all write SQL. VB (I think) is the prefered front end for SQLServer db's but it really depends on what your going to be doing with it.

If you want to keep the Access front ends for it then it's pretty simple, SQL server and Access both come with ODBC drivers to connect to each other. All you have to do is link the tables into the back end Access db and give them the same table names, everything 'should' slot into place nicely...

Does anyone know why, or how I get them. I tried to reinstall them but to no avail.

Cheers Ian, that's done the trick.

Access won't let me ... Dim db As database Saying user defined type not defined. But it will let me... Dim rs As Recordset But won't let me... Set rs = db.openrecordset Presumably the last one is directly related to the the first. DOes anyone know why this is happening, and more...

You can use the Transer Spreadsheet function in a macro and specify the range there. HTH

don't cross post

I don't have any examples to hand, and if you've not done much VBA I suggest you do it in small stages so you can see whats working and whats not, before puting all together. Create an OnClick event from a button that runs the code to build the SQL statement, then display the result in a memo...

I'd write it in VBA, you can test for Null values and create a SQL statement from that. Dim strSQL as String strSQL = "SELECT * FROM Table WHERE " If me.freq <> Null Then strSQL = strSQL & "freq LIKE '" & me.freq & "'" End if It takes a bit of jiggery pokery when your concatenating a few SQL...

Thanks Drevlin. I couldn't get it to carry the values with the Sub call, it kept telling me it was expecting a Sub or Function call (at which point I screamed at my computer "It IS a Sub call!!!") It works without the attched variables though. Alas, no matter, I declared the variables as...

Nice one, it's starting to make a bit more sense now. It' seems to be calling the Sub/Function but it's returning 0 values, not sure why. Any ideas? Option Compare Database Public Sub Command126_Click() Dim timeStart As Date Dim timeFinish As Date Dim Day As Integer Dim Lunch...