I have a continuous subform in an Access 2003 form. The first control on the subform is an unbound dropdown box. When the form (and subform) are opened the dropdown on the first record receives focus, but the text is blank (just a blinking cursor). If I click on any other record, the first record's dropdown text then display the corre...
I have a JET table with an auto-number as the primary key, and I would like to know how I can retrieve this number after inserting a row. I have thought of using MAX() to retrieve the row with the highest value, but am not sure how reliable this would be. Some sample code: Dim query As String Dim newRow As Integer query = "INSERT INTO...
Using Access 2003 Date Column datatype is text Table1 Date 20090528 20090529 20090530 20090502 20090504 Expected Output 28-May-2009 29-May-2009 30-May-2009 02-May-2009 04-May-2009 ..., How to make a query for the Expected Output Date format? ...
I need to create a decimal field in MsAccess 2003 through DAO. How do I do that? Other fields I can create using following codesnippet, but not decimal. How do I set type, precision and scale? NOTE : a decimals datatype = 20, but setting a datatype to 20 results in invalid data type Dim db As DAO.Database Dim tbl As TableDef Dim f...
The application part of my database is in Access 2003, and I use tables that are linked from SQL server. Now, I have some tables that I have to link from an Oracle database. I link them through and ODBC connection and it works fine. Is it possible to link that Oracle link in SQL and then link that table as it is already linked in Acces...
Pretty much what it says on the tin. I've tried googling around but can't find anything helpful. I'm trying to automate a process and part of that involves running forms/VBA code from an access 2003 database. What's the best way to call these from C#? ...
BACKGROUND: I have an Access 2007 application, with a form which builds a Filter string to pass to a Report, which uses a stored query. In Access Options, I have "SQL Server Compatible Syntax (ANSI 92)" checked for This database, and the Filter string includes a LIKE clause with % wildcard characters. ISSUE: Randomly when I save or...
I've got two ms access .mdb files that I need to compare/merge. Any good tools out there for this? Any way to easily export both to ascii sql where I can use something like Beyond Compare? ...
Does anyone know where I can find a good mapping tool to use in connection with Access data? Similiar to Mappoint but not even as detailed/in-depth. Anything that would work with Access or Excel would be really what I need. Thanks! ...
I have an access 2000 application to manage. The DSN is pointing to the production Postgresql database and I'd like to point it to the one running on my machine for testing. The problem is, I can't figure out how to change it. I tried running odbcad32.exe, and I did see the DSN and was able to change it to what I wanted (and it did pas...
i have a pretty complicated form. as you can see below: however, i have only maybe 8mb of data total in the database. the way it works is it populates the listbox all the way on the left with all the record names. when you scroll through the records it loads the appropriate data for each record when i scroll through the listbox all...
can someone give me an example of what a calculated control is in ms-access? ...
i have been hired to take over a ms-access database. i know sql and vb.net and vba; however i dont have experience with ms-access. this is what it looks like: what steps should i take to start to understand the structure ? ...
is this good code? can it be simplified somehow? SELECT u.id,u.title,u.title,u.first,u.last FROM (((tblusers u LEFT JOIN tbluserstudentteacher ON u.id = tbluserstudentteacher.student_teacher_user_id) LEFT JOIN tblUsersSubjects ON u.id = tblUsersSubjects.user_id) LEFT JOIN tblUserAvailability ON u.id=tblUserAvail...
I have a query that shows me a listing of ALL opportunities in one query I have a query that shows me a listing of EXCLUSION opportunities, ones we want to eliminate from the results I need to produce a query that will take everything from the first query minus the second query... SELECT DISTINCT qryMissedOpportunity_ALL_Clients.* FRO...
I'm currently rewriting our company's database app, which is an Access-VBA frontend for a SQL Server (Express) backend. I've been managing the application for 4 years or so now and when I started here it was a single *.MDB-file on a network share (which got corrupt on a weekly basis). Since then I changed the DB to a multi-user *.MDE, ...
I am trying to export the following data in the query from ms sql server to access, it says an error "Field wkid already exists in the table results" when i try to execute the same using sql query analyser, its not giving any error.i am getting the results in the grid Select a.wkid,a.stid,a.pfid,pf.pfname,a.modid,mm.md,a.catid, [sp],re...
Hi! Often a label control is bound to a textbox or similar. I know that there is a way to access the label through code, but I do not remember now how to do it. Anyone that knows? Maybe something like: Me.txtName.Child!lblName.Value Or Me.txtName.Parent!lblName.Value I will use this when I am enumrating through the controls on a...
Hello, I have a Microsoft Access form that is bound to a linked SQL Server table that has a computed column. I have a control bound to the computed column. I already realize that the computed field cannot be refreshed until AFTER a record is saved. Beyond that, what is the best way to refresh that textbox that is bound to the compute...
Hi I've been working on a project where to migrate the databases from MS Access 2003 to MS Access 2007, with customizing ribbons. I was able to have it work but the problem now is every time I open forms or reports it became very slow. And I don't know why Another thing is: The QAT also disappears. Any idea why? Thanks Additional: ...