Hi Everyone- I currently support an MS Access database that has linked connections using the Microsoft ODBC Driver for Oracle. I can connect to the current linked tables without any issues, but we are required for security reasons to change the password on the account accessing the Server. I have changed the password successfully but...
For Acccess Database which open with Message "This database has been opended read-only". For this DB when we connect using C#.net application with OleDbconnectio ..at time of updating Query it give Error "Operation must use an updateable query." I just want to prompt user if DB opened with ReadOnly Permission In Access Database.. how ca...
Hey all, I managed to integrate my Database quite well with Excel in the end, but in the end after I showed it to the bosses they asked me to develop the forms and reports in Access again. That did not take too long fortunately, so I ended up doing two front ends for one back end Database. But in the end it'll be a fully Access database ...
I am working on a Windows Form-Based application in Visual Studio 2008 using C# with an Access database as a back end. I added the Access database into the project by going to Data->Add New Data Source and I am able to retrieve data from the database's custom-made DataSet perfectly. My next goal is to save new data back into the Access ...
I am adding a part name to the database using a form, What code do I put behind the Add part button to validate against duplicate part names? (part number is the primary key) I think I need another recordset to search and compare the table but i'm a bit lost, any help would be great. Private Sub btn_add_Click() rs_parts.AddNew With rs_...
I have a muulti-language Access application that needs access to languages/keyboard layouts installed on the machine. I have certain fields that accept input in various languages. I would like to be able to change the active language/keyboard layout when these fields are entered and exited. I'm sure that there is some sort of windows AP...
MS Access hangs when I try to click "view code". How can I resolve this? ...
I'd like to find the best editor for flat SQL Server Compact edition databases. Essentially we want to push around arbitrary flat typed datasets of under 4 Gb each and have a good editing experience for manipulating this data. Access isn't the first thing that comes to mind, but I'm looking for a more "de facto" approach rather than the ...
Hi I need to insert data from DB to another DB. I run this query from VB.NET: for example: Insert into DBDestino.tablaDest (campo1,campo2) select valor1,valor2 from DBOrigen.tablaOrigen Field "campo1" is integer (in DBdestino) But sometimes the value "valor1" (in DBOrigen) is NULL. If I run the previous query, it returns error a...
Hi how can I format a currency field in a query to show without the £ symbol, but still include the correct figure after the decimal point? thanks ...
I am doing a inner join between two tables where one is an association table, so there is a many to one relationship. I am trying to come up with a query that can decide if the key on the join exist more than once than store a value multiple in the update column, but not sure the efficient way to make this happen: SELECT MainTable.Na...
I need to prompt the user for 2 dates, e.g. 1/1/2008 , 2/5/2008 , and generate a two column report with all 0-23 hours for each date in the range. The date being in the first column and the hour being in the second column. 1/1/2008 0 1/1/2008 1 1/1/2008 3 [...etc] 2/4/2008 23 ...
Hello Other time I need your help, I am developing an app in C# using an Access database(2007), the problem I think is the query updtate, I have searched over internet but nothing works, I have a datagridview and It has 3 columns the user needs to puts data to the last 2 columns(5 rows), I already do it but when I fill the columns in ...
I'm really brand new to all this, so excuse me if it's a stupid question. I've got two list boxes on an MS Access form. I'm resizing the list boxes based on how much data I'm getting back. However, this form needs to print, and the list boxes have enough data in them that they need to stack one above the other. When the first list box ex...
this query: SELECT sentmails.[VersandDatum], sentmails.[DatumMailGeplant], mailintervals.[Interval], definitions.[Subject], users.[Name], sentmails.[MailArt], Objekte.[Name], sentmails.[Erledigt], sentmails.[ID] FROM Objekte RIGHT JOIN (users RIGHT JOIN (definitions RIGH...
PARAMETERS [prmAuto] Long; CREATE VIEW view (IndexItemCaption) AS SELECT IndexItemCaption FROM IndexItems WHERE Auto = prmAuto; This create view doesn't work for me. Does anyone know why? Thanks! ...
I am helping a friend with this database and when I select a record with the drop down it pulls up the correct record but when I TAB or hit ENTER it goes to the next record. How can I fix this? ...
Hi, I'm working on a Access database which generates some mails with mail merge called from VBA code in the Access database. The problem is that if I open a new Word document and start the mail merge (VBA), Word opens the same Access database (which is already open) to get the data. Is there any way to prevent this? So that the already ...
I got and error message when I am trying to implement this query. It is saying syntax error, can someone help me... strLocalSql = "SELECT tblEventTypeList.EventType" & _ "FROM tblEventTypeList" & _ " WHERE tblEventTypeList.[EventPage] = " & ts & "" & _ "ORDER BY tblEventTypeList.[E...
I can store records in the DB by using combobox with the following code. Here single part number is selected and partnumber related data is stored in the DB table. But I want the code for Listbox...When I select multiple partnumbers ..how can I store in the DB table? Case "Pn ADDED to Wrapper", _ "Pn REMOVED from Wrapper" ...