Search results for query: *

Thanks Tweetldee. I realised after I wrote the post that I needed a development package but I couldn't find an alternative to using ActiveX. I'll try out the windows API example you suggested. Thanks, cbd

I am trying to use an activeX control-Mircosoft Common Dialog Control- to use a Browse button to Open and Save files?, like in faq181-152. Unfortunately I keep getting an error that I don't have the license required to use this component. Does anybody know why or how I can get a license? If...

i have run into a problem. I believe you code is meant for a different version of MS Access. I have Access 97 and the compiler complains about the line: rs.[Risk Phrase Number] It gives the error "Expected: identifier or bracketed expression" Any ideas of how to over come this error.

Thanks for that. I'll try it out tomorrow and let you know how I get on.

Basically yes. I know it seems like an unusual thing to do but there would be only about 2-3 records in the subform for each record in the main form. Thanks

I have a form based on a table called "List of Materials". Within this form I have a subform(really its a list box) with only one column in it called "Risk Phrase Number". I would like it so that when i view the form as a datasheet I would be able to see the subform field...

I have three tables, "List of Materials", "Risk Details" and "Risk Phrases". Risk Phrases table contains risk numbers with the associated risk phrase. List of materials store general information about a material and Risk Details joins each material with its...

Is it possible to an item from an unbound listbox. At the moment when I click on the list box it won't let me select any item. The listbox has no Control Source and the Row Source query gets items from a table other than the forms Record Source.

I have an excel file with 3 sheets and about 40 graphs. The excel file connects to an external database when opened and populates the 3 spreadsheets with data. I have created a macro that automatically plots the graphs using the information in the 3 spreadsheets. My problem is that I want the...

Geoff, could possible explain your code in more detail. I am actually using Access to export the data to Excel. I am exporting the data to a sheet called "10mg" and I have a graph then on another sheet called "10mg Yield". Say the Category(X)axis labels is in column A in...

At the moment I am exporting a query from Access97 to Excel97. The data is exported into a template with various graphs. Every works grand but my problem is that the number of records that get imported into the spreadsheet varies each time but the graph source data requires me select a fixed...

I am afraid James Goodman that I am using Access 97 and the OpenReport method does not support Opening Arguments. Thanks for your idea mflancour. I actually did some thing very similar by declaring a public variable, setting that variable when the button in the form was clicked and accessed...

I am afaid that your code didn't work. The openReport method doesn't allow opening args, only the openForm method allows that. Have you any more ideas?

I currently have over 30 reports in my access 97 database. All these reports have the same layout. The only difference between each report is the record source query used to open the report and a label that give a title for the report. I am trying to use just one general report, changing the...

At the moment I am using an input mask on many of my forms to ensure that users enter data in the correct way. However users are complaining a lot because when they click on a box containing an input mask they have to ensure it is at the start of the box. Is it possible to force the cursor to...

Thanks for the help. It could just be the old computer I am using. I'll just ignore the error message as you advised.

I am using Access 97 to transfer records into an excel spreadsheet, I keep getting the follow error : run-time error '-2147417851 (80010105)' Method 'CopyFromRecordset' of object 'Range' failed The code actually does copy the records into excel but then displays the above error in Access. I...

I am converting documents from paper into a ms access database. Each document used to be signed off by the person that wrote the document and by a person who verified the document. I was wondering is it possible to have a similiar system in ms access 97. I have already implemented user level...