Threads Replies Last Post 225 Pages: <<  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  >>   Change Recordsource with VBA I put a toggle button on my form that I want use to switch the recordsource of my form. Here's the code I am trying to use: Private Sub tgl_Active_Pending_or_Comp_Click() If Forms!frm_Implementation_Pipeline.RecordSource = "qry_Implementation_Frm" Then Forms!frm_Implementation_Pipeline.RecordSource = "qry_Implementation_Frm_Complete" ElseIf Forms!frm_Implementation_Pipeline.Re... 3 31.08.2006 19:39:02 Textbox event calling function on Drag & Drop I have built a form with a textbox where I can drag and drop text. I want to be able to call a function after I drop the text on the box. My problem is the onChange event must fire before the text is in the box because my code fails because there is no text to work with. Is there another event that would work better or a way to delay the execution of the function until the textbox contai... 2 31.08.2006 19:15:32 Programming interaction with Excel from Access The following sub works fine--fromAccess it opens Excel and plops a formula into a given cell and does the calculating. My question is: Can I make a form in Access where the user can enter a formula and associate that input with a variable in the program below so that we can change the formulas in Excel without changing the sub everytime we want to make that change? I hope my question... 2 31.08.2006 19:08:02 maxlocksperfile I am trying to update approximately 15,000 records. I keep on getting Error 3052: File sharing lock count exceeded. Increase MaxLocksPerFile registry entry. How do I get around this. This program ran fine under Access 97. We just upgraded to Office 2003. Any ideas would be appreciated. -- M. Shipp... 2 31.08.2006 17:35:11 Search results to display in subform I want to create a search form where there are unbound text fields (search in one or more fields) in the Form Header, with the subform in Details. I would like to display the fields in the subform. I would also like there to be an option to create a report... I'm a Beginner/Novice at coding... Any help would be appreciated. Thanks.... 4 31.08.2006 16:49:02 Opening up a Emulator I am trying to use the Shell Function. I know that the Shell function opens up a .exe file but what if you have to open up a exe file plus a setting for that exe file. Pcomm = Shell("C:\Program Files\IBM\Personal Communications\pcsws.exe") This works but when it opens the exe file it asks for some settings and then it will not work. The Shortcut for the exe in the target: "C:\Prog... 4 31.08.2006 16:23:02 Another VB SQL question I want to update a table in VB based on responses on a form, ie: If txtIdea_Accepted = yes then update calc set accepted = 50. txtIdea_accepted has a record source in table "updates" that will record "yes" or "no", but I have a calculation table that needs to have an associated value to that yes or no for future calculations. Thank you for any help!!!... 1 31.08.2006 16:14:03 Access VB question I know this is a VERY BASIC question, but would appreciate help. I have a form in Access2000 that is tied to a table and used for input. I want to write a very simple SQL in VB to retrieve an ID number from a table within the mdb file and assign it to a variable. How would I do this? Essentially, the SQL I want to write is: "select max(idea_number) from ideas;" Thanks in advance for you... 5 31.08.2006 15:01:02 Creating a Distribution List in Microsoft Outlook I need to know how to move items from a query to a Microsoft Outlook Distribution list. I mainly just need the e-mail addresses to go into the list, but it wouldn't hurt to have the name corresponding to the address for each record. It is all the records in a single query. Any Ideas??... 1 31.08.2006 14:20:01 kick users off shared database I came across this code and am trying to use it for my database. Is a small database that will track the process of moving code through the SDLC process. Each time there is movement to testing an approval is warranted. There may be up to 20 or so people using this database at the same time and if I run into problems and need exclusive rights, I would like to be able to "kickemoff". ... 4 31.08.2006 13:55:01 DAO Recordset Help I need a lesson in recordsets. I want to use a recordset to open a form and add a new record. I am having trouble finding all the necessary code to create the recordset, make the form use that recordset and then update the table after they choose to save it. Should they choose not to save, the autonumber on the table should not advance. If I get comfortable with this code, I will use it ... 4 31.08.2006 13:04:03 Link to open text file I need to link a table to a text file that is always open as a service log file. This is for read-only reporting, and I don't care if the file changes after I open the table. I tried to link to the file, but Access refused. How can I link to an open text file? Thanks, Tony Scandora Tony at AES Systems Corp dot com... 3 31.08.2006 13:02:49 how do i convert dbase prg/exe file to work with access 2003 i am using dbase program with .exe file from .prg files. i need to move program to access 2003. is there any software that will let me convert .prg file that can create executable file that will work in access? thanks ... 2 31.08.2006 02:54:40 Need Help for Northwind Example in office Xp hi I m using the Employees form in the Northwind Sample in Office Xp, i have created a separete database & imported the tables , forms , macros from the Sample Northwind Database... After running the New Database , i am getting the following error in the coding,,I haven't do any modifications in the code.. error is: Compile error " variable not defined " in the following line ... 7 31.08.2006 02:04:02 New Record Design Delima I have one form that I use for two actions, modifying existing information and adding new records. To add a new record, my current method involves changing the record source to a temp table and append the new record to the main table. However, I have discovered the option "acFormAdd" on the docmd.open, etc., as another method and creating a new recordset, using addnew, and update. These ... 4 31.08.2006 01:53:10 refreshing linked tables: NO DAO hello, is there any method to refresh linked tables without having to code into DAO? Anything in ADO or ADOX? I think there should be something in ADO, but I'm not able to find out what. Help very appreciated. Rocco... 3 31.08.2006 00:02:01 Saving a field of a record as a string I need to create a module that will create a string that involves several records. The record fields are located in a query and the string should look something like "record1text; record2text; record3text;....". I need to know how to access this query, save the first record's field as a string and then move to the second, third, and so forth. I can do the loop and concatenation of string... 2 30.08.2006 20:12:02 Special Characters in variables Is there any way to use special characters in variables? I've inherited a database with messed up field names and I want to use a field name with a / in it as a variable. Is there a way to do this without renaming the field? ... 6 30.08.2006 20:10:13 Outlook Automation: Suppress Warings Hi, How do I suppress the virus warnings when automating Outlook to send email? Thanks in advance, Josh ... 3 30.08.2006 20:04:02 Running Access 2003 VB Module code example I got a code example of how to create a Module from the Microsoft Knowledge base on how to fix a problem with a hyperlink field. The example is at:http://support.microsoft.com/default.aspx?scid=kb;en-us;323202&Product=acc2000 The module works when I edit and and press the F5 key to run it, but how do I get it to run automatically without having to do that? I need it to run automatica... 8 30.08.2006 19:09:02 Automate sending e-mail based on values in a database Good Morning, I have a database that tracks recurriing employee training dates. I am looking for a way to send a training reminder via e-mail to an individual based on a date calculation. For example: It's determined (via calculation) that an individuals CPR certificate will expire in 60 days. This would be the trigger to send an e-mail to the individual an e-mail. The e-mail addr... 3 30.08.2006 18:43:02 desperately need code to automate access2003 from word 2003 > I have a Word document that is filled with data. I set up a button on > the document where the user is supposed to click on the button and run > VBA code. The code is supposed to open an access database and run a > select query and then insert new data into the access database. The > database is in the same directory as the document. I am limited to > starting it from W... 2 30.08.2006 18:18:11 pop- up I am doing a Printer inventory and have two columns, type of cartridge and the quantity. What I would like to do is when the quantity of each cartridge goes below 3 when exiting, every time, a pop up warning “Inc is low for cartridge X. Order more “shows up. So far I have it giving a pop up that tells when the quantity is low, but want I really want it to do is tell the type of cartr... 1 30.08.2006 17:25:02 Renter data I am trying to get access to (copy) renter a record into the table once a text box has been clicked. When the test box is clicked (after update) it places the current date and time in that box. I am wanting access to copy that record and insert it into the table as a new record. Can this be done????... 1 30.08.2006 16:49:02 Zip code linking Hi, I'm linking City & State to a zip code, but I want the function to pay attention to just the first 5 numbers in the zip code. Please advise how I would change this code to make that happen. 'Links some zip codes to cities Private Sub txtZipCode_AfterUpdate() Dim rsCurr As DAO.Recordset Dim strSql As String strSql = "SELECT City, State FROM tblCity WHERE Zip = '" & txtZipCode & "'" ... 4 30.08.2006 14:17:02 225 Pages: <<  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  >>