Threads Replies Last Post 363 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  >>   Programming Form in MS Access 2000 Hi! I need to program a form in MS Access 2000, so as I see, I need to know Visual Basic to do it. I am very new in programming, that's way I ask you: 1.- How can I change a "Date fiel" to "number field"? 2.- How can I declare a Array? 3.- Becouse I need to subtract two "Date fiels" I think I need a type transformation otherwise it dosnt work. Many greetings, Latina_Da... 5 25.09.2006 15:17:01 Writing to StatusBarText I asked this before but it seems to have disapeared: How can I display a message at the botton of the form. I'm trying to set the StatusBarText but it won't let me. Me.StatusBarText = "Hi everyone!" <<< doesn't work ... 5 25.09.2006 14:44:18 Customized standard menus and toolbars have been reset! Hi, I am an Access developer. To make things a lot easier, I use a lot of extra buttons on the standard menus. A lot of these buttons are linked to public functions I wrote to automate some time-consuming actions. Now today when I started Access, all my extra buttons and menus were gone! I can only see the standard Access menubars with the standard items. I can still see the added toolbar... 3 25.09.2006 14:05:00 Tabs Onclick Event Hi all I have an unbound main form with couple of tabs with subforms embeded on them. What I want to do is I have some control (ie txtboxes, cbo boxes, and lstboxes) that I would like to be displayed depending on the selected tab. I put some VBA code to control the visibility of these controls on the OnClick event of each tab but I don't see anything being hidden or rather no action fire... 4 25.09.2006 13:53:03 Reference a field on a subform I have search through a lot of the old post on referencing things on a subform but can not get anything to work. What I have is a ticket system and I want to be able to open tickets from my subform to work them. I am using the ticket # to link the subform to the frmOpenTicket. I keep getting an error that it can not find the form. The form is open and I have triple checked the name for mispel... 8 25.09.2006 13:05:19 Export Data to Xls Hello! Why when we export an Access report to Excel, all the data are exported except those that in the Report_Footer? and I cannot place the data into the Page_Footer because it will be displayed on each page. Thanks for any suggestion. ... 2 25.09.2006 10:14:52 Can I use a combo box to display or add different information? My questions are linked: If I have a combo list, say of car models and I want to display information for each model in a form: Model, engine capacity, year and fuel type for that model, then select a select a different model, and the details change, is this possible? How would I do this? Secondly, if I want to capture both home and work address information through a form, I would lik... 3 25.09.2006 08:14:02 sub form Hello, I have a sub form that has check boxes for user input, I want to put a command button on my form so the user can clear the checked boxes all at once. any thoughts?... 2 25.09.2006 07:29:02 Multi-select I have a list box with multi-select activated, this list boxs works great. I need all (selected) records to be printed on one report. I guess what I asking for is an example of code to gather all selected records and print them on one report.... 5 25.09.2006 04:53:52 Copy data How can i copy or save data to another table?(it's just like duplicating the same record into a new table).Hope to use vb code to do it in form...tq -- Message posted via http://www.accessmonster.com ... 2 25.09.2006 04:47:03 Hyperlink Button Hi all I have a form which contains a field for a hyperlink. The user should be able to edit the hyperlink by pressing the avaliable button. The following code is then started: Me!photo1.SetFocus RunCommand acCmdEditHyperlink This is only an extract, when I try to run this I get the error 2046, command not avaliable. Can someone help me get this on track. If you need more of t... 2 25.09.2006 02:29:02 Requery a subform I have a Main form with 2 subforms. One of the subforms, frmSub1 contains records and the other subform, frmSub2 is a sum of the records in frmSub1. Each time I update records in frmSub1, I want frmSub2 to requery to post the new totals. My thought was to add the following code in frmSub1 AfterUpdate Event: Forms!frmSub2.Requery The code errors out saying that the form cannot be foun... 3 25.09.2006 00:43:51 Info: download mdb module for creating internal documentation Hi, i've created a selfcontained module (tested with Access2003) for download which allows you to document your systems (done via two tables) here a short description: '####################################################################################### ' mdlCreateObjectListingInTables '####################################################################################### ' ' Att... 1 24.09.2006 23:38:26 Insert and show a photo Hello How could I insert a photo on the database and show it in a form? I have created an OLE object and try to insert a photo but I don´t success showing the picture in the form, I can only open it clicking twice and see the image but not surfing form one record to another. Thanks for all ... 2 24.09.2006 23:04:02 3 separate Forms, How do I move each form record forward wih one b I want to be able to move the record forward in 3 separate subforms on a (tab page) within my main form, but when I set a macro with the ‘GoToRecord’ command, I get the following error: The table ‘Final Top 10 A’ is already opened exclusivley by another user, or it is already open through the user interface and cannot be manipulated programmatically. So, I tried putting in an... 2 24.09.2006 22:57:01 Access ADP Truncating Characters in SQL Table I have an Access 2000 ADP which is a front-end to a SQL Server database. One table I am using has a VARCHAR column of 8000 characters. Inside the code of the Access ADP, where I assign a string variable to the SQL table's column, the resulting value in the SQL table is truncated. It only retains the last 40 characters or so of the string (it is not just cutting off the end, but rather... 2 24.09.2006 22:13:01 access 2003 how do i design an access database table for compiling all the laws to help prepare me for taking a bar examination?... 6 24.09.2006 20:37:10 Cascading 3 combo boxes help I mistakenly posted this to the excel programming group. Please excuse this double posting. I have these two cboboxes in my app and the 'cascading' works great. What I need is the coding for ThirdCboBox that would be using both of the first two cboboxes to limit the choices available to the userin the third cbobox , but I don't know how to construct the sql statement to include two 'limit'... 4 24.09.2006 19:45:14 Prevent record from being saved Who could help me? In a form I select a person from a dropdown list and than I check if there already is a record in the table (with a dcount). If there is, the record should not be saved in the table after closing the form. How can I reach this? I did not get reply to my question in the Dutch communities so I am now turning to the UK one, hoping someone can help me. Ron... 2 24.09.2006 18:49:01 Prevent double records I have first two columns in datasheet date and time. How to prevent double entries in rows? Example: Date Time -------------------- 6.9.2006 10:30 6.9.2006 10:30 In this case i want message box with warning and empty field time. Date can be same lake previous but time must be different. Thanks!... 4 24.09.2006 18:45:01 Re - order Level I am trying to incorporate a re-order level function within a database I am designing and need some suggestion / advice.... I have a function "Onhand" which gives me my current stock total. I have added a new field in to tblproducts called reorderlevel which is where the user can enter a number at which reordering should take place. e.g. StockTotal= 10 reoderinglevel =10 item ??????? ... 3 24.09.2006 17:12:01 error in background color change code Hi - I requested help this morning in changing the background color of all controls on all forms in a database and received the response below - the problem is I get a Data type mismatch at this line of code: For Each Doc In Ctr.Documents Am I possibly missing a reference? Thanks. (Response) This is the function that I use to change the colour of all forms and controls, it is set up f... 2 24.09.2006 14:32:01 Store "Between and data" from a query Hello I have a query in which I introduce two dates, beginning and end. This query makes some calculations and is used for a report. Is it possible to store thise information I introduce for the date so I can put in the report? I mean, if the report asks me for the beginning date and ending date, I´d like this information to appear in the report. Thanks for all ... 4 24.09.2006 13:00:01 Calculation Help I have a form which has a stock total field which is populated by a =OnHand function I also have a field called RRPrice which has the cost of the item. What I wouldlike to do now is stocktotal x RRPrice = Stock Value I have tried the following in the control source of a text box =OnHand([ItemCode])*[RRPPRICE] but all I get is #Name? Any suggestions? Thanks in advance! ... 3 24.09.2006 01:44:42 parameter?? I have added a command button to a form with the following:- Dim str As String str = "UPDATE Testtable SET Testtable.CentreId = 1, Testtable.TypeId = 4 WHERE ((Left([Testtable]![CTEXT],3)="PAY"));" DoCmd.RunSQL (str) When I click the button, I am getting a prompt for a paramenter. If I run the query I do not get the prompt. Is there a simple way to avoid getting the prompt from... 4 23.09.2006 22:32:30 363 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  >>