I believe it is MOSS 2007. The version of access is 2007 as well.
I have come up with half of a solution thus far. Here is what I did:
I posted my excel spreadsheets on sharepoint and wrote a simple macro for them that saves any changes to a duplicate spreadsheet which is located in a shared network drive. I linked the files in the shared drive to my access db on sharepiont and it works fine.
The problem...
VBnewb13
Last Activity: Aug 6 '10, 08:04 PM
Joined: Jun 28 '10
Location:
-
Save a duplicate copy in excel using VBA
For some reason, excel stops working when I use this code...
Code:Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) ThisWorkbook.SaveAs "C:\Users\Me\Desktop\test2\test2.xlsm" End Sub
What I am trying to do is save a duplicate copy of my workbook in another location. Is there maybe another way to go about doing this? I am really new... -
Basic VBA outline for a search function
Hello everyone,
I already accomplished what I am trying to do by using Microsoft Access, but I would like to somehow do it in excel as well (or atleast do something similar).
What I have done is created a search enging (with the advice of a few kind experts from bytes!) that searches through tables and displays the results in a subform based upon user input. The user has the ability to select which columns from the... -
Integrating Access with Sharepoint
Hello everyone,
This might not be the appropriate thread but I'm looking for some bigtime help and this is the closest subject I could find :P
My problem deals with Excel, Sharepoint, and Access all in one. I will try to detail it as best as I can.
To start, I have an Access Database containing some forms and 3 tables. These 3 tables are linked to 3 Excel spreadsheets. The main purpose of this database... -
MS access open in edit only on sharepoint
Hello all,
I've recently run into a problem in dealing with access and sharepoint. Everytime I try and open my access db from a sharepoint document library it asks if I want to open in 'read only' or 'edit' mode.
The database is used as a search tool so everytime a search is run, something in the db changes. Therefore, it has to be opened in an edit only mode.
The problem is how can I alter the settings... -
Multiple search values in one text box
I have a text box that I would like to type values in separated by a "," and be able to pull all matching values from the table it is searching.
Here is what I have so far:
the textbox called "SearchALL" is where I would...Code:Forms!fsubDataSheet.RecordSource = "SELECT * FROM Table1 WHERE (Field1 Like '*" & [Forms]![frmDataSelect]![SearchALL] & "*'"
-
Yea, you're right, that makes perfect sense. I've given it some thought and I feel that I am goign to forgo that capability. It really does not affect what I am trying to do in such a way that it needs to be given attention.
I greatly appreciate your detailed answers. They were very helpful :)
Best...Leave a comment:
-
Hey Jim,
I thought I would pick your brain since you were clever enough to develop the previous code. I had a question about what you suggested...
I inserted a text box (named searchALL) to act as an 'all encompassing search' of the displayed data. I tried to be more specific with this line by sayingCode:Forms!fsubEmployees.RecordSource = "SELECT * FROM Employees"
...Code:Forms!fsubEmployees.RecordSource
Leave a comment:
-
How to use a variable within SQL code that is embedded in Visual Basic
...Sorry if that question was confusing. Allow me to explain better:
I currently have this line of code:
My problem is that I have more than one Table I would like to select data from (not just Table1...there is also Table2, Table3, etc). I have a combo box that lists all of my tables and I would like to be able to select a table from the combo...Code:Forms!form1.RecordSource = "SELECT * FROM Table1"
-
That worked out great once I renamed what I needed to! That is exactly what I was trying to accomplish...Leave a comment:
-
The subform is based on a query data table. Is it possible to choose which columns on the table appear in the subform itself?Leave a comment:
-
I need this because some tables I want to search through contain 20+ columns, most of which are irrelevant. I want the user to be able to select which columns they want to appear so they may be able to view more relevant information instead of scrolling through everything.
I am interested in how to hide the controls based on checkboxes. Does this mean I will be able to hide what columns appear?
Thanks again...Leave a comment:
-
How to control which colums are displayed as output by using query?
The question is a bit more complicated than it sounds I think. What I am trying to accomplish I will explain using an example:
I have a subform based on a query. This query is a data table that contains 5 columns. I have a textbox into which I input data, hit a command button, and it searches the query and displays matching items in the subform. However, it shows all 5 columns... What I would ideally like to do is have a checkbox... -
How to search database and only search for parts of cells?
Hello,
I made a form with a text box, button, and subform (which displays data from a query). When I type data into the text box and hit the button, it returns the entire row from the query datasheet in the subform.
What I would like to do is this: The first column of the query table, for example, contains numbers
(i.e. 8452 6484) in that format. #### ####. Since these numbers are in one cell, I would like... -
I figured it out. I had to enable some security options I guess. That's why when I initially created something it worked, but when I closed the db and reopened it nothing would work.
thanks for your help though, it worked out great :)Leave a comment:
-
That is brilliant, I see exactly what you are saying. I really can't get it to work for some reason. I'll detail exactly what I have set up:
I have a form. On this form I have text1 and check1. I have the exact code you suggested.
How do I set the default value of check1 to off.
Me.check1.value = 0 ?
Or what do I type in the data section of properties where it says default value?
Thanks...Leave a comment:
-
Visual Basic code for enabling and disabling text boxes in MS Access?
Hello all,
I have been having some troubles figuring out how to do this. Naturally, I have looked through this forum and countless others, all yielding the same answers to my question... which for some reason I cannot get to work. I can't quite figure out what I'm doing wrong here.
I am in the process of creating a search form that searches through a database using different parameters. This parameters are text boxes....
No activity results to display
Leave a comment: