Search results

Can you suggest a good book or resource for learning "proper" sql please? I always used the Dummies books in the past and found them quite good for other things.

Okay folks I got it sorted, and it was CJ London who provided the clue: I forgot to add spaces into the string when breaking it down into chunks :banghead: I would like to make a few points though: The sql as it stands was generated by the query builder in Access, and not being over proficient...

I'm trying to execute a query, or at least this point a string of sql on an Access table from within Excel vba. A forum member kindly gave me a code to copy some data from excel to access to a temporary table. Now I would like to copy that data into it's permanent home table within the db. I'm...

Must be a version issue, I'm running 2013 and it just won't work. Nevermind, arnelgp has provided what appears to be an elegant solution.

Interestingly, or rather frustratingly I cannot get only the value into the new columns. using the "=VALUE" function is as bad as before. Annoying. I've just tried putting values only into the columns and it still doesn't work properly so it's not a formula issue.

Hi Ridders, thanks for the reply. I had considered that but wondered if there was a code based solution. Many thanks, Lol

Hi, this one has had me running round in circles for a bit tonight:banghead: I'm copying multiple ranges of cells from excel into access and it works fine EXCEPT two of the columns, k and l are calculated. K is a summation of 5 columns i.e a1+b1+c1 etc and L is a date calculation, a specific...

works perfectly now, thank you. I didn't realise Access would be enforcing data rules in a stand alone table with no primary key allocated. Thank you.

I'll upload the databse so you can see exactly what's happening.

I've uploaded a couple of screenshots

What I mean is columns are being shuffled down past their corresponding rows, blank lines inserted where there were none. Curious.

In fact the whole things disjointed. Any ideas?

Brilliant! What does it do? :confused: Hang on, not so brilliant it's offsetting data in the table the rows are not pasting as they are copied from the worksheet?

I'm attempting to copy data from an excel sheet to a table in an access db. I came across some nice simple code, put in my own parameters, and just the ONCE it worked! Now, despite everything appearing to be "as it was" it hangs with the db table open but nothing pasted into it and when...

Bless you but this is my original client, for whom I work pro-bono, who hasn't the time to sit and discuss what they want they are simply relying on me to provide them with something and amend it as and when needs dictate. I know I must be a frustration at times, and I DO appreciate the help and...

If I try to be more "normal" do you promise to come back and play nicely? :D

This is from a form which allows users to search the db for PPE issued between two user defined dates and a category the user selects from a combo. Plan? in my head same as the specification. Same situation as before, customer doesn't know what they want so I'm trying to anticipate their needs...

Therein lies the solution, despite all my searching on the internet I didn't come across anything that told me I had to have every field in my SELECT statement in the GROUP BY, in fact there was very little except the most basic syntax. I can go away now and have a further go and see where I...

Okay, so I have an SQL string to use as the recordsource for a subform. What I would like to do though is sort the data by date and group it by it's category. If I just use the ORDER BY then the string works well, but as soon as I bring the GROUP BY into the equation then I start getting errors...

Okay it works after a little tweaking on the syntax for the sql string. Code below for anyone interested: Private Sub Btn_PPE_Search_Click() strSearch = "SELECT Tbl_Issue.Issue_Employee_ID, Tbl_Employees.Employee_Employee_Name, Tbl_PPE.PPE_PPE_Category, Tbl_PPE.PPE_PPE_Description...