In VBA (Access 2000) is there anyway to send information to a form between two open instances of the database? For example : User 1 has an instance open of DB.MDB on his PC and has FormOne open. User 2 has another instance of DB.MDB open on her PC and has FormOne open. Can User 1 maniuplate the contents of a textbox on User 2's FormO...
Hi, I am working on an Access database and in it I need to extract several reports. For one of them I need to compare two lists of numbers, List1 and List2(I get both from separate queries) and display only those numbers that are in List1 but not in List2. Can anyone help please? Thank you. ...
I am trying to open an ADOConnection component. The database is in MDB format. I use JET to access it. Whenever I use AdoConnection.Open in my code the window pops up and asks for userid and pass. I enter "Admin" for userid and leave password empty, and it works, but I don't want this window to pop up. I tried using AdoConnection.Open('A...
Hi The situation: In Outlook I get a message from a server. The content of the message needs to be put into an Access db. But, there may not exist another message with the same date. So, I need to look into a db if there is already a message with the same date and time. If there exists one, then it needs to be replaced and otherwise th...
For ease of discussion, consider this basic table (Test) in Access... ID division name role 1 1 Frank 100 2 2 David 101 3 3 John 101 4 2 Mike 102 5 2 Rob 102 7 3 Dave 102 8 3 Greg 102 I want to count the users of a certain role in a division. If I ...
I'm having a heck of the time trying to figure this one out. I want to pass a Controls collection to a function but I get a type mismatch. Here's the function declaration: Public Function DoStuffToCollection(topCtlList As Controls, isLocked As Boolean) And here's how I call it: Call DoStuffToCollection(myPage.Controls, isLocked) m...
I need to join my data table to a server calendar file (has set fiscal dates, periods, etc.). I don't get any results and believe it is because my table has date/time like "11/23/2009 11:30:34AM" and the calendar file only has date/time like "11/23/2009", so the fields are not identical. current SQL reads like: From tbl_data Inner Join...
Hello, I'm making a database in Access 2007, and currently I'm struggling with a query. In only one column, it is possible to cose multiple answers. So, when I open the query I get 3 rows when 3 answers were given. I would like to concatenate the rows into one. Sometimes there is no answer, sometimes 1 or 2 or maximum 3. For the moment...
hi I just migrated to ms access 2007 and created my own ribbon. In my form, I have this "print" button where if you click that it will open the "report form" here is what I wrote in my VBA code: Case "btnPrintRevisionEingabe" DoCmd.OpenReport acReport, "Revision_Eingabe_rpt", acSaveNo and when I clicked on the "print" button I'...
First some context: I have a Microsoft Access 2000 project (ADP file) accessing a SQL Server 2000 Database. The main form of that application has a lot of controls and subforms. On one of the subforms which contain a summary of some information about companies, each record has two buttons that lead to a search form that access a web ser...
My client has an Access (2000) application that we didn't write and we don't have access to the MDB (it's an MDE). One of the functions is to create a packing slip report. There's no option to preview, only print or save to file. There's a field that represents a weight; it's a Double field. On a standalone machine, it prints correctly...
I have an access table with an automatic primary key, a date, and other data. The first record starts at 36, due to deleted records. I want to change all the primary keys so they begin at 1 and increment, ordered by the date. Whats the best way to do this? I want to change the table from this: | TestID | Date | Data | | 36 |...
Let's say we have a [Valuations] table containing several values per date and per fund: -FundId -ValDate -Value1 -Value2... The Primary key is obviously FundId+ValDate. I have also indexed the ValDate field since I often query for values on a specific date. My question is: should I also create a specific index for the FundId, or i...
I've struggling with this problem on my own, then with some help, then search about it; but I haven't had any luck. So I decided to ask. I have two forms in Access 2007 lets call them MainForm and EntryForm. MainForm has a subform and a button. The button opens the EntryForm in Add Mode. What I want to do is when the EntryForm saves the...
I have my database set up as such: Each product I have has it's own table where it records the quantity sold/transaction # (so column 1 is "transactionID", column 2 is "quantity") ex) p-backScratcher (where p- is indicative of "product") There are also tables for each year which hold records of each transaction that went through. Eac...
Is there a way to export a database query to OPML? ...
I'm trying to return an ID's last 4 years of data, if existing. The table (call it A_TABLE) looks like this: ID, Year, Val The idea behind the query is this: for each ID/Year in the table, LEFT JOIN with Year-1, Year-2, and Year-3 (to get 4 years of data) and then return Val for each year. Here's the SQL: SELECT a.ID, a.year AS [Year],...
Hey, I don't really understand database connection strings so I'm having problems debugging it. Any help not only figuring out the problem but also what is going on would be really appreciated: I have a website on my localhost and I'm trying to get a sqldatasource to populate my gridview but it gives me the error 'Data source name not f...
i have a security application that stores its data in a access database.now i'm required to make a realtime synchronization (replication) between that access database and a new database in sql server 2005. these two database are the same. any suggestion?! ...
I'm trying to produce a list of names and addresses of our clients that have paid within a particular timeframe. Doing a query with just the client table is fine, but when I link in the payment table and access fields from that, the clients address (memo field from the client table) is displayed only as little square symbols. If I leave...