Hi all, I have a form with 1 combo box (YearToBeBuilt) and 2 text box fields (Cost and YearofExpenditureCost). All controls are linked to a main table and the table is updated once the selections/entries have been made on the form. I have written a procedure in VB called ReCalcIt()which performs the following procedure when called: ...
I have an Access 2007 db with a table that is a linked text file. The db is used for reporting purposes only, no updating. When more then one user accesses the db which is stored on a network share, the second user gets an error message. "the microsoft access database engine cannot open or write to the file........It is already open...
Such a simple question, but I cannot find the answer (Google, MS help, SO): How can I check by VBA whether an unbound checkbox @ a Access form is checked by the user or not? Can't find the right property. Thanks in advance. UPDATE: I use this code after the suggestions of @HansUp and @RC: Private Sub CmdTest_Click() MsgBox "Check1...
So I have an access mdb file that was originally create using Access 2003/Office 2003. Since I have recieved a new image at work that has 2007 Office installed. The file extension of the access database is still mdb., and the convert was done to 2002-2003 Access database previously. Here is my question: I have users that still need to a...
The use of lockWindowUpdate API in VBA code avoids screen flickering when updating screen content. It also greatly improve calculation delays, as the computer do not have to refresh the screen after each calculation\update made on the underlying recordset. Unfortunately, I cannot have it work correctly with Access 2007 runtime! On some...
I have used .NET 3.5 with C# to create functions to gather data from a product's web service. Now we have a need to be able to get at that data in a Microsoft Access 2007 application. I am not particularly familiar with VSTO et al, and I don't want to have to fuss with anything on the MS Access side--I'll leave that to our VBA expert. B...
Hi, I've got an Access application that connects to Sybase 1192. Access 2003 works fine, but when I open the same app. using Access 2007, I get the message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified I've checked using the command prompt that I'm able to connect to Sybase successfull...
In Access 2007, I have a form set up to allow previewing and exporting options for the project's reports. DoCmd.OutputTo seems to behave strangely when dealing with reports that have the Modal property set to true. Modal is currently set to True in the Open event for all of the reports that I'm working with. If I do DoCmd.OpenReport s...
I have an MS-Access 2007 database with links to SharePoint 2007 lists, I run XP professional. The lookup fields are not all updated when I synchronize after I create records offline . I built a test with the following result: I created 3 SharePoint lists A, C, D. C has a lookup to A and D has a lookup to A I created an MS-Access databa...
I am using a Delphi procedure to Compact Access Database Code sniphet of procedure is: procedure CompactDatabase(pFullDatabasePathName : string; pLoginName : string = ''; pPassword : string = ''; pSystemDb : string = ''); var JE : TJetEngine; sdbTemp : String; sdbTempConn : String; sdbSrcConn : Stri...
===problem=== i'm using a LEFT JOIN, SQL expression, on 3 tables. i'm getting an unexpected error "JOIN expression not supported" from MS ACCESS 2007 when i try to run it. ===details=== these tables are all connected parent: is at the highest level child1: child of parent child2: child of parent grandchild1: child of child1 thi...
I've got a Access 2003 application that generates Excel reports by querying Sybase. One of the reports produces 204,000 rows. This was getting split across multiple sheets in Excel 2003. I'm now testing whether Excel 2007 can be used and if all data can be dumped into a single sheet. The Access VBA code used to copy result sets to Exc...
I need to prompt the user for 2 dates, e.g. 1/1/2008 , 2/5/2008 , and generate a two column report with all 0-23 hours for each date in the range. The date being in the first column and the hour being in the second column. 1/1/2008 0 1/1/2008 1 1/1/2008 3 [...etc] 2/4/2008 23 ...
I had asked this prior, but I think I worded it poorly or perhaps not clearly enough. I'm pretty new to Access and SQL, but I'm pretty adept with computers. I've read a few books/websites on Access/SQL, but I'm finding this problem a bit difficult. This would be a lot easier if it was a simple SELECT range, but the scenario wants me to g...
Hello, What are best practices for deploying an Access application? I use a BE/FE architecture, both parts Access 2007. I don't want the users to change the VBA code or the design of forms or tables. May be adding adhoc queries. Should a make a ACCDE file? Thanks in advance for your suggestions. ...
I have several excel workbooks that each have a desire spreadsheet that will continually be updated with data by non-tech users and the process now is that the data is being manually entered into an Access DB through an Access GUI that is linked to the DB tables. To eliminate the manual input I was thinking I can import the data into acc...
Normally, I'd set a "Contains" filter on my string field, and enter my value in the modal box, but I want to audit the process. UPDATE Data SET Data.[Assumed Expires]=Data.[Assumed Expires]+365 WHERE Data.[Description]=strSearch; Thanks a pile! ...
Trying to construct a query in Access 2007. One of the columns has the data type "Memo". Sometimes the latest version is returned and for others the display is blank. Only if I right-click and select "Show column history" on each row, can I actually see the full set of data in this column. Is there a way through the query designer or...
I have a table that stores invoices and a form based off of that table that looks like an invoice so that you can search previous invoices. Currently I am creating the invoices in excel and then exporting the data as a new record into the Invoice table. I was wondering if there was a way I could create the invoices from my Invoice form. ...
I am trying to change a text field to a number field, however, any attempt to make changes is met with the same error. Apparently this field is part of a relationship. I've looked through everything. The relationship window shows no connection to this field. I have selected the show "All Relationships" button, but still nothing. Ano...