Threads Replies Last Post 43 Pages: <<  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  31  32  33  >>   y_board_Enter_function)_on_Form. Hi, I am using FORM to enter ID number and Employee number. For this I am using touch screen. We are not using key board. I just need to create Macro or VB code with a Command button when press this button need to do “Enter” . Then it is going to next field. Any help would be appreciated. Indu Create a button to do “Enter”(Key board Enter function) on Form. Indu ... 2 03.05.2006 13:41:37 Executing a Macro from a script I am using a script (.bat) to run msaccess.exe which in tern runs a macro. My server has Microsoft Access 2003 installed, but the database itself is version 2000. I have a 3rd party scheduling software running the script. So far, I have not been able to run the macro successfully. The script either runs to completion according to the scheduling software, but does not run the macro or... 4 02.05.2006 00:33:04 How do I requery a combo box in a subform? Hello, I hope you can help! I am creating a database with details on Retro gaming systems. I have a main form, called Systems, where everything to do with old Retro Gaming systems is displayed for each System. From within this form, I have a tab control, which has two tabs: Games and Accessories. Each displaying the details of all games or accessories on that particular system by w... 10 09.05.2006 09:31:26 Siva from India.. Help please I have done a project in access and created Report with the help of Macros to export into Excel sheet. After creating Excel sheet I have created one more Macro to create good look in Excel. Should I do it from Access itself to operate excel macro.? I mean my excel macro should work when I export from access itself. Pl. provide example also... Thanks, Siva from India... ... 1 09.05.2006 06:35:01 Siva from India I have done a project in access and created Report with the help of Macros to export into Excel sheet. After creating Excel sheet I have created one more Macro to create good look in Excel. Should I do it from Access itself to operate excel macro.? I mean my excel macro should work when I export from access itself. Pl. provide example also... Thanks, Siva from India...... 1 09.05.2006 05:41:00 Filter by Selection macro not working Hi, I created a macro that uses "Run Command" and then I chose "FilterbySelection" from the list of available commands. I used the Wizard to assign this macro to a command button on my form. When I try to run it I get the following error: ACTION FAILED. then another box that says COMMAND NOT AVAILABLE NOW. Even though I can use the regular FilterbySelection button from the toolbar j... 1 09.05.2006 02:28:02 macros generating incorrect SQL in SQL Server 2000 Hi, ok, I'm a bit of a newbie (or rather, I've been away from SQL Server for quite some time). A client has given us an Access DB to "migrate" to SQL Server. Moving the tables, related data structures, and data is no big deal, of course. The macros on some of the forms are another story, though. Many seemingly simple macros create ODBC errors when they're run now. It appears to be that ... 1 08.05.2006 20:41:01 "This recordset is not updateable..." did my macro cause this? Background: I have created two forms to view the information in an asset database: One form (Asset) looks up by asset number (the asset number is also the key field for the database), the other form (Location) looks up the assets that are located at a particular office or location. I am trying to link the two forms using a macro: the Macro: At the Location form, there's a button call... 1 08.05.2006 17:49:03 Help with Access sending an e-mail I am trying to get Microsoft Access to send a report using SendObject in a macro. I have the macro working and it sends the e-mail with the report to Outlook, but Outlook does not send the e-mail. I have to manually open Outlook, go the Outbox, double click the message and then click send. I tried chaning the property Edit Message in the Access macro to YES and then clicking SEND when th... 4 08.05.2006 15:15:30 Open Report I would like to be able to open a report in another access database. Can somebody tell me the best way to open a connection to a database and call a certain report. -- Thanks in advance Stefan... 6 07.05.2006 23:03:02 Use a macro to export a table to Excel I have a macro that runs a make table query to pick up 'unmatched' data and put this in a seperate table. After running the query the macro renames the table to include the current date using the expression ="SUN_InRDB_NotArcade_tbl_" & Format(Date(),"ddmmyyyy"). I would then like the macro to export this data to Excel using the new table name as the file name. I don't want any prompts ... 2 05.05.2006 07:53:01 Rename Action Is it possible to set up the Macro to prompt for the new name in the RENAME action?... 2 05.05.2006 05:36:40 Condition If, Then, Else logic How do I make conditions in a macro work like an if, then, else type statement? What I would like to do is have the macro run a query, if the results are null; follow one set of commands, else if the results are not null follow another set of commands. I can make the macro run the query and recognize the condition, but not choose the path I want it to follow within a macro group. An... 7 04.05.2006 20:18:54 automatic dublicate Hi folks, hope you can help me out. I am working in a small private school and we have a DB for studentsdata, classes, etc. I wonder if there is some way to create an automatic "dublicate" for a record as long as lets say last name and father's name of a new student are the same as of one old student.. In that case we could assume that this child is a brother or sister of some already in t... 3 03.05.2006 22:10:02 delete all tables in a database with macro I have to delete all tables in my database and then import new ones from a source. If I try to delete the tables manually then I get a confirm delete message for each one. This is tedious. If I simply import the tables without deleting the original ones then the new ones get a numeral appended to the name. (ex: orders1) This causes problems with my queries. Any suggestions?... 7 03.05.2006 19:46:19 How do in use macros in access to create relationships? I desire to import a table from another database, and repeat the process but maintain relationships with other tables in the receiving database.... 2 03.05.2006 13:46:02 What is an expression builder example to filter all exact matches? I have just created a database. Within the form i have a Last Name field. Basically what i need, is to be notified (by a msg box in a Macro) everytime that data entry is made with identical last names. I dont want to prevent it same last name data entry and there is no 1 last name i want to filter. Just any general last names that happen to be exacally the same. I know how to do thi... 4 03.05.2006 01:01:02 First in First out layering I started with the inventory template and configured it to suit my needs so this gives you an idea of what my database looks like. I used the suggestion by allen brown and set up a stocktable, Acquired table, and Acquired detail table. I need to have a guide for coding to be able to have the system to do fifo by quantity and price. The prices change by vendor and cardboard prices. So... 1 02.05.2006 23:45:02 Set all values in a field back to zero. (0) I need to change all the values in a field on a form (that is linked to a query and tables) back to zero, in order to enter new data for the new year. Is there a way to program this rather than having to scroll thru each record and manually type the 0 into the field for each record? I can't seem to get it right.... 3 02.05.2006 12:16:03 set value and goto record I'm running a macro that sets the value of a text box in one form based off another form and it's relaying the wrong info. When I type in the value manually it works ok but doing it by macro returns 12/30/1899 or 00:03:35 for some reason This is the code using in the set value dialog area item Forms![frmPMprocLO]![Text29] expression =[Forms]![frmPMByNum]![Dayup] Also, how do you ... 3 02.05.2006 00:18:03 additional code to filter results of macro needed hello I am in need of additional code to filter the results I am getting for my macro. right now the code creates a list of all diagnoses and ICD codes for a specific patient according to the SSN. I want to filter this list so that it only includes Active diagnoses and omits the inactive ones. code as of now is: Public Function ListDiagnoses(TheSSN As String, TheDateofVisit As String... 2 01.05.2006 20:06:01 ANN: C# Online.NET FOR IMMEDIATE RELEASE First Wiki-based Online C# and .NET Reference at C# Online.NET Dallas, TX — A new concept in online references for Microsoft .NET programming languages is being pioneered by C# Online.NET–a new wiki-based, online C# and .NET reference. C# Online.NET offers documentation, tutorials, and C# source code examples for .NET languages beginning with the C# language. “Compa... 1 01.05.2006 17:16:27 using macro to email report on exact day and time Hello, I'm sure this has already been asked before but I'm trying to use a macro to send a report (any object) from the database on the last business day of the month. Any help would be greatly appreciated. I have the macro created with the 'send object' action but i don't know what condition to place before it to email on the exact date. Thanks! ... 3 01.05.2006 15:42:13 windows scheduler and access macros Hello, Can someone help me to look into using Windows Task Scheduler to set up a command line to open my database and run a few macros on certain predetermined dates? I was able to set up a task to open the database but this was directly connecting to the base not running a command line. Any help would be greatly appreciated! Thanks. ... 4 01.05.2006 15:21:34 syntax for where condition Can someone tell me what the correct syntax is for opening a form to a certain record based on a value from a combo box in a subform? I am using open form in the macro and I have tried the following in the Where Condition and when the Action Failed pop up comes up I can see in the aurguments that my expression just as it is in the macro which tells me it couldn't evluate my expression (... 8 30.04.2006 00:05:24 43 Pages: <<  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  31  32  33  >>