Search results

...here's a more difficult one - I hope! We use a database application at work which is normally opened in a web page, using a link. I don't know anything about the application itself, but I have (legitimately) been provided with some javascript that will open a specific record within the...

You didn't! I'm embarrassed enough, anyway! :o:o:o

Done that! Thank you for the heads up! Pete

Well, I'm glad you all noticed my deliberate mistake! I definitely need a new pair of glasses. Cheers, Pete

Hi stopher, Code, as requested. I did try to define the text data as String, but I kept getting errors until I changed it to Variant.... Private Sub cmdAddRecord_Click() Dim dbsWhatever As DAO.Database Dim rstTableName As DAO.Recordset Dim strNewAuthority As Variant Dim...

I have a form for users to enter data which is saved to a table, but the dta in one of the fields isn't being copyied over, and I can't see why. tblApplications has these fields: Location - (Data Type = Text, Field Size = 255, Format = @, Required = No, Allow Zero Length = Yes, Indexed = No...

Oops. Typo in calling the function! Works perfectly now. Sorry Pete

Hi. Taking advantage of other questions asked here, but I don't seem to have this working properly :-( I've copied and pasted the code and followed the instructions, but is seems the corrections are automatically carried out by Access? Having said that, the very first letter of the sentence...

Erm, I think the answer to my question is 'Yes'? It seems to work when I Close the form. Silly me!

I think your question's rhetorical, but let me explain a little better and see if I am getting... I can open frmZ from both frmA and frmB. To ensure I go back to frmA or frmB when I've finished with frmZ I need to use the OpenArgs function. To do this, I add OpenArgs to the end of the DoCmd...

Sorry, but I'm definitely missing the point here. If I'm adding the code to the Unload event procedure, how does that tie in with the Click event of the CommandButton on frmZ? Thank you (and for your patience!)

Got it, thanks. I'm probably missing something here, but how do I get back to the original form? I would use the On Click event procedure for th CommandButton, so is this where I'd use String from the OpenArgs? Thanks

Thanks arnelgp, but can I use that and use a criteria argument, as well? Pete

Hi, I have a form (frmZ) that can be opened from one of several forms (frmA, frm B, etc.) When I close frmZ I want to goback to whichever form it was opened from, but (as usual) I'm struggling :o I was thinking of using the CommandButton OnClick event to get the form name, but I don't know...

All done, thank you Isskint. Big hugs, Pete

I probably gave the impression of confusing myself (which I'm really good at :)), but I got there in the end! Thanks for the comments, though. They did help!

Hi The form is used to review all records, one at a time, so I was hoping to replace the ComboBox with a TextBox purely for 'aesthetic' reasons. When I add aTextBox to do this I get the Code rather than the Name of the Authority, so I was thinking of using DLookup rather than coding it with...

...as most things are - when you know the answer! I have a form with a ComboBox from which users pick a value. The control source is separate from the form's data table. I want to use a 'viewing' form so users can see everything, but not change it. I would like to change the ComboBox to a...

Thanks for the advice. I'll go and see what I can do with it. Pete

Brilliant, thank you :-)