vanlanjl
Last Activity: Nov 5 '09, 08:23 PM
Joined: Feb 27 '09
Location:
-
Im not sure I follow. Each location has mulitple devices, multiple devices of the same type, each device has its own device name which is the PK. When i log into a router it has a host name and the is the same as the DeviceName in the database. So I do have for example multiple switches in one location they are just each defined by their host name (DeviceName) -
where could i find more information on this. I keep getting links to "Normalizat ion"
My databse is "Normalized " but not in this manner.Leave a comment:
-
Vertical Growing/Dynamic Growth In Access Tables
Okay this is very complicated (for me), but i need some help on this please.
I am creating a Network Diagram in Visio, along with this I have collected all the Information for every Network Device in my companys organization for each location across the country. I have placed this all in a a Excel spreadsheet, and exported to Access. I will then Export from Access to SQL Server. (I am doing this becuase I understand access better than SQL.)... -
What i have done so far is:
I have imported my Access tables and queries to SQL Server Express
I have connected my Sql Server Express Database to Visual Studio Pro 2008
I have created a aspx page conected my tblContacts to it and createda basicsearch parameter.
What I would like to do is re-create my Access Forms and Reports in Visual Studio for web access.Leave a comment:
-
Yea, I wasn't sure which topic to ask it in. I am most fammilar with Access and with this Access forum, and its users. I have little knowledge in Visual studio, but have Visula Studio 2008 and enjoy the tutorials in it very much. I also have a little sql experiance. I have succesfully installed SQL Server 2008, and have succesfully migrated the Access tables into SQL. Form that point I am not sure what to do.
If you feel my post is...Leave a comment:
-
Access to SQL Server Express with web/sharepoint interface
Okay this is a general question.
I have an Access 2007 databse and am wanting to push it to sql server 2008 with either a web interface or sharepoint interface.
How would I go about doing this.
I have Acess 2007, Visual Studio Pro 2008, Sql Server 2008 and Microsoft Expression, and Sharepoint.
I do not know alot about thses apps except Access 2007, so I know there will be alot of learning... -
I figured it out.
...Code:Option Compare Database Private Sub cboChargeCode_NotInList(NewData As String, Response As Integer) Dim strSQL As String Dim i As Integer Dim MSg As String 'Exit this sub if the combo box is cleared If NewData = "" Then Exit Sub MSg = "'" & NewData & "' is not currently in the list." & vbCr &
Leave a comment:
-
"Not in list" event for Access 2007
I cannot get the not in list event to work right.
On my form I have a combo box named "cboChargeC ode"
I have a table named "tblChargeC ode"
I would like it so when you enter a value into the cbohargeCOde that is not listed it will alert you and ask you if you would like to add such item.
My code
...Code:Private Sub ChargeCode_NotInList(NewData As String,
-
Actually I feel they are relevant becuase people may run into the same problem. In todays IT world it is common practice to know all the pros and cons before taking action. And that is what I was providing.Leave a comment:
-
I found one issue though. Since the datbase that I am working with utilizes the AdFromOutlook command, there are issues with creating a FE & BE. The reason being is that the addfromoutlook command is very picky when it comes to the table. the only I have been able to get it to work is to use the templat "contacts". So when making a front end and back end and linking the two together changes the properties in contacts table which keeps...Leave a comment:
-
Comments on FE / BE.
Thanks! Nice and easy!
**Edit - Posted in response to http://bytes.com/topic/access/insigh...nd-back-end-fe **Last edited by NeoPa; Mar 13 '09, 03:42 PM. Reason: Only relevant technical comments to articles please -
Never mind - figured it out - For some reason you have to create the table "contacts" provided as a template table for it to work - after wich you can add or delete fileds that you feel you will not need. Creat cmdbutton and in the onclick event procedure - DoCmd.RunComman d acCmdAddFromOut look
works like a charm yo!Leave a comment:
-
ADDFROMOUTLOOK Macro Help
I created a Databse with an AddFromOutlook cmd button the utilized the AddFromOutlook Macro that is built into Access 2007. Does anyone have experiance with this?
I have gone back and noticed alot of errors in my database so I started a fresh one that is now normalized but cannot get the AddFromOutlook Macro to save the new contact to the tblCOntacts as a new record.
Please any halp would be awesome. -
uhh... thats my threadLeave a comment:
-
Missing the point. I am already linked by using the addfromoutlook macro that is built in to access. That is not the problem postedLeave a comment:
-
ITS ALIVE!!!
lol
It works - Thanks PuppyDogBuddy!Leave a comment:
-
Above code will open the new form but it opens blankCode:Private Sub cmdSystemPrepCheck_Click() DoCmd.OpenForm "frmSystemPrepChecklist", , , "[UserName] = "" & Forms!frmSearchUsers!UserName & """ DoCmd.Close acForm, "frmSearchUsers" End Sub
Leave a comment:
-
Run-time error '3075':
Syntax error (missing operator) in Query expression '[UserName]='.
Would it be because UserName is not a field on the frmSystemPrepCh ecklist?
Doo i need to add it? and make it invisable to the user?Leave a comment:
-
Hmm not sure if I understand your question as simple as it is. Lets see if i can clarify for you. When I push the cmdAdFromOutloo k button it opens the search window in outlook. I type in the users name I looking for then click add and it automatically adds it to my tblContacts. BUT on my form frmSearchUsers, instead of populating the fields with the NEW user that was just added it goes to the first user in the table. I want it to be populated with...Leave a comment:
-
Form1 to open Form2 with same records in form1?
Okay lets see if I can do this with out confusing myself or others. First I will give ALL the details then state my problem and request at the bottom.
Tables:
tblContacts
ID
Company
LastName
FirstName
Initial
E-MailAddress
JobTitle
BuisnessPhone
HomePhone
MobilePhone
faxNumber
Address
City
State/Province
Zip/PostalCode...
No activity results to display
Leave a comment: