Search results

Thanks Rx, I see where you're going on this but I have no idea what API Access 2010 is. In fact, i'd like to learn about all these acronyms somehow. I'm using ODBC PassThrough queries...if that helps? I'd guess I'm using ADO or OLE DB so can't distinguish between ERRORS or MESSAGES? Would it...

Try Forms!frm_Navigation_Form!PatientTab.SetFocus The tab control/subform shouldn't be referenced as it acts just like a control, not a subform lol

Refer to this when referencing a different form, in case my syntax is wrong: http://access.mvps.org/access/forms/frm0031.htm

Sorry, 'Control' should be the Name of the control to set focus to. But first try setting the forms focus. Forms!frm_Navigation_Form!NavigationSubform.frm_Patient.Form.SetFocus

Try setting the focus to the form, or a control on the form you want to show: e.g. Forms!mainform!subform.form.setfocus

Hello folks I've really started to embrace Stored Procedure and thought it would be good to validate within them too. I'd normally validate in a VBA function but I like the approach of having rules and business logic stored centrally within SQL Server. I shall have tables used within...

Hey, does anyone know how to determine an Outlook mail items date received property? Its nothing obvious like mailobject.received. Also, how can we find this out ourselves? There must be a reference library somewhere so I guess I'm not using the correct terminology. Thanks for any help :)

Indeed, many thanks! The labels button does it all for you, adding multiple columns and formatting it to label dimensions. Easy peasy!

I'm thinking about printing labels, 8 to a page - 4 rows 2 columns. Am I right in thinking this is beyond Access's ability? Cheers folks

Cheers, you're quite right it all depends on many things. I chose to keep it on the form as a record source, including adding a new record, but the VBA for this was far more than creating a separate unbound dialog form. I'm sure I'll keep learning and refreshing as I go. :)

Hey folks, it's been a while but I'm back in the development game again :D I'd really appreciate your thoughts... What really is the best way, programming-wise and user experience-wise when presenting records in a form: 1) Use the form with sub-forms to show records. Add new records via a...

This is great, thanks Chris! It's very strange how it will only work when you add the following code: Private Sub Form_Open(Cancel As Integer) Me.txtHighLight.FontSize = 24 Me.txtHighLight.FontName = "Terminal" Me.txtHighLight.Format = ";" & Chr(34) & String(250, 219) & Chr(34)...

Excellent, thankyou very much! I had to change a column already present so I just used the latter line. For the benefit of anyone else needing this, if you remove "UNIQUE" it will create an index that allows duplicates...and make sure you use different index names if creating more than one in...

Hey guys, I need to change the design of my table and make a field Indexed, both with or without duplicates. I think maybe TableDef is used but cant figure out how :( Im using 97 If anyone has any code that would be great. cheers Ian

No probs. Splitting would help, but then you may end up duplicating a lot, then this can become a nightmare to manage (and tedious to repeat). Maybe because its simple numbers and no large processes, Access could handle it.

100 users using MS Access heavily? :eek: My experience with Access gives me the thought that it may not work, or you'll get loads of problems. Depending on what you'll be doing, you should consider how you create new records. If you use AutoNumbers, 100 people trying to add records at the same...

I'd break each part of the SQL down and run them separately to see what kind of numbers I get. Any #Errors from the division can cause the overflow, as logically how can you order an error? :rolleyes:

Hey, I dont suppose anyone can recolect any software that performs as an interface for many access front ends? I basically allows you to create create small Access databases as Objects, and bring them together via an interface, thus making large database over multiple user groups easy to manage...

oops, see Multiple Database Interface :D

www.access-autopilot.com...just the job