Hi, Is there a way to create Access databases (.mdb) without actually using Ms Access? I'd like my app to create it instead (when user presses "New Document" on the toolbar). I'm using Delphi 5 Ent. Thanks in advance! :-) ...
I'm doing things with Microsoft Access. Now i want to make a list of dates between two dates. for example input : 1-1-2010 and 5-1-2010 give me the values. 1-1-2010 2-1-2010 3-1-2010 4-1-2010 5-1-2010 I want to do this in SQL if it's possible, otherwise in VBA. ...
I wrote code: str = "INSERT INTO prod_LJ_Completion VALUES (" _ & 0 & ", " & PartID & ", " & cmbLJ_TypeID.value & ", " & isChk(chkLJ_Transformator.value) & ", " _ & isChk(chkLJ_LAD.value) & ", " & txtLJ_KevlarCable.value & ", " & txtLJ_GrayCable.value & ", " _ & txtLJ_WhiteCable.value & ", " & cmbLJ_CylinderTypeID.value & ",...
Are ordinary sql queries different from MS Access 2007 queries? I have this simple query but it is not working in MS Access query (SQL View). What is wrong with this? SELECT StudentSubject.*, Subject.*,Professor.*, Student.*, Church.* FROM ( SELECT StudentSubject.*, Subject.*,Professor.* , Student.* FROM ( SELECT StudentSubject....
hi, how to onnect Microsoft Access Database to visual c# for example: i make a database that have a table named "student" and fields " id , name " so i make a c# form that have 2 text boxs and a button "add" that add the contents of the two text box to the database bye ...
I created a new MS Access project against a SQL Server 2008 database using windows based authentication. (UPDATE: Now using Login Credeitnals, same results though) I have some tables in the (dbo) schema and some I made in a (prj) schema. In the access project itself, prj is not recognized but the dbo are. Looking at the access table l...
I keep on getting the error "incorrect syntax near keyword 'where'." DoCmd.RunSQL "insert into userPreferences (userId, GroupId, preferenceId, properties, isDefault)" & _ "select " + Me.UserId + ", " + Me.GroupId + ", preferenceid, properties, 1 from preferences " & _ " where preferenceId not in " & _ "(selec...
Hi. In MS Access I need to bind text field to cell of the table (in report). How to do this? ...
Hi! I have this website to search for books, there is only ONE text field, to search by words, title author, whatever it types. if the name of the book is hello goodbye, and the author is A. Jones if i type hello i get the result of the book (my query is using the like statement) i check if title like %string_introduced% or author ...
Consider an Access front end and SQL Server 2008 backend. Access boolean datatype values are displayed as checkboxes on their forms. I want similar functionality except that my data backend is SQL Server 2008 One of my fields is a 0 or 1 in SQL Server, and when I display this data on my form in Access I want it to be displayed as a chec...
How do I replace all numbers in a column of a table to divide my 0.6. Let's say the column reads: 1 2 3 I want it to become: 0.6 1.2 1.8 ...
I have a query and I would like to use an IIf function as part of the criteria. Here is the full SQL: SELECT Hits.HitID, Hits.ListingID, Hits.HitCount, Hits.HitDate, Hits.HitTypeID, Hits.IsDeleted FROM Hits WHERE (((Hits.HitDate)>=[Forms]![frmReports]![txtStartDate]) AND ((Hits.IsDeleted)="N")); Here is the piece of code that causing...
hi i have 2 tables: A: ID,Namae B: ID,Name i need that where A.ID = B.ID will be added colum ZZ with the value '1' else '0' (only for show the table - i dont want to update table B) for example: A 1 | aa 2 | bb 3 | cc b 1 | gg | 1 4 | hh | 0 3 | ss | 1 how to write this in Access query ? thak's in advance ...
I usually make applications with the front end in Access 2003 - 2007 and the back-end on SQL Server 2008. When I create an ODBC to link the tables in access I have two choices in the ODBC Data Source Administration page on my Windows XP PC: Server 2008: SQL Server Native Client 10.0 v.2007.100.2531.00 SQL Server v. 2000.85.1132.00 W...
Scenario: In an Access project a main form has to be positioned and rearranged depending on the size of the Access-Application window. This should be done using VBA. As far as I know there is no way in Microsoft Access VBA to capture the Restore/Maximize-Event of the Access-Application window (I refer to the Access Window itself not any...
My Access programming is a little rusty, & I've never worked with Excel files all that much. I have a requirement to bring data from Excel spreadsheets into Access 2007. These spreadsheets have a fixed (predictable) format, but it includes a "header area" where I need to read single data items from specific cells, followed by a mass of ...
I am trying to create a query within a commercial ERP system that uses Access as its database, E2 Shop System. So it just runs the query through Access. I want the query to tell me "how much time was logged on every machine on a prompted date, even if it is 0". I have figured out how to get it to output how much time is on a machine...
Consider this Access query: SELECT prod_Parts.ID, prod_Parts.Number, prod_Parts.Revision, prod_Parts.Description FROM prod_JT_Shipping INNER JOIN (prod_JobTraveller INNER JOIN prod_Parts ON prod_JobTraveller.PartID = prod_Parts.ID) ON prod_JT_Shipping.JT_ID=prod_JobTraveller.ID; Also this: SELECT p...
I'm wondering if it is possible to use VBA to store, delete and recreate relationships on tables in Access VBA? The deletion part is easy, but how to store it in such a way as to be able to restore it after it's been deleted is where I get stuck. I originally wanted to know so that I could bulk copy certain tables from one database into...
I have a few tables: a medError table, an option table, and a selected_options table. When somebody submits the relevant form, I have an insert which inserts all the info from the form to the medError table. However, on this form, there is a section of dynamic checkboxes based on the items in the option table. The selected_options table...