I'm using Access 2007 connecting to a MS SQL db through ODBC. I have a table called 'bases' it looks like this: Name ID Site -------------------- Home 1 111 Work 2 111 Car 3 111 Castle 4 111 Store 1 222 Rest 2 222 Now the tricky part is that the only part of this tabl...
Hi I want to get to the VB modules in Access 2007. Normally I would do it by Alt+F11, but it doesn't work. Thanks, nikolz ...
I'm in a college class using the Microsoft visual studio 2008 for visual basic and i have a project where i'm supposed to connect a database but it can't recognize the database file as a database. I followed the book exactly so i don't know what the problem is. ...
Dears , I developer a report in Access 2007 and i want to know if there is any way that allow me to view this report in Asp.net web page ? ...
Hi. I've created a database in access 2007 that needs to be used by 3 users. I'm stuck because I don't know whether to place a copy on each users' computer or to place it on their SQL server. Placing it on the server would mean one access point which is desirable for data consistency but I don't know whether I need ActiveX. Don't know ho...
I am building my own CRM access database that will contain a list of contacts. I would like to have an opportunity reference one contact as an employee, and another as the customer. Is there a way that I can add employees using their internal user ID (always 4 digits) and autonumber customer contacts? I don't plan on building forms un...
I am writing a distributed DB Application with an Access Front end. Essentially an mde with some forms and reports. Should I use an access mdb to hold the backend tables or use MySQL or some other database? ...
Hi everyone, as example, I've the following SQL query ( using Access 2007 ) SELECT ID, FirstMaturityDate, PayMentDate, iif(PayMentDate>FirstMaturityDate, PayMentDate, FirstMaturityDate) as Maxdate from Table 1 Actually, I need the alias Maxdate for further processing, but I don't want to to see Maxdate as column ...
Say I have a form on which a number of buttons exist. Everything works as it should when the buttons are clicked. How do I go about assigning keyboard shortcuts to my buttons so that Alt+A runs the action of Button A, Alt+B runs the action of button B etc. seems like this would be trivial to do but I've not been able to see where I can ...
I have a spreadsheet that I am converting to an Access DB. I have a column of typed out customer names that I want to replace with the appropriate customer number from our accounting system. I have created a table with the customer info, and a query that shows what ID needs to be inserted into the source data. What I'm looking for is:...
Has anyone ever tested a Microsoft Access 2007 .accdr application on Windows Vista 64 bit version? I sell a shareware program using the Access 2007 runtime, and, for one customer with that setup, there's some kind of problem. According the user ". When I try to execute the program, it opens IE and then brings up the dialog box to either...
How can I UPDATE a field of a table with the result of a SELECT query in Microsoft Access 2007. Here's the Select Query: SELECT Min(TAX.Tax_Code) AS MinOfTax_Code FROM TAX, FUNCTIONS WHERE (((FUNCTIONS.Func_Pure)<=[Tax_ToPrice]) AND ((FUNCTIONS.Func_Year)=[Tax_Year])) GROUP BY FUNCTIONS.Func_ID; And here's the Update Query: UPDATE...
I'm doing some development in access and I'm running into an issue where I need to make sure that a form is updated in a buttons OnClick handler. I was thinking that it might work something like this: if me.dirty then me.update 'This is a nonexistent form method' end if <rest of handler> If such a thing exists, will I have to...
I'm building a form in access that has a several sub-forms in a tab control The sub-forms are working fine, but when I set the parent form's Record Source property and bind a few Text Boxes to the data, I find that a null recordset has been returned. I've tried this with several different queries (each of which works in a separate quer...
Although I've done VBA projects within a single application for both MS Access 2007 and Excel 2007, I haven't automated multiple applications at the same time. The generalized project is to open access, run some update queries that appends data to various tables. Then Excel needs to get the data. Some formating changes are needed in E...
As in the title I cam across a strange phenomenon. I have a form which contains two subforms. On both subforms I have a button which triggers requery of the relevant subform. If after loading the form, I immediately click on this button (requery the form) I get error "3021: No current record" when I try to save the value of the primary ...
Dears we want to have a hosted C# web service in IIS that i can pass to its method SOL Query and it execute the query on a Access 2007 DB file that exist in the same server that contain Web service and return data We Already the following code <%@ WebService Language="C#" CodeBehind="~/App_Code/Service.cs" Class="Service" %> u...
I have an Access 2007 Project with a SQL Server 2005 backend. However, when creating a new stored procedure from within Access, it comes up with an error: ADO error: The specific schema name DOMAIN\username either does not exist or you do not have permission to use it How can you create a stored procedure using the 'dbo' schema ins...
Just curious, when I imported data from a spreadsheet with 519 lines into an empty table, why did my autonumber keys start at 56,557,618? How big can this get? I don't want to end up running out of digits for my primary key field as I didn't even start on the project and I expect to be dumping spreadsheets in quite regularly. ...
I have an access 2007 table with about 3000 records, to which I have added an additional field containing a numeric value. I would like to run an update query on the table, going through all the records in my table and setting the value of this new field to the same as an existing field in the table. is there a quick way to do this in ...