Hi everyone
It has been a while since my last login, so pardon me if I posting this in a incorrect location.
My question is around the storage and versioning of an excel application.
This is vage to me too. I am just trying to come up with a strategy around an important excel application, that is used on daily bases by few people.
What is the smart way of storing this file, and where (just a folder with...
tara99
Last Activity: Aug 4 '08, 06:03 AM
Joined: Oct 20 '06
Location:
-
Excel Storage and Versioning
-
MS Word & VBA - Populating user input into a document (Word)
My question is in regard to writing VBA to automate things in MS word.
I have a template such as a letter to a business unit or some one which can be used repeatedly.
I have few fields in this letter and they have been repeated few times, what I want to do is to is to type those repeated words once only and want them to get populated across the letter.
I was thinking about to have few input boxes asking for those... -
No Mary it is string, but don't worry it is solved for the moment.
It was just the matter or deleting Me and using the variable that i had those two fields stored in.
Thank you so much for prompt reply... -
Syntax error in SQL Delete statement
strSQL4 = "DELETE * FROM ExecutiveRespon sibilitySecurit y WHERE [ExecutiveRespon sibility]= '" & Me.ExeResponsib ility & "' and [NetworkID] = ' " & Me.UserID & "';"
DoCmd.RunSQL strSQL4
I am trying to delete from a table.
ExecutiveRespon sibility and NetworkID are fields in the table ExecutiveRespon sibilitySecurit y
Me.ExeResponsib ility and... -
Adding all of items displayd in the list box to a table
Hi Guys
I have a list box which displays CCs from a table based on a query.
I have a text box for the user to input ID
I want to do the following
1. To allow the user select multiple item and enter an ID in the text box and click a button called add. Those selected CCs for that ID will be inserted in to a table.
2. to have a button called "Add ALL", I want this to insert all the... -
ERROR Message :Previous operation cancelled
I am trying to update a table. It works but at the end the system displays the following Message
"Previous operation cancelled"
Does any one know what does this means.
Thanks -
Mary I have tried those too but the value is never null it always displays the first selection.
I don't know why,...Leave a comment:
-
Thank you Mary
I am working on something else which needs to be finish the next 2 days.
But i will try the above code and get back to you.
cheers...Leave a comment:
-
Ok than, if that is the case I better saty with what I have now,
Thank you so much to both you Neopa and Mary for helping with my query.
Cheers...Leave a comment:
-
When you find the solution, let me know, becasue I have the same problem
Thanks...Leave a comment:
-
Try something like this behind your combo box's row source
...Code:SELECT table.servicetype FROM table table.service HAVING (((table.service)=forms!YourformName!Sevice-Combobox-name));
Leave a comment:
-
Hi NeoPa
I have created a form but it doesn't let me add anything just shows what ever is available.
The thing that I have done is too complicated to explain.
I will start from the very beginning that I have set up the tables and then move through to the stage I have difficulty with.
Please be patient
I have 6 tables and they are:
...Code:Server ---- Table [B]FieldName Dat[/]
Leave a comment:
-
Thanks Mary and NeoPa for your inputs
I have done that part,
Sorry if I didn't ask my question properly.
I guess my question is about the listbox size, how can I make it dynamic, to change its size depending on the number of item it holds (small/ big).
Does this make sense??
Is it possible.
Thanks...Leave a comment:
-
Thanks Mary
It is fine now...Leave a comment:
-
Hi Guys
I have used the following code
But there...Code:Dim strSQL As String strSQL = "UPDATE Applications " & _ "SET Owner = " & Me.NewOwner & " , Responsible = " & Me.NewResponsbile & " " & _ "WHERE Application = " & Me.Application & ";" DoCmd.RunSQL strSQLLeave a comment:
-
Thanks Mary
I have tried this, but it still not working, it still doing the same thing.
I am not sure how but it seems like although the application list is not selected but it has its value. the same goes for the rest of the List Boxes.
How can I do this via one button.
To have only one button called View which opens the reports for the different selection from different List Boxes.
Can you help...Leave a comment:
-
How to Update multiple fields in a table
Can some one tell me the correct syntax of Update statment for updating multiple fields.
I want to update few item in record (few fields i a table).
Thanks -
Inserting into a table with 4 fields but only 2 fields need to be updated
I have a table called Applications which had 4 Fields and they are:
ApplicationID --- this is auto numeber and Primary Key -- can't be duplicated
Application
ApplicationOwne r
Responsible
Now I have the following record im My table
ApplicationID Application Owner Responsible
6 Budget Model Anthony Gust Unknown
I have two... -
I Mary
I have tried this but this won't work.
Is this correct
This code is behind ViewApplication button
...Code:Private Sub ViewApplication_Click() On Error GoTo Err_ViewApplication_Click Dim stDocName As String If ServerList.ListCount = 0 Then 'Or DepartmentList.ListCount = 0 Or LocationList.ListCount = 0 Then MsgBox "There isLeave a comment:
-
Hi guys
While a go I had problem of selecting and deselecting.
I had 4 List boxes, I wanted to select an item from ListBox1 and other three list boxes get deselected.
The above code solved this, Thanks to Mary.
Now
I have 4 buttons, called ViewList1, ViewList2, ViewList3 and ViewList4 which display reports based on the selection from the list boxes. For example, when I select an item from Listbox1 and hit the button...Leave a comment:
No activity results to display
Leave a comment: