Search results

Have you tried this approach http://www.datawright.com.au/access_resources/access_tips.htm#tip_boot_users

Same for Massachusetts. I think the early settlers in New England and Eastern Canada brought the names with them from Britain. Hence the same pronunciations.

You are referring to ordinal numbers. Here is one link from a google search. Not sure where or how you are using them. http://www.accessforums.net/forms/ordinal-number-format-14242.html

You have tried to copy and paste a row number and not the values. That is why Excel has errored. Try this: Private Sub Rect143_Click() Dim LastRow As Long Dim FirstRow As Long Open "C:\temp\TESTGC.XLS" For Input As #1 'open 1st excel file LastRow = ActiveSheet.UsedRange.Rows.Count 'capture...

There is an alternative method to doing this if you have created your query in the QBE. You can use the transferspreadsheet method. Read here to get started: http://accessblog.net/2006/07/export-to-excel-range.html If you are unfamiliar with transferspreadsheet, then look here...

Here is a solution that you can use in a query. Then make the query your record source for your report. http://www.datapigtechnologies.com/flashfiles/percenttotal.html

Dick, I am interested in helping, but do not want any money either. Suggest you let the whole board help on this as many heads working will solve the issue. For confidentiality sake, you could copy the db and sanitize the personal information and then upload the sanitized version for the sake...

A VBA procedure could be written to mimic exactly what Mike has done in the video, but one would need to see the current table with sample data to ensure that it works properly. It would entail many lines of code but is possible. Unless this process is to be repeated on a regular basis, ie...

Dick, No file available. I think that you need to sign up for media fire in order to access it. Only able to view their marketing of the site. Suggest you try something like Box.net where it is free to post and share.

Here is a method to remove duplicates. http://www.datapigtechnologies.com/flashfiles/duplicateproblem.html

You could create a new query. Bring each of these queries into the new query. Join them on the name and bring the fields from each onto the grid as well as the names.

Here is a sample db that lets you determine which field (only one) you want to have in your query. You should be able to adapt this to a list box of check boxes to do what you are looking to do. This is just a means for you to see a methodology. Additionally, here is a link to a search form...

Suggest you upload your db with dummy data, so that we can examine and analyze it and provide you with a viable solution. I have no idea what the error message means. Sounds like you may have attempted an update or append query instead of an aggregate query.

Create a new query using the existing query as the record source. Add the table that contains the staff names used in the form combo box. Join the names from the table to the query. Drag the name field from the table onto the grid. In the grid, drag the staff driver and the staff passenger...

First, you will not be able to import your Excel table as it currently stands as it is not in a table format. I will not be able to open your Access file until later today as the machine I am working on currently has only AC2003 loaded. I would urge you to read the following link before...

No file attached.

Here is somthing I found a year or so ago that may be helpful

Have you split the db into a FE and BE? Read here http://www.databasedev.co.uk/splitting-ms-access-database.html

Dick start here http://www.databasedev.co.uk/querydef.html

Attach this code to a command button: me.yourtextboxnames.value="" me.requery