Search results

No worries, have a fun day!

Welcome to the forum! 3 databases? You mean tables right? You can use the Column property to bring backa value from a combo box, other than the bound column. As insomevaariable = combobox.column(x)Where x is the column number you want, starting from 0.

When you say status, you mean lock the record, right? By default, Access uses pessimistic locking, so that when the record is open on the form, nobody else can edit it.

Like tabbed browsing on the web? You can't add a new tab in form view, so what you'd need to do is create the maximum number of tabs you'd need and hide the ones you don't want to see. Then, as the user clicks on the next tab, unhide the next one, and so on.

Hi! There are a few do-it-yourself password threads on this site, might be worth having a search....

Also worth checking what the bound column number is in combo0. The Value property, I think, returns that. The other way to do this would be to subsitute combo0.column(x) for .value, where x is the classID's column number, starting from 0.

Have you tried dropping the itemdata line?

The navigation pane? Is there a little arrow at the top of where it should be? Or is there just nothing at all? If the latter is the case, there's probably an option to hide/show it somewhere... Thinking about it, does F11 do the trick?

Vista is a horrible, horrible OS for networking with other systems... I've had all sorts of problems but the first thing I can think to check is your network protocols on both machines. I *think* I solved this once by adding the Novell Netware BIOS one to both connections, then it worked fine...

OK. First thing I can see there is that you're risking the user choosing the wrong organisation by giving them the option to change it when you add a project. But anyway... What you need to do is have the Add Project form go to a new record when it opens, and just take the Org ID from the main...

Well... I'm just guessing really - but essentially, if you can see the remote PC in your network browser, you'll also be able to see it in the link table wizard in Access... let us know how it goes! One thing I can foresee is that you'll have to make sure the connection is open every time you...

Morning! Yes I believe you can, having had a bit of a google about it - I've not used SSH before, but if you can open the connection and see the remote computer through the network, you can link tables between two databases and share the info that way. That would definitely be the best way to...

Ah, I see.... well, anything's goiing to be better than a giant excel sheet :) OK - so, you're going to be emailing the DB between companies? One thing to consider would be file size I suppose...

It's the form in the subform control you're requerying, not the subform control itself. I think the code is subformcontrol.form.requery

OK - where I've put "SQL Statement with where clause..." I meant actually put your SQL statement in... Example:cbx_OrgName.rowSource = "SELECT * From Orgnames WHERE [Orgnames].[OrgID]=" & txt_OrgID & ";"What you need to do is have cbx_OrgName's row source as "table/query", create a query that...

Oh yeah... that's what I meant... :)

Sounds right, give it a go and see what happens :)

You'd have to set the row source for the combo box in VBA in the afterupdate property of the text box. So:If txt_LastNam is null then comboname.rowsource = whatever Else comboname.rowsource = SQL statement with where clause to filter based on orgid Endif

Bob Larson kindly helped me out with something similar in this thread:http://www.access-programmers.co.uk/forums/showthread.php?t=211105&goto=newpost

You could requery the subform when the main form gets the focus back to make it show the updated data, as in subformname!sourceobject.requery