emajka21
Last Activity: Jun 26 '09, 06:52 PM
Joined: May 10 '07
Location:
-
I got it work. Thank you for your help. I understand how it works but the syntax gets me everytime! :) -
I am getting it to work now "sort of". My statement is below:
strSQL = "Update SalaryRate SET Salary = " & rstSalaryRate!S alary & ", HourlyRate = " & rstSalaryRate!H ourlyRate & " WHERE EmployeeID = " & rstSalaryRate!E mployeeID & " and EffectiveDate = " & rstSalaryRate!E ffectiveDate & ""
I don't get a syntax error any more but no records...Leave a comment:
-
I keep getting a syntax error in my update statement. I have tried it numerous different ways and I am not sure what the correct syntax should be.
This is the last version I tried:
strSQL = "Update Salary-Rate SET Salary = rstSalaryRate!S alary WHERE EmployeeID = rstSalaryRate!E mployeeID"
I am sure I am missing some kind of ', &, or ".
I have also tried Me.EmployeeID = rstSalary![EmployeeID]....Leave a comment:
-
Access 2003-How to export a table and then reimport it later
I am working on an HR database for my work. I need to be able to "update" this database once it goes live but the powers that be don't want me to see the salaries. So my boss wants me to create a macro that allows HR to export the salary table and replaces the salary fields with bogus numbers. Then once I am done doing what ever I have to do he wants another macro that reimports that data.
I can export the data to an external... -
Ok I got it to work. I modified it some:
-----------------------------------------------------------------------
Private Sub cboPositionTitl e_Change()
Dim wrkJet As Workspace
Dim dbsTraining As DAO.Database
Dim rstTraining As DAO.Recordset
Dim strPathToTrngDB As String
Dim test As Integer
strPathToTrngDB = "h:\DRR.mdb "
'Create Microsoft Jet Workspace...Leave a comment:
-
First, thank you all for responding to me.
Linq,
1. We're not the normal organization (or else things might be easier! :)
2. The HR database is located in the HR network drive. There are only about 3-4 people who have access to any portion of this drive and they are not willing to give it to this other person. (Heck they truthfully don't want me to look at the info.) Management is highly paranoid.
3. This...Leave a comment:
-
Access 2003-How to update records in 2 separate Access databases
I have been working on creating a HR database. Everything is working fine there but now they want a training database. I basically need a few fields from the employee table and I need the full department table. I also need the position titles table along with 1 additional field. I was able to export everything fine to the new database.
Is there a way to update the training database when data is updated in the HR database. I figured... -
Never mind, I think I figured it out. Since using the form authentication creates a sql database I think that is my problem. My free webhost doesn't support sql databases, only access databases.. Fun...
Thanks for the help!Leave a comment:
-
Well I uploaded it to the server and it isn't working. This is quite frustrating!
When I go to log in I just get an application runtime error. Any thoughts on why??
I am going to email them back about this.
This was the web hosts answer:
Dear Customer,
Thank you for your inquiry regarding your account(s).
Free sites are hosted in busy environment. They are
...Leave a comment:
-
Never mind I figured it out. That wasn't my problem though... I think i need to contact my host provider...Leave a comment:
-
Well I have installed Microsoft SQL Server Express. Any idea why my aspnetdb.mdf file is not showing up in there? Does the file have to be in a certain spot for it to find it?Leave a comment:
-
shrinking ASPNETDB.MDF
Ok I created a ASP 2.0/c# website that is using form authentication and it created a 10meg file. I need to shrink this so I can put it on my free hosting website which has a size limit. I have read several articles saying to download the Microsoft SQL Server Express. I did but it does not find this database for me to attach and shrink. I try to "open" it and it gives me an error. I found a script that will supposedly shrink it for... -
Never mind. I think I got it working. The next step is to upload it to the server and see if it works!Leave a comment:
-
Well I sort of got the form authentication working except for 1 thing. My sitemaps. I have 2 sitemaps, 1 for anyone and 1 for admins. I don't want the admin sitemap to be visible until the admin logs in. I read to do this I could use securityTrimmin gEnabled="true" . This does hide the second sitemap but it doesn't bring it back when I log in. I don't know what I am doing wrong here. I know my security is working because if I take...Leave a comment:
-
Hello again,
Thanks for everyone's help on this. I contacted the host provider and got a generic message stating to check the tech support page which sucks. So I replied with a more specific question. Lets see if they get back to me with a real answer or not.
Either way I plan on looking into the form authentication this weekend. I have other things going on that I can't spend alot of time on it until then. If I run into...Leave a comment:
-
Umm I'm not sure. I am using what ever is default for session variables. Here is my web.config:
[code=xml]
<?xml version="1.0"?>
<configuratio n>
<appSettings/>
<connectionStri ngs/>
<system.web>
<pages theme ="purple" />
<compilation debug="true"/>
<authenticati on mode="Windows"/>...Leave a comment:
-
Well I have to change that theory again. After more testing I have found that the pages are timing out. It is just the form because visible and I didn't have them to turn back to invisible if the user wasn't an admin.
At least I found one flaw....
I also emailed my host provider to ask about their servers... Lets see what they say. Does anyone have any other suggestion other then session variables?Leave a comment:
-
Well I had time to play with it a bit more. It seems that if I stay in the same page and add data (while refreshing and clearing the form after the data is saved)the session doesn't time out. It seems to loose the session variable when I go from page to page. It has to be the way I coded the pages. Any thoughts on this?Leave a comment:
-
No, I'm not sure how to do that. Where do I set that? In the web.config?Leave a comment:
-
Session variables timing out too soon in ASP 2.0
I created a website in ASP 2.0/c# that connects to an Access 2000 database. Currently I have 4 pages that people can view without logging in, which are reports that post marathon race results. Only one maybe two people will actually ever have to log in to enter the race data.
For the login I created a form that asks for user name and password. Then I do a sql query to see if that matches the information in the database. If it does...
No activity results to display
Leave a comment: