Search results

Hi I have a CSV file with a number of records therein. I import the file into Access and I DROP all unwanted columns. But, I also need to add a couple of columns too. Here is a summary of the tasks I need to complete... 1) ADD a date (simple enough) column - but I specifically need the date in...

Just solved it... in the button event - Prompt the user to confirm the addition of the new record - temporarily change the forms AllowAdditions property to TRUE , add the new record, then change the property back again..! nVar = QuestionMessage("Add New Record?", "New Record Prompt") If (nVar...

I am using a table to hold data relating to 3 very similar products, one distinction is that one of these items has a value in that remains constant. If I set this field to have a default value at table design level - all 3 units get this same value, which is incorrect. I am using continuous...

I am cleaning up a database that has been around for some time and I wish to be able to check for references within REPORTS/VBA Module code/ Form Designs etc. anywhere there is likely to be a reference to either an Access TABLE or QUERY.... I know there is the 'Object Dependancies' function...

I have a Sales report grouped by Customer that shows annual sales figures for each. When the report runs - the database user is prompted for the 'Start Year'. The reports retrieves data for all years from Start to present year... I wish to be able to visually illustrate the Trend for each...

Thanks Bob - I am using Excel 2007, where is this Wizard feature you mention? And will I be able to create a macro that I can run with every spreadsheet I create...?

I receive a CSV file from a service that provide horse racing data. I wish to work through the rows and using a simple cell value of say 0 to distinguish rows I want to avoid from those I want to keep. When I have worked through all the rows - I wish to be able to invoke a VBA function, to...

Thank you for your suggestion - it got me thinking and I decided to strip out of the race string, the first four letters of each Race Track name id. This was then the lookup value I search for in the array, also containing 4 letter track names for all unique race track names..... Much...

Thanks for your suggestion, the trouble with this solution as I see it is that the first param to MATCH is the lookup value - which in this case is the full race title comprising not only the race trackname but also distance and race time etc. eg. Race string = 12:30 Cork 2m4f Nov Hurdle So...

I have a list of horse racing data for UK and Irish races. What I wish to do is define a list of all IRISH track names -lets call this track array I wish to search through a range of all race results in range say (A1:A100) and return an "I" character where any occurence of track array is found...

Scratch that request ....with a little extra effort ...... I came up with... .... preceeded the AddItem call - with this, which seems to work fine.... Private Sub cboSpindle_AfterUpdate() 'update combo with new entry Call AddItemToEnd(cboSpindle) End Sub Function AddItemToEnd(ctrl...

I am using a sequence of combo boxes on a 'Continuous' form. To reduce the possibility of error I am using a 'Value List' combo box where I use AddItem method to add the previously entered string to the combo control so that it is there for use when entering the next record. This works fine -...

Hi All! I have a folder containing Word document files that are all titled with a 4 digit identifier..... 5012.docx, 5013.docx etc. I need Access to interrogate said folder and create a word document with the next number in the chronological sequence ... So if the highest number is 5013...

Having been able to work through the code - it seems that the sample does not actually fully meet with what I was attempting to do. The sample database advised, relies upon having a shortcut menu definition on the toolbar with full menu structure in place.... by definition this database uses a...

(...By 'downloaded file' I was simply referring to the SAMPLE DATABASE!) I have successfully loaded the database at my work PC, so can use this as foundation for what I have in mind. Thank you very much for your help here, a great help.

Are you able to let me know what references are included when you open the database on your setup please...? I have 3 only.. Visual Basic for Applications MS Access 12.0 Object Lib MS Office 11.0 Object Lib Thanks

Thanks for the link - but if I run the 'as downloaded' file - it doesnt run. (The project compiles fine) Also, if I EARLY bind in using the MS Office 11. Object Library (as stated in the code module)- same error results... "The expression OnOpen you entered as the event property setting...

I have searched in the Samples Database area - perhaps it is stored under something other than DYNAMIC or SHORT CUT MENU.... if anyone can qualify specifically where this reference is, perhaps you could let me know, t'would be a great help. Thank you.

I am using Access 2003 and have a custom shortcut menu. I wish to add some entries to this shortcut menu dynamically. Background : I am displaying a list of customer orders and wish to offer the user the facility to filter the search for one item instead of the default of ALL. The dynamic...

Thank you for your response. Your suggestion is an option, but to my mind is far from ideal. Because of the wealth of data that I am analysing (upto 250 rows of data per day), I wish to be able to reference the daily totals on the summary sheet with ease. With each MONTHLY worksheet having...