Search results

Thank you FoFa. I am using Access 2002. Does it have the capability for RTF type fields? Or will Access 2007 possibly support such a function? Lately, I've been saying "Just wait until 2007 comes out. That'll make this easy." as my standard response to user's. :)

My form has a Memo field that stores "To Do" descriptions. My user wants to be able to add bullet points next to their entries. There could be multiple To Do's in a single field. Any help is appreciated.

Sorry for the confusion. BankRep is short for Bank Representative, that is someone who works for the Bank. Each client will have a designated BankRep and of course each BankRep must work for a particular bank. My problem is structuring a table so that a BankRep can be assigned to a Client AND...

I need help with my table structures. Attached is a Access 97 sample of my existing tables. Questions 1) I need a new table that shows which BankRepID’s are assigned to each ClientID. Currently the relationship between the Banks and their BankReps is normalized. But every time I create a...

Go to Tools > Options > Edit/Find and remove the appropriate checkmarks in the Confirm section.

Yes, I know it well. But it has been a mirage in the desert for me. Here is my AfterUpdate Code on the Subform: Private Sub Form_AfterUpdate() Forms![frmEnterTransaction]![frmClientCash].Form.Requery End Sub It works great when a record is modified but does nothing when a delete occurs. If...

This issue is still unresolved. Any help is appreciated. The only method I can get to work is a command button that the user must click but this is confusing since the form updates in all instances other than a delete.

Me is a shortcut to reference something. For example, rather than type the full path: Forms!Orders!OrderDetails.Form!TotalAmount You can use Me!TotalAmount Dwight

I have not been able to solve this yet. I have had no luck searching the Chart Options or the VBA Help files. I'm sure it is some simple setting I am missing. Any ideas?

I have a form that allows my users to enter transactions. The transactions are entered on a subform in datasheet view. At the top of the main form is a continuous form that shows a cash balance figure. On the After Update Event of the subform I requery the continuous form to reflect changes...

Take a look at the DateDiff Function.

That worked perfectly! The form looks much more professional now.....and I can cross off that TO DO. Thanks, Dwight

I would like to create a form with a double layered tab format that has the look and feel of the MS Access Options form under Tools. What code or technique is required to make this work? For example, how do I make sure when the user selects the front row or back row of tabs that only this form...

Open your query in design view. Right click on criteria for the field where the parameter will go. Click on Build. In the menu find the form with your text box on it in the Forms folder. Once you have that open click the text box. That's it.

Open your query in design view. Right click on criteria for the field where the parameter will go. Click on Build. In the menu find the form with your text box on it in the Forms folder. Once you have that open click the text box. That's it.

It is my understanding that the surest way to perform data validation is to use VBA code on the form where the data is entered into the table. By placing code on the form's Before Update event you prevent the user from inputting incorrect and/or incomplete data. So I suggest looking into this...

In Office XP at least you can run your report, then under Tools > Analyze it export it to Excel. The format will be horrific but it is possible. Uncle Gizmo has the best suggestion. Export your query (or table) using the Transfer Spreadsheet method in VBA. Dwight

The problem was the Group by on the day.

If you post a sample of your db I will take a look.

Look at Ghudson's Browse code to allow the user to select an Excel file on the form you will create. This will tell the VBA code the file path. http://www.access-programmers.co.uk/forums/showthread.php?t=97787 And take a look at the TransferSpreadsheet function in VBA to do the importing. Dwight