Threads Replies Last Post 359 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>   Autonumber in an unbound form using VB I am not sure how to do this... I have an unbound form named frmWallDetails. I want to autonumber a field named "wallNo" using a query as the date source using VB. Any suggestions will be greatly appreciated. Regards, Walter... 3 12/26/2008 5:56:01 PM Year prefix on primary key autonumber, but restart with '1' yearly Basically keeping the original autonumber and create another auto added one with the prefix, have all foreign tables use the auto added number while the autonumber runs in the background....? All in Main table: 1. Rename and keep the existing autonumber (ProjectID_orig) in order to keep all existing records as they are. (do need to delete the relation ships and reinstall after renaming, ... 13 12/26/2008 5:54:01 PM Deleting a LAN file from Access using VB I create reports and output them to a directory on the LAN. I need to delete the word document on the LAN if someone deletes the information relevant to the Word document. For example, if someone creates an invoice and saves it to the LAN and later that invoice is deleted, I need to delete the Word document they saved to the LAN.... 2 12/26/2008 5:07:44 PM Disable or remove the close button in Access 2007 What code do I need to use to hide or disable the close button in Access 2007? I know that the idMSO is "WindowClose" but I am just not sure what the XML needs to be. Mr B ... 3 12/26/2008 2:14:00 PM transferspreadsheet worked in Access 2003, doesn't work in Access 2007 I have a database I built in Access 2003. It has been working just fine for 1 1/2 years. I just converted it to Access 2007. One of my instances of transferspreadsheet no longer works. All the other instances work just fine. I get an "External table not in the expected format." error message. I've tried using an .xls and .xlsx extension for my export file. I exported the query using th... 5 12/25/2008 4:55:46 PM Automating Excel Spreadsheet With Access 2007 the calculated cells are not showing formulas... My Access program creates an order guide spreadsheet that is sent to the customer... he fills in quanity (column 3) which needs to be extended by the price (column 4) and put the result in the Extended (column 5). i also give an order total at the bottom of the range.. (essentially column5 = column4*column3)... Can s... 2 12/24/2008 8:18:30 PM Use relationship or not? I have a very large main table (over 100 fields) that I can easily make into other "main topic" tables ... that is I can make it into 3 instead of having just the one. There would only be a 1-1 relationship. Is there ever the time when this is ok to use? I've never had a table this big before and it is kind of freaking me out. Thanks!... 8 12/24/2008 7:35:01 PM Constant expressions error I'm sure I'm missing something simple in this, but needs some help. I have a form with 3 drop-down combo-boxes, which a subform is populated with a list of questions (which has another subform which will populate the answer, but not got that far yet) from the selections made from the drop-downs. I had a look around and found http://www.microsoft.com/office/community/en-us/default.msp... 5 12/24/2008 6:32:38 PM Setting focus to main form Thanks for reading this. Here is my problem. I have two forms I'm working with. Main menu form {frm_menu} and a sub form called frmbkbox which is hidding. The way the subform works is when I get to day 7 that subform appears and has a button that you click on to perform the backup/copy. Clicking on the button does perform the backup/copy. Where the problem comes up is when I try to hide the ... 4 12/24/2008 3:28:25 PM Linking a field to a Query in VBA Dear all, I'm trying to use VBA to output the results of a list of Queries to Excel spreadsheets using the TransferSpreadsheet command. What I have is a source table with the Query names, and a relevant department code, so I'd like to use this table to create only the queries that match a specific department. In short, I'm creating an Excel Workbook with a number of audits for each ... 2 12/24/2008 11:40:16 AM 2007 Ribbon: minimize using code Hi. Does anyone know if the ribbon in Access 2007 can be minimized using code? I know that it can be hidden using this code: docmd.ShowToolbar "Ribbon", acToolbarNo But I just want to minimize it. Thanks much!... 2 12/24/2008 11:14:15 AM The ABC's of Application Distribution Hi – I’m nearing the end of development for a small Access application and I’m starting to think about beta testing and distribution. I’ve developed the application completely in Access 2003 (I don’t own, nor have I used any “developer’s editions" or tools like Visual Studio). I need advice on preparing & packaging the application for distribution. What are the essent... 7 12/24/2008 1:17:02 AM Parent reference I've addressed this question in the reports group, but I have a more general question. The ID field in my database uniquely identies a customer. For different applications in my database I want to the user to supply the info to determine the ID, either an ID or a last name or a last name and first name. So I've created a generic form that will determine the ID. I will then use that I... 2 12/23/2008 11:38:55 PM Using a stored procedure as record source of a form - does this wo I am converting to an ADP and I am trying to replace a sql statement in a form record source with a stored procedure. I added the parameter needed by the stored procedure to the Input Parameters. Everytime the form opens I get an error. It is not a problem with the stored procedure because it runs fine from SQL Mgmt console or from a VB.Net application, so this has to be yet another pecu... 1 12/23/2008 10:45:01 PM Synchronize 2007 with runtime Is it possible to distribute a form in a runtime environment and create functionality to update a Sharepoint server? If not, what is the option with 2007 to synchronize data in a distributed runtime environment?... 1 12/23/2008 10:27:05 PM Changing MainID Autonumber into auto added number YY0000, incl. ye I am running into the dilema not beeing able to use my current autonumber as my mainID, primary key.... I need to use a six digit number which has to inlcude the last two digits of the current year the record is added, 090001, 090002…. The dBase already contains 10,000+ records in a dz tbl's and need to keep the records. Thanks for your help!! ... 2 12/23/2008 7:48:28 PM print form hi, i have the following print code which works in excel, but i am trying to figure out how to modify it to work in access to print a form: ActiveWindow.SelectedSheets.PageSetup.Zoom = 80 ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True thanks in advance, geebee ... 2 12/23/2008 4:56:07 PM Closing recordsets I'm really trying to establish good habits regarding garbage collection while coding in VBA. I like to always do a "rst.close" and "set rst=nothing". However, sometimes "rst.close" fires an error because there was an error while it was in scope (I assume, anyway). So, I haven't found a definitive answer on whether "set rst=nothing" alone is good enough, even if rst is still in scope... 5 12/23/2008 5:46:01 AM Download File, Copy Text To Clipboard A Web site has 1,000 hyperlinks, each pointing to a different text file with a .abc extension. I have loaded the document names into an Access table, intending to write a program to download the files. To that end, I have set a reference to the Microsoft HTML Object Library, so I can create and control an instance of MSIE. Problem 1: MSIE won't display a file with a .abc extension. Inst... 5 12/23/2008 2:36:39 AM Insert Into?? Add record to an unbound table?? I'm not sure how to do this. I'm using Access03; I have a workorders form and then a workorder parts subform. The subform is bound to the workorder parts table. I also have a table called "InventoryTransactions." This is from one of the MS example templates. If a user creates a PO, the quantity ordered and quantity received values are added to the table InventoryTransactions. When a ... 2 12/23/2008 2:11:23 AM form not opening hi, i have a form that took me 2 days to design and code. then this morning when my supervisor logged (the database is on my desktop. i am hoping this is coincidence rather than trying to sabotage) in i noticed that i got an error message after I added an IIf statement to one of the fields... the error message basically said "... there is not enough memory to perform.. please close... 3 12/22/2008 10:49:56 PM SQL string in VBA Good day all; I'm having a problem with an SQL string built in VBA. On my forms I'm using the value in a Combo Box (e.g., cboSelChkList) as part of the SQL string to filter the form’s recordset. The SQL created in VBA replaces the form’s Record Source. This works fine in that scenario, but does not work in another. The subroutine to build the SQL is as follows; Public Sub SelectR... 5 12/22/2008 10:41:01 PM automatically import multiple named-ranges from Excel to Access I have named-ranges in multiple Excel 2003 workbooks located in a single directory. The named-ranges that I want to import from each workgroup are identical. For example, cells $A$4:$R$199 are named 'HOUR12' in each workbook. I would like to import all of the named- ranges, 'HOUR12', from each workbook into an existing Access 2003 table. The headers and formatting in each named-range are iden... 7 12/22/2008 9:37:01 PM >> class recordsource Hi, just wondering, is it possible to have a class as the recordsource for a form or report? If yes, how? The reason is that I would like to have more control over record navigation, editing and audit trail. Many thanks, Jonathan... 4 12/22/2008 8:51:01 PM Automating a rename of a table? Need a methodology for automating (either in VBA code or inside a macro) renaming a data source (the problem here is that when you import a filename with the same name as an existing data source, the imported filename gets subscripted with a 1 - in order for the queries to run properly, we have to rename the data sources removing the subscript and overwriting the original data source bef... 4 12/22/2008 6:44:44 PM 359 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>