Threads Replies Last Post 43 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  >>   Unhiding database-window When my Access starts I get an own main form. The database-window is hided. I want to put a button to my main form which brings the database-window unhided. How can I do this the simpliest way. -- Thankful for Your help!... 5 11.09.2006 08:24:01 Access and VB Ok I an new to this and need a little help.... I have customised the following code but I dont know how to implement in to the access form, do I put the code behind a command button? Any help is much appreciated. Function OnHand(vProductID As Variant, Optional vAsOfDate As Variant) As Long 'Purpose: Return the quantity-on-hand for a product. 'Arguments: vProductID = the pro... 27 11.09.2006 02:49:43 object referred to in VBA not an OLE object I have a macro that has been working fine for over a month. It's a simple setvalue macro that synchronizes user ID on a form and subform. Yesterday, however, I changed the names of all my forms to eliminate all spaces. I then went through all macros and code to update all references to the forms. Everything else in the database seems to work fine, but when I went to enter data in the... 1 09.09.2006 17:54:01 Ms Access HElp Reposted Allen, Thank you for you help I have managed to get it up and working!! Can I ask you another questiong re your AppInventory? I was to create a report based on the stock tootals created what is the best way of doing this as the code which you provide requires for you to enter the prouct code in order to get a total. Any advice is much appreciated! Thanks again "Allen Browne" &l... 1 09.09.2006 16:27:23 Reporting records whose subscription wil expire I would like to have a query open and stay open if it returns any records, but close if matching records is zero. I created a query to report customers whose subscription is getting ready to expire [ExpirationDate] between Date() and Date()+30. I put it in an autoexec macro, so that upon opening the database, it opens. But if no one's subscription is ready to expire, I'd rather not see... 3 08.09.2006 22:04:45 Conditional Expression I have a form containing a calc'd field. On that same form is a txt box where the user takes that calc'd number and enters it into that txt box (without getting into specifics, I need to store that calc'd value in a table and this method works pretty well). However, people do occasionally make mistakes and I'd like to create a macro that will display a message box when leaving focus fr... 2 08.09.2006 17:35:56 Refresh Command - Crashes Access I have an Access application that crashes Access "Microsoft Office Access has encountered a problem and needs to close" when a particular line of code is run. The line of code is simply 'DoCmd.RunCommand acCmdRefresh'. This error happens not 100% of the time but about 2/3rds of the time Suggestions and/or Solutions?? Database is split (front end is local, and back end is on a server)... 1 08.09.2006 10:22:01 Find a record and append it as a new record with a macro I have some experience in creating Tables, Quries, Reports and Forms but no knowledge of VBA. I am experimenting with Macros for the first time. My Table is simple -- no relationship, just a single table. For data entry I use a Form. I frequently need perform a sequence of action on this Form: (1) Find a Record (based on ID field) * For this, click on ID control, press Ctrl-F to open Fin... 1 08.09.2006 09:29:02 Creating a pdf as the output We have macros that create and print out batches of works orders. We are looking to e-mail the works orders to contractors rather than posting. This means that instead of simply printing out the batch of works orders, we want them to be created as indvidual pdf fiies which we can then digitally sign and e-mail to the contractor. Is there anyway within a macro command of sending the o... 2 07.09.2006 21:32:38 keep format? i have a excel file which has different formatting in the data such as interior color. this file will be linked to my access where i will do query to sort out the data then export it back to the excel file. is there anyway that i can keep the format which mean after filter and back to excel, the data will still have their original format.... 1 07.09.2006 02:47:01 VBA You entered an expression which has no value I have setup a form and created a text box called ItemCode I have set the control source to be =OnHand([ProductID]) When I load the page with the following code I get the above error VBA You entered an expression which has no value. Can anyone help me out hear I nearly have no hair left!!! Function Onhand(VProductID As Variant, Optional vAsOfDate As Variant) As Long 'Purpose:... 10 06.09.2006 23:54:31 Opening a record from a query on a subform to open another form I have a form [Tracking Main] which contains a subform [Engineering Projects Query Subform] thats built off of a Query[Tracking Query Main] and I want to be able to use the "OnClick" feature to open the selected project from the Tracking Main Form in the another form [Detail Screen] so that I can then update informaiton in this record This is the statement that I have tried to use but ... 1 06.09.2006 20:10:02 How do I use "hide a row function when #N/A appears" in a macro? I have several large workbooks in Excel with up to 28 sheets. I use a VLOOKUP to enter pricing in the sheets, some 10,000. I have 50 offices with different product availability factors. If the product is unavailable a #N/A appears. I then go in and hide the row or rows where #N/A appears in the pricing column. There could be up to 150 rows that need to me manually hidden per sheet. ... 2 06.09.2006 16:25:46 macro Hello, I need to run a macro every hour but don't know how. My goal is to just have this macro run every hour, but not have to have the database open. If I have to have it open, then fine, but I'd rather not. Thanks for your help, Joel ... 7 05.09.2006 22:48:55 Making Label visible/invisible I finally figured out how to make fields visible/invisible based on a checkbox (yes/no) option. However, I am having problems with a Labelbox. Here is the setup: I have a vehicle service table that the primary key (ServiceID) and the VehicleID (relational field to table that contains info about each vehicle, ie make, model, year, color, etc). These are the first two fields that a u... 4 05.09.2006 20:53:48 Merging fields with MS Word All, I created a database that keeps data of my clients, such as projects related to that Client, personnel related to that Client etc. I also create records for letters, proposals, reports and faxes that are linked to a Client, a project and a related contactperson. Now I would like to run some queries where fields for each specific document (proposal, fax, etc.) are selected ... 1 05.09.2006 18:47:26 Access help! Ok, I have looked at this and customised it I think correctly, do I put the code under the click event of a command button? Sorry new to this and getting to know the ins and outs. Thanks "ruralguy via AccessMonster.com" <u12102@uwe> wrote in message news:65cb79e35d4ab@uwe... > MVP Allen Browne covers this pretty well. > http://allenbrowne.com/AppInventory.html > &g... 3 05.09.2006 07:42:16 Passing input in brackets [] to a variable? I use [describe input I need] in queries to ask for input. Is there anyway to pass the input to a variable so I can use that input in other queries or even in multiple queries in a macro? ... 9 05.09.2006 01:02:48 Database Help I have created a database which hold customer details, stock control and sales. I am having difficulty with the following. When I sell and Item I need this to be deducted from the total stock for the item which has been sold, what is the best way to do this? I have the following tables. tblinvoice Invoice ID(pk) CustomerID(fk) InvoiceDate InvoiceNotes Tblinvoicedetails ... 4 04.09.2006 22:50:13 Code changes from this code to print queries necessary to print out macro definitions In searching the web for a method to print out macro definitions, I found this code from allen Browne to print out query definitions. Is there a similar way to print out macros? Public Function ShowAllQueries() Dim db As DAO.Database Dim qdf As DAO.QueryDef Set db = CurrentDb() For Each qdf In db.QueryDefs Debug.Print qdf.Name, qdf.SQL Next End Function... 6 04.09.2006 13:42:54 Dates of birthday Hello I have form in him are fed friends with specifications of people and birthdate I want that in their birthday of the date will color red or will jump me sign Thank you -- dov... 2 04.09.2006 05:03:12 Update table with a macro Hello, I have a form that is used to enter specific electrical readings on pumps. I have placed a button on my form to open a report to show these readings for a specific pump based on which pump has been selected in the combo box on my form. The idea behind this is so that the user can enter new information, then view that information along with previous information without having to ... 3 03.09.2006 23:49:42 SetValue Macro I've tried just about everything I can think of, even reverting to microsoft help and access bible, but still can't figure out what I'm doing wrong. First, I'm still using Access97 for this project. I have a form that has a drop down list of bill #s. When the user picks one then hits ok, it should start a macro that prints the bill (that works) then start the setvalue macro to set a check... 2 01.09.2006 22:02:35 Autorun macro Hi, Is there a way to have a macro run in specific hour? But not using Windows Task Manager. I´d like to set this time in Form. Thanks Schwarz... 3 01.09.2006 16:52:21 Formula Help I know this is probably easy but my brain is not function too weel this morning. I nneed some assistance with a formula... I have a speadsheet that I need to input a value in one cell based on a value entered from another cell... Example: if cell "A" = $1.00-$5.00 cell "B" should state "Send Letter" if cell "A" = $6.00-$10.00 cell "B" should state "Phone Call" if cell "A" = $11.... 2 01.09.2006 16:40:01 43 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  >>