I am doing an append query that takes data from a table(TIMESHEET )from data base "A" and appending that data to the same table in database B. Database B has a password and when I try to run the Query I get the not a valid password message box. Below is what access gave me when I ran the Query Wizard. I found other similar questions online but none of the solutions for those worked.
For reference "bmi test.mdb" would be...
282 results in 0.0079 seconds.
-
Not a Valid Password problem Access
-
Sql - insert into
I have an sql statement which I was hoping someone may be able to help me with. I'm getting the following errors:
1 - runtime error 3346 (Number of query values and destination values are not the same
2 - Runtime Error 3075 syntax
...Code:strSql = "INSERT INTO tblConversation ( " & _ "RecordID, LeadID, Conversation, Subject, DateEntered, ContactDate, ContactTime, FollowUpDate -
error 150: Can't create table
Hi
Am trying to create a table called (sub_categories ). This table have two columns :
sub_category_id : Primary (int)
parent_category id: not null (int)
Both tables reference the column (id) from categories table. When i try to creating the table it gives me the error :
ERROR 1005: Can't create table 'shoppingcart.s ub_categories' (errno: 150)
Here is the SQL syntax... -
My append query won't add new records.
Hi
I have an append query which won’t add new records. I have two tables and I need the new data from TableA (FSP Attainment Import) to add a new record into TableB (Master), however I only need it to add the new data and ignore the old. For example if TableB holds (Row 1) A B C D (Row 2) B C D E (Row 3) C D E F and TableA holds (Row 1) A B C D (Row 2) B C D E (Row 3) C D E F (Row 4) D E F G (Row 5) E F G H. I only need the data... -
PHP+ODBC+FREETDS: select [field] AS [name] does not work!
Hi guys,
I have a unix server which has PHP 5.2.13 installed, and it has access to two SQL servers (one is running MSSQL SERVER 2000 and the other MSSQL 2005).
It uses FreeTDS - details:
Version: freetds v0.82
freetds.conf directory: /usr/local/etc
MS db-lib source compatibility: no
Sybase binary compatibility: no
Thread safety: yes... -
I need to do a post with comments. help
hello i need to do a post with comments, im using a listview to view the posts, and comment too, but the list view only lets me see the posts when the table comment has data... even if the table post is full of data it wont display because the table comment has no data... how can i overcome this?? -
DLookUp function doesn't want to work with my code
...Code:Private Sub Command11_Click() Dim strSQL As String Dim criteria As Integer Dim ete As String Dim row, place As Integer ete = Me!etenduse_nimi row = Me!Rida place = Me!number criteria = DLookup("[broneeringu_id]", "BroneeringudQ", " etenduse_nimi='" & ete & "' AND rida=" & row & " AND number=" & place & " AND Toimumisaeg=" -
I Can't select the fields i need in the query result!
I have this query and it works fine however i need the query to display the forename and surname and currently it only displays the max value of the sum it performs
Does anybody know what i can do?
Thanks
...Code:SELECT MAX(Intermediate.Total_Amount_Of_Likes) AS Total_Amount_Of_Likes FROM ( SELECT Forename, Surname, Sum(Likes) AS Total_Amount_Of_Likes FROM Instructors, Exercise_Class_Type, Exercise_Class_Staff,
-
make a list of all the numbers in a listbox
i want to make a list of all the numbers in a listbox(sql data source) and then delete all the numbers in a dropdownlist all the numbers found on listbox....
i have no idea how to do this..
i managed to get the numbers in the correct order, but for example i add 1 to the the listbox,my dropdownlist would start at 2 but then add 15, meaning my dropdownlist would start at 16 and 2,3,4,5..16 is gone ... basically what i want to... -
How to use SQL query in VBA function?
I am using Access 2010. I have a database that consists of bookings, receipts, clients and so on. I have made a form for booking tickets. The first field I have on my form is a combobox where a user can choose the username. And the second (receiptID) field should be filled automatically after the user has chosen appropriate username. I have an idea how to fill that field but what i don't have are the skills.
My Receipts table has these fields:... -
how do i select everything except a UserName in sql?
hi, basically what i need is to "block" a username(meaning i want to block the current user online) in the SQL statementCode:@username = Profile.Username
...Code:SELECT vw_aspnet_UsersInRoles.UserId, vw_aspnet_Users.UserId AS Expr1, vw_aspnet_UsersInRoles.RoleId AS Expr2, vw_aspnet_Roles.RoleId, vw_aspnet_Users.UserName, vw_aspnet_Roles.RoleName, aspnet_Profile.UserId AS Expr3, aspnet_Profile.PropertyNames
-
VB Failed To Update SQL Using Update ... SET....WHERE
Hi ... i tryin to update my SQL using this method but it didn't update...Anyone have a better way to do this ?
------------------------------------------------------------
...Code:Case "OUT" Dim connectionstring As String = "Server=PENW3GFSB2S\SQLEXPRESS;Database=People;Trusted_Connection = yes" Dim query As String = "Update [Names] Set [TimeOut]= -
how can I display data into my Jtextarea from my data base Mysql
hi,
I have problem when I try to displa data from my database mysql to my jTextarea,when I compile I have an error exception like :
I have used a select query from my table where the name is the name writed in my jTextfield,this is my code,I hope that some one help me because I don't know how to reesolve the problem and thanks:...Code:SQL Exception: java.sql.SQLException: Can not issue SELECT via executeUpdate()
-
Adding 'ALL' in rowsource of combobox.
I have acombobox used to filter data on selection of any value.I want to add a value 'ALL' in my combobox for users to select all the values i.e. remove filtering.union all is not working somehow.Here's the query:
...Code:[*]SELECT DISTINCTROW tblMIMAIN.A_JOBNO AS Jobno, tblMIMAIN.A_EQUIPDESCR AS Equipment, tblMIMAIN.A_LOCATION AS Location, tblMIMAIN.A_ID, IIf(IsNull(tblMIMAIN!A_PROJECTID)," ","**13Mplan**") AS 13Months
-
automatically run a SQL statement quarterly or monthly
I have a SQL statement that I need to run on my databases quarterly (monthly would work too). It compresses the database and speeds up the searching of it for my company. As of right now, I just have a reminder on my calender to tell me when I need to run it. My question is, is there a way to set it up so that this statement will run automatically?
