Search results

Thank You !!

Related Question Please forgive me for taking this thread off on a tangent, but I have been trying to find information on Phone Numbers and found this thread. What Data Type works best for Phone Numbers? I have tied to use "Number" (Long Integer & Double) I have also tried "Currency" I keep...

re: No Accounts Yes, It is back on. I have done all this since the web was re-activated. Sorry if I didn't state that more clearly in my last reply

More Info I am sure that my ISPs system is compatible with Outlook. I installed Outlook as part of my Office Professional 2003 suite on a Dell PC running XP Pro. One interesting coincidence, I have a high speed connection through my local cable company. Internet service for my area was down...

My ISP morphed to a new company, forcing me to change my email addresses. When I went to the email account window to create new accounts for the new addresses I could create the new accounts and they test OK. When I access the emails from the ISPs web site I can find the test emails. I have...

Thanks, I will give this a try.

Late Reply A quick apology, I took some time off, then had a crisis at work. Please don't take a two week gap in my reply the wrong way, I really appreciate the feedback, from you and this forum. All the incredibly bright people who contribute to it really humble me. I need to be able to...

Thanks for replying As I mentioned I want to do this from an Excel worksheet. It didn't seem as hard to create the original record set as it is to modify an existing record. It seems like there's a lot more secutity involved, which probably makes sense. I have been trying to go through "Help"...

I have made several attempts to do this, my most current attempt follows, I get "Runtime Error 424 Object Required" at the highlighted Line. Researching this error code suggests that I am not declaring a variable properly. Any help with the variable declarations, or the Object /Properties I am...

I am a rookie when It comes to Access Excel and writing bits of code to share info between these applications. Most of the problems I have seem to center around defining Objects and Properties. Is there a place where I can find a list of common objects/properties for Access, Excel and other...

I want to do exactly what a "Find Record" and "Save Record" comand button would do, but with Code. I need the Object/Property to do this. Specifically, I want define a Record number based on a variable, modify the record, and then Save the record. (The Record number is a Primary key.) Dim...

I can take information from an Excel worksheet and import it into Access by specifying a path to an existing table and using DBS.AddNew to add a new record. I update the table DBS.Update and save the Primary key value to a variable which I return to the worksheet and add as a record number...

I need to show a daily log of events. This is currently a FileMaker Pro DB but will be converted to Access some time in 2007. Along with that, my boss wants to be able to display announcements that he would add from time to time. So I need to make posting announcements pretty easy to do and I...

My boss wants me to figure out a cheep way to put a screen crawler at the bottom of a monitor that displays the status of some systems. I was thinking that there should be some way to do this with MS PowerPoint. Has anybody out there ever tried to do something like this? I know there is an...

I want to Open an Excel file with an AutoOpen sub fron Access, I am currently using a CreateObject statement to do this. I can open the Excel file with no problem, but the AutoOpen sub doesn't run upon opening the file. The first part of my question is:Why doesn't the AutoOpen sub run when...

Thank You. Between your info and more searching in this group, I was able to get the Worksheet to open. But It still Isn't running subs called in the AutoOpen subroutine when I open the spreadsheet from the Access form. Private Sub cmdAddDoc_Click() 'On Error GoTo Err_cmdAddDoc_Click MsgBox...

So do I need to replace the term "get" with another term...like "Open" or "Start" to open a closed file? (Those two don't work)

Upon returning from a vacation I was notified of a problem with a form in an Access file. I have a command button which is supposed to open an Excel workbook used as a data entry form. The Excel file has an "Auto Open" sub that clears the form upon opening the Excel file. Here is the...

Thanks a lot!! Sergeant, That code was just what I needed. I only had to nudge it (gently) and it worked like a dream. Again, Thank you

I have an Excel workbook that several groups use as a template. I don't want the users to accidently save their (completed) form over the template. I have a form that is visable OnOpen that requests a new file name, then saves the new file in a specific folder for each group. I would prefer to...