Greetings,
I've got an access database on a server, and in a client PC I've got an excel spreadsheet... I run a query from the client PC involving some maths to develop different price lists from values stored in the DB on the server...
Problem #1: I dont want the client PC to be able to control the queries, is there a way to store the access query on the server PC and have the excel worksheet just access it on the server...
miffe
Last Activity: Sep 27 '06, 10:10 PM
Joined: Sep 11 '06
Location: Monterrey, Mexico
-
Bizzarre problem involving Excel-Access :x HELP
-
MySQL - Excel
Is it possible to run query's from MS Excel on 'PC1' being on the same network LAN as 'PC_Server' which has Apache, MySQL and Php with MySQL Extensions installed?
If so, how can I run the query and produce results?
Thanks a lot,
Miffe -
I've solved that problem...
My problem now is this:
I want to make a spreadsheet in Excel that on startup it will process a query and import data to a sheet in the workbook.
Know any method on how to do all this automatically?
thanks -
miffe -
I would consider using only one database, using more than one (when not absolutely nessesary, I.E. for other product management, etc) is not nessesary, use one but use extensive tables/relationships to manage them and break up the info as much as you can, I.E. dont use duplicate records, or use them the least possible and just add relationships between columns.
This way your traffic of data shouldn't be that slow, remember to use a...Leave a comment:
-
I suggest you open a connection to the database using the data control first of all, then run an SQL command using the recordset property of the data control, with the SQL command you can get a result query of the names or data you need.
You then can load the info into the array. First of all create the array in the General Declarations part,
Dim array (idClient, Number, Name)
then just run a loop to read...Leave a comment:
-
You usually just add the SQL in between the () in an OpenRecordset, altough if it is not working, try the next:
Dim rs As RecordSet
Set rs = db.OpenRecordSe t("SELECT * FROM dbo_vwBookingIn fo WHERE [BookingNumber]=" & Me!JobNumber, dbOpenDynaset)
Note that there are various properties available for OpenRecordSet, I suggest you examine these properties when using VB/Access or SQL access, it can save...Leave a comment:
-
Help Seting User Privileges / Special Setup please
This is my first time on the site but I hope to be a regular here, not just asking but answering... Quick question:
I have a server PC with a main access database, and I will create an interfase for it in Visual Basic, but I have another computer which does invoices and stuff, and it requires the price list that is on the server PC. The server might not always be on, so I have two choices that I know of:
Establish user...
No activity results to display
Leave a comment: