Search results

OK, got that thanks. I did get another error (screenshot attached), so I'll have to look at the tables again, because of the conversion error! Thanks, Pete

And here's the SQL: INSERT INTO Original ( [Premises Reference] ) SELECT Append.*, Original.[Premises Reference] FROM Append LEFT JOIN Original ON Append.[Premises Reference] = Original.[Premises Reference] WHERE (((Original.[Premises Reference]) Is Null)); Pete PS: [Premises Reference] is PremID

Hi plog, I did that and pretty sure I followed your instructions, but I get an error when trying to run it. The error is: The INSERT INTO statement contains the following unknown field name: '[Premises Reference]'. Make sure you have typed the name correctly, and try the operation again...

...but I was really trying to do this myself! I have two tables, structurally the same and with a lot of duplicated data - basically, I manually 'fixed' different data in both of them and I'm having difficulty merging them into a 'consolidated table to include both updates. So, in detail: The...

So, I've made some progress... I've got the Strings all sorted and end up with the following variable: strApplication = "http://application/home/redirect/?&target=_blank&m=premises&c=premises&a=edit&i=" & strPremID This opens the application, but doesn't open the specific record. However, if...

Hi Ranman256, I probably didn't give enough information, sorry. The application I referred to isn't like Word, Excel, etc., but rather a database application that's written as a browser (forgive my terminology!), so what I'm trying to do is open that application in, I assume, the users default...

Hello, I would like to open a web-based application from my Access project, but I'm not sure how to 'translate' the javascript to an Event Procedure on a Command Button. The java script is...

Oops. They turned up after restarting Access. Sorry :o:o

I've definitely followed these instructions: Right-click the menu bar at the top of the Navigation Pane, and then click Navigation Options . In the Navigation Options dialog box, select the Show Hidden Objects check box, and then clickOK. ...but I definitely cannot see the hidden items in...

Re: This Recordset is not updateable... I DID IT! :D :D I had the DLookUp looking at the wrong tablename! Wot a plum :o

Well, I sorted it - in a roundabout sort of way. As I keep backups, I changed the the name of the form causing the problem and imported an older one. I spent ages reconfiguring it to look like the knackered one and? It works - although everything is the same. I changed one control at a time...

I saw that - what a melon! That didn't resolve it, though. I also got rid of the fields with lookups associated with them and calculated fields, but that didn't help, either. Funnily enough though, there are a few weird things going on! When I double click the form in the object browser, I...

Hi Minty, Did that, but with the same result. Not sure where to go next... Pete

Blimey. That was quick! I'm on it, Pete

OK, a bit of an update... If I open the form by double-clicking if from the Object browser window, I can edit the data. If I open the same form from a cmdButton, I can't. The cmdButton event is: Private Sub cmdEdit_Click() Dim strAuthority As String Dim strReference As String Dim strTown As...

I'm getting this when I try to update fields on a form and, although I've looked on the internet and found results relating to Queries, they don't seem to apply as the form is only linked to a table - and I'm confused (again!) The only thing I can think of that could be causing this is the main...

Hi guys, Thanks for all your advice and comments on this. Rather than using the On_Click event on each of the forms, I'll use the On_Load event of the 'slave' form (thanks sneuberg :)) to set the form up. (This) problem solved :D Pete

It might be a bit much to ask, but I could send it to you - I would ask you not to give it to anyone else though, please? Or be too amused at my efforts :D Pete

I love it when techies talk dirty :D:D

Oops. No, I get 2 when Years is the selected option. I'm using the command to set the visibility of several controls based on the option value. Erm, should I use "If optExpiryDate.Value = 1 Then "?