Search results for query: *

I have a combobox on a MS Word userform called cboCustName which I want populated by a SQL database. I've already successfully created the connection and have populated the combobox with the correct data. My next problem is this: How do I pull more than one value into the combobox? I want...

Is there a way to export SQL Server diagrams to email to clients? I'm more used to Access databases, so not having the "Save Relationships Report" feature is odd for me. Thanks! "Sleep is the best meditation." - Dalai Lama

I am running an Access 2000 ADP pointing to a MS SQL 2000 database. One of my forms is pulling a recordset that is in the 15000+ records range. Under options for my ADP I have set the "default max records" to both 20000 and unlimited, but for some reason, none of these settings...

Hello, I have 1 table that looks like this Table XItem { TransactID TransactStatus nVarchar TransactStatusId Int This is all done in a MS SQL 2000 backend What I want to do is when a user updates either TransactStatus or TransactStatusID I would like the field to update the the other...

Hi, I'm a self-taught VB6 novice programmer and was thinking of going back to basics. I am planning to take an introductory programming course but am torn between which language to use: C#.NET or VB.NET I'm currently using Access 97 VBA at work, but want to get into more data-oriented...

Came across two nifty functions that enable you to find out the name and path of the currently open database for people using Access 97. Thought it would be of use. I mostly use it in the footers of my reports combined with the CurrentObjectName function to help me figure out which report came...

Hi, I have a form where the user enters some info into a text box and then clicks on a command button marked "OK" to proceed. They now want to enable a shortcut by running the same code when enter is pressed while in the textbox itself. So instead of typing and clicking the button...

Hi, I've been desparately looking for Access Snapshot Viewer 8.0 and have not been able to find it on Microsoft's websites. I am able to get version 9.0 but need version 8.0 If anyone can help me find a site that has it available for download I would be very appreciative! Thanks, Theresa...

Is there a function out there that will allow me to accomplish the following in a report: 1) Calculate time elapsed from one time to another (both medium time formats) eg. [EndTime]-[StartTime] 2) Then take the outcome and add them all together to get a total elapsed time in hours and minutes...

I have several automation routines that with one button click, sends data via email using Outlook. I now need to convert these same routines for our users who use Novell GroupWise. Do I need any specific libraries to control GroupWise from VBA? Does anyone know where I can find these files...

I keep getting this error message when I run several of my Word automation modules. Usually, I just end the runtime error, and proceed to run it again. The module will usually complete its routine without a hitch. Now I'm getting this error message 50% of the time, which is annoying my...

Is there a way to differentiate between the action of printing out a report and looking at a report in Print Preview? I have an OnPrint routine that logs the user and date whenever any reports are generated. Unfortunately, I only want to log users that have printed out the report and not those...

I don't know if this is possible but I wanted to know if Access can preload specific queries on startup. This is help aid load times of some of our forms which have rather large recordsets. There must be some sort of On StartUp event or preload command for the database. Theresa "Sleep is...

Hi, I am currently designing a replicated Access 97 database where using the standard security setup is not an option. I've therefore had to design a custom login for my users. I wanted to know if there was a way for me to grab the machine ID from where the user opened my replicated Access...

Hi, I currently run a database that has a "Meetings" table. I was wondering if anyone knew how to run a REPORT that would display these meetings in their respective dates. I need to show them in the traditional month by month calendar style to distribute to my users...

Hi, Every now and then I get a #Name? error in my database in fields where the Date() function is used. This is a quite a pain since I have forms that will not open due to important date calculations that they require. Does anyone know of any causes for this error and possible fixes for it...

Hi, Is there a way to get the following information from the database using the current date? Current Date + 2 weeks on a working day Friday (in Canada) Essentially, I want to find out what date is the date two weeks from now on the Friday. I've reviewed most of the other date formulae posts...

Hi, I have successfully been able to use Access to send out Outlook email messages, but now I'm curious about formatting those messages through automation. I know Access works well with Word to create nicely formatted documents but can you do the same with Outlook mail messages? I am...

I've declared variables in my code to equate a value at the beginning of a loop and wanted to "re-set" the variable to nothing at the end. Part of it looks something like: Dim dbs As Database Dim rst As Recordset Dim rstFilter As Recordset Dim GetDate As String GetDate =...