Good idea but I can't actually do this because we have an application that uses this DSN which connects to the original production database.
Thanks tho......
Craash
Last Activity: Mar 4 '07, 10:01 PM
Joined: Jan 21 '07
Location:
-
Hi Mary, thanks for the reply. Microsoft does not make it that easy for us. When you access the query properties it lets you change everything but the DSN connection.
I believe I have figured out a way to do it by using a simple script...
ActiveSheet.Que ryTables(1).Con nection = "ODBC;DSN=newDS N"
ActiveSheet.Que ryTables(1).Ref resh
Believe it or not this seems to work...Thanks :)...Leave a comment:
-
Excel DSN Query
I have an excel spreadsheet that I have created a query using a DSN to access a sql database. My question; is there a way to change the DSN without creating a new query?
I have a SQL database that is used as a backend to an accounting application. Currently many upper management users have created spreadsheets to pull reports from this database using the backend (DSN connection). Since this is a production database I have created... -
Excel DSN Query
I understand this is an access forum so I apologize if this is inappropriate.
I have an excel spreadsheet that I have created a query using a DSN to access a sql database. My question; is there a way to change the DSN without creating a new query?
I have a SQL database that is used as a backend to an accounting application. Currently many upper management users have created spreadsheets to pull reports from this database using... -
Here is the Assigned form to maybe give you a better idea of what I am talking about.
The subform datasheets are all linked using the link child and master fields to the employeeID so the sheet only displays the assets and software assigned to this user. I was hoping to change the status which would clear the employeeID field and change the available from no to yes. I will see how to change this so the dates would replace this ide...Leave a comment:
-
Hi NeoPa,
I came to this forum looking for advice and help. If you guys believe that this is the best way then I will try to make this work. I will start making changes to the forms and the tables.
If you have any advice on how to proceed please let me know and as always thanks for your help :)...Leave a comment:
-
Hello Nico,
Thanks for the advice. It does sound more logical and perhaps the best way to go. I wil give this a shot and see how far I can get. Thanks :)...Leave a comment:
-
No problem NeoPa, I am thrilled that you are even considering helping me on this mess. :)
I am currently reading Access 2003 Programming by Example with VBA, XML, and ASP by Julitta Korol. Maybe I will figure it out and be able to post the solution (My goal)
I may just be approaching this all wrong, as stated earlier I have only been doing this for less than a month and am still becoming familiar with the concepts.
...Leave a comment:
-
Whew, you’re good at understanding poorly defined information.
Ok here goes, I had omitted the tbl_software to avoid further confusion. Haha
The StatusID field represents an employee's status within the company. When the employee leaves the company the status would change from active to inactive.
With that change I am looking for a way to release the assets and software licenses assigned to that user.
...Leave a comment:
-
...Code:tbl_Assets fld_AssetID; AutoNumber; PK fld_EmployeeID;Number;FK; Combo Box; Query:SELECT tbl_Employee.EmployeeID,tbl_Employee.LastName & ", " & [FirstName] AS Expr1 FROM tbl_Employee ORDER BY tbl_Employee.LastName & ", " & [FirstName]; fld_Available; Yes/No; Check Box [B]tbl_Employee[/B] fld_EmployeeID; AutoNumber; PK fld_StatusID; Number
Leave a comment:
-
Thanks for the tips NeoPa...I can use all the advice I can get. I find this very frustrating and rewarding at the same time. :)...Leave a comment:
-
Insert Into? Delete? Update?
Access 2003 I am very new at this...
I have created an Asset and Software License Tracking Database.(I use the word created very loosely)
tbl_Assets
field_EmployeeI D (Pulled from a lookup table)
field_StatusID (CheckBox)
tbl_Software
field_EmployeeI D (Pulled from a lookup table)
field_StatusID (CheckBox)
I only listed the fields I felt relevant
The form... -
Thanks missinglinq, worked great. I tested it several ways before replying...Than ks to both of you for your help...Leave a comment:
-
The problem seems to be because the AssetID textbox on the upgrade form is bound to the AssetID field in the tblAssetUpgrade . If I make the textbox unbound the code works fine but will not commit the value to the table....Leave a comment:
-
Stumped
The Form and Field names are correct. I have changed the names to obvious wrong names to verify the error would be different and it is, so it is not the naming convention or wrong names within the code.
Thanks for the help...Leave a comment:
-
My mistake ... this is actually giving a runtime error 2448
You can't assign a value to this object...The object is a text box the field in the table is a longinteger
This is producing the error...
Private Sub Form_Open(Cance l As Integer)
Me![AssetID] = Forms![frmAssetInfo]![AssetID]
End Sub
The field in the table is a long integer...Tried changing it to text and no help...Leave a comment:
-
Thanks ADezii,
Needed the second part...worked great :)...Leave a comment:
-
Asset Upgrade Form
Hello, I am fairly new to creating databases with access.
I am using Access 2003 and have created an Asset tracking database.
I have a form to enter the asset information with the primary key as the asset ID#, on this form I would like to add a button to open an upgrade form. On the upgrade form I would like to have the Asset ID# field automatically filled in with the one on the form that the button resides. Any ideas? I think that...
No activity results to display
Leave a comment: