Search results for query: *

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...

Is there a built in function or can I use acombinations of commands or code to take a name formated LAST,FIRST and out put a string FIRST LAST.

I have a text field that looks like 070-71000-5400 and I would like a function or macro to remove the "-" so that the end result looks like 070710005400 Thanks

Has anyone found documentation that describes the potential pitfalls or problems one might encounter when running access 2003 with an MDB that was created in Access 2000.

Thanks - I learned something

I am running Office XP Pro with XP pro OS. I would like to be able to enter a date as mm/dd/yy and have it assume mm/dd/yyyy. For example 060503 would be entered and 06/05/2003 would be displayed. I do not see a date format that allows this to happen. Do you have a work around?