Search results

Oh, I see. Brilliant! Thanks. :)

Would I use that function in the form OnClose event? Sorry, I'm a bit of a novice at all this, how do I use that in conjunction with error messages and then send the user back to the form if they haven't filled in something important? Do I just put the focus back to the relevant control?

Sure, they work with the following code: Save and Add New Record Private Sub SaveAdd_Click() Me.LoopVal = CalcFourLoop(AccDescAVal, AccDescBVal, AccDescCVal, AccDescDVal) RunCommand acCmdSaveRecord DoCmd.GoToRecord , , acNext End Sub My aim is to save all the form input and open a new record...

Yes, I've got three buttons: Save and Add New Record Save and Exit Exit without Saving

Maybe, how do I do that please? Is it on the form exit event?

There's a group of fields at the start of the setup process for populating a database of items, I need them all to be filled in before saving the item, these key bits of data are used in lots of other menus and queries in the database. It's basically like the form you use at the start to...

I am using code like this to give warning messages and pass on focus to boxes only when things are selected. Private Sub TextBox2_Exit(Cancel As Integer) If IsNull(Me.TextBox2) Then MsgBox "TextBox2 cannot be left blank" Cancel = True Else ComboBox1.SetFocus End If End Sub I do this...

Thanks, but presumably that's form-wide is it? I only want to give a friendly error on certain fields. Can someone please tell me what the validation text is for the following rule please? "Only allow numbers (negative or positive) with a decimal place in any position." Thanks!

I want to put a friendly error message when that happens - is there a way to do that other than through Validation Text?

Tearing my hair out trying to find any help from any source (despite loads of searching and looking in books!) showing me how to make a validation rule for numeric values including a decimal place, eg, I want to allow double values. I have the table field set to Double, but I need to do the...

It's empty at the start, so I assume it has a Null value at load, but is there a way to check that please? I'm not sure what you mean by 'width of the first column', which property is that in the property list? The column count is 2 and the bound column is 3.

You mean select the control, press F4 and put that expression @;"enter some value" in the Format field? Nothing happens. I checked this page and it just says put the string in quotes and off you go, but again, no effect...

Hi everyone. :) I have several combo box fields in a bound form where they are selecting values from a list (values stored in a separate table) and then loading a number into the bound table field when selected. How can I put a text prompt in these fields when loading the form which gets...

That sounds interesting, thanks, I will try it. Where do I store a Module in Access, does that have to be associated with an event from a form or a query or something, or is it separate?

Hi, I have to do a formula based on the input in four fields and display the calculated value in a report. I only need to use this calculated value in one report. Is the best way to do this to use a calculated field in the table where the four fields are located? Or should I be thinking of...

Ah, that's interesting. You mean put that in the on click event of my form's save button?

Yes, I know how to do it via a popup form. I don't understand your point about being able to use multiple record sources for the same form but dependant on opening criteria. Do you mean do some VBA when the form is opened to decide which recordsource to bind the form to? That's not the same...

I don't think you can set multiple record sources for a form without using subforms? Or do you know how? A query will only add to my nightmare as the record source is large and complex. I think the answer is to use another little popup form, but I was just wondering if there was some VBA method...

Aha! I didn't know I could have more than one record source for a form. On the Property Sheet for Data, Record Source only seems to have one entry possible? What is the syntax for adding another table there please? EDIT OK, been looking this up and you are talking about using a Query as the...

Afternoon all. :) I can't quite imagine how I do this. I have a form AddNewEquipment. This is bound to a table, EquipmentDetails. EquipmentDetails has a Yes/No field, 'ParentChoice'. So when EquipmentDetails.ParentChoice = Yes, I want to open up a new text box, AddNewEquipment.ParentDescr...