Search results for query: *

To clarify we are using Voicemail Pro. Their are three modules listed. Overflow Over Flow Out Over Flow In *84 using the :Over Flow Out" to sets the user varible to "OUT" and the Overflow module has a True/False Test User Variable, if user varible is set to "OUT" which is true, then it is set...

My receptionist has asked for a short code be setup so she can put all incoming calls into the General Voicemail box when she leaves her desk for a few minutes. She mentioned that *84 was the code she used in the past but it is not working. When I lookup the *84 code its settings are: Code...

Gerry, I was looking into that option as well. However, we have a default location where the word files are copied from. Once copied they go into their respective project directory. Copying the word files and the .txt file from the default directory to the project folder is it going to...

Skip, Thank you for making me aware of this. For whatever reason, I never realized or seen the link to "Thank "Screenname" for this valuable post!" I have no problem doing that from now on. I should take the time and go back to my previous post and give the credit where its needed.

Does anyone know of a way to setup a header in a word file that reads its header text from a txt file? We have a system in place that contains around 277 individual MS Word files in one folder. A user will go into this folder and copy out the individual word files they need for their project...

I changed the query syntax to: FirstLetter: Left([tblProducts .prodTagID],1) Works now.

I have a report based on the following Query: Field: prodTagID Table: tblProducts Field: RoomNumber Table: tblRooms Field: Quantity Table: tblFunitureSelection The report is grouped on prodTagID. The product tags contain the following values: A101, A102, B101, B102, C101, etc. I want...

I thought I had this database working exactly how I wanted it to till recently. I have a form with a subform on it for selecting products. If a product is selected in the subform, saved, and then later deleted it does not delete it from the table, so when I run my report the entry still exist...

SumOfQuantity text box control source: =Sum([Quantity]) Quantity is numeric type as well as ProductPrice. Still looking for assistance.

txtTotalCost is located in in a group header which also contain the SumOfQuantity and ProductPrice text boxes. SumOfQuantity is set you stanard format and ProductPrice is set to Currency format. I was putting the txtSumTotalCost in the Page Footer.

Version: Access 2007 I have a text box (txtTotalCost) with the following control source: =([SumOfQuantity]*[ProductPrice]) on a report However, I want to calculate the total sum for all these text box values but I get the #Error. I created a new text box (txtSumTotalCost) and entered the...

Sounds good, thanks for the response.

Duane, Still having a bit of a problem when I set prodTagID and RoomNumber in the tblFurnitureSelection as indexed. When I go into the table design view and click Indexes from the tool bar it shows the following: Index name = PrimaryKey Field name = FunitureSelectionID Sort= Ascending...

Recreated it using the query wizard and the totals are calculating correctly now. Very odd. I notice the new query did not have any sorting options selected, so not sure if that was causing the issue or not.

I am trying to calculate the total number a product is selected based on the following table fields: prodTagId Quantity I created the following query: prodTagID sumQty: Quantity tblFunitureSelection tblFunitureSelection Group By Sum Ascending...

Just a single project record. The DLookUp worked out well. Thank You

Sorry title should read, Table information in REPORT, not form.

I have a table that hold "project information" Project Number Project Name 1 Project Name 2 Project Street Project City Project State Project Zip I would like to have this information appear on my reports in the header. When I "Add Existing Fields" to the report it wants to create a...

I missed this in your previous post: "You should probably set a unique indext on the RoomNumber and ProdTagID fields to prevent duplicates." I went into the tblFunitureSelection and set the RoomNumber field and prodTagID fields to "Indexed Yes(No Duplicates)" but after doing so I realize that...

I had to rebuild my form/subform and it seems to be populating correctly. I'll need rework my other forms I had setup to create the Typical Rooms so hopefully with the information you have provided me in this post, I hope I do not struggle with it too bad.