Search results

Thanks for the reply noboffinme. Your answer is along the lines of what I had expected. I broke down and did it the old fashion way. At least (I hope) this should be a one time issue.

Excel 2007 Once again I have been asked to do something in excel - anyone that knows me understand that I do not get along with excel :banghead:. VB and Access yes - Excel just messes with my mind :banghead: Ok here is what I need to do I have two sheets. Sheet1 has 4 columns... Customer...

Don't think this reply was meant for this question - LOL

Thanks Brian - I'll give it a shot and see what happens.

Access I understand - Excel I am almost clueless in :confused: I have 3 columns in a spreadsheet. Column A is numbers (1234), Column B is numbers (4321), Column C needs to have a formula that returns true of false based upon the numbers in Column's A and B. If possible this needs to look at...

Just what I needed on a Friday…Man, I can't seem to stop laughing. It has been like uhm…5 minutes, like well maybe 3 or uhm maybe like uhm 12 minutes now - but I have now been able to get my eyes to stop watering but why are my cheeks still stop hurting. And yes I live in the East - and after...

In the query for your report have the criteria for your order number set to the following. [Forms]![Form Name]![Field Name] This tells the report to open based upon the order number that is in current form. Form Name = the name of your form Field Name = the name of your order number field...

Good to hear you have it working. Glad I was able to help.

I am not sure if you have this working or not. However... There are several ways I do this...(neither may be the best way...but they both work for me) NOTE: I don't set the combo as Hyperlink on either. The First Way - I use this method if the URL is to be entered into the table without...

Glad I could help.

If you want to have the macros converted to code...It's actually easy to do. While in design mode of the form - click on Database Tools on the ribbon Then on the left side click on Convert Form's Macros to Visual Basic (this will convert all macros in the current form to code) Don

Not trying to step on HiTechCoach or anything... However, below is yet another way of doing this. If you are opening the new invoice using a button you could add the following code to the OnClick event of the button. DoCmd.OpenForm "NAME_OF_FORM_TO_OPEN", acNormal, "", "", , acNormal...

This may not be the only solution however, it's the only solution that I am aware of... It is Open Source and free... http://www.pcesoft.com/Access-Spell-Checker-Tool-Source-Code.html

After playing around just about all day with this thing...I figured it out... And to think - in access I could have create 1 query, 1 report, done some copy and pasting and change a few little things here and there and I could have had it finished in less then one hour... I still have a ton of...

I am using Excel 2007 - most of the company is still on Excel 2000. I can do this rather easy in Access however, the Boss man wants it in excel and I have basically zero knowledge of excel. Anyways what I need to do is this. If you look at the attached sample you will see a sheet called...

Glad I could help...

It sounds like the properties of the orginal file itself may have been set to read only. Right click the file...go to properties and see if is has been set to Read Only. I have had this happen several times...

You should be able to do something this like this to copy the field into the clipboard... Me.IPAddress.SetFocus 'Set the focus to the filed holding the IP Address... DoCmd.RunCommand acCmdCopy 'Copy the field into the clipboard... Call Shell("C:\Program Files\PATH\TO\SecureCRT.exe", 1) 'Open...

I am assuming you are using a query to do the import…To stop the error messages try this… DoCmd.SetWarnings False ‘This turns the error messages off DoCmd.OpenQuery "qryYourQryName", acViewNormal, acEdit 'This is your qry DoCmd.SetWarnings True ‘This turns the error messages back on

Tom Good to see you got it working... I would have answered you yesterday but I have just been covered up... At least you are working now... Glad we could help...