Search results

Thanks Colin, all completed without any errors. So far so good.

This is Debug-Compile from the toolbar ? No. But I have deleted the autoexec macro and put the opening Form into Options-Current Database-Display Form and it hasn;t happened since. But it was an intermittent problem before this. I was hoping there would be some way to look at what was causing...

Thanks. A lot easier to follow like that.

Thanks Maj. After reading the link the latter method seems way easier !

I've run a delete query on my table and now want to update its count Field (to number 1 to recordcount). Can an update query do this? I'm a bit stumped how to construct the sql. Or should I just iterate through a recordset and edit each record ?

I did a compact and Repair and twice it brought up the error. So in Form_Open I put Msgbox "Open" and the next C&R brought up the msgbox then went on to load normally after pressing OK. Repeated 4 times and Ok every time. So took out the msgbox and ok. Closed and Opened DB - still OK. Bit of a...

Sometimes (maybe once in 10) when I open my DB I'm told The expression On Open you entered as the event property setting produced the following error: File not found: All I can do is Ok. Then I close the Form, Open it again and it's fine. When the error does occur, how can I trap it ...

Thanks Paul, I thought I'd tied that without success but it's working now. An update query might be problematic checking each first ?

I'm updating various fields in my table from two recordsets like so If Nz(Dest!Year) <> Nz(rst!Year) Then Dest.Edit Dest!Year = rst!Year End If If Nz(Dest!AlbumTrack) <>...

> Objects should not be referred to by their module. I'll try and so that (thats the "Form_" bit ?) but suspect it's happened a lot as never been taught otherwise and generally go with what works. Unrelated but you guys will know, The form is showing e.g. 42 records and a verticle scroll bar...

Fair enough. Thanks. Will leave it how it is.

Thanks very much one and all it's working great. Private Sub Form_Load() DoCmd.MoveSize 6000, 3000, 12 * 1440, 6 * 1440 ' docmd.MoveSize r,d,w,h If Nz(Me.OpenArgs) > "" Then Me.RecordSource = Me.OpenArgs Me.Artist.ControlSource = "Artist"...

I'm setting the record source in code before opening the Form. Is that wrong? Form_frmzqryUSA.RecordSource = sql DoCmd.OpenForm "frmzqryUSA", acFormDS

I've been setting Datasheet Forms Record source to a query then each fields control source via the dropdown in Properties - Data Tab. Now I'm wondering if instead you can set Form record souce to the actual sql string insted of the query name, and not need the query. But then the control...

Agreed, it's working pretty good with just the Form. And I learned how to prevent adding another record via Nav control. (with a second table in the query). Ok on the Form load startup.. I'd actually looked there but didn't notice it. So I have a few redundant Autoexec macros now!

Yes, I was incorrectly calling the Navigation control the "record selector"? I also had some glitch in the Form where the On_Current event didn't work. With a second Form (or new one) it does work but I'd deleted the first so no way to see what might have been wrong. I didn't realise it was...

I still could not (even after duplicating your frmPic) get Form_Current to work. Anything there was ignored. It drove me batty. In the end I imported your frmPic, where Form_Current does work. I have added tblApplicationSettings for Path, qryImages and stored the filenames in tblImages...

Ah, Jeez sorry - no wonder I was getting nowhere. Yes, Navigation buttons... and your db has been very helpful. So it is true the say an event when clicking Navigation buttons will only fire if there is a bound control on the Form ? I don't want a control (at the moment anyway) rather just the...

Before adding that image control, would that lose me the drag/resize behaviour I have at the moment ? I'd still like to find how to pick up the record selector click on the Form I have now.

I'm using that event and a click on the record selectors is ignored. So more must be involved ?