Recent content by DMHCCI

What would be the method for 2003Office?

Access 2000 running under Windows XP

Is there a way to select a printer with coding, or macros that is different than the default printer in Windows when printing access reports. I want to print labels on a special label printer that is not the default printer.

I have a field coming from a non Access Table defined as a text field with the data formated as mm/dd/yy (08/01/05 for example). I would like to be able to convert this in a query using some sort of date function so that access can recognize it as a date field for sorting and selection criteria.

Was looking for a built in function or coding that would allow pressing a button to browse for a file on local or mapped drives and store the selected full path name in a control on a form.

I am looking for a median function built in to a query such as: SELECT median(number_list) AS medianoflist FROM basequery; Access has Min, Max, Avg etc. Is there a way to run a query and get median - which is the middle number of a list: Example: 1 6 8 10 11 8 is the median (middle number...

Does anyone have or know where to get an Access VBA coding module that will encrypt a string variable using MD5 or SHA one way Encryption? Or any other ideas or resources with canned routines.

Thankyou very much. Works wonderfully.

I see what you are doing. What I need is a way to do something even more generic. What would be the syntax for a table? table(strtable).controls(strcontrol).value Any other forms of this?

Dim FieldName as String FieldName = "[forms]![client]![name]" &Fieldname = !last_name In the example above I want to be able to get the contents of [forms]![client]![name] updated by the contents of !last_name. The compiler rejects this syntax. Perhaps there is a different character or...

Is there any functions or coding samples available that can take a string of Characters and create a compact binary Number/PIN. The requirement would be that given the same string of data, it would always produce the same unique binary data. For instance if the string contained...

Thanks I see what you are doing but am unclear on the following: Do I need a separate Set for each query? Set rsA = dbs.OpenRecordset("[Query A]") Set rsB = dbs.OpenRecordset("[Query B]") And if so how would I alter your code to make sure I have matching records in Query A and Query B at...

Does anyone have a generic coding example or an online resource of a coding example that will do the following: 1) Read a record/row in TABLE_A (Transaction File). 2) Read a matching record/row in Table_B (Master File) based on a common key. 3) Perform Calculations Using fields from both...

Is there a way to call or run or launch an Access.mdb from an Access.mdb? I have a customer with multiple applications and would like to develop a Master Menu that would call up other access programs using buttons or links. I have been putting them in a folder up until now and making shortcuts...

For example I have a time field that contains a value 1:15 - meaning 1 hour and 15 minutes. I want to convert that to 1.25 hours and store in a decimal field. I started by subtracting a "start time" from a "stop time" field and stored the results in a "accumulated time" field. Now I need a...