MeeMee
Last Activity: Aug 6 '11, 01:56 PM
Joined: Jan 7 '08
Location:
-
ya i know that it is not normalized, problem is they want me to use the excel sheet and import in access and not make changes, i knew it is impossible to do but thought of asking if there are other indirect ways , thanks anyway. -
Select columns based on user input range
Hi,
I have a table in access which has the following columns:
ID Pname Aug10 Sep10 Oct 10 Nov10 Dec10
and more column for the months until the year 2015.
I have a form which has two comboboxes that lets the user selects the start MMMYY and the end MMMYY. I am not able to find a way to write a query that selects the correct columns based on the user's input.
For example if... -
If it's possible I have another question :)
I am using a code on form load to check weather the DAO reference is added on the client machine or not. If it is not added, it will automaticalyl do that.
...Code:Private Sub Form_Open(Cancel As Integer) DoCmd.Maximize Dim Ref As Reference Const constrDAO = "DAO" Dim blReferenceFound As Boolean blReferenceFound = False
Leave a comment:
-
Hi ADezii
Thanks alot for your reply , I tried your Mid code on my PC and it worked , however to test it for the clients , I'll have to wait for the problem to reappear to test if it solves the error without the method given by Microsoft :(
and I'll try the Function call method too
I'll feed back once I get the error again :)
Thanks alot for your replies ..
P.S Don't worry...Leave a comment:
-
Access DAO Reference/Right Function Error
Hi,
I have a problem in one of the MS Access systems at work. I am using some database functions that requires the DAO reference. The system is working fine on my PC, however it occurs on the clients PCs. I am using Access 2003.
Whenever the use clicks on a specific button that has a code which creates a specific Code through a number of steps the following error appears:
I am using this... -
I managed to add one record by filling in the empty fields and testing, I found that there was one field that needed to be given a value although it is not a mandotry field and accepts Null .. Problem solved :)
thanks alot...Leave a comment:
-
one question, the tables has some foreign keys refrencing other tables, I am not using these fields in the append query, I don't want to assign values to them, could this be causing the problem ??Leave a comment:
-
Yes , I checked for triggers, it doesn't have any .. I tried adding a new record , only one, again got the same error, I'll try the method you mentioned ..
Thanks alot :)...Leave a comment:
-
there are some NOT NULL fields but I made sure they have data, some default values on some columns and a unique constraint but they allow null, and some foreign keys, it is a huge table but i am adding data to some fields...Leave a comment:
-
I am still getting the error after adding the where clause, the records I am adding into the linked table are not there in the linked table so it is strange i am getting key violations since the combination of the PK is not there in the linked table...Leave a comment:
-
Append Query & Key Violations Error
Hi
I have a problem appending data into an oracle table from access. I imported the new data from an excel sheet into a table in access and useed an append query to add the data into a linked oracle table. The linked table has a composit primary key (Code, Org). The table in access has new data that are not in the oracle table and the data in the PK fields are not duplicated. I also made sure that both tables have same data types.... -
Linking MS Access to Oracle
Hi,
I am trying to get some tables from the oracle 10g database that I have on my machine into an access database. I used the Get External Data option in access and followed the steps in this tutorial:
http://aspalliance.com/893_Creating_an _MS_Access_2003 _Front_End_for_ an_Oracle_10g_E xpress_Edition_ Database.2
For example, I tried getting the Employees and Departments tables from the hr schema. I was able to link... -
Thanks alot for your help, I will give it a try ..
I installed it IIS locally so I can work with forms, and till now I didn't need to configure anything in its console, I am trying to read as much as I can about the deployment process, I found this
http://support.microsoft.com/kb/299868
It seems simple, but I am not sure if this is all that I need .. I'd appreciate your advice.
Thanks alot...Leave a comment:
-
Hi,
No I get no error, anyway it finally worked after I changed the permission to the wwwroot folder by going to Properties > Security.
I have another question, the intranet website has not asp code at all, it is all html, so it is not in the wwwroot folder. I am not that experienced with servers, now I know that IIS and FP extensions must be installed on the server so that the form works , just like I did locally....Leave a comment:
-
Save Form Data to Access DB
Hi
I have a problem with saving form data to a MS Access database. I am using Windows XP, FrontPage 2003, Access 2003, IIS 5.1 and FrontPage Server Extensions.
I have followed several tutorials I found online, created a simple form and changed its properties so that when the data is submitted it is saved into the database. When I click on the submit button , I get a confirmation page but nothing is written in the database.... -
Thanks alot debasisdas and Lotus 18 :)Leave a comment:
-
VB6 and tmp files
Hi,
I noticed that my vb6 project folder has lots of .tmp files such as "VB313.tmp" and it is increasing by time. What is causing this ?? and how can I get rid of them ?? Is it safe to delete them ??
Thanks In Advance. -
Tried it and it worked , it now shows all retrieved records even if it was one.
Thanks again :)
Hopefully this will be the last problem...Leave a comment:
-
Still getting a run-time error '-2147217900 (80040e14): Syntax error in Insert Into Statement.Leave a comment:
-
I keep getting syntax error
rtype is a ...Code:sSQL = " Insert Into TRequests(CPR,Name,JobTitle,Directorate,Section,Grade,EmploymentDate,ReqDate,ReqType,ReqSubType,ByEmployee,Status,Comment,Seen) Select CPR,Name,JobTitle,Directorate,Section,Grade,EmploymentDate,ReqDate,ReqType,ReqSubType,ByEmployee,Status,Comment,Seen From Requests Where ReqType = rtype And ReqSubType = ReqTypeCmb.Text And Directorate = 'Direc1'"
Leave a comment:
No activity results to display
Leave a comment: