Search results

I need to import an rtf file into excel, there must be a way to do this, any idea's

I tried it and still get a list of the same item numbers. I only need the most current date returned, not all the other dates. Are there any sample databases anywhere

My table has the following fields ItemNo Name ImageName DateRecd 123 Foo 00123.jog 1/1/06 123 Foo 00FOO.jpg 10/11/06 123 FOO FOO123.jpg 7/5/04 456 bar 00456.jog 6/10/06 456 BAR...

I don't think this can be done,but here it goes, I have a purchase requisition database, when the PR is approved an email message is sent to the user, it would be user for the user to click on a link in the email and get the report they require, verse manually going to the datebase and being...

Not In ("unknown","none","various") works like a charm Thanks

I'm uisng a crosstab query to give me the top 10 rejects in a query. I want to omit "various", "none" and "unknown" I can get the criteria to not show "various" by using Not "unknown" but when I try and add none and unknown to the statement they show anyway, I've tried Not "unknown" Or "none"...

I'm trying to create a query, (looked at Northwinds query top 10 most expensive and I don't get it) that will sort through thousands of records and tell me what the top 10 rejected parts are. I'm guessing for starters a cross tab, which I think would summarize and then some how extract the 10...

I'm trying to disable users from right clicking, from within a combo box and selecting paste. The following code is suppose to work Private Sub DESCREP_DESCRIPTION_GotFocus() Application.CommandBars("Form View Control").Controls("Paste").Enabled = False End Sub but it doesn't work, any...

I have a form that I want to Displays random messages / Tips / Reminders etc. It works (subform) except now I want to call the popup form from another form: this is what I have: This part doesn't work Option Compare Database Dim showtip As Boolean ‘Defined as Boolean so tip only displays once...

You rock!!!!!!!!!!!!! I tried the form fFindOpenImportfile form and I was actually able to see a pdf and open it. It works in 2003, do you think I could use the code in 97? I totally agree with the Active X thing. One other database I had created in a multiuser environment, I ran into the...

Thanks for all the time to help me - greatly appreciated. I tried to insert Microsoft Common Dialog Control, and it's telling me I don't have the license required to use this active x control. I searched on how to install it and its says to select "register". THere is no dialog box for this...

Long story short, I need to have a command button (using xp) open up a folder where pdf's are stored, so the user can search. (orginally I wanted a pdf to open, then I tried having explorer open, so this is my last idea I've tried a lot of the code in the archieves but none work exactly. For...

worked like a charm - thanks

How do I write this, I do know the code needs to go on the before update of the form If a quanity is entered then defect_descripion must contain something. I've tried: If quanity <=0 then defect_descripion not null or defect_descripion ="" msgbox "you must select a defect descripion" I...

I am hoping to accomplish having access calculate turnaround time, but I'm not sure it can be done with the way I set up my database. I have the following fields: DateIn (system) and Timein(system) which time and date /time stamps when a request is entered. When the request is closed a...

I'm doing something wrong, as this isn't working for me. I have 2 fields on a continuous subform Quanity and Defect_description, if a Quanity of larger than one is entered then a Defect_description must be selected. Defect_description is a combo box. I put this on the before update of the...

pdf's? This works great. I tried it with jpg and it works too, but I've tried to do it with pdf's and I get a message the field is to small to accept the amount of data you attempted to add. The pdf is one page. I increased the image picture area to accomodate a 8.5 x 11 page and I still keep...

I have a field, integer, that needs to be exactly 6 characters long, no more, no less. How would I set this?:p

I don't think this can be done, but.... Is there a way of setting a hyperlink to open the correct report / or record from an email or document? I have a db in which the purchasing dept. send an email out when a PR is approved. The user then has to go to the db, login, go through at least 2...

I'm stumped, and assume the answer is easy but.....I have a number field, <number> w/4 characters. For data entry the users need to type in 4 numbers from a card. I made the field size 4 and made it required, but how would I stop the user from entering 3 or 2 characters?