Search results

I can't open that website, can you copy the content, please.

I've read a lot about using FE/BE. What I'm not clear on is the limitations: What will happen if multiple users attempt to edit the same record? Are there any limitations?

Thank you. That is what I was doing, I was just hoping that it could be done using one query... I considered using a y/n field named Active instead of archiving, but decided against it because the users directly access the table (even though they know they shouldn't). I decided not to use 2...

Hello All Experts, Here's my latest question: I have a table I use to store archived records, the records originate from two tables (they are joined on one of the fields). This part works. The SQL I use is: INSERT INTO tblHistory ( SellerID, Surname, FirstName, Phone, Cell, Fax, Email...

You will find two complete articles with samples explaining all you need to know (and much more) at the following links. Unfortunately it requires a paid membership, but I think they do have a free trial. Cascading Combos Cascading Combos on Continuous Forms and Datasheets

No problemo.

Excel doesn't have the NZ function. Either add a reference to MS Access library, or create your own: Public Function NZ(ByVal Value As Variant, Optional ByVal ValueIfNull As Variant) As Variant ' Same as NZ Access function. Returns Empty if the parameter Value is empty or ' null, or returns...

You need a reference to the Microsoft DAO Library. From the Project menu, click References, and then select the Microsoft DAO 3.5 Library check box. If you don't want to manually add a reference on each machine you use the file, you can use late binding, see...

Impossible to answer without seeing the code.

.Text is the way to do it in classic vb. In Access you can only access the text property of a control that has the focus, thus you've runned into that runtime error.

Just remove the .Text part and your good to go.

That method will only work if there is no code on the OnCurrent event of the main subform. If some code does exist you must manually requery the hidden textbox (i.e. add the following to the OnCurrent event in the main subform: Forms![YourFormName]![YourHiddenTextbox].Requery).

Never mind, I sorted it out after some head banging. The method outlined in the above link will only work if there is no code on the OnCurrent event of the main subform. If some code does exist you must manually requery the hidden textbox (i.e. add the following to the OnCurrent event in the...

I followed the instructions for Synchronizing Two Related Subforms on a Main form at http://www.fmsinc.com/microsoftaccess/forms/synchronize/linkedsubforms.asp. For some reason the hidden textbox doesn't get updated as I move from record to record, and therefore the whole-thing doesn't work...

Thank you works well.

Tried your suggestion. It doesn't do a thing (never goes beyond 1).

where exactly to I requery the textbox, so it shows the correct number of selected records?

Can't get ti to work. It produces a #Name? error.

It has to go on the form's on timer event.

Ok my mistake. It still doesn't work, numbers are shown but they don't have anything to do with reality (never will it show less that 2, usually it shows numbers a lot higher).