Search results

Glad to be able to help! Yes, Hampshire born and bred ...

I think if you store the data in the TABLE as a hyperlink then when you click it it should open up an email in your default mail program? enter the data as mailto:me@hotmail.com or get user to enter just me@hotmail.com then run an update query on the table to add the "mailto:" prefix to each...

I have tried to extract the relevant Form and Code to the attached database. Hopefully you'll understand what's going on, but to make it work you'll need to create a few databases (all copies of the same original, with different names) and park this FE and all the BE's to a folder called...

Seems like the Time() function overrode the Input Mask setting!

ok try Default Value = Left(Time(),5) Just tried it and it seems to work.

OK ... I had some help from this Forum creating what I call a "Database Switcher" utility. This varies from your requirement insofar as what I needed was simply to change the NAME of the linked _BE file as I have a FE Database that needed to link to multiple Client BE's (to safely segregate...

You could perhaps export the data from a QUERY (based on the Table) rather than the TABLE itself??

What format is the Field in the underlying table, where the Date is actually stored??

Cleverer people than me will give you the solution you've asked for ... all I would ask is why you are managing files in this way? This simplest route to glory is for all users to use a common folder on their hard drive or for you all to use the same BE on a shared server. This way no-one has...

It's not at all clear from your text where the "check box" comes into play. Can you give a little more detail?

I would say:- 1) You certainly don't need another database 2) The BE doesn't even need to be read-only 3) You can effectively control what the Client views, edits, or adds by use of Forms restricting which tables (and which fields within the table records) they can add or edit data Hope this...

If using Access 2003 :- File>Export>Enter File Name>Save as Type>Text Files>Export All>Delimited>Next>Include Field names on First Row>Next>Finish

Use individual APPEND queries to map and import data from your various data sources. To avoid reading in duplicate records, link the Source Data table to the Database table using one or more (unique) fields and using the IsNull criteria against those same fields in the Database table.

'(tblMasterPersonnel.FirstName)="042" Or (tblMAsterPersonnel.EmpID)="044"))'. Try removing the last ")", as above, possibly even the one before as well ...

So, just so I understand, your subreport calculates and displays the correct value ... and you want a Text Field in the Main Report to display that same total is a pre-determined place?

Could be that different printers are causing the issue? To test, point the Runtime and the Full Licence at the same network printer as see if there's still a difference?

I would take steps to ensure that each record in each of the 265 expected files has a text field which identifies which team (from 001 to 265) has submitted the data. Plus, and additional text field indicating which Month each record belongs to e.g. 2012_07, 2012_08, etc. With these two fields...

I wonder, is the blank required field being using as a Parent field on the Main Form to link to a Child field on the Sunform? This might explain the symptom at least ...

Certainly, in earlier versions to 2010, you would as part of the routine be asked to create a NAME for the table and then get a confirmation/successful message. Are you getting these messages?

Have you simply omitted an "=" sign? Current coding: 'tblMasterPersonnel.FirstName"042" Or (tblMasterPersonnel.EmpID)="044"))' Amended coding: 'tblMasterPersonnel.FirstName="042" Or (tblMasterPersonnel.EmpID)="044"))'