Search results

Hi, Thanks for your reply. I'll read the help files more carefully. I did have a look at them before (just a really quick look in fact) but didn't spot the main issues. From the bits and pieces of code snippets I've gotten from this site and others I had the impression that people just picked...

Hi all, Are there particular advantages/disadvantages for the use of the various on current, on open, on load, on activate etc. events for a form? To me it seems as if there is not much difference between them but that's probably plain ignorance from my site, why else would the different...

I think I haven't explained that I'm using 2 tables here: tblPatents (contains the field PublicationID) tblNotesOnPatent The button on frmNotes opens the notes specific for that PublicationID record. What I'd like to achieve is that a button on on that form opens another form to enter a new...

Really? That's worth looking into this option in more details than! I'll give it a go. Thanks for the advice and explanation. Wally

Thanks. Yes, I could do that and if that's the best solution I will. I was hoping there is a possibility to 'overrule' the disable code in individual cases. Is there such a code?

Users of my DBs get view/edit privileges on forms based on their loginname. If fPrivileges("E") = True Then Me.AllowEdits = True Else Me.AllowEdits = False End If Works fine except that when somebody is not allowed to edit the form the comboboxes to quickly...

Thanks Mile-O-Phile, I'm still having no luck though. The first line of code opens the correct form OK but won't let me enter data. looking more closely at the qry this form is based on I see that I have 2 autonumbers in it. That's not allowed is it? I'll change my qry and will try again. If...

Hi, I'm trying to open a new record form from another form. This is the code I came up with that dosn't work DoCmd.OpenForm "frmSingleNoteOnPatent", acNormal, , , "PublicationID = " & Me.PublicationID DoCmd.GoToRecord , , acNewRec I get error message "type mismatch" I don't...

Pat, I did notice that AncientOne's code missed some code that I originally had there: & "" However, that didn't do the trick either. What I've got now is this: Dim stDocName As String stDocName = "rptPatentFamily" DoCmd.OpenReport stDocName, acPreview DoCmd.RunCommand...

Thanks for your advice AncientOne. I've had a lot of trouble getting this to work but it's fine now. I hadn't realised that I also had to enter criteria in the query that underlies the report. Learned something new again :) Thanks again, Wally

I’m trying to create a report from a cmdButton on a form with 2 subforms. The main form has the linking filed. Using the code below I get a pop-up that asks for a criteria value and has the wanted value (the IDnumber in the form) above the input field. If I manually enter that number I get the...

Thanks all, It looks like I had included too many tables in the qry. I've reorganised a little and was able to leave out two tables and now the qry is updatable, and so is the form. Thanks for your assistance. Wally

Forget the one above, I've copied from the DB I was working on and it's incomplete. It may not make all the difference, but here's the complete SQL SELECT tblNewApplication.PDNumber, tblNewApplication.PriorityDocument, tblNewApplication.PriorityDate, tblNewApplication.Title...

I'll try the SQL first. The DB is too big to upload and I'd have to strip it first. I'm hoping this will give you an idea of where the problem is: SELECT tblNewApplication.PDNumber, tblNewApplication.PriorityDocument, tblNewApplication.PriorityDate, tblNewApplication.Description...

Oops! Sorry, I thought you did. No, if I open the query it's not updatble, i.e. I don't have an empty record at the bottom. I don't get the error message as I wouldn't have a clue as to where to add a record in the query Like I've just answered to Mile, I'm actually using a new record button...

Hi Mile-O-Phile, The piece of code you suggest is exactly what I've got there. I see why you think I'm just moving through the records. That's my error, I've actually got a 'New Record' button there. That's always worked OK but not anymore. At least not on the new form. The old form, based on...

Hi AncientOne, 1. I'm using my form to add and edit records (at least, thats what I used to do and hope to do with this one). As far as I now my form is editable, i.e. I've done nothing different to these frms from what I used to do and I've always been able to add and edit. Update query? Do...

Hi all, Today I've made a few new forms in my DB that use a query as a source. Forms work fine except for one little (?) thing: I cannot create a new record on any of these forms!! I get the following error message: "You can't go to the specified record. You may be at the end of a record...

Problem solved Thanks GHudson, Rich and AncientOne for your advices and explanations. With a little more fiddling I've got it working now. :)

Thanks for your suggestion. I gave it a 30 seconds try and got an error message probably due to interference with some other code. Í won't have time before Sunday to work on this but will give it a serious go then and will post the result. Thanks for your help, Wally