I have an excel file which I've been supplied a layout for with the name, length, start and end positions of each field for a data file. Any ideas on an any easy way to use this layout file to import the data file into its respective fields in access or excel? ...
I'm a .NET / C# software engineer who's been recruited into a temporary job function I'm not thrilled with. My company uses an MS-Access application for many of it's current functions. The Visual Basic version in use for this is (v6.5). The developer that assembled it (who's on vacation overseas at the moment) has a 'login' form that ...
Consider the following table: ID nonUniqueID value total -------------------------- 1 12345 5 x 2 12345 10 x 3 789 20 x 4 789 5 x I need to make a query something like this (psuedo SQL), which will work within Access 2007: UPDATE table SET total = SUM(value) WHERE nonUniqueID IS SAM...
I need to make a connection to an Access Database. In order to do that I created a System DSN. I had success making that connection using local files. However, the database must be at a remote server and I mapped a network drive so I can access the database files. Mapping the drive and using the remote files, an error arises when I try ...
Hi, I am trying to bring back records from a table called CTN_LIST where the created date is no older than 90 days. The code is below (created_dt<=-90) Set PlatinumList = db.OpenRecordset("SELECT FORMATTED_CTN FROM CTN_LIST WHERE ((Status='Available') AND (Category='Platinum')) AND (In_Offer_List = True) AND (Created_DT<=-90);", dbO...
Hi all, I have a report in Access 2007 that is opened by pressing a button on a form. This button triggers an OpenReport macro, where the report is told to open in Print Preview view, and Dialog window mode. How can I manually set the size of this window, along with the opening zoom level? In the properties of the report, both AutoResi...
I am upscaling an access 2003 database to SQL Server Express 2008. The tables appear to be created ok and the data looks ok. I have an MFC application that connects to this database. It worked fine connecting to access, but when I connect to SQL Server I am getting the following error on a select statement. DBMS: Microsoft SQL Server...
I have a project in Access 97 that I have to add the ability to export a report to excel. When you run the report within the program there is already the ability to export to word and to excel though the excel only some of the headers. Through research I found that I might be able to get it to work using OutputTo but unfortuneately I c...
I'm hoping someone can either tell me what I'm doing wrong correct my flawed understanding of how this works and explain why it's not possible. I've been developing a fairly basic database/program for a client in Access. They have Office 2007, I have Office 2010. Initial test of creating a database in 2010 (in "2007" format) and opening...
Hi, I've got a legacy MS Access DB. How can I see the changes made to that DB? e.g. changes of Code etc. Does MS Access store it? ...
I have 3 tables A, B and C I am doing this :- /* There is no relation between Table A and Table B . Table A is just used to provide values to C.Profile */ 1st step ) D <---- Select * from C where Profile=1 // want to give a specific ProID(I have successfully retrieved it from A table) 2nd Step ) Output <--- Select B.sname,D.Status fr...
AdoTable1.Filter:= 'Date = #'+FormatDateTime('dd/mm/yyyy', Tomorrow)+ ' #' ; Why is Date surrounded with number signs?? Is this Access -specific?? thanks in advance! ...
I have a Microsoft Access database and I have two tables. Table1 has a primary key and Table2 has a foreign key that references Table1's primary key. This relationship is set up and viewable in the Relationship viewer in MS Access, the 'Enforce Referential Integrity' check box is checked, and the Join type is an inner join. The relations...
My problem is that my program only crashes when debugging using Visual Studio. The background: My program comprising various modules accesses an Access 2007 database via one module. I installed Access 2010 to do some testing of it so we can see if we should use that runtime in a upcoming release. I built all my modules in debug and I ca...
I am working with a fairly large database of information. I need to use a distinct set of values in one saved query as the parameter in the 'where' clause for another query. What is the best way to iterate through the result set of distinct values? I am fairly new to Access and VBA. ...
I am working with a table that someone else designed. The field is designated as a number. I want to enter a 2 digit number with one decimal place. [Ex: 27.5] The field is automatically rounding to the ones place with a 0 in the tenths place. (27.0) The field size doesn't matter, I have tried them all. I put in formatting and an inpu...
I am updating an Microsoft Access 1997 mdb. I want to find out how one of the reports are generated and I am not sure which queries the program uses to generate the report. I am only able to access the design and preview mode or the report. Is there an easy way to identify how the report is generated? Specifically which queries, tables...
I'm trying to get the length of a string in order to format a report using VBA in Access 2000. Yes I know this old but it's what I've been asked to do. I want to get the width of the string when printed; exactly what TextWidth() is meant to return. What I'm finding is that for strings ranging for 4-20 characters the returned value can ra...
Hi, I need somebody to point me to the right direction, I have a MS Access DB that is updated by HP devices, and I have to sync it with the SQL Server 2008. I have a few Ideas, and I would like to know what do you think about this: Is there anything like triggers on access? if so can I comunicate with a SQL Server? Is there any way to...
i have create a login forms name login where the username is type in txtEmployee textbox and i need to display the same in the second page in form in ms access. ...