Search results

Access 2000. I have table of many hundreds of records. One of th fields of text looks like this: XXXXXXXXXXXX and I want it to look like this: XXX XXX XXX XXX by adding the spaces. Would someone please show me how to write the function or code to add the spaces to the text as shown : Thanks :o

Hi FoFa, Yes, I have experience with this technique. I guess I have been looking for the Holy Grail of comboboxology. I have been presented options by better programmers than I whose ideas are also similar to what I have tried in the past. I guess I will have to just stick with what is...

I have an Access 2000 database with a Customers-Order form scenario identical with the Orders form in Access’s Northwind (NW) Database. Whereas the NW database has about 91 customers that are accessed from the “Bill To:” combo box, I have several thousands of customers. I find it very...

Thanks Newman, that worked! Giaruso

Access 2002. In a Customer's table, I have separate FirstName and LastName fields. The form's Record Source is a query based on the Customer's table. At the form or query level, I also display the first-last names concatenated. I need to ensure, using code, that the FirstName-LastName, when...

Access 2002/2003. I have inherited an old Access 2000 database where one of the fields in the table had a Number data type with TEXT in it. I noticed the wrong data type and I change it to text. All appeared OK until I attached a combo box to this field. When clicking in or opening the combo...

In a bound report, I have two bound controls (names: txtEndTime & txtStartTime) and an unbound calculated control (txtElapsedTime). The two bound controls have General Date as their format property. The unbound calculated control's Control Source contains...

Mresann, too kind, thanks much. Giaruso

I am using the two lines of code below Each in separate columns of a query (or two text Boxes on a form) to calculate the elapsed time between two dates formatted as General Dates. The first line of code (in column A, "txtTime1") calculates to the total minutes between the two dates, the...

Thanks Andy, I'll give it some thought. Denny G.

Thanks. I want to synchronize Combo Box A (on the main form) with Combo Box B (on the Subform). In this case, Combo Box B is dependant on selection made in Combo Box A. All this AFTER Combo Box A has selected a specific RECORD in the subform. Denny G ;)

I have a main form with a subform. On my main form, I have a combo box set to "find a record on my subform, based on what I select in the combo box." This works great! At the same time, I want to use this main form combo box to synchronize with a combo box in the subform to display a value...