Search results

Arnel no I haven't, I just did a quick reply to Ridders whilst I cooked my tea. To be honest what you have offered looks exactly what I was expecting it to be. Many thanks for your help.

Hi Ridders and thanks for the suggestion. One thing I forgot to mention (sorry I'm unusually tired at the moment due to a health issue) was that I need to pass the value to a variable as I want to use it in a MsgBox. Does an expression in sql work that way? Regards, Lol

Apologies folks, I was unusually tired when I posted the appeal for help. Just to clarify, this piece of code is run from an Excel spreadsheet and is intended to check data about to be written into a database against a, as it were, master list in the same database. The two tables are not linked...

As it says, I think the root of my problems are in the cursor settings but I'm struggling to nail it down. I have some code below and basically it's comparing two tables and finding the total number of records that have no match. It works so far but it keeps returning a total of -1 which I know...

Well I got it sorted in the end. I had the form bound to the Tbl_Vehicle, the combobox was unbound and its source set to all the vehicle registrations in Tbl_Vehicle, and the text box bound to Vehicle_Reg in Tbl_Vehicle. I had the following code behind a button: Private Sub Command35_Click()...

Thank you for the great bit of code, I will certainly enjoy trying to understand it! Many thanks, Lol

And this is the problem, I need a bit of re-education I think. What I have been doing is relying on the combobox wizard to set the data source and what it does. What I would like to learn is how to do it manually for future references so if you have a link or the patience to do a step by step...

Apologies for that, as it stands the form is bound to Tbl_Vehicle and the combobox and textbox are unbound. Thanks, Lol

Not really it has work sensitive data in there. The code I am using is in the word document I uploaded and I can answer any questions on structure etc.

Interesting. What I am trying to achieve though is the use of a combobox to allow the user to select the offending registration quickly and then enter the new reg in a textbox. A click of a button would change the combobox value to the textbox value. Would your method work that way, and how...

Could you explain how I could do that please? Brain a little foggy.

Hi folks, not been doing much for a while and then the phone rings and it's work moaning about a problem :) Please see attached sheet as the site insists I am posting 58000 characters regardless of the browser I use!

Morning Ridders, I assume you mean allowing for the fact that the smiley face is actually a colon and a closing bracket?

Hi, could just do with some advice on network file paths. I have got an Excel s/s that exports data to a Access d/b via vba behind a button. In development the file path has been c:\ etc etc Now however the files are to be networked and the filepath I have been given is thus: office(\\brfile)...

Many thanks folks, much appreciated as Microsoft's info on this sort of thing is buried deeper than a deeply buried thing!

Got a strange one here because I have used what i thought was exactly the same syntax in another query string and gotten no problems. I'm passing the value of a combobox to a string and executing it as a query in vba, but I keep getting asked for a parameter. I've checked the control name, done...

Just learned the hard way that Excel, from where I am driving this thing, doesn't like the Nz function. Might save you some grief in the future :D

Okay, here we go! I pruned my sql code to this: INSERT INTO Tbl_Costing ( [Job Code], EmpName, HoursWorked, WeekEnding ) SELECT Tbl_Trial.[Job Code], Tbl_Trial.EmpName, Tbl_Trial.HoursWorked, Tbl_Trial.WeekEnding FROM Tbl_Trial WHERE Tbl_Trial.[Job Code] AND Tbl_Trial.EmpName IS NOT NULL; I...

Okay, so I've pruned the sql somewhat to this, the idea being to remove all the blank cells before inserting them into the main table, Tbl_Costing: INSERT INTO Tbl_Costing ( [Job Code], EmpName, HoursWorked, WeekEnding ) SELECT Tbl_Trial.[Job Code], Tbl_Trial.EmpName, Tbl_Trial.HoursWorked...

Hi, having got my sql in some sort of order in a previous post I am trying to insert the sorted fields into another table. Testing the code without the "Insert" clause it works fine, but when I come to try and insert the data into a table I get a warning from Access that it can't append all the...